Login

11-16-2010, 05:27 PM

[eluser]veritascs[/eluser]
Try something a little more simple (just to see if everything works). Using some examples from http://ellislab.com/codeigniter/user-gui...mples.html

database.php

Code:
$active_group = "default";

$active_record = TRUE;

$db['default']['hostname'] = "<hostname>";

$db['default']['username'] = "<username>";

$db['default']['password'] = "<password>";

$db['default']['database'] = "<databasename>";

$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";

controller testDB.php

Code:
&lt;?php

class testDB extends Controller {

    function index()

    {

        $this->load->database();

        $query = $this->db->query('SELECT product_id, product_name from products');

        foreach ($query->result() as $row)

        {

            echo $row->product_id;

            echo $row->product_name;

            echo "<br />";

        }

        echo 'Total Results: ' . $query->num_rows();

    }

}

/* End of file testDB.php */

/* Location: ./system/application/controllers/testDB.php */

Notice I have debug on and am not calling a model or view. Does something more simple like this work for you? //fyi http://wallaholics.ever-flow.net/testDB