All articles

  1. Access local array data source

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

  3. ADD missing in detail grid in INLINE mode

  4. Adding Totals on Local Array

  5. Advanced Search Date Comparison

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

  7. Ajax .post() does not return results right away

  8. Align Datagrid Center on a Page

  9. Always Display Integrated Search Toolbar When Page Load

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

  11. autocomple off

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

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

  14. Can't display grid in Internet Explorer 11

  15. Cannot activate phpgridlie under my wordpress

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

  17. Cannot save or edit records. How to debug?

  18. Capture time stamp on submit

  19. Case insensitive search

  20. Catch Errors on the Sever Side

  21. Center Add/Edit Form

  22. Change date display format

  23. Change edit properties without modifying the source code

  24. Change header row height

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

  26. Change Search Default Value

  27. Change set_col_frozen background transparency

  28. Collapse Datagrid on Initial Display

  29. Column Color

  30. Column Order Position

  31. Compare again database NULL in set_conditional_value function

  32. Complex Sql Query

  33. Conditional format - compare two cells

  34. Configuring Oracle

  35. Connect phpGrid to MS SQL Server from Linux

  36. Constant value in create/edit form

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

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

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

  40. Custom button in action column

  41. Custom Server Side Data Validation

  42. Customize Edit Form Layout

  43. Data bar solid color?

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

  45. Datapicker displaying behind the edit form

  46. Datetime Format

  47. Dealing with very large datasets

  48. Declaration of ReplaceProcessor::process() is not compatible

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

  50. Disable the Entire Datagrid

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

  52. Display caption in subgrid (Enterprise license only)

  53. Display column in grid but hide when edit

  54. Display datagrid somewhere else on the page

  55. Display field value from grid using custom event

  56. Display grid from multiples tables

  57. Display group summary without any detail records

  58. Display Icon/Image In a Virtual Column

  59. Display multiple grids from the same database table

  60. Display Value from URL Querystring Parameter

  61. Displaying Header vertically

  62. Displaying TIMESTAMP Fields in an Editable Grid

  63. Dropdown Concatenation

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

  65. Edit Grid of a JOIN or a complex query

  66. Edit Master Detail Grid that Uses SQL Alias

  67. Edit not working

  68. Editable Datagrid with Add Only Ability

  69. Elongated grid when theme is set

  70. Empty value stored as NULL in Autocomplete

  71. Enable inline search by default

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

  73. Escape HTML characters in datagrid

  74. Example not working

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

  76. Expand All Subgrids on page load

  77. Export to EXCEL downloads XML file

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

  79. Fatal error: Class 'C_DataGrid' not found

  80. Fatal error: Declaration of DuplicateProcessor::process($tokens) must be compatible with SetProcessor::process($tokens, $isUpdate = false)

  81. Fix group sum floating (decimal) issue

  82. Foreign characters display

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

  84. Generate PHP array from SQL query with C_Database class

  85. Get Selected Rows from Multiple Grids

  86. Get selected values of the grid view

  87. Get value from a specific cell from selected row

  88. Go to the last page on grid load

  89. Grid text align

  90. grid width issue

  91. Hide Icons and Change Caption Dynamically

  92. Horizontal scrollbar missing on tablet PCs/mobile devices

  93. How do I make lookup fields (id fields referencing to other table) make dropdown from other table?

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

  95. How to add a row called total automatically?

  96. How to center the grid

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

  98. How to Create a Confirm Dialog Box Before Submit a Change?

  99. How to disable column sort

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

  101. How to fix PHP Fatal error: Class 'C_DataGrid' not found

  102. How to format text capitalization and other formats

  103. How to get new ID generated from insert?

  104. How to grab the table rows in a grid

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

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

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

  108. How to preserve a value of NULL as on update as it is being set to 0

  109. How to Receive PHPGrid Update Notice

  110. How to resolve MODx session issues

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

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

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

  114. How to sort phpGrid Data on two columns

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

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

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

  118. How to view Sql generated during CRUD?

  119. How to wrap text a cell?

  120. HTML source is displayed with WYSIWYG

  121. Huge Footer!

  122. I hav a problem using WHERE in my queries

  123. 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

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

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

  126. inline editing limited to single cell

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

  128. Integrated Search on Hitting Enter Key

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

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

  131. Joomla! Integration

  132. Keep PHP Session live

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

  134. Make Change to phpGrid Default CSS stylesheet

  135. Master Detail foreign key not populated on insert

  136. Master Detail layout - side by side

  137. Master Detail Table with Different Foreign Key

  138. Maths calculations

  139. Mergy Multiple Columns in A Single Column

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

  141. Missing CSS Map files

  142. Modx Evolution (CMS) Integration solution to share

  143. Move the Search Outside of the Grid

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

  145. Need Invoice

  146. Nested grid relationship by date field

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

  148. Only top (first) row selectable

  149. Parse error

  150. Php Grid is not visible

  151. PHP Session

  152. Phpgrid - datepicker local customize

  153. phpGrid DB2 Starter or the phpGrid Full version?

  154. phpGrid fonts change

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

  156. phpGrid Installation and Setup

  157. PHPGrid referencing old server directory

  158. phpGrid support forum

  159. PHPGrid to go to a specific page during load

  160. phpGrid UNION query

  161. phpGrid with Stored Procedure

  162. phpGrid won't run with Sql Server

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

  164. Prevent column being searchable

  165. Refresh the grid after submit

  166. Refresh without post

  167. Remove Alternative Row Color Completely

  168. Remove Duplicate Values in Group Summary

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

  170. Replacing Hyperlinks with Images

  171. Require fields border color

  172. Resize "View Record" display?

  173. Resize Grid According to Current Screen Size

  174. Resize Images Displayed In the Entire Grid

  175. Resize subgrid width

  176. Row Select Click Event

  177. Run custom jQuery AFTER the datagrid is loaded

  178. Sample code to save local array back to database with custom edit script

  179. Save Columns Selected in Column Chooser

  180. Save Data in Calculated/Virtual Column to Database

  181. Save Local Data Array Back to Server via Ajax

  182. Save stored value in PHP Session when inserting

  183. Search Column that Uses Multiple Select

  184. Search Column that Uses Multiple Select

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

  186. Set datagrid to the width of its parent DIV

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

  188. Set Minimum Width for Autocomplete edit type

  189. Set Row Height

  190. Set the grid width to the parent DIV

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

  192. set_locale not working

  193. set_query_filter not working in Subgrid

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

  195. Show Javascript Alert When a Row Is Clicked?

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

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

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

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

  200. SQL Server Field Name Truncated after 30 Characters

  201. Strict Mode Error Reporting Ovewrite

  202. subgrid blank add form?

  203. Suppress "Loading phpGrid..." messages

  204. 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.

  205. Tool tip for column headers

  206. Trigger PHP data grid refresh in time interval

  207. Unable to edit

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

  209. Update another cell after save

  210. Update SQLite Doesn't Work

  211. Use arrow key to navigate a grid

  212. Use Custom Session Name

  213. Use Inner Join

  214. Using array_replace_recursive in PHP Version lower than 5.3

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

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

  217. 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

  218. Week start on Monday

  219. When to use Sql View?

  220. Where to obtain updates and invoices?

  221. Wordpress Plugin

  222. Working with Twitter Bootstrap

  223. WYSIWYG doesn't work

Feedback and Knowledge Base