[eluser]cpeele[/eluser]
Hey guys, I am very new to codeIgniter and am trying to get my page to display some database results but no rows show.
1) I have data in my database
2) I have set autoloading
3) Here is my database configuration:
Code:
$db['default']['hostname'] = "localhost";
$db['default']['username'] = "root";
$db['default']['password'] = "";
$db['default']['database'] = "qno";
$db['default']['dbdriver'] = "mysql";
$db['default']['dbprefix'] = "";
$db['default']['pconnect'] = TRUE;
$db['default']['db_debug'] = TRUE;
$db['default']['cache_on'] = FALSE;
$db['default']['cachedir'] = "";
$db['default']['char_set'] = "utf8";
$db['default']['dbcollat'] = "utf8_general_ci";
4) Here is my Controller
Code:
<?php
class Questions extends Controller
{
function index()
{
$data['query'] = $this->db->get('questions');
$this->load->view('questions', $data);
}
}
?>
5) Here is my view
Code:
<?php if($query->num_row() > 0): ?>
this does not show :(
<?php endif; ?>
<ul>
<?php foreach($query as $row): ?>
<li><?=$row->name?></li>
<?php endforeach; ?>
</ul>
6) Here is my output when I do a print_r($data);
Code:
Array ( [query] => CI_DB_mysql_result Object ( [conn_id] => Resource id #28 [result_id] => Resource id #29 [result_array] => Array ( ) [result_object] => Array ( ) [current_row] => 0 [num_rows] => 2 [row_data] => ) )
Please if anyone can help me I would really appreciate it. I would like to start using CI over CakePHP but I can't even get this to dispaly database results.
Thanks for any help,
Chris