Bind jQuery Chart to MySql Database using PHP

[MichelMember]

Hello,
I’ve been trying to work with the chart example as described, with data coming from the database,
but when I run the application it is showing only blank page. Then when I run data.php alone
it displays a message: “SQL Error 1: Table ‘invoices’ doesn’t exist”, means while I successfully
downloaded Northwind database and integrated it well in my phpmyadmin and the table invoices is there
populated with data.

Any help will be appreciated.

Thanks

[Peter StoevKeymaster]

Hi Michel,

I suggest you to check the connect.php file and write the correct DB name, login and password. A working sample with jqxChart bound to MySQL DB is available online: http://www.jqwidgets.com/jquery-widgets-demo/demos/php/chart.htm?arctic

Best Regards,
Peter Stoev

jQWidgets Team
http://www.jqwidgets.com/

[PsychoticDiabloParticipant]

I know this post is a little old, but in the event someone else comes across this looking for help I just wanted to say the resolution to this for me was that when receiving this error “SQL Error 1: Table ‘invoices’ doesn’t exist” it was telling me the “I” in invoices was capitalized and it was looking for a lower case “i”.

Simply put I logged in to phpmyadmin went to the database Northwind and changed the “I” to a “i” in the table invoices and it did the trick.

I found the answer here Dev.MySQL

[sai9000Participant]

I am new to jqwidgets and just installed it. I have all the tables correct. I have all database connectivity correctly configured.
I also am experiencing “No Data to Display” message on all mysql bound php examples.
I debugged data.php files and I see that data is getting to the php file.

Any help is appreciated.

[Peter StoevKeymaster]

Hi sai9000,

If your data.php returns data, then check whether the url in index.php is correct and check whether the jqxDataAdapter and all the required datafields and Grid columns are initialized correctly. In general, you should read this help topic: http://www.jqwidgets.com/jquery-widgets-documentation/documentation/jqxgrid/jquery-grid-datasources.htm to learn how to bind jqxGrid to any data source.

Best Regards,
Peter Stoev

jQWidgets Team
http://www.jqwidgets.com/

[Author]

Posts