Skip to content

All articles

← Knowledge Base

  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. Call to undefined function PhpOffice\PhpSpreadsheet\Shared\mb_strlen()

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

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

  20. Can't display grid in Internet Explorer 11

  21. Cannot activate phpgridlie under my wordpress

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

  23. Cannot save or edit records. How to debug to reveal SQL error details?

  24. Capture time stamp on submit

  25. Capture time stamp on submit

  26. Case insensitive search

  27. Catch Errors on the Sever Side

  28. CELL edit with add and delete buttons

  29. Center Add/Edit Form

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

  31. Change "Cancel" button behavior

  32. Change date display format

  33. Change edit properties without modifying the source code

  34. Change header row height

  35. Change locale for Calendar datepicker

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

  37. Change Search Default Value

  38. Change set_col_frozen background transparency

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

  40. Collapse Datagrid on Initial Display

  41. Column Order Position

  42. Compare again database NULL in set_conditional_value function

  43. Completely hide parent container's horizontal scrollbar

  44. Complex Sql Query

  45. Composer install did not install autoload.php and all the dependencies

  46. Conditional border

  47. Conditional format - compare two cells

  48. Configuring Oracle

  49. Connect phpGrid to MS SQL Server from Linux

  50. Constant value in create/edit form

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

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

  53. Create nested dropdown array from database table

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

  55. Currency conversion

  56. Custom button in action column

  57. Custom Server Side Data Validation

  58. Customize Edit Form Layout

  59. Data bar solid color?

  60. Datagrid is not visible except the header and footer

  61. Datagrid row height does not change

  62. Datapicker displaying behind the edit form

  63. Date Picker does not seem to allow for Future Years by Default

  64. Datepicker selectable years range is only from 1972 to current year.

  65. Datetime Format

  66. Dealing with very large datasets

  67. Declaration of ADODB_db2::_query(&$sql, $inputarr = false) not compatible

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

  69. Default to last page on page load

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

  71. Demo Web Install Issue

  72. Deploying to GoDaddy

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

  74. Disable or cancel delete on row condition in FORM

  75. Disable or cancel delete on row condition in FORM

  76. Disable the Entire Datagrid

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

  78. Display caption in subgrid (commercial license only)

  79. Display column in grid but hide when edit

  80. Display data from other columns with customer formatter

  81. Display datagrid somewhere else on the page

  82. Display field value from grid using custom event

  83. Display grid from multiples tables

  84. Display group summary without any detail records

  85. Display Icon/Image In a Virtual Column

  86. Display less columns in mobile device

  87. Display multiple grids from the same database table

  88. Display server error message during edit

  89. Display Value from URL Querystring Parameter

  90. Displaying Header vertically

  91. Displaying Header vertically

  92. Displaying millions of records with row count

  93. Displaying TIMESTAMP Fields in an Editable Grid

  94. Dropdown Concatenation

  95. Dynamic Details Grid Caption

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

  97. Dynamic Subgrid Caption

  98. Edit Grid of a JOIN or a complex query

  99. Edit Master Detail Grid that Uses SQL Alias

  100. Edit not working

  101. Editable Datagrid with Add Only Ability

  102. Elongated grid when theme is set

  103. Empty value stored as NULL in Autocomplete

  104. Enable inline search by default

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

  106. Error when deleting row in Inventory Management demo app

  107. Error: Class 'C_DataGrid' not found in (PHP Namespace)

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

  109. Escape HTML characters in datagrid

  110. Example not working

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

  112. Expand All Subgrids on page load

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

  114. Export in Excel with .xml format?

  115. Export to EXCEL downloads XML file

  116. Fatal error: Call to undefined function mysql_connect() "...r\adodb5\drivers\adodb-mysql.inc.php on line 364

  117. Fatal error: Class 'C_DataGrid' not found

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

  119. File upload - Uncaught ReferenceError; possible file upload attack

  120. FIND not work with Inner Join

  121. FIND not work with Inner Join

  122. Firebird Install & Setup on MacOS

  123. Firebird Install & Setup on Windows

  124. Fix group sum floating (decimal) issue

  125. Force grid to reload the after update

  126. Force Text to Upper Case Upon Submit

  127. Force Text to Upper Case Upon Submit

  128. Foreign characters display

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

  130. Generate PHP array from SQL query with C_Database class

  131. Get Selected Rows from Multiple Grids

  132. Get selected values of the grid view

  133. Get value from a specific cell from selected row

  134. getSelRows with some Phpgrids on the same windows

  135. Go to the last page on grid load

  136. Grid text align

  137. grid width issue

  138. Height of cell in form edit

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

  140. Hide Icons and Change Caption Dynamically

  141. Horizontal scrollbar missing on tablet PCs/mobile devices

  142. How can I save the username of the user who modifies the row during edit?

  143. How can I test grid before buying it?

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

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

  146. How to add a row called total automatically?

  147. How to add header to column alias, and how to hide it?

  148. How to apply MD5 or SHA2 to a field

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

  150. How to call custom edit form

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

  152. How to center the grid

  153. How to center the grid

  154. How to change MySQL port

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

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

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

  158. How to disable column sort

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

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

  161. How to format text capitalization and other formats

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

  163. How to get currently selected row?

  164. How to get grid name/id of the subgrids and detail grids?

  165. How to get new ID generated from insert?

  166. How to get the filter/search?

  167. How to grab the table rows in a grid

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

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

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

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

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

  173. How to Receive PHPGrid Update Notice

  174. How to resolve MODx session issues

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

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

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

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

  179. How to setup Laravel 10 Inventory app (IMS)

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

  181. How to style a form input element

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

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

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

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

  186. How to view Sql generated during CRUD?

  187. How to wrap text in a cell?

  188. HTML source is displayed with WYSIWYG

  189. Huge Footer!

  190. I hav a problem using WHERE in my queries

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

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

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

  194. Individual Column Color and Styling

  195. inline editing limited to single cell

  196. Install phpGrid complains vendor folder is missing.

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

  198. Integrated search not working with query with JOIN

  199. Integrated Search on Hitting Enter Key

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

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

  202. Joomla! Integration

  203. jqGrid undefined is not a function

  204. Keep edit form open after submit

  205. Keep edit form open after submit

  206. Keep PHP Session live

  207. Large select/dropdown, but select list only shows first 100 entries

  208. Make Change to phpGrid Default CSS stylesheet

  209. Many-to-many relationship

  210. Master Detail foreign key not populated on insert

  211. Master Detail layout - side by side

  212. Master Detail Table with Different Foreign Key

  213. Maths calculations

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

  215. Missing CSS Map files

  216. Modx Evolution (CMS) Integration solution to share

  217. Move the Search Outside of the Grid

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

  219. Multiple files upload support

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

  221. Need Invoice

  222. Nested grid relationship by date field

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

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

  225. Only top (first) row selectable

  226. Open PDF export in a new tab?

  227. Parse error

  228. PDF can not display Chinese character

  229. PHP Session

  230. phpCtrl/C_Session not found

  231. Phpgrid - datepicker local customize

  232. phpGrid DB2 Starter or the phpGrid Full version?

  233. phpGrid fonts change

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

  235. phpGrid Installation and Setup

  236. phpGrid Laravel 10 Integration?

  237. phpGrid on Joomla

  238. phpGrid PostgreSQL support

  239. PHPGrid referencing old server directory

  240. phpGrid support forum

  241. PHPGrid to go to a specific page during load

  242. phpGrid UNION query

  243. phpGrid with Stored Procedure

  244. phpGrid won't run with Sql Server

  245. phpGrid works with Lite version but fails to run in Premium version

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

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

  248. Prevent column being searchable

  249. Quotes in table names and fields names in Postgres

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

  251. Refresh without post

  252. Reload grid after changing view

  253. Remove Alternative Row Color Completely

  254. Remove Duplicate Values in Group Summary

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

  256. Remove the associated files after deleting a row

  257. Replacing Hyperlinks with Images

  258. Require fields border color

  259. Resize "View Record" display?

  260. Resize Grid According to Current Screen Size

  261. Resize Images Displayed In the Entire Grid

  262. Resize images uploaded after Ajax file upload

  263. Resize subgrid width

  264. ROW DELETE

  265. Row Select Click Event

  266. Run custom jQuery AFTER the datagrid is loaded

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

  268. Save Columns Selected in Column Chooser

  269. Save Data in Calculated/Virtual Column to Database

  270. Save Local Data Array Back to Server via Ajax

  271. Save stored value in PHP Session when inserting

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

  273. Search Column that Uses Multiple Select

  274. Search Column that Uses Multiple Select

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

  276. Set datagrid to the width of its parent DIV

  277. Set default value during Edit

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

  279. Set Minimum Width for Autocomplete edit type

  280. Set Row Height

  281. Set Scroll while freezing columns

  282. Set the grid width to the parent DIV

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

  284. set_form_dimension in Subgrid

  285. set_form_dimension issue in bootstrap theme

  286. set_jq_editurl() or enable_edit example

  287. set_locale not working

  288. set_query_filter not working in Subgrid

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

  290. Show Javascript Alert When a Row Is Clicked?

  291. Soft Delete (flag to delete but keep the record)

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

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

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

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

  296. SQL Server Field Name Truncated after 30 Characters

  297. SSL/TLS CONNECTION TO DB

  298. Store and Display Persian Numbers

  299. Strict Mode Error Reporting Ovewrite

  300. subgrid blank add form?

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

  302. Support case sensitive or insensitive search

  303. Suppress "Loading phpGrid..." messages

  304. The bottom of the grid has too much space

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

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

  307. Timezone Warning

  308. Tool tip for column headers

  309. Trigger another php file via AJAX after delete?

  310. Trigger PHP data grid refresh in time interval

  311. Unable to edit

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

  313. Unnecessary Space at the bottom of the phpGrid page

  314. Update another cell after save

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

  316. Update Credit Card

  317. Update SQLite Doesn't Work

  318. Update subtotal after copy row

  319. Use arrow key to navigate a grid

  320. Use Custom Session Name

  321. Use Inner Join

  322. User Management - Log username

  323. User Management settings

  324. Using array_replace_recursive in PHP Version lower than 5.3

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

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

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

  328. Week start on Monday

  329. When to use Sql View?

  330. When to use Sql View?

  331. Where to enter discount code during checkout?

  332. Where to keep phpGrid in Laravel?

  333. Where to obtain updates and invoices?

  334. WordPress Integration

  335. Wordpress Plugin

  336. Working with Twitter Bootstrap

  337. Would my system continue to work after license expires? Will it stop working?

  338. WYSIWYG doesn't work

Feedback and Knowledge Base

(thinking…)