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 [...]
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, [...]
Now you can export selected rows and columns at runtime. This means no code change, Export selection options are now on accessible with grid operations toolbar.
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 [...]
We’ve further enhanced PHP Grid and JQuery UI Autocomplete integration.
Types and Steps shows how to integrate database driven type ahead / autocomplete by lookup sql query.
1) Basic Typeahead (single field)
Step1: Set formatter to autocomplete on desired column
$col["formatter"] = "autocomplete"; // autocomplete
Step2: Set format options query. The field in sql [...]
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 [...]
When we have many columns in a grid with less amount of data in cells, there is a requirement to have vertical text in column headers to improve overall visibility. On several requests, this feature is added now. You can define text angle and other SVG attributes like font style etc.
Just added a new filter option, that let you filter columns having a dropdown with checkboxes to select multiple items. It also support textbox to quickly search your desired item within filter options. This is similar to excel like auto filtering.
-> Already have [...]
Based on several customer’s feedback, We’ve now integrated ‘Select2′ control with PHP Grid.
Now you can use ‘Select2‘ control with PHP Grid’s Add or Update operations. Select2 is a jQuery based replacement for select boxes. It supports searching, with in your large select box data items. It gives behavior similar to ‘Combo-box’ control [...]
We have made several additions in our customized dialog layout feature.
1) You can have 2, 4, 6 column layout in your Add or Edit dialog forms of PHP Grid.
2) You can also Add sections (sub-titles) within form to separate input data group.
3) A field can span to several columns where [...]
I just added a new feature, that allow you to have multiple subgrids at same level.
Usage is pretty easy, just define 2 grids as detail grid and it’ll be there when expanded.
Active licensed customers can request latest build & demo files via email (firstname.lastname@example.org)