This topic contains 7 replies, has 4 voices, and was last updated by Yavor Dashev 3 years, 7 months ago.
Viewing 8 posts - 1 through 8 (of 8 total)
-
I am having trouble rendering my data into the grid layout. I am using PDO postgresql as my database call and I am able to successfully retrieve the data via a PHP call. However, I am having difficulty storing that data into my jqwidgets/jquery grid. The documentation on “Server Side Paging with jqxGrid using PHP” is outdated and not sure how to proceed.
The specific issue I am having is in my
index.phpfile where it is able to retrieve the data via PHP but I was unable to store that data into the grid.Here is an image without the data since I am not sure how to store that data into the grid:
This is my code thus far:
—
<?php require 'vendor/autoload.php'; use PostgreSQLTutorial\Connection as Connection; use PostgreSQLTutorial\CustomerDB as CustomerDB; try { $pdo = Connection::get()->connect(); $customerDB = new CustomerDB($pdo); $customers = $customerDB->findCustomer(1, 5); } catch (\PDOException $e) { echo $e->getMessage(); } ?> <!DOCTYPE html> <html> <head> <title>PostgreSQL PHP Querying Data Demo</title> <link rel="stylesheet" href="../jqwidgets/styles/jqx.base.css" type="text/css"/> <link rel="stylesheet" href="../jqwidgets/styles/jqx.classic.css" type="text/css"/> <meta name="viewport" content="width=device-width, initial-scale=1" /> <script type="text/javascript" src="../jqwidgets/jqxcore.js"></script> <script type="text/javascript" src="../jqwidgets/jqxbuttons.js"></script> <script type="text/javascript" src="../jqwidgets/jqxscrollbar.js"></script> <script type="text/javascript" src="../jqwidgets/jqxmenu.js"></script> <script type="text/javascript" src="../jqwidgets/jqxcheckbox.js"></script> <script type="text/javascript" src="../jqwidgets/jqxlistbox.js"></script> <script type="text/javascript" src="../jqwidgets/jqxdropdownlist.js"></script> <script type="text/javascript" src="../jqwidgets/jqxgrid.js"></script> <script type="text/javascript" src="../jqwidgets/jqxgrid.pager.js"></script> <script type="text/javascript" src="../jqwidgets/jqxgrid.selection.js"></script> <script type="text/javascript" src="../jqwidgets/jqxdata.js"></script> <script type="text/javascript"> $(document).ready(function () { // prepare the data var theme = 'classic'; var source = { datatype: "json", datafields: [ { name: 'CompanyName' }, { name: 'ContactName' }, { name: 'ContactTitle' }, { name: 'City' }, { name: 'Country' } ], cache: false, url: 'CustomerDB.php', root: 'Rows', beforeprocessing: function (data) { var data = <?php echo json_encode($customers); ?>; source.totalrecords = data[0].TotalRows; } }; var dataadapter = new $.jqx.dataAdapter(source); // initialize jqxGrid $("#jqxgrid").jqxGrid( { width: 600, source: dataadapter, theme: theme, autoheight: true, pageable: true, virtualmode: true, rendergridrows: function (params) { return params.data; }, columns: [ { text: 'Company Name', datafield: 'CompanyName', width: 250 }, { text: 'Contact Name', datafield: 'ContactName', width: 200 }, { text: 'Contact Title', datafield: 'ContactTitle', width: 200 }, { text: 'City', datafield: 'City', width: 100 }, { text: 'Country', datafield: 'Country', width: 140 } ] }); }); </script> </head> <body class='default'> <div id="jqxgrid"></div> </body> </html>—
<?php namespace PostgreSQLTutorial; /** * Create table in PostgreSQL from PHP demo */ class CustomerDB { private $pdo; /** * init the object with a \PDO object * @param type $pdo */ public function __construct($pdo) { $this->pdo = $pdo; } /** * Return customer rows during pagnation * @return array */ public function findCustomer($pagenum, $pagesize) { $starts = $pagenum * $pagesize; $stmt = $this->pdo->prepare('SELECT "CompanyName", "ContactName", "ContactTitle", "City", "Country" FROM customers LIMIT :starts OFFSET :pagesize'); $stmt->bindValue(':starts', $starts); $stmt->bindValue(':pagesize', $pagesize); $stmt->execute(); $customers = []; while ($row = $stmt->fetch(\PDO::FETCH_ASSOC)) { $customers[] = [ 'CompanyName' => $row['CompanyName'], 'ContactName' => $row['ContactName'], 'ContactTitle' => $row['ContactTitle'], 'City' => $row['City'], 'Country' => $row['Country'] ]; } return $customers; } }
Viewing 8 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic.