All articles

  1. Access local array data source

  2. Add Custom Button and Move the Toolbar to the Top of the Datagrid

  3. Advanced Search Date Comparison

  4. Advanced Search: Enable greater than/less then for date fields

  5. Align Datagrid Center on a Page

  6. Always Display Integrated Search Toolbar When Page Load

  7. Auto Increment (auto-increment) Field validation Due to Underscore Character in Primary Key

  8. Can I change the tool bar with search, edit, delete from footer to header?

  9. Can Virtual Column Be Used to Create New Column for Database Table?

  10. Cannot activate phpgridlie under my wordpress

  11. Cannot display datagrid in IE8, but works in Firefox

  12. Cannot save record back to database. How to debug?

  13. Catch Errors on the Sever Side

  14. Center Add/Edit Form

  15. Change date display format

  16. Change edit properties without modifying the source code

  17. Change header row height

  18. Change Master Detail Grid Layout e.g. side by side

  19. Change Search Default Value

  20. Change set_col_frozen background transparency

  21. Collapse Datagrid on Initial Display

  22. Column Color

  23. Column Order Position

  24. Compare again database NULL in set_conditional_value function

  25. Complex Sql Query

  26. Conditional format - compare two cells

  27. Configuring Oracle

  28. Connect phpGrid to MS SQL Server from Linux

  29. Constant value in create/edit form

  30. Could not connect to the database (MySQL) but works with PDO

  31. Create edit type "select" options manually from SQL query

  32. CRUD (Create, Remove, Update, Delete) Not Working

  33. Custom button in action column

  34. Custom Server Side Data Validation

  35. Customize Edit Form Layout

  36. Data bar solid color?

  37. Data is not showing up (blank grid) in MS SQL, MySql, or other database

  38. Datapicker displaying behind the edit form

  39. Datetime Format

  40. Datetime in datepicker

  41. Dealing with very large datasets

  42. Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in

  43. Display a value in a cell that references a value in another table

  44. Display column in grid but hide when edit

  45. Display datagrid somewhere else on the page

  46. Display field value from grid using custom event

  47. Display grid from multiples tables

  48. Display group summary without any detail records

  49. Display Icon/Image In a Virtual Column

  50. Display Value from URL Querystring Parameter

  51. Displaying Header vertically

  52. Displaying TIMESTAMP Fields in an Editable Grid

  53. Dropdown Concatenation

  54. Dynamic dropdown based on cell value in a row.

  55. Edit Grid of a JOIN or a complex query

  56. Edit Master Detail Grid that Uses SQL Alias

  57. Edit not working

  58. Editable Datagrid with Add Only Ability

  59. Elongated grid when theme is set

  60. Enable inline search by default

  61. Error during Export - Warning: date() []: It is not safe to rely on the system's timezone settings.

  62. Escape HTML characters in datagrid

  63. Example not working

  64. Excel Export Issue with  character causes export to fail (User Contributed Article)

  65. Expand All Subgrids on page load

  66. Export to EXCEL downloads XML file

  67. Fatal error: Call to undefined function mysql_connect() "...r\adodb5\drivers\ on line 364

  68. Fatal error: Class 'C_DataGrid' not found

  69. Fix group sum floating (decimal) issue

  70. Foreign characters display

  71. Format UNIX Timestamp to Human Readable Time Format Using Custom Formatter

  72. Get Selected Rows from Multiple Grids

  73. Get selected values of the grid view

  74. Get value from a specific cell from selected row

  75. Grid text align

  76. grid width issue

  77. Hide Icons and Change Caption Dynamically

  78. Horizontal scrollbar missing on tablet PCs/mobile devices

  79. How to "crop" text so that the text won't wrap

  80. How to center the grid

  81. How to change the height of a row (not header row but data row)?

  82. How to disable column sort

  83. How to display total sum of a column of ALL the records in the footer?

  84. How to format text capitalization and other formats

  85. How to get new ID generated from insert?

  86. How to grab the table rows in a grid

  87. How to Increase Size of Multiple Select in Edit Form

  88. How to obtain CRUD type in Ajax call after submit?

  89. How to Obtain Entire Datagrid Data as an Array?

  90. How to Receive PHPGrid Update Notice

  91. How to resolve MODx session issues

  92. How to Set Active Row During Page Load in Master Detail

  93. How to set the "select" col_edittype be readonly?

  94. How to show remaining characters in a field on the edit form?

  95. How to sort phpGrid Data on two columns

  96. How to tell what version of phpGrid I have?

  97. How to upgrade from phpGrid Basic to Professional, or from Professional to Enterprise?

  98. How to upgrade phpGrid from Basic to Professional, or from Professional to Enterprise?

  99. How to view Sql generated during CRUD?

  100. How to wrap text a cell?

  101. HTML source is displayed with WYSIWYG

  102. Huge Footer!

  103. I hav a problem using WHERE in my queries

  104. I have 3 different status (1,2 and 3) - I want to assign values to each.. active, inactive and archived .. how do I do this? If I set conditional statement , only the latest value works

  105. I just want to be able to adjust hours and minutes.

  106. I want checkbox columns to display as checkboxes, not 1's and 0's.

  107. inline editing limited to single cell

  108. Integrate phpGrid with MVC based frameworks such as Yii, Symphony, Laravel, Codeignitor, Zend Framework, CakePHP, Joomla, Drupal etc

  109. Integrated Search on Hitting Enter Key

  110. Is there a way to disable resorting all columns?

  111. Is there a way to round the avg format for the footer row?

  112. Joomla! Integration

  113. Keep PHP Session live

  114. Laravel Fatal error: Class 'C_DataGrid' not found in (PHP Namespace)

  115. Make Change to phpGrid Default CSS stylesheet

  116. Master Detail foreign key not populated on insert

  117. Master Detail layout - side by side

  118. Master Detail Table with Different Foreign Key

  119. Maths calculations

  120. Mergy Multiple Columns in A Single Column

  121. Microsoft SQL Server (MSSQL) Collation and Unicode Support

  122. Modx Evolution (CMS) Integration solution to share

  123. Move the Search Outside of the Grid

  124. Must fill every fields to save, or nothing gets saved!

  125. Nested grid relationship by date field

  126. Notice: Undefined variable: fkey or fkey_value in edit.php (MS SQL)

  127. Only top (first) row selectable

  128. Parse error

  129. Php Grid is not visible

  130. PHP Session

  131. Phpgrid - datepicker local customize

  132. phpGrid DB2 Starter or the phpGrid Full version?

  133. phpGrid fonts change

  134. phpGrid insert error - Need to hide primary key during edit

  135. phpGrid Installation and Setup

  136. PHPGrid referencing old server directory

  137. phpGrid support forum

  138. PHPGrid to go to a specific page during load

  139. phpGrid UNION query

  140. phpGrid with Stored Procedure

  141. phpGrid won't run with Sql Server

  142. phpGrid, Laravel 5 Integration: Class 'C_DataGrid' not found

  143. Prevent column being searchable

  144. Refresh without post

  145. Remove Alternative Row Color Completely

  146. Remove Duplicate Values in Group Summary

  147. Remove horizontal scroll when set_autowidth() is set to true

  148. Replacing Hyperlinks with Images

  149. Require fields border color

  150. Resize "View Record" display?

  151. Resize Grid According to Current Screen Size

  152. Resize Images Displayed In the Entire Grid

  153. Resize subgrid width

  154. Row Select Click Event

  155. Run custom jQuery AFTER the datagrid is loaded

  156. Save Columns Selected in Column Chooser

  157. Save Data in Calculated/Virtual Column to Database

  158. Save Local Data Array Back to Server via Ajax

  159. Save stored value in PHP Session when inserting

  160. Search Column that Uses Multiple Select

  161. Search Column that Uses Multiple Select

  162. Session.save_path for php.ini hosting at

  163. Set column visible in grid, but hide during edit

  164. Set datagrid to the width of its parent DIV

  165. Set field required based on another field value using events

  166. Set Minimum Width for Autocomplete edit type

  167. Set Row Height

  168. Set the grid width to the parent DIV

  169. set_col_edittype - Display a empty/blank value in dropdown

  170. set_locale not working

  171. set_query_filter not working in Subgrid

  172. Show a column as link based on value of another column

  173. Show Javascript Alert When a Row Is Clicked?

  174. Soft-delete record by flagging a value (Flag for delete)

  175. Sorting columns with Key-Value pairs when edit type is "select"

  176. Sorting columns with Key-Value pairs when edit type is "select"

  177. Special Characters in Non-English Collation in SQL Server

  178. SQL Server Field Name Truncated after 30 Characters

  179. Strict Mode Error Reporting Ovewrite

  180. subgrid blank add form?

  181. Suppress "Loading phpGrid..." messages

  182. The grid appears not to display the bottom line completely. I have tried increasing the pagination and the table dimensions but I'm still unable to see the bottom of the table.

  183. Tool tip for column headers

  184. Trigger PHP data grid refresh in time interval

  185. Unable to edit

  186. Undefined constant ODBC_BINMODE_RETURN and SQL_CUR_USE_DRIVER when running MS SQL Server

  187. Update another cell after save

  188. Update SQLite Doesn't Work

  189. Use arrow key to navigate a grid

  190. Use Custom Session Name

  191. Use Inner Join

  192. Using array_replace_recursive in PHP Version lower than 5.3

  193. Verify uniqueness of a new value entered when edited or added through phpGrid before saving

  194. Warning*: session_start(), Cannot send session cache limiter ...

  195. Warning: session_start() [function.session-start]: open(/var/php_sessions/) failed: No such file or directory (2) in /www/phpGrid/server/classes/cls_db.php(1) : eval()'d code on line 1

  196. Week start on Monday

  197. When to use Sql View?

  198. Where to obtain updates and invoices?

  199. Wordpress Plugin

  200. Working with Twitter Bootstrap

  201. WYSIWYG doesn't work

Feedback and Knowledge Base