How to save an array to a mysql database in laravel

Question

So i wanted to save some tags data to the database from the UI form,

Tags: ["male","female","kids"]

I tried everything like but it saves as a string, ialso tried checking if i can alter the data type to array in mysql, or json but i got this

You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'JSON(255) NOT NULL' at line 1

I also tried json_encode and json_decode() but still no head so please what can i do?

Pls share what you have tried! Based on an error message only it is a bit difficult to figure out what may have gone wrong. — Shadow
– Shadow, Commented Jul 21, 2016 at 23:24

Community · Accepted Answer · 2017-05-23 12:32:36Z

2

There isn't any data type as JSON or Array in DB.
What you can do is use the tags field as TEXT as told by @Rick James and then encode your input as json by using json_encode() method before inserting and decode it after retrieving the data from DB by using json_decode() method.

JSON is basically a minimal, readable format for structuring data. Which means it can be considered as a String.

Here is a good post about JSON, in case you need. What is JSON?

edited May 23, 2017 at 12:32

CommunityBot

11 silver badge

answered Jul 22, 2016 at 4:43

jaysingkar

4,4351 gold badge22 silver badges27 bronze badges

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

4 Comments

jaysingkar Over a year ago

@MN that's very strange. It must work on server. Is there any error or exception during usage ?

Mostafa Norzade Over a year ago

Thanks. I have this error: Invalid argument supplied for foreach()

jaysingkar Over a year ago

@MN it's very hard to understand the problem from this. Though you can try printing the string before decode and after decoding, try printing the variable with var_dump()

Mostafa Norzade Over a year ago

Thanks. my problem solved with (array) json_decode() !!

Rick James · Accepted Answer · 2016-07-22 02:58:50Z

0

There is no datatype called JSON. Instead use TEXT without the (255).

answered Jul 22, 2016 at 2:58

Rick James

144k15 gold badges144 silver badges255 bronze badges

Collectives™ on Stack Overflow

How to save an array to a mysql database in laravel

2 Answers 2

4 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related