CRUD - Create, Retrieve, Update, Delete to Database

[STEVE]

Dear Paramvir,

The product example explained in tutorial doesn't update/delete/create data to the table. 
It can only retrieve data from the database. I just followed your tutorial but I don't know where I made mistakes.

please check my codes in the attachement as below

Best Regards,
Steve.

[paramvir]

There are couple of online CRUD examples to follow as per your requirement:

https://paramquery.com/pro/demos/editing_batch

https://paramquery.com/pro/demos/editing

https://paramquery.com/pro/demos/editing_instant

[STEVE]

Dear paramvir,

I am beginner not like you.  It is really hard and tough.  Almost I was to cry.

Would you give me these sample files?

Why didn't you post the sample files on these pages.  I was always confused whenever I was reading it.

Please be nice to me.  I don't know at all.  Please save the time.

Best regards,
Steve.   

[STEVE]

It can only retrieve data from the database.

please see the attachment.

[STEVE]

It is also same results.

It can only retrieve. CUD is not working.

please see the attachment.

[paramvir]

Dear Steve

Please check this comment in the source code. (saveauto.php)

Code: [Select]

//JSON.stringify not required for PHP
list: JSON.stringify( gridChanges )

so change your source code to

Code: [Select]

list: gridChanges

instead of

Code: [Select]

list: JSON.stringify( gridChanges )


[STEVE]

Finally, It is working now!!!!

Thank you  Paramvir.

[STEVE]

Hello paramvir,

I changed some lines of the source code of products.php. The changed parts were related to a table.

I could see the data but I couldn't update/delete/insert.

I got the error message from the log folder.

   VirtualProtect() failed [87] parameter is wrong.

I wan to know how to debug this problem.   and how to see the data which is producing through each line of the source code.

I am going to attch the source codes.  Please see below.

Best regards,
Steve.

[paramvir]

It's your environment specific issue.

Please use xdebug to debug your code and find out which line is causing the error.