All articles

  1. Access local array data source

  2. Account access, link to the latest version

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

  4. ADD missing in detail grid in INLINE mode

  5. Adding Totals on Local Array

  6. Advanced Search Date Comparison

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

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

  9. Align Datagrid Center on a Page

  10. Allow file upload to include files other than pictures

  11. Always Display Integrated Search Toolbar When Page Load

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

  13. Auto populate hidden fields

  14. autocomple off

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

  16. Browser Autofill interference

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

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

  19. Can't display grid in Internet Explorer 11

  20. Cannot activate phpgridlie under my wordpress

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

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

  23. Capture time stamp on submit

  24. Capture time stamp on submit

  25. Case insensitive search

  26. Catch Errors on the Sever Side

  27. CELL edit with add and delete buttons

  28. Center Add/Edit Form

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

  30. Change "Cancel" button behavior

  31. Change date display format

  32. Change edit properties without modifying the source code

  33. Change header row height

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

  35. Change Search Default Value

  36. Change set_col_frozen background transparency

  37. Clear nested grid after selection change in master-master grid

  38. Collapse Datagrid on Initial Display

  39. Column Order Position

  40. Compare again database NULL in set_conditional_value function

  41. Completely hide parent container's horizontal scrollbar

  42. Complex Sql Query

  43. Conditional border

  44. Conditional format - compare two cells

  45. Configuring Oracle

  46. Connect phpGrid to MS SQL Server from Linux

  47. Constant value in create/edit form

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

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

  50. Create nested dropdown array from database table

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

  52. Custom button in action column

  53. Custom Server Side Data Validation

  54. Customize Edit Form Layout

  55. Data bar solid color?

  56. Datagrid is not visible except the header and footer

  57. Datagrid row height does not change

  58. Datapicker displaying behind the edit form

  59. Datetime Format

  60. Dealing with very large datasets

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

  62. Default to last page on page load

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

  64. Deploying to GoDaddy

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

  66. Disable or cancel delete on row condition in FORM

  67. Disable the Entire Datagrid

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

  69. Display caption in subgrid (commercial license only)

  70. Display column in grid but hide when edit

  71. Display data from other columns with customer formatter

  72. Display datagrid somewhere else on the page

  73. Display field value from grid using custom event

  74. Display grid from multiples tables

  75. Display group summary without any detail records

  76. Display Icon/Image In a Virtual Column

  77. Display multiple grids from the same database table

  78. Display server error message during edit

  79. Display Value from URL Querystring Parameter

  80. Displaying Header vertically

  81. Displaying Header vertically

  82. Displaying TIMESTAMP Fields in an Editable Grid

  83. Dropdown Concatenation

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

  85. Edit Grid of a JOIN or a complex query

  86. Edit Master Detail Grid that Uses SQL Alias

  87. Edit not working

  88. Editable Datagrid with Add Only Ability

  89. Elongated grid when theme is set

  90. Empty value stored as NULL in Autocomplete

  91. Enable inline search by default

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

  93. Error: Class 'phpGrid\C_DataBase' not found

  94. Escape HTML characters in datagrid

  95. Example not working

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

  97. Expand All Subgrids on page load

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

  99. Export to EXCEL downloads XML file

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

  101. Fatal error: Class 'C_DataGrid' not found

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

  103. Fix group sum floating (decimal) issue

  104. Force grid to reload the after update

  105. Force Text to Upper Case Upon Submit

  106. Force Text to Upper Case Upon Submit

  107. Foreign characters display

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

  109. Generate PHP array from SQL query with C_Database class

  110. Get Selected Rows from Multiple Grids

  111. Get selected values of the grid view

  112. Get value from a specific cell from selected row

  113. getSelRows with some Phpgrids on the same windows

  114. Go to the last page on grid load

  115. Grid text align

  116. grid width issue

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

  118. Hide Icons and Change Caption Dynamically

  119. Horizontal scrollbar missing on tablet PCs/mobile devices

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

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

  122. How to add a row called total automatically?

  123. How to apply MD5 or SHA2 to a field

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

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

  126. How to center the grid

  127. How to change MySQL port

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

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

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

  131. How to disable column sort

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

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

  134. How to format text capitalization and other formats

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

  136. How to get grid names of the subgrids and detail grids?

  137. How to get new ID generated from insert?

  138. How to get the filter/search?

  139. How to grab the table rows in a grid

  140. How to include a user's ID "behind the scenes" during edit?

  141. How to include a user's ID "behind the scenes" during edit?

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

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

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

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

  146. How to Receive PHPGrid Update Notice

  147. How to resolve MODx session issues

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

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

  150. How to set up a hidden column to be searchable in advanced search?

  151. How to set up a hidden column to be searchable in advanced search?

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

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

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

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

  156. How to view Sql generated during CRUD?

  157. How to wrap text in a cell?

  158. HTML source is displayed with WYSIWYG

  159. Huge Footer!

  160. I hav a problem using WHERE in my queries

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

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

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

  164. Individual Column Color and Styling

  165. inline editing limited to single cell

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

  167. Integrated Search on Hitting Enter Key

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

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

  170. Joomla! Integration

  171. jqGrid undefined is not a function

  172. Keep edit form open after submit

  173. Keep PHP Session live

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

  175. Make Change to phpGrid Default CSS stylesheet

  176. Many-to-many relationship

  177. Master Detail foreign key not populated on insert

  178. Master Detail layout - side by side

  179. Master Detail Table with Different Foreign Key

  180. Maths calculations

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

  182. Missing CSS Map files

  183. Modx Evolution (CMS) Integration solution to share

  184. Move the Search Outside of the Grid

  185. Moved from mySQL to MSSQL showing "undefined" error message

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

  187. Need Invoice

  188. Nested grid relationship by date field

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

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

  191. Only top (first) row selectable

  192. Parse error

  193. PDF can not display Chinese character

  194. PHP Session

  195. Phpgrid - datepicker local customize

  196. phpGrid DB2 Starter or the phpGrid Full version?

  197. phpGrid fonts change

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

  199. phpGrid Installation and Setup

  200. phpGrid on Joomla

  201. phpGrid PostgreSQL support

  202. PHPGrid referencing old server directory

  203. phpGrid support forum

  204. PHPGrid to go to a specific page during load

  205. phpGrid UNION query

  206. phpGrid with Stored Procedure

  207. phpGrid won't run with Sql Server

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

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

  210. Prevent column being searchable

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

  212. Refresh without post

  213. Remove Alternative Row Color Completely

  214. Remove Duplicate Values in Group Summary

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

  216. Remove the associated files after deleting a row

  217. Replacing Hyperlinks with Images

  218. Require fields border color

  219. Resize "View Record" display?

  220. Resize Grid According to Current Screen Size

  221. Resize Images Displayed In the Entire Grid

  222. Resize subgrid width

  223. Row Select Click Event

  224. Run custom jQuery AFTER the datagrid is loaded

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

  226. Save Columns Selected in Column Chooser

  227. Save Data in Calculated/Virtual Column to Database

  228. Save Local Data Array Back to Server via Ajax

  229. Save stored value in PHP Session when inserting

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

  231. Search Column that Uses Multiple Select

  232. Search Column that Uses Multiple Select

  233. select list only shows 100 entries

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

  235. Set datagrid to the width of its parent DIV

  236. Set default value during Edit

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

  238. Set Minimum Width for Autocomplete edit type

  239. Set Row Height

  240. Set Scroll while freezing columns

  241. Set the grid width to the parent DIV

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

  243. set_form_dimension in Subgrid

  244. set_jq_editurl() or enable_edit example

  245. set_locale not working

  246. set_query_filter not working in Subgrid

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

  248. Show Javascript Alert When a Row Is Clicked?

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

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

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

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

  253. SQL Server Field Name Truncated after 30 Characters


  255. Strict Mode Error Reporting Ovewrite

  256. subgrid blank add form?

  257. Subgrid does not cascade deletion on child tables in Sqlite

  258. Suppress "Loading phpGrid..." messages

  259. The bottom of the grid has too much space

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

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

  262. Timezone Warning

  263. Tool tip for column headers

  264. Trigger PHP data grid refresh in time interval

  265. Unable to edit

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

  267. Unnecessary Space at the bottom of the phpGrid page

  268. Update another cell after save

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

  270. Update SQLite Doesn't Work

  271. Update subtotal after copy row

  272. Use arrow key to navigate a grid

  273. Use Custom Session Name

  274. Use Inner Join

  275. Using array_replace_recursive in PHP Version lower than 5.3

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

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

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

  279. Week start on Monday

  280. When to use Sql View?

  281. When to use Sql View?

  282. Where to enter discount code during checkout?

  283. Where to obtain updates and invoices?

  284. WordPress Integration

  285. Wordpress Plugin

  286. Working with Twitter Bootstrap

  287. WYSIWYG doesn't work

Feedback and Knowledge Base