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. Allow file upload to include files other than pictures

  10. Always Display Integrated Search Toolbar When Page Load

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

  12. autocomple off

  13. Blank grid that Data is not showing up in MS SQL, MySql, DB2 or other database

  14. Browser Autofill interference

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

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

  17. Can't display grid in Internet Explorer 11

  18. Cannot activate phpgridlie under my wordpress

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

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

  21. Capture time stamp on submit

  22. Case insensitive search

  23. Catch Errors on the Sever Side

  24. CELL edit with add and delete buttons

  25. Center Add/Edit Form

  26. Center Edit Form and Display Scroll Bar in Bootstrap Theme

  27. Change date display format

  28. Change edit properties without modifying the source code

  29. Change header row height

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

  31. Change Search Default Value

  32. Change set_col_frozen background transparency

  33. Collapse Datagrid on Initial Display

  34. Column Order Position

  35. Compare again database NULL in set_conditional_value function

  36. Completely hide parent container's horizontal scrollbar

  37. Complex Sql Query

  38. Conditional format - compare two cells

  39. Configuring Oracle

  40. Connect phpGrid to MS SQL Server from Linux

  41. Constant value in create/edit form

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

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

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

  45. Custom button in action column

  46. Custom Server Side Data Validation

  47. Customize Edit Form Layout

  48. Data bar solid color?

  49. Datagrid is not visible except the header and footer

  50. Datapicker displaying behind the edit form

  51. Datetime Format

  52. Dealing with very large datasets

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

  54. Default to last page on page load

  55. Delete Callback - Delete some Files when record is deleted from a table

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

  57. Disable the Entire Datagrid

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

  59. Display caption in subgrid (commercial license only)

  60. Display column in grid but hide when edit

  61. Display datagrid somewhere else on the page

  62. Display field value from grid using custom event

  63. Display grid from multiples tables

  64. Display group summary without any detail records

  65. Display Icon/Image In a Virtual Column

  66. Display multiple grids from the same database table

  67. Display server error message during edit

  68. Display Value from URL Querystring Parameter

  69. Displaying Header vertically

  70. Displaying TIMESTAMP Fields in an Editable Grid

  71. Dropdown Concatenation

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

  73. Edit Grid of a JOIN or a complex query

  74. Edit Master Detail Grid that Uses SQL Alias

  75. Edit not working

  76. Editable Datagrid with Add Only Ability

  77. Elongated grid when theme is set

  78. Empty value stored as NULL in Autocomplete

  79. Enable inline search by default

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

  81. Escape HTML characters in datagrid

  82. Example not working

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

  84. Expand All Subgrids on page load

  85. Export Failed. Allowed memory size of xxxxxxxx bytes exhausted

  86. Export to EXCEL downloads XML file

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

  88. Fatal error: Class 'C_DataGrid' not found

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

  90. Fix group sum floating (decimal) issue

  91. Force grid to reload the after update

  92. Force Text to Upper Case Upon Submit

  93. Foreign characters display

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

  95. Generate PHP array from SQL query with C_Database class

  96. Get Selected Rows from Multiple Grids

  97. Get selected values of the grid view

  98. Get value from a specific cell from selected row

  99. Go to the last page on grid load

  100. Grid text align

  101. grid width issue

  102. Help! I still cannot get Nested Dropdown to work

  103. Hide Icons and Change Caption Dynamically

  104. Horizontal scrollbar missing on tablet PCs/mobile devices

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

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

  107. How to add a row called total automatically?

  108. How to apply MD5 or SHA2 to a field

  109. How to avoid error "Please enter a valid data type ..." when leaving the field blank

  110. How to center modal/pop-up edit form

  111. How to center the grid

  112. How to change MySQL port

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

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

  115. How to disable column sort

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

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

  118. How to format text capitalization and other formats

  119. How to get a selected row data in grid populated via local array source

  120. How to get new ID generated from insert?

  121. How to get the filter/search?

  122. How to grab the table rows in a grid

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

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

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

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

  127. How to Receive PHPGrid Update Notice

  128. How to resolve MODx session issues

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

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

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

  132. How to sort phpGrid Data on two columns

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

  134. How to upgrade from phpGrid Basic to Professional, or from Professional to other higher licenses?

  135. How to upgrade phpGrid from Basic to Professional, and higher licenses?

  136. How to view Sql generated during CRUD?

  137. How to wrap text in a cell?

  138. HTML source is displayed with WYSIWYG

  139. Huge Footer!

  140. I hav a problem using WHERE in my queries

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

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

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

  144. Individual Column Color and Styling

  145. inline editing limited to single cell

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

  147. Integrated Search on Hitting Enter Key

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

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

  150. Joomla! Integration

  151. jqGrid undefined is not a function

  152. Keep PHP Session live

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

  154. Make Change to phpGrid Default CSS stylesheet

  155. Master Detail foreign key not populated on insert

  156. Master Detail layout - side by side

  157. Master Detail Table with Different Foreign Key

  158. Maths calculations

  159. Mergy Multiple Columns in A Single Column

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

  161. Missing CSS Map files

  162. Modx Evolution (CMS) Integration solution to share

  163. Move the Search Outside of the Grid

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

  165. Need Invoice

  166. Nested grid relationship by date field

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

  168. Notification "saved successful" but doesn't create new record

  169. Only top (first) row selectable

  170. Parse error

  171. PHP Session

  172. Phpgrid - datepicker local customize

  173. phpGrid DB2 Starter or the phpGrid Full version?

  174. phpGrid fonts change

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

  176. phpGrid Installation and Setup

  177. phpGrid on Joomla

  178. phpGrid PostgreSQL support

  179. PHPGrid referencing old server directory

  180. phpGrid support forum

  181. PHPGrid to go to a specific page during load

  182. phpGrid UNION query

  183. phpGrid with Stored Procedure

  184. phpGrid won't run with Sql Server

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

  186. phpgrid.COM vs. phpgrid.ORG Huh?!?

  187. Prevent column being searchable

  188. Record when a recored is created and updated using Timestamp

  189. Refresh without post

  190. Remove Alternative Row Color Completely

  191. Remove Duplicate Values in Group Summary

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

  193. Remove the associated files after deleting a row

  194. Replacing Hyperlinks with Images

  195. Require fields border color

  196. Resize "View Record" display?

  197. Resize Grid According to Current Screen Size

  198. Resize Images Displayed In the Entire Grid

  199. Resize subgrid width

  200. Row Select Click Event

  201. Run custom jQuery AFTER the datagrid is loaded

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

  203. Save Columns Selected in Column Chooser

  204. Save Data in Calculated/Virtual Column to Database

  205. Save Local Data Array Back to Server via Ajax

  206. Save stored value in PHP Session when inserting

  207. Search by the Accented Characters such as à, Ê

  208. Search Column that Uses Multiple Select

  209. Search Column that Uses Multiple Select

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

  211. Set datagrid to the width of its parent DIV

  212. Set default value during Edit

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

  214. Set Minimum Width for Autocomplete edit type

  215. Set Row Height

  216. Set Scroll while freezing columns

  217. Set the grid width to the parent DIV

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

  219. set_form_dimension in Subgrid

  220. set_locale not working

  221. set_query_filter not working in Subgrid

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

  223. Show Javascript Alert When a Row Is Clicked?

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

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

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

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

  228. SQL Server Field Name Truncated after 30 Characters

  229. Strict Mode Error Reporting Ovewrite

  230. subgrid blank add form?

  231. Suppress "Loading phpGrid..." messages

  232. The edit form missing scroll bar when form is longer than the page

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

  234. Timezone Warning

  235. Tool tip for column headers

  236. Trigger PHP data grid refresh in time interval

  237. Unable to edit

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

  239. Update another cell after save

  240. Update column based on the changed value of another column

  241. Update SQLite Doesn't Work

  242. Update subtotal after copy row

  243. Use arrow key to navigate a grid

  244. Use Custom Session Name

  245. Use Inner Join

  246. Using array_replace_recursive in PHP Version lower than 5.3

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

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

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

  250. Week start on Monday

  251. When to use Sql View?

  252. Where to enter discount code during checkout?

  253. Where to obtain updates and invoices?

  254. WordPress Integration

  255. Wordpress Plugin

  256. Working with Twitter Bootstrap

  257. WYSIWYG doesn't work

Feedback and Knowledge Base