// Fetch data from database $sql = "SELECT * FROM employees"; $result = $conn->query($sql);
// Connect to database $conn = new mysqli($dbHost, $dbUsername, $dbPassword, $dbName);
// Connect to database $conn = new mysqli($dbHost, $dbUsername, $dbPassword, $dbName); aggrid php example updated
I hope this helps! Let me know if you have any questions or need further clarification.
<!DOCTYPE html> <html> <head> <title>AG Grid PHP Example</title> <script src="https://unpkg.com/ag-grid-community/dist/ag-grid-community.min.noStyle.js"></script> <link rel="stylesheet" href="https://unpkg.com/ag-grid-community/dist/styles/ag-grid.css"> <link rel="stylesheet" href="https://unpkg.com/ag-grid-community/dist/styles/ag-theme-balham.css"> </head> <body> <div id="grid" style="height: 200px; width: 400px;" class="ag-theme-balham"></div> <script> // Fetch data from PHP script fetch('grid.php') .then(response => response.json()) .then(data => // Create AG Grid const gridOptions = columnDefs: [ field: 'name' , field: 'email' , field: 'department' ], rowData: data ; // Fetch data from database $sql = "SELECT
new agGrid.Grid(document.getElementById('grid'), gridOptions); ); </script> </body> </html> This HTML file includes the AG Grid library and creates a simple grid with three columns. It then fetches data from the "grid.php" script and passes it to the AG Grid.
Create an HTML file called "index.html" and add the following code: It then fetches data from the "grid
// Convert data to JSON $data = array(); while($row = $result->fetch_assoc()) $data[] = $row;