Database Utility Class¶

Initializing the Utility Class¶

Load the Utility Class as follows:

$this->load->dbutil();

You can also pass another database object to the DB Utility loader, in case the database you want to manage isn’t the default one:

$this->myutil = $this->load->dbutil($this->other_db, TRUE);

In the above example, we’re passing a custom database object as the first parameter and then tell it to return the dbutil object, instead of assigning it directly to $this->dbutil.

Once initialized you will access the methods using the $this->dbutil object:

$this->dbutil->some_method();

Using the Database Utilities¶

$dbs = $this->dbutil->list_databases();

foreach ($dbs as $db)
{
        echo $db;
}

if ($this->dbutil->database_exists('database_name'))
{
        // some code...
}

if ($this->dbutil->optimize_table('table_name'))
{
        echo 'Success!';
}

if ($this->dbutil->repair_table('table_name'))
{
        echo 'Success!';
}

$result = $this->dbutil->optimize_database();

if ($result !== FALSE)
{
        print_r($result);
}