UPDATED 2/13: Added License (MIT) Info to code
UPDATED 1/13: Changed ‘required’ ‘required_once’ to avoid errors of redeclaring CI_DBforge
I am working on a project in CodeIgniter that requires use of the database forge class to create/modify/delete database tables. Because the project makes use of database transactions, creating tables with the MYISAM engine was not going to work. So I was faced with two choices: Make all the database creation, etc run by manual queries such as
CREATE TABLE `blah`...
or extend the dbforge class. After some tinkering about I finally managed to successfully do this. Here’s how:
(Note: I am using CI 2. This also assumes you are somewhat familiar with extending CI classes)
- Create a MY_Loader.php file in application/core (or open it if you already have one).
- If you had to create the MY_Loader file, paste the following:
<?php if ( ! defined('BASEPATH')) exit('No direct script access allowed');
class MY_Loader extends CI_Loader {
}
- Paste the following in your MY_Loader file:
/**
* Extend the Database Forge Class
*
* @access public
* @author (Original) EllisLabs / (Extension) J Elmore
* @license MIT
* @version 1.0
* @return string
*/
function dbforge()
{
if ( ! class_exists('CI_DB'))
{
$this->database();
}$CI =& get_instance();
$class = 'CI_DB_'.$CI->db->dbdriver.'_forge';require_once BASEPATH.'database/DB_forge'.EXT;
require_once BASEPATH.'database/drivers/'.$CI->db->dbdriver.'/'.$CI->db->dbdriver.'_forge'.EXT;if( file_exists(APPPATH.'database/drivers/'.$CI->db->dbdriver.'/'.$CI->db->dbdriver.'_forge'.EXT) ) {
require_once APPPATH.'database/drivers/'.$CI->db->dbdriver.'/'.$CI->db->dbdriver.'_forge'.EXT;
$class = 'DB_'.$CI->db->dbdriver.'_forge';
}$CI->dbforge = new $class();
}
This basically adds the code to find/include the extended class, and instantiate it -
Next you need to create some folders in your application directory. First, create the folder database. Then, within the database folder, you’ll need to create a drivers folder. Within the drivers folder you’ll need to create a folder for the database type (mysql, mssql, etc) you are using. Since I am using MySQL, I created a mysql folder. My folder structure, then, looked like this:
application/
-->database/
----->drivers/
-------->mysql/
- In the driver folder you created (in my case, the mysql folder), create a file in the format _forge.php. In my case I created mysql_forge.php.
- Create your extended class:
<?php if ( ! defined('BASEPATH')) exit('No direct script access allowed');
class DB_mysql_forge extends CI_DB_mysql_forge {
}
- Have fun extending the functions! To get my tables to specifically create with the InnoDB engine I used the following code:
/**
* Modify _create_table to use InnoDB
*
* @access public
* @author (Original) EllisLabs / (Extension) J Elmore
* @license MIT
* @version 1.0
* @return string
*/
function _create_table($table, $fields, $primary_keys, $keys, $if_not_exists)
{
$sql = parent::_create_table($table, $fields, $primary_keys, $keys, $if_not_exists);$sql = rtrim($sql, ';');
/* Should note here that I have a custom config file with the key/value pair to hold the
default database engine to use */
return $sql.' ENGINE='.config_item('database_engine').';';
}
I tried simply extending the dbforge class but since all the magic happens in the driver classes it was necessary to extend the driver and modify the functions there. Also, I know there are ways to set the mysql server to default to InnoDB creation but since this project may be sold/released at some point it is easier to modify the CodeIgniter files than to try and provide instructions for something most people wouldn’t be able to or know how to do.
