Results

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();