2608 comments found.
Hi, i planned a new project based on PHP 8.3. Before i by a new licence i developed a proof of concept on my local maschine. Basis is my last download of pdocrud Version: 6.1.1 When i press button save in my new application based on php 8.3 i get multiple error messages:
Deprecated: Optional parameter $op declared before required parameter $task is implicitly treated as a required parameter in C:\xampp\htdocs\prokox\script\classes\PDOCrud.php on line 983
Deprecated: Optional parameter $page declared before required parameter $totalrecords is implicitly treated as a required parameter in C:\xampp\htdocs\prokox\script\classes\PDOCrudHelper.php on line 191
Deprecated: Optional parameter $parameters declared before required parameter $data is implicitly treated as a required parameter in C:\xampp\htdocs\prokox\script\classes\PDOCrudTableFormat.php on line 122
Deprecated: Creation of dynamic property PDOCrud::$langData is deprecated in C:\xampp\htdocs\prokox\script\classes\PDOCrudAjaxCtrl.php on line 13
Deprecated: Creation of dynamic property PDOCrud::$formFieldHide is deprecated in C:\xampp\htdocs\prokox\script\classes\PDOCrudAjaxCtrl.php on line 13
Deprecated: Creation of dynamic property PDOCrud::$dataHTML is deprecated in C:\xampp\htdocs\prokox\script\classes\PDOCrudAjaxCtrl.php on line 13
Deprecated: Creation of dynamic property PDOCrud::$fieldList is deprecated in C:\xampp\htdocs\prokox\script\classes\PDOCrudAjaxCtrl.php on line 13
Deprecated: Creation of dynamic property PDOModel::$characterSet is deprecated in C:\xampp\htdocs\prokox\script\classes\PDOModel.php on line 117
{message“}
Do you have any idea, whats wrong. I’d like to fix this issues before i by next license. Great to hear from you. Thx. Olaf
Hi, i also get an error using “where”-Statement: Deprecated: Creation of dynamic property PDOCrud::$whereCondition is deprecated in C:\xampp\htdocs\prokox\script\classes\PDOCrud.php on line 1379
When i call demo site with where-statement, i get the same error based on PHP 8.3. Regards, Olaf
Any idea whats wrong with the where-statement under PHP 8.3?
Hi Developer? no idea?
HI
Its Deprecated message that means the functionality is Deprecated in the latest version of PHP. You can either hide that message by setting error_reporting(-1) in pdocrud.php or you can declare a variable named $whereCondition in file as mentioned in the error. Please check. Thanks
hi, and thx for your advise. I have set the error_reporting parameter but nothing happens. Then i found a solution the following solution: In PDOCrud.php i changed the code from
- Class PDOCrud {
to
- Class PDOCrud extends \stdClass {
Now no deprecated messages where shown. Hope that helps and no other side effects later
. Thx.
Issue’s With AJAX and Inline Editting. Changing a numeric field attempts to save as string, and fails.
For Check duplicate records how should I can pass multiple fields. Suppose checking duplicate records of register_number and “email” for this example $pdocrud = new PDOCrud(); $pdocrud->formFields(array(“register_number”,”first_name”,”last_name”,”email”)); //Check for duplicate record. You can pass multiple fields also. $pdocrud->checkDuplicateRecord(array(“register_number”)); echo $pdocrud->dbTable(“student”)->render(“insertform”);
non-required form fields are getting inserted as empty strings. When I try to submit with a blank value that is required to be integer but also is_nullable in the SQL schema I am unable to create a new record.
I get the error “SQLSTATE[HY000]: General error: 1366 Incorrect integer value: ’’ for column ‘fed_tax’ at row 1”.
Shouldn’t we be using NULL instead for those values or excluding the empty column from the insert?
Hi, For non-required fields, default value of the field is inserted. If it’s string type then default blank value is inserted. Thanks
There is no forget password demo. How can I build forgot password page?
Rest API and CRUD Generator
works for oracle database connection
Cuando genero el cuerpo del HTML5 en mi proyecto, este me regresa un error en mis formularios, en mis filtradores, y en mis botones, dándome como error: “Session has been expired. Please refresh your page to continue.”
¿Por qué ocurre esto y como lo soluciono?
https://adw-mx.us.stackstaging.com/cProgramas_Test.phpHi
It may be due to incorrect config url or your server setting. Please check on your server that sessions are enabled. Thanks
¿Como puedo ocultar un input junto con su label?
yes, you can hide label and field both. Thanks
Hola, como puedo saber cual es el error que tengo, si es php o es del contenido de mis campos, saludos
https://adw-mx.us.stackstaging.com/cProgramas.phpHi
Please share the code used in this page to check further. Thanks
when i use file input plugin and upload file, when i go to edit a record and save it, all uploaded file delete from table, how can i solve this?
can i use depended field command and where command? i have 3 selectable field in form that 2th field is depended with 1th field and 3th field is depended with 2th field.
when i use fieldDependent, all WHERE conditions is ignored.
in previous relatedData or fieldDataBinding
Hello,
Very nice script. I need help. How to use in php MVC?
Best regards,
Hi
You can create the object of PDOCrud and get data using render function in controller and pass it on view. Thanks
Hi, when i use google recaptcha in edit form and when i save form, i see this error. how can i solve this? SQLSTATE[HY000]: General error: 1300 Invalid utf8mb3 character string: ’\x82\xB7\x9Cj\x9B\\x85\xAA\xDE\xB2\x9A’\xB1’
Hi,
Captcha doesn’t save in the db so it must be something else. Please share your code. Thanks
hi at the first of all, excuse me for bad English. how can i use multiple WHERE statement, when i use Raw data data operation (in select query)
Hi
Please check $pdomodel->where(“empId”, array(36,37), “BETWEEN”);
“columnname”, “value to be checked”, “operation and,or,between
how can i check value of two or more columns?
You can apply multiple where statements
Why doesn’t relatedData doesn’t work the same as fieldDataBinding? I need the field to show the values of multiple other fields from an other table in the grid as well. Not only when editing.
Hi,
Both have different functionality. but surely, I will try to make relatedData work as fieldDataBinding as well. Thanks
dbOrderBy doesn’t work with an array of columns where keeps giving me a deprecated error in php8.3, but it does work
Hi
Please download the latest version. All the issue related to latest php version changes has been resolved. Thanks
Hi
I use the “date picker” to insert in the sqlite DB the day the payment for an event is due, but the event requires both the DATE and the TIME to save the time it begins.
How I deal that? (Other using two fields, of course
)
Thanks
Hi,
You need to set the fieldtype to datetime. It will show both date and time. Thanks
Demo seems to have some problems, can you fix it?
Hi,
We have fixed the demo. Please check. Thanks
Demo isn’t working, 404 errors etc..
Hi,
We have fixed the demo. Please check. Thanks