Ag-grid Php Example Here

<?php require_once 'config.php'; $input = json_decode(file_get_contents('php://input'), true);

// Execute main query $stmt = $pdo->prepare($sql); foreach ($params as $key => $value) { $stmt->bindValue($key, $value); } $stmt->execute(); $rows = $stmt->fetchAll(PDO::FETCH_ASSOC); ag-grid php example

// Apply pagination $sql .= " LIMIT $limit OFFSET $startRow"; ?php require_once 'config.php'

// Grid configuration const gridOptions = { columnDefs: columnDefs, rowModelType: 'serverSide', serverSideStoreType: 'partial', cacheBlockSize: 100, pagination: true, paginationPageSize: 100, enableSorting: true, enableFilter: true, animateRows: true, onGridReady: function(params) { params.api.setServerSideDatasource(dataSource); } }; $input = json_decode(file_get_contents('php://input')

// Get total row count $countSql = str_replace("SELECT * FROM", "SELECT COUNT(*) as total FROM", $sql); $stmt = $pdo->prepare($countSql); foreach ($params as $key => $value) { $stmt->bindValue($key, $value); } $stmt->execute(); $totalRows = $stmt->fetch(PDO::FETCH_ASSOC)['total'];

$limit = $endRow - $startRow;

<?php require_once 'config.php'; $input = json_decode(file_get_contents('php://input'), true);

// Execute main query $stmt = $pdo->prepare($sql); foreach ($params as $key => $value) { $stmt->bindValue($key, $value); } $stmt->execute(); $rows = $stmt->fetchAll(PDO::FETCH_ASSOC);

// Apply pagination $sql .= " LIMIT $limit OFFSET $startRow";

$limit = $endRow - $startRow;