There are several ways to generate query results.
result
Get result set.
// Get products as array
$products = $this->db->query("SELECT * FROM `:prefix:products`")->result();
foreach ( $products as $product )
{
echo $product['id']
}
// Get products as objects
$products = $this->db->query("SELECT * FROM `:prefix:products`")->result('object');
foreach ( $products as $product )
{
echo $product->id;
}
row
Get result set row.
// Get product as array
$product = $this->db->query("SELECT * FROM `:prefix:products` WHERE id=5 LIMIT 1")->row();
echo $product['id'];
// Get product as object
$product = $this->db->query("SELECT * FROM `:prefix:products` WHERE id=5 LIMIT 1")->row(0, 'object');
echo $product->id;
// Get row with the index of 3 in the products array
$product = $this->db->query("SELECT * FROM `:prefix:products`")->row(3);
echo $product['id'];
totalRows
Get total number of rows.
$products = $this->db->query("SELECT * FROM `:prefix:products`");
echo $products->totalRows();