CodeIgniter MySQL Insert Data

After creating a database and table, the next step is to insert data.

In CodeIgniter, you can insert records using:

1. Active Record (Query Builder) – recommended, easy & secure.
2. Raw SQL Queries – direct SQL commands.

🔹 Step 1: Load Database

Make sure database is loaded. Add this in autoload.php:

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

Or load it manually:

$this->load->database();

🔹 Step 2: Insert Data using Query Builder

Example: Insert into users table

class InsertController extends CI_Controller {

    public function insert_user() {
        // Sample data
        $data = array(
            'name'  => 'John Doe',
            'email' => 'john@example.com',
            'created_at' => date('Y-m-d H:i:s')
        );

        // Insert data
        if ($this->db->insert('users', $data)) {
            echo "User inserted successfully!";
        } else {
            echo "Failed to insert user.";
        }
    }
}

👉 URL:

http://your-site/index.php/insertcontroller/insert_user

🔹 Step 3: Insert Multiple Records

public function insert_multiple() {
    $data = array(
        array(
            'name' => 'Alice',
            'email' => 'alice@example.com',
            'created_at' => date('Y-m-d H:i:s')
        ),
        array(
            'name' => 'Bob',
            'email' => 'bob@example.com',
            'created_at' => date('Y-m-d H:i:s')
        )
    );

    if ($this->db->insert_batch('users', $data)) {
        echo "Multiple users inserted!";
    } else {
        echo "Failed to insert multiple records.";
    }
}

🔹 Step 4: Insert Data using Raw SQL

public function raw_insert() {
    $sql = "INSERT INTO users (name, email, created_at) VALUES (?, ?, ?)";
    $this->db->query($sql, array('Charlie', 'charlie@test.com', date('Y-m-d H:i:s')));
    echo "User inserted with raw SQL!";
}

🔹 Step 5: Get Last Inserted ID

$this->db->insert('users', $data);
$insert_id = $this->db->insert_id();
echo "Inserted user ID: " . $insert_id;

🔹 Output Example (users table)