Sometime we need custom Add or Edit forms for data entry purpose. With this feature it’s now doable to connect your HTML Forms with PHP Grid and it will use PHP Grid API for add/edit operations. See Screencast for more.
Active license customers can request free upgrade using this link.
On various occasions, we want instant access to see or edit our database tables without having time to write a whole module with add, edit, delete, list, search (CRUD) operations. Whether your database is SQL Server, Oracle, DB2, MySQL or PGSQL — PHP Grid provides you easy solution that takes database credentials in config and provide table access in form of lightweight and rich featured PHP Grid. It will provide you complete functions within your existing application admin interface.
This lightweight, yet power-featured PHP Grid Database Editor is developed by very simple code OR we can say by just configuration. In main code logic, we simply passed the dropdown value of selected table in $g->table attribute, and that’s all!
$g = new jqgrid();
// set few params
$grid["caption"] = "Grid for '$tab'";
$grid["autowidth"] = true;
// set database table for CRUD operations
$g->table = $tab;
// render grid
$out = $g->render("list1");
You can extend this code to incorporate Access Control (ACL), Exporting Data (PDF, CSV, XLS) and several other features to make a powerful tool. We omitted them to show the code simplicity. This demo is based on MySQL, but you can have same function for MS SQL Server, Oracle, PgSQL databases.
PHP Grid comes with free version and a licensed version. With Free version you can connect with others databases like MySQL, MS SQL Server, Oracle, PgSQL,DB2. Licensed version also supports many advance features which you can integrate in your application.
Complete code for this demo can be accessed from this link.
Today, we are glad to announce the release of PHP Grid v2.0.
Adding a lot of features, updates, optimizations and fixes. Thanks for all who contributed in evaluation.
Overall User Interface Enhancement, New Glyph Icons, Cozy Spacing Layout enabling it to be used on mobile devices easily. Bootstrap3 is also supported now. This version comes with 3 layouts, i.e. Cozy, Bootstrap and Classic (old slick version).
New Professional Themes (Dark, Light, Colored). Metro Color Themes light/dark/black are recently added. You can also rollover your custom color theme using jQueryUI.
Integration with jQuery Plugins. Now you can connect plugins like datetime, autocomplete, select2, fancybox, ckeditor, jscolor and many others with simple process, enabling endless possibilities in features.
Added support for many missing database engines
And finally, all such features gave same experience on modern browsers.
Added support for PHP v5.0+ to v7.0
PDO and MySqli Drivers support
New Glyphicon (Iconset) / Bootstrap3 support
Muliple File Uploading Support
Support for SQLite and Firebird databases
Advanced Search Conditions (Search in Groups)
Exporting selected rows and columns
Session data based grid (with add/edit/del)
Exporting Master Detail PDF
Image auto-embed support in PDF export
Select2 plugin support for data entry and search form
We recently added support for Firebird & SQLite Databases. These fast, slick and reliable databases will help in running portable apps with PHP Grid. Thanks to PDO library, it’s integration is very with little configuration changes.
We’ve added most robust and efficient complex searching method in PHPGrid.
This enables the more advanced search dialog allowing to add any number of complex group conditions. The user can now add or delete an unlimited number of conditions to perform the search as shown in screenshot.
This will formulate following search query, “( … )” refers groups in search query:
(name LIKE "%An%" OR company LIKE "%Mar%")
(name LIKE "%Fa%" OR company LIKE "%Far%")
gender = "male" AND client_id < 25
Hope you like this feature. Customers with active subscription can get latest build + demo via email.
We also offer discounted renewal prices for customers with expired subscription.
For any case, contact on our support team at ([email protected]).
In demo, select columns using column chooser and rows by multiselect option, then click Export selected button. This will export PDF of selected rows/cols. As the grid exports PDF format, the data table can be printed by your favorite PDF reader.
I recently updated online documentation page to make it developer friendly, fast and each to navigate. The previous version was very unorganized, and honestly speaking, i usually didn’t use it for my development (instead i preferred Ctrl+F in markdown file — docs.txt).
Now, in updated version on right side, there is a list of complete table of contents for easy access. It also contains a new ‘Using’ section that dictates the steps required to implement certain feature.
The new section of documentation is kept simple with focus on:
1) Steps to Use
2) Code Snippet / Picture
3) Full Code / Live demo
The future updates are also planned to be in same format, and i believe it’s just what a developer like in documentation. Copy > Paste > F5!