Instructions to install & run ezSQL within codeigniter

-------------------------------------------------------

1) Download ezSQL from here: http://ezsql.jvmultimedia.com/ & Unzip

3) Move: ezsql/shared/ez_sql_core.php -- To: application/helpers/ez_sql_core_helper.php

4) Edit: application/config/autoload.php

- Edit $autoload['helper'] to look like so...

- $autoload['helper'] = array('ez_sql_core');

- Edit $autoload['libraries'] to look like so...

- $autoload['libraries'] = array('database','ezsql_codeigniter');

5) At the top of your controller (in the constructor) add the following two lines

$this->load->library('ezsql_codeigniter');

$this->ezsql = new ezSQL_codeigniter;

6) Hey presto

Now you can use ezSQL in any of your controller functions like so...

function index()

{

global $db;

$db->get_var("SELECT CURDATE()");

$db->debug();

}

or you can do this...

function index()

{

$this->ezsql->get_var("SELECT CURDATE()");

$this->ezsql->debug();

}

Important 1!

All the database configuration is done via codeigniter see...

http://codeigniter.com/user_guide/database/configuration.html

Important 2!

It doesn't matter what type of database you connect to (mySQL / Oracle etc) ezsql

works the same - the db type is configured in codeigniter NOT ezSQL

Have fun!