+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Archived Discussions (https://forum.codeigniter.com/forumdisplay.php?fid=20)
+--- Forum: Archived Development & Programming (https://forum.codeigniter.com/forumdisplay.php?fid=23)
+--- Thread: Passing to json_encode an array of all the MySQL table rows generated by row_array() (/showthread.php?tid=60317)
Passing to json_encode an array of all the MySQL table rows generated by row_array() - El Forum - 02-28-2014
[eluser]Unknown[/eluser]
Hello guys, my first post here with the hope you can help me out for a problem I've been having.
What I need to do is to pass to json_encode an array, that is the result of the row_array() function.
In my model, in fact, i have a very simple function
Code:
public function tuttiProdotti()
{
$q = $this->db->query('SELECT * FROM products');
if( $q->num_rows() > 0 )
{
return $q->row_array();
}
return FALSE;
}That gives to my controller an array with more than one row. In the function of my controller I have
Code:
if($item = $this->inventories_model->tuttiProdotti()) {
$product_name = $item['name'];
$product_cost = $item['cost'];
$product_tax = $item['tax_rate'];
$tax_rate = $this->inventories_model->getTaxRateByID($product_tax);
$product = array('name' => $product_name, 'cost' => $product_cost, 'tax_rate' => $tax_rate);
}
echo json_encode($product);As you may expect this gives to my json_encode datas for only one row (I think the last selected row?) while I want to pass it an array, made itself of ARRAYS (the $product variable).
Any help to find out how to achieve this, and how to retreive the data in a later phase, would be greatly appreciated.
I hope you can help me go out of this mess!
Passing to json_encode an array of all the MySQL table rows generated by row_array() - El Forum - 02-28-2014
[eluser]InsiteFX[/eluser]
Code:
$product = array();
if ($item = $this->inventories_model->tuttiProdotti())
{
foreach ($item as $row)
{
$product_name = $row['name'];
$product_cost = $row['cost'];
$product_tax = $row['tax_rate'];
$tax_rate = $this->inventories_model->getTaxRateByID($product_tax);
//$product = array('name' => $product_name, 'cost' => $product_cost, 'tax_rate' => $tax_rate);
$product['name'] = $product_name;
$product['cost'] = $product_cost;
$product['tax_rate'] = $tax_rate;
}
}
echo json_encode($product);When dealing with data like that you need to use a foreach loop.
So it would be something like that. Not tested.
Passing to json_encode an array of all the MySQL table rows generated by row_array() - El Forum - 02-28-2014
[eluser]InsiteFX[/eluser]
You can read more about it here:
CodeIgniter User Guide - Generating Query Results
Passing to json_encode an array of all the MySQL table rows generated by row_array() - El Forum - 02-28-2014
[eluser]InsiteFX[/eluser]
Duplicate post please delete