Free Php Script to show DataGrid

Question

I want to show an online editable datagrid like in asp.net to the user. My development is in php and i have mysql database. Is there any free of cost alternative which is ajax powered as well for me to enable the user to add/edit/modify data online.

I have a MQSQL Database. Ain't there any control which can do databdinging to a mysql databse?

Answer 1

look on :

jquery tablesorter plugin

http://tablesorter.com/docs/

OR

edit :

http://php-team.blogspot.com/2009/05/10-jquery-datagrid-plugins.html

Answer 2

You can check out the following (both of which can be easily integrated to your PHP scripts):

• dhtmlxGrid

Ajax-enabled JavaScript grid control with cutting-edge functionality, powerful data binding, and excellent performance with large datasets.

dhtmlxGrid's notable features:

• Built-in filtering, searching, grouping
• Auto-calculated values in footer/header
• Loading from XML/CSV
• Easy client-to-server comunication
• Resizable/movable columns
• Drag-and-drop rows/columns within grid
• Ability to create any editor or cell formating (I believe this is what you're looking for )
• Math Formulas for cells

Also,

• jQuery plug: TableSorter 2.0

plugin for turning a standard HTML table with THEAD and TBODY tags into a sortable table without page refreshes. tablesorter can successfully parse and sort many types of data including linked data in a cell

Another jQuery plugin (althought I haven't tried this one) is

• Ingrid, the jQuery Datagrid - here's an example: Ingrid example

an unobtrusive jQuery component that adds datagrid behaviors (column resizing, paging, sorting, row and column styling, and more) to your tables.

If you want to code each editable cell, you may also use Edit in Place using Ajax, which also uses jQuery.

PHP Team also has a list of jQuery Datagrid plugins.

Answer 3

flexigrid or jqgrid may help you .. both using jquery.

another alternatives are YUI and ExtJS . both have grid library (which I haven't try those)

Answer 4

I used PHPMYDATAGRID, to much good effect. Has anyone used it?