Generate PHP array from SQL query with C_Database class
Here's a code snippet using C_Database class to generate PHP array. You should use it for database agnostic operations such as key value pairs used for nested dropdowns.
$sql = 'select
s.supplierCode, s.supplierZip, s.supplierPhonenumber,
spl.productLineNo, spl.productLine,
p.productName, p.MSRP
from suppliers s
inner join supplierproductlines spl on s.supplierName = spl.supplierName
inner join products p on s.supplierZip = p.supplierZip';
$db = new C_DataBase(PHPGRID_DB_HOSTNAME, PHPGRID_DB_USERNAME, PHPGRID_DB_PASSWORD, PHPGRID_DB_NAME, PHPGRID_DB_TYPE,PHPGRID_DB_CHARSET);
$results = $db->db_query($sql);
$data1 = array();
$count = 0;
while($row = $db->fetch_array_assoc($results)) {
$data_row = array();
for($i = 0; $i < $db->num_fields($results); $i++) {
$col_name = $db->field_name($results, $i);
$data1[$count][$col_name] = $row[$col_name];
}
$count++;
}Learn detail here: https://phpgrid.com/example/complex-query/