How to save added record to database.

QuestionsHow to save added record to database.
Peter Moh asked 6 years ago

I download phpGrid lite for testing.
It is vrey good to display data from databse.
It seems phpGrid has many build in functions to allow add new record and edit a selected record.

But after I clicking Submit button to save a new added row or edited row, I check the result from phpMyAdmin or using SQL from command line. It is found that no row was added and the edited row has not been changed.

Please let me know how to make it work.

4 Answers
Abu Ghufran answered 6 years ago

Hello,

Please check out the FAQ .. q#1 for debugging purpose and let me know the json result.

Note: We only provide solution related to the product at http://www.phpgrid.org/download

Ben Walter answered 6 years ago

I have having the same issues. I'm interested in purchasing but I am not able to get this to work. It displays data fine. Unable to perform any CRUD operations though.

Here is the error I received.

Oh and an FYI – Chrome will also let you view this – Tools –> Developer Tools

Couldn't execute query. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Release,Load,Shipper,ShipCity,ShState,PUDate,PUInfo,Consignee,ConsCity,ConsState' at line 1 – INSERT INTO tblSchedule (ID,Release,Load,Shipper,ShipCity,ShState,PUDate,PUInfo,Consignee,ConsCity,ConsState,DelDate,DelInfo,Carrier,BaseRate,FSC,Lumper,Detention,Total,OneidaLoad,Notes,Complete) VALUES ('3','987456431','','','','','','','','','','','','','','','','','','','','')

Abu Ghufran answered 6 years ago

Hello,

RELEASE is a keyword in mysql, so that might be causing issue.
Although fix is required in lib to use `release` instead of just keyword, but quick solution would be to rename field.

I'll add it in todos for coming build.

Ben Walter answered 6 years ago

Ah ha! I changed Release to ReleaseNo and still had no luck. But your suggestion got me thinking – so I changed Load to LoadNo and now it works.

Thank you!

Your Answer

3 + 5 =

OR, enter

Attach code here and paste link in question.
Attach screenshot here and paste link in question.



How useful was this discussion?

Click on a star to rate it!

Average rating / 5. Vote count:

As you found this post useful...

Follow us on social media!

We are sorry that this post was not useful for you!

Let us improve this post!