this db query codeigneter return code example
Example: get results from db and put in javascript array codeigniter
$query = $this->db->query("YOUR QUERY");
foreach ($query->result_array() as $row)
{
echo $row['title'];
echo $row['name'];
echo $row['body'];
}