Databases
StackOverflow2013
Postsdbo
POhow to display mysql database contents with slickgrid?
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POhow to display mysql database contents with slickgrid?
    text
    copied!<p>newbie to stack overflow, doing my best to ask this question correctly. </p> <p>aim:</p> <ol> <li>to display the contents of a mysql database via slickgrid in an html page. </li> <li>to be able to style this grid with a theme from the jquery ui theme roller. </li> <li>to be able to edit and add records to the database via this interface. </li> </ol> <p>research:</p> <p>i have looked for all the major 'grid' apps and came across:</p> <ul> <li>phpgrid</li> <li>jqgrid</li> <li>datatables</li> <li>flexigrid</li> </ul> <p>and also browsed through a list of grids here:</p> <ul> <li><a href="http://superdit.com/2012/01/18/20-jquery-table-datagrid-plugins/" rel="nofollow noreferrer">20 JQuery Table Datagrid Plugins</a></li> </ul> <p>and read that the jquery ui team were actually going to release their own grid but it is on pause at the moment. </p> <p>so with that research i decided on slickgrid because people have said it is fast and i like the clean layout and the fact that it can be skinned with jquery ui (and it is free). </p> <p>most of the syntax and methods i have found for getting data from a database using slickgrid i can not understand (newbie in these areas to) but the closest i found to a set of 'instructions' was here:</p> <p><a href="https://stackoverflow.com/questions/6668613/slickgrid-ajax-data">SlickGrid AJAX data</a> </p> <p>however i get stuck at step 5. </p> <p>so i guess this post is asking, can anyone please provide step-by-step instructions for a newbie on how to:</p> <ol> <li>display the contents of a mysql database via slickgrid in an html page. </li> <li>be able to edit and add records to the database via this interface. </li> </ol> <p>i have downloaded the zip file from <a href="https://github.com/mleibman/SlickGrid" rel="nofollow noreferrer">slickgrid github page</a> which contains the existing examples. </p> <p>thank you! </p> <p>ps i had links to all apps and sources mentioned but as a new user was not able to post more than two links. </p>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload