Laravel. Database seeder multiple rows not working

Question

I want to seed database with multiple rows with a seeder:

public function run()   {
    DB::table('users')->insert([

        [
            'name' => 'Guest',
            'surname' => 'Guest',
            'email' => '[email protected]',
            'phone' => '+777',
            'password' => bcrypt('password'),
            'is_admin' => false,
        ],
        [
            'name' => 'Alexander',
            'surname' => 'Jones',
            'email' => '[email protected]',
            'phone' => '+12321321312',
            'password' => bcrypt('password'),
            'is_admin' => true,
        ]

    ]);

However when i run php artisan db:seed it seeds only with the first row. How can i make seeder for multiple rows? L5.2 documentation lacks this kind of information. Please help!

Instead of use DB, can you use App\User .. and do something like User::insert(). Does that work? — prateekkathal
– prateekkathal, Commented Dec 12, 2016 at 18:19
@TheAlpha: you mean my code should work? But in fact, it doesn't... To prateekkathal: it didn't work, same - just 1 row, instead of 2. — Alexander Kim
– Alexander Kim, Commented Dec 12, 2016 at 18:21
@MikeHarrison I am getting errors there, but not related to a seeder. — Alexander Kim
– Alexander Kim, Commented Dec 12, 2016 at 18:27

Community · Accepted Answer · 2020-05-31 17:54:42Z

1

Try this once..

$mul_rows= [
    [ 'name' => 'Guest',
            'surname' => 'Guest',
            'email' => '[email protected]',
            'phone' => '+777',
            'password' => bcrypt('password'),
            'is_admin' => false,],
    [  'name' => 'Alexander',
            'surname' => 'Jones',
            'email' => '[email protected]',
            'phone' => '+12321321312',
            'password' => bcrypt('password'),
            'is_admin' => true,]
];

foreach ($mul_rows as $rows) {
   //$insert = DB::table('departments')->insert($mul_rows); old
   $insert= DB::table('users')->insert($rows);
if($insert){
//success message here
}else{
//Failure message here
}
}

edited May 31, 2020 at 17:54

CommunityBot

11 silver badge

answered Dec 12, 2016 at 20:23

Soniya Basireddy

3792 silver badges10 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Mike Harrison · Accepted Answer · 2016-12-12 19:21:19Z

0

Through chat we discovered that the rows were actually being inserted but when calling to the DB through w/e tool the OP was using was only returning 1 result at a time which made it appear.

For other users using Sequel Pro (https://sequelpro.com/) I suggest looking at the table view and not running queries as that may be misleading. Not entirely sure but we think that it is adding a limit of 1 to the end of the query.

answered Dec 12, 2016 at 19:21

Mike Harrison

1,40314 silver badges18 bronze badges

Collectives™ on Stack Overflow

Laravel. Database seeder multiple rows not working

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related