codeigniter 3 database seeding code example

Example 1: codeigniter 4 database seed multiple

<?php

namespace App\Database\Seeds;

use \CodeIgniter\I18n\Time;

class PeopleSeeder extends \CodeIgniter\Database\Seeder
{
  public function run()
  {
    $data = [
      [
        'name'        => 'Andy',
        'address'     => '8733 Apple Street, 10',
        'created_at'  => Time::now(),
        'updated_at'  => Time::now()
      ],
      [
        'name'        => 'Buddy',
        'address'     => '643 Banana Street, 135',
        'created_at'  => Time::now(),
        'updated_at'  => Time::now()
      ],
      [
        'name'        => 'Anie',
        'address'     => '112 Lemon Street, 121',
        'created_at'  => Time::now(),
        'updated_at'  => Time::now()
      ]
    ];

    // Using Query Builder
    $this->db->table('peoples')->insertBatch($data);
  }
}

Example 2: codeigniter 4 db seed

<?php namespace App\Database\Seeds;

class SimpleSeeder extends \CodeIgniter\Database\Seeder
{
        public function run()
        {
                $data = [
                        'username' => 'darth',
                        'email'    => '[email protected]'
                ];

                // Simple Queries
                $this->db->query("INSERT INTO users (username, email) VALUES(:username:, :email:)",
                        $data
                );

                // Using Query Builder
                $this->db->table('users')->insert($data);
        }
}