web interface to view and update mysql tables
Does anyone know of any tools/table editors that I can embed on websites to view/update mysql tables? I want a tool that I can design how a data grid looks (fonts/colors/ editable column or not), pass query result to populate the grid, ajax pagination, configurable re updating mysql tables I.e. if row edit requires multi-table update.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
@LajuanTaylor
Thanks - I believe phpMyAdmin is for administrators; I'm looking for something to embed in websites for users to view/edit/update specific mysql data that I make available to them. If you believe phpMyAdmin can be customized/embedded into web pages as a user interface, please post back.
@Marco - thanks - I'll look into EditableGrid and report back
Thanks - I believe phpMyAdmin is for administrators; I'm looking for something to embed in websites for users to view/edit/update specific mysql data that I make available to them. If you believe phpMyAdmin can be customized/embedded into web pages as a user interface, please post back.
@Marco - thanks - I'll look into EditableGrid and report back
Oh, I see. phpMyAdmin is not the tool then that would provide the CRUD grid you are looking to implement.
The following tutorial might something you can use. It creates a Twitter Bootstrap powered grid to perform CRUD operations against a MySQL database: http://www.startutorial.com/articles/view/php-crud-tutorial-part-1/
Secondly, take a look at phpGrid. It's not free, but you can download the lite edition to test the product. One benefit is that a product license can be purchase to support more databases other than just MySQL. http://phpgrid.com/example/
The following tutorial might something you can use. It creates a Twitter Bootstrap powered grid to perform CRUD operations against a MySQL database: http://www.startutorial.com/articles/view/php-crud-tutorial-part-1/
Secondly, take a look at phpGrid. It's not free, but you can download the lite edition to test the product. One benefit is that a product license can be purchase to support more databases other than just MySQL. http://phpgrid.com/example/
This solution is free - http://www.grocerycrud.com/examples/products_example
@LajuanTaylor: GroceryCRUD is a library for CodeIgniter: if you don't use CodeIgniter, you can't use GroceryCRUD
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks - this should get me started
http://www.phpmyadmin.net/home_page/index.php
It's web based and designed to administer MySQL via web interface.