How to store array data into database in Laravel

Question

I have some JSON data; I decode that JSON data into an array, now I need to save the link column, id column and username column into my database table (the table name may be the product). So how to insert/save this column into the database in Laravel? My single node array structure format is below.

   {
        0 => {
          +"attribution": null
          +"tags": array:11 
          +"type": "image"
          +"location": null
          +"filter": "Normal"
          +"created_time": ""
          +"link": "https://www.url.com/p/myimage1/"
          +"id": "4354"
          +"user": {
            +"username": "user"
            +"profile_picture": "https://mypic.jpg"
            +"id": "224"
            +"full_name": ""
          }
        }
       
        }

What is the issue? 1) Create a class object 2) set object property value 3) save object. — Ravi Hirani
– Ravi Hirani, Commented Jun 6, 2016 at 11:56
@RaviHirani the link which you given according to this create a new record in the database,but my problem is different,i already have array data i need to save this data into my data base product table. — bhatt
– bhatt, Commented Jun 6, 2016 at 13:13
@raj: in that case you need to find record by PK. see this link:- Retrieving Single Models / Aggregates — Ravi Hirani
– Ravi Hirani, Commented Jun 6, 2016 at 13:30

Alexey Mezenin · Accepted Answer · 2016-06-06 12:03:16Z

2

One way to do that is to save original json data or convert array to json with ->toJson() or json_encode() and save it to a DB as Json data:

$table->json('options'); // JSON equivalent for the database.

https://laravel.com/docs/5.2/migrations#writing-migrations

answered Jun 6, 2016 at 12:03

Alexey Mezenin

164k27 gold badges309 silver badges287 bronze badges

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

Comments

Naveed Ali · Accepted Answer · 2020-08-24 11:51:27Z

1

you can use toJson() method for it as below:

$table->toJson('options');

answered Aug 24, 2020 at 11:51

Naveed Ali

1,0458 silver badges16 bronze badges

Collectives™ on Stack Overflow

How to store array data into database in Laravel

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