Site icon WDB24

How to setup and run Codeigniter Migration

Ahsan Zameer
codeigniter featured image

Database migration is one of the best features that you get in any PHP framework. Database migration in the framework is just like a version control of your database tables. And another feature of migration is that you don’t have to send or put separate database file to other developers.

Codeigniter also comes with builtin migration feature and we are going to learn how to steup and run database migration

First let’s have a fresh copy of codeigniter from its site. You are unfamiliar with codigniter installation, no worries you can check my post how to install codeigniter in XAMPP.

Enable Migration:

By default migration is disabled in codeigniter. You have to enable it by going to config/migration.php and $config['migration_enabled'] to TRUE

Create Migration Folder:

Next thing is to create a migrations folder in the application folder. Remember name of the folder must be in plural no singular.

Ways to create Migration File(s):

There are 2 ways to create a migration file. Means name of the file should be in following 2 ways.

  1. Sequential: Migration file name should start with 001. Each number should start with 3 digits and there must not be any gaps in the sequence.
  2. Timestamp: Each migration is numbered using the timestamp and format must be YYYYMMDDHHIISS (e.g. 20181208100537)

By default, timestamp is set to migration type. But you can change this by going to config/migration.php file and set $config['migration_type'] value from timestamp to sequential

In this tutorial, I will be using a sequential type.

Create Migration File:

Migration file must extend CI_Migration class and class will have 2 functions. One is up() and second is down(). Up function will have table creation code and down function will get drop table code. $this->dbforge is a database manage class which will take care of database. You can visit Database Forge Class for further digging.

Now let’s create a migration for users table. I am creating a file in application/migrations folder as 001_Users.php

After creating 001_Users.php goto config/migration.php and set $config['migration_version'] value to 1 and $config['migration_auto_latest'] to TRUE

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
 
<?php
class Migration_Users extends CI_Migration{
public function up(){
$this->dbforge->add_field(array(
'id' => array(
'type' => 'INT',
'constraint' => 11,
'unsigned' => TRUE,
'auto_increment' =>TRUE
),
'email' => array(
'type' => 'VARCHAR',
'constraint' => 90,
),
'password' => array(
'type' => 'VARCHAR',
'constraint' => 255,
),
'first_name' => array(
'type' => 'VARCHAR',
'constraint' => 90,
),
'last_name' => array(
'type' => 'VARCHAR',
'constraint' => 90,
),
'last_name' => array(
'type' => 'VARCHAR',
'constraint' => 90,
),
'token' => array(
'type' => 'VARCHAR',
'constraint' => 255,
),
'is_active' => array(
'type' => 'TINYINT',
'constraint' => 1,
),
'created' => array(
'type' => 'DATETIME',
),
));
$this->dbforge->add_key('id',TRUE);
$this->dbforge->create_table('users');
}
public function down(){
$this->dbforge->drop_table('users');
}
}
 


Run Migrations:

Now create a migration controller in controllers folder. I will create Migration.php and write below code.

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
 
<?php
 
defined('BASEPATH') OR exit('No direct script access allowed');
 
class Migration extends CI_Controller{
function __construct()
{
parent::__construct();
$this->load->library('migration');
}
public function index()
{
if ($this->migration->current() === FALSE)
{
show_error($this->migration->error_string());
}
echo "Done";
}
}
 

Before running migration make sure you have already setup your database in config/database.php file. Now go to browser and type localhost/your_project/migration/index. If all goes well, migrations and users table will create in database.

Exit mobile version