Introduction Welcome to phpGrid! The most beloved datagrid for PHP developers. If you are new to phpGrid, we [...]
A Basic PHP Grid Example A basic PHP grid requires only as little as TWO lines of code. First of all, always create a [...]
Descriptive Column Header By default phpGrid pulls out the data field name defined in database as the header for each [...]
Hide Column For columns need not to be shown, such as primary key, use method set_col_hidden() to hide [...]
Datagrid Caption By default, phpGrid displays table name as the caption. You can change the datagrid caption [...]
Export Data to Excel, PDF, CSV, and HTML phpGrid currently supports export in native Excel format, CSV, PDF, and HTML [...]
Integrated Search phpGrid includes integrated search. By default, this feature is not enabled. To enable search [...]
Set Grid Height and Width Use set_dimension() method to specify grid initial height and width. The default height and [...]
Datagrid Pagination By default, the pagination size is 20. It means maximum of 20 records can be displayed in a [...]
Advanced Search phpGrid also includes advanced search. By default, this feature is not enabled. To enable [...]
Load Data with Vertical Scroll In contrast to traditional pagination method to browse through data, you can use vertical [...]
Theme Roller * * Please note this feature is only available in paid versions. ** Premium Themes are now [...]
Hyperlink Display You can display the text in column as static hyperlink by calling set_col_link() and passing [...]
Display Dynamic URL From example above, we learn that phpGrid can display simple, static URL using set_col_link() [...]
Data Format Display phpGrid comes with several frequently used data formatter through set_col_format() method. [...]
Image Display Display image is easy in phpGrid. Simply set the column name in set_col_img(), phpGrid will [...]
Interactive Datagrid Resizing When enabled, the small triangle icon is displayed at the right bottom corner of the grid. The [...]
CRUD PHP Datagrid (Editable Datagrid) * * CRUD PHP Datagrid feature is only available in paid versions. The PHP datagrid is not [...]
Read only fields Sometimes we don’t want certain fields to be editable, then we can use set_col_readonly() [...]
Required fields To set fields as required in an editable grid, use set_col_required() method. If required [...]
Grid Edit Types – Select, Checkbox, Textarea, Autocomplete, WYSIWYG, etc. After enabling edit, set types of data grid edit controls with set_col_edittype() for any [...]
Master Detail Grid * * Please note this feature is only available in Premium and higher editions. The phpGrid went [...]
Master Detail with Column Alias It can be tricky working with master detail grids with column name alias, especially during [...]
Multiple Editable Grids Did you know it is possible to have multiple editable grids in a single page? No need to [...]
Column Grouping with Summary * * Please note this feature is only available in paid versions. phpGrid can group [...]
Master with Multiple Detail Grids * * Please note this feature is only available in paid versions. phpGrid supports a master grid [...]
Nested Master Detail Datagrid * * Please note this feature is only available in Premium and higher editions. The master detail [...]
Locale Setting If you are using phpGrid in a language rather English, you may want the datagrid to display [...]
Reference to Multiple Databases * * Please note this feature is only available in paid versions. phpGrid nows supports data [...]
Display Non-English Characters If database is created in charset other than default charset, e.g. “latin1″, some characters [...]
In-cell Data Bar * Bar chart is a great way to visualize numeric data. phpGrid now supports bar chart natively [...]
Conditional Value * * Please note this feature is not available in Lite and Basic versions. Conditional Value is [...]
Create Excel-Like, Responsive Grid Expand to Current Window Width Use enable_autowidth() and enable_autoheight() to set datagrid [...]
Horizontal Scroll Set parameter $shrinkToFit in set_dimension() to false to enable horizontal scroll when the [...]
Method Chaining Method chaining is now supported starting version 5.0. It’s not required, but it provides more [...]
Custom Event Handler phpGrid supports custom event handlers using the add_event() method. The event handlers are [...]
Column Property You can now directly manipulate individual column properties without using helper set_col_* [...]
Hyperlink to Call JavaScript Function You can show hyperlink using set_col_link for static link or set_col_dynalink for dynamic link. [...]
PHP Datagrid AJAX File Upload *The file upload is supported under the commercial license. File upload is one of the most [...]
Customize Edit Form Layout By default, the edit form is displayed a single column table. This is fine for table with small [...]
phpGrid, phpChart Integration It’s easy to combine phpGrid and phpChart to create a seamless integrated, interactive, [...]
Virtual/Calculated Column Starting version 5.5, you can now add virtual column, AKA calculated column, to your existing [...]
Custom Data Validation phpGrid automatically does data validation based on database data type such as a string cannot [...]
Column Freeze You can now use the set_col_frozen() method to set the column freeze method. It’s useful [...]
Column Methods Version 5.5.5 introduced set_grid_method() method. You can use this method to call any jqGrid [...]
Inline Edit Actions Column Inline edit mode also comes with actions column with edit and delete buttons. Use add_column [...]
Row-level Edit Permission Using actions column in the earlier example, it’s now possible to specify row-level edit [...]
One Table, Multiple Datagrids You can certain have more than one datagrid instances from the same database table. Just make [...]
Column Chooser & Sortable Row The example below demonstrates column chooser and sortable row features. Click on the column [...]
Composite Primary Key Support * * An exclusive feature for phpGrid commercial License In the past, phpGrid supports [...]
Multiple Datagrids Side by Side When having multiple datgagrids on a page, it’s common you need to change the default top [...]
iOS, Android Mobile Support phpGrid works well in iOS and Android mobile devices. Visit the following demo on your mobile [...]
Nested/Cascade/Dependent Dropdown Use “autocomplete” control and set_nested_dropdown() method, dependent dropdown, [...]
Header Grouping Header grouping adds additional columns above the datagrid header rows, so that columns below [...]
Save Data in Virtual Column It’s possible to save data in virtual column to database.To save data in virtual column [...]
Mobile Device Optimized phpGrid has decent mobile device support. View the below demo on your mobile device such as iOS [...]
Math (e.g. Sum, Avg, Count) Operation It’s possible to perform math operation on numeric columns with a little bit help from [...]
Externalize Search You can even externalize search fields without ever using phpGrid’s integrated or [...]
Multiple Fields Global Search * * Please note global search feature is only available in commercial licenses. In [...]
Work With Different Database Types You should specific PHPGRID_DB_TYPE value in conf.php. It can be one of the following strings. [...]
Local Array Data Source * * This feature is available with a commercial license. phpGrid now supports local array [...]
phpGrid, Twitter Bootstrap Integration This is a step-by-step tutorial of how to integrate SmartAdmin, or any other Bootstrap [...]
phpGrid Laravel Integration (version 1) This is a step-by-step tutorial of how to integrate the Laravel PHP framework with phpGrid. [...]
Conditional Formatting with Custom Javascript What would you do if you need more than set_conditional_format() and set_conditional_value() [...]
phpGrid, Laravel and Bootstrap (version 2) Note this tutorial has an updated version. Check out the latest, much improved Dashboard + [...]
phpGrid and CodeIgniter Integration Introduction CodeIgniter is a popular, open source PHP framework loosely based on the MVC [...]
Integrate with .CSV or Google Spreadsheets You can use a local .csv or Google Spreadsheet as a data source to populate your datagrid. In [...]
phpGrid and Zend Framework Integration Introduction IntroductionZend Framework (ZF) is a popular open source, MVC web application [...]
phpGrid Now Has Improved IBM DB2 Support! THIS TUTORIAL IS OUTDATED. “ibm_db2” is now the recommended extension to access the [...]
Announcing phpGrid v6.7 Today we released phpGrid version 6.7. It updates several major core components to support PHP [...]
Working with Complex Query Keep in mind that any direct editing is always limited to the primary table. For example, in [...]
Access DB2 through “ibm_db2” extension * Access to DB2 through “ibm_db2” extension is only supported in the commercial [...]
Persist State of the Sort Order and Page On Page Reload Sometimes you need the datagrid to be able to remember sort order and current page. For that, [...]
Drag and Drop Grouping * Please note this feature is only available in commercial licenses. You can enable drag [...]
Tabbed Grid – Build a DataGrid With Tabs Note that some features used in this demo are only supported in phpGrid Enterprise 6.9+. [...]
Advanced Search with Date & Number Range Filter Advanced search now supports range filter for both date and number. To enable search use [...]
WYSIWYG editor with font colorpicker Font colorpicker is now built right into the phpGrid Wysiwyg editor for both inline and form [...]
Form-Only Edit Mode * Please note this feature is only available in commercial licenses (7.0+) phpGrid now supports [...]
Enhance Edit Form There are many ways to enhance the edit form in regular datagrid + form, or just in form-only [...]
Load Existing Record into Form (Form-Only Mode) * Please note this feature is only available in paid versions. You can load existing [...]
Joomla! CMS Native Support * Please note this feature is only available in paid versions (version 7.0+). phpGrid [...]
CRUD success/error status display Starting version 7, phpGrid now displays status of either success or error confirmation [...]
phpGrid Symfony Integration Files needed for this demo phpGrid Lite (free) Symfony 3 (free) Where to keep phpGrid [...]
Create a Database Management System in 15 Lines of Code Introduction We will learn how to build a fully functional, single-page database content [...]
Set Start Day of the Week in Datepicker Sunday was named as the first day in Jewish and early Christian tradition. However, Sunday is [...]
Rating Plugin Integration phpGrid has built-in jQuery rating plugin support since version 7.1.5. In set_col_format(), [...]
Bulk Edit, Select Multiple Rows You can select multiple records with set_multiselect() method. When multiselect is enabled, a [...]
Drag & Drop Rows Between Grids You can drag and drop rows between two or more grids using a mouse. In the demo, we have both [...]
Show Remaining Characters in Textarea/Input In a recent user support request, the user would like to see the remaining characters allowed [...]
Build a Simple CRM from Start to Finish Customer Relationship Management (CRM) is a system that manages customer interactions and data [...]
Build a Project Management Application From Scratch What is a Project Management Application? A project management application is a software system [...]
A Step-by-Step Guide to Building a Donation Manager from Scratch in PHP – Part I Introduction This Donations Manager application can be used by charitable organizations to [...]
A Step-by-Step Guide to Building a Donation Manager from Scratch in PHP – Part II In this part of the tutorial, we will continue from where we left off in Build a Donation [...]
Creating a Custom Inventory Management Application in PHP and MySQL Introduction You do not need bloated enterprise software to effectively track your inventory. [...]
Loading from Large Database Table with 3 Million Records! The total record count is usually one of the most expensive database operations due to [...]
Tagging with autocomplete To enable tagging, you can set the type of grid edit control to autocomplete with [...]
