how to save the array values as each record in mysql database

Question

How can I save the following array values in my sql table?

Array (
   [0] => "/path/to/file/file_name1.jpeg"
   [1] => "file_name1.jpeg"
)
Array (
   [0] => "/path/to/file/file_name2.jpeg"
   [1] => "file_name2.jpeg"
)

Following is my table structure,

id - int - auto inc
path - varchar(200)
name - varchar(50)

Thanks in Advance.

Alexey Mezenin · Accepted Answer · 2016-12-25 15:00:13Z

2

You can insert an array of data with insert() method:

$data = [
    ['path' => '/path/to/file/file_name1.jpeg', 'name' => 'File 1'],
    ['path' => '/path/to/file/file_name2.jpeg', 'name' => 'File 2'],
    ['path' => '/path/to/file/file_name3.jpeg', 'name' => 'File 3'],
];

Model::insert($data);

Or:

....
DB::table('some_table')->insert($data);

answered Dec 25, 2016 at 15:00

Alexey Mezenin

164k27 gold badges309 silver badges287 bronze badges

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

2 Comments

Haripriya Over a year ago

Thanks @alexey, I am returning that array value from function. Am passing that returned value to save into database. Pls suggest me how to pass that array value to save into database.

Alexey Mezenin Over a year ago

I guess you should create new question, describe the situation and post some code, so we'll be able to help you with that too.

Amit Gupta · Accepted Answer · 2016-12-25 15:02:43Z

0

You can use foreach and create method as:

foreach ($array as $key => $value) {
    ModelName::create(['path' => $value[0], 'name' => $value[0]]);
}

Remember to add path and name in your model's fillable attribute.

answered Dec 25, 2016 at 15:02

Amit Gupta

17.7k5 gold badges46 silver badges54 bronze badges

2 Comments

Alexey Mezenin Over a year ago

This will work, but this will create DB query for each insertion.

Amit Gupta Over a year ago

It's use full when you have an observer for create method.

DivineCoder · Accepted Answer · 2016-12-25 15:15:39Z

0

You can add multiple values with the following

$data = array(
    array('name'=>'value', 'path'=>'value'),
    array('name'=>'value', 'path'=>'2048'),
    //...
);

Model::insert($data);

You can find more here https://laravel.com/docs/5.3/queries#inserts

answered Dec 25, 2016 at 15:15

DivineCoder

7525 silver badges11 bronze badges

1 Comment

DivineCoder Over a year ago

if you want to update timestamps you will have to pass 'created_at'=> $now, 'modified_at'=> $now Hope it will help

Collectives™ on Stack Overflow

how to save the array values as each record in mysql database

3 Answers 3

2 Comments

2 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related