Data Grid in PHP [closed]

Question

I need to create a datagrid in a web application using php as the backend programming language, which will be populated from a MySQL database objects (views, stored procedures). The end user should be able to edit the data in this datagrid and the data in MySQL tables will need to get updated.

If you can give me some examples -tutrial, demos, project with explanation on how to use those with examples, it will be a great help.

Answer 1

You can use http://phpgrid.com

$dg = new C_DataGrid("SELECT * FROM orders", "orderNumber", "orders"); 

// change column titles
$dg->set_col_title("orderNumber", "Order No.");
$dg->set_col_title("orderDate", "Order Date");
$dg->set_col_title("shippedDate", "Shipped Date");
$dg->set_col_title("customerNumber", "Customer No.");

// hide a column
$dg -> set_col_hidden("requiredDate");

// change default caption
$dg -> set_caption("Orders List");

$dg -> display();

examples can be found on http://phpgrid.com/example/

it's easy to use and looks pretty.