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, Jul 21 '16 at 23:24

score 2 · Answer 1 · edited May 23 '17 at 12:32

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 '17 at 12:32

Community

1
1

answered Jul 22 '16 at 04:43

jaysingkar

4,315
1
18
26

@MN that's very strange. It must work on server. Is there any error or exception during usage ? – jaysingkar May 29 '19 at 17:04
Thanks. I have this error: `Invalid argument supplied for foreach()` – Mostafa Norzade May 29 '19 at 18:18
@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() – jaysingkar May 29 '19 at 18:43
Thanks. my problem solved with `(array) json_decode()` !! – Mostafa Norzade May 29 '19 at 18:50

score 0 · Answer 2 · answered Jul 22 '16 at 02:58

0

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

answered Jul 22 '16 at 02:58

Rick James

135,179
13
127
222

How to save an array to a mysql database in laravel

2 Answers2