codeigniter 4 database seed multiple
> php spark db:seed TestSeeder
3.5
4
<?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);
}
}
Thank you!
4
0
4.29
7
<?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);
}
}
Thank you!
7
0
Are there any code examples left?
New code examples in category PHP
-
PHP 2022-03-27 22:40:03 index:of curiosa 2019 mp4
-
PHP 2022-03-27 22:35:13 Dijkstra’s algorithm php
-
PHP 2022-03-27 22:35:12 get_declared_classes
-
PHP 2022-03-27 22:30:23 php move index of a value to first position in array
-
PHP 2022-03-27 22:25:01 wordpress get_date
-
PHP 2022-03-27 21:30:38 php shorten string with dots
-
PHP 2022-03-27 21:10:46 php header 500
-
PHP 2022-03-27 21:05:06 laravel schedule run
-
PHP 2022-03-27 20:25:12 Get page title, excerpt or content by id
-
PHP 2022-03-27 20:00:27 php convert date from dd/mm/yyyy to yyyy-mm-dd