Aggrid Php Example Updated Jun 2026

Create an index.html file using AG Grid v31+ with the server-side row model.

AG Grid is one of the most powerful JavaScript data grids available today. When combined with a PHP backend, it becomes an enterprise-grade solution for displaying, filtering, sorting, and paginating large datasets. This updated example demonstrates how to integrate AG Grid with a modern PHP backend (using MySQL/MariaDB) while leveraging the latest features of both technologies.

if (!empty($whereClauses)) $whereStr = " WHERE " . implode(" AND ", $whereClauses); $sql .= $whereStr; $countSql .= $whereStr;

Used json_decode(file_get_contents('php://input')) for robust asynchronous request handling. aggrid php example updated

: Always enforce accurate typing in your PHP outputs. Wrap metrics like IDs or Salaries in integer fields within your MySQL schemas so JavaScript parses filters properly without text casting errors.

"rows": [...], "lastRow": 1542

CREATE TABLE `products` ( `id` int NOT NULL AUTO_INCREMENT, `product_name` varchar(255) NOT NULL, `category` varchar(100) NOT NULL, `price` decimal(12,2) NOT NULL, `stock_quantity` int NOT NULL, `last_updated` timestamp NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`), KEY `idx_category` (`category`), KEY `idx_price` (`price`) ); Create an index

By adopting these strategies, you can build data grids that remain snappy and responsive even with millions of records.

const datasource = getRows: async (params) => const response = await fetch('server-side-api.php', method: 'POST', headers: 'Content-Type': 'application/json' , body: JSON.stringify( startRow: params.request.startRow, endRow: params.request.endRow, sortModel: params.request.sortModel, filterModel: params.request.filterModel ) ); const data = await response.json(); if (data.success) params.successCallback(data.rows, data.lastRow); else params.failCallback();

echo json_encode($rows); catch (PDOException $e) http_response_code(500); echo json_encode(['error' => 'Database error']); This updated example demonstrates how to integrate AG

This guide provides a integration between AG Grid (v31+) and PHP 8.2+ using:

| Action | AG Grid Request parameter | PHP handling | |--------|--------------------------|---------------| | Sort | sortModel: [colId:"price", sort:"desc"] | Builds ORDER BY price DESC | | Text filter | filterModel: product_name: filter: "laptop", type: "contains" | product_name LIKE '%laptop%' | | Number filter | filterModel: price: filter: 100, type: "greaterThan" | price > 100 | | Date filter | filterModel: last_updated: dateFrom: "2024-01-01" | DATE(last_updated) >= '2024-01-01' | | Pagination | startRow: 200, endRow: 300 | LIMIT 100 OFFSET 200 |

The AG Grid configuration that consumes the JSON. 1. Setup the Database

Do you need to implement or Server-Side Filtering to handle millions of rows?