Code

Discussion on PDO Crud – Advanced PHP CRUD application (Form Builder & Database Management)

Discussion on PDO Crud – Advanced PHP CRUD application (Form Builder & Database Management)

Cart 2,301 sales

ddeveloper supports this item

Supported

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 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.php

Hi

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.php

Hi

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

by
by
by
by
by
by

Tell us what you think!

We'd like to ask you a few questions to help improve CodeCanyon.

Sure, take me to the survey