How to store data in db in array form

Question

i want to store my PHP values in db(mysql) in the form of array...

for example

$a=array{10,20,30,40};

i want to store this variable $a in to db in the array form like how it's storing in array using index.

why i want to do this because in future i may have to perform update or delete operation on the array values..

i know that it's possible to do this thing... but i don't know how to implement this..

i searched about this topic but i didn't get proper answer....

Please suggest me how to do this things...

@NitishKumar for example i store my above value in db in the form of string like {10,20,30,40} and then i may have to update/delete 20 from the string or i may have to add new value... — 404 Not Found, Sep 13 '13 at 06:57
use implode(',',$a) see this link once http://php.net/manual/en/function.implode.php — nickle, Sep 13 '13 at 07:00
then store individual values in a table so that you can make edit or delete easily — nickle, Sep 13 '13 at 07:03

Shankar Narayana Damodaran · Accepted Answer · 2013-09-13T06:57:29.690

2

Why don't use json_encode in PHP and store it on your database. It's the best way.

The array will be converted to a string and will be stored. Retrieve the data and make use of json_decode and then start working as per your needs.

Example:

<?php
$arr = array('a' => 1, 'b' => 2, 'c' => 3, 'd' => 4, 'e' => 5);

echo json_encode($arr);
?>

OUTPUT:

{"a":1,"b":2,"c":3,"d":4,"e":5}

edited Sep 13 '13 at 06:57

answered Sep 13 '13 at 06:52

Shankar Narayana Damodaran

68,075
43
96
126

i want to store it in db in single attributes.. and my question is in db how to store? – 404 Not Found Sep 13 '13 at 06:53
1

When you pass the array to json_encode, it will be converted into a string, you can directly store that into the database. – Shankar Narayana Damodaran Sep 13 '13 at 06:55
@ØHankyPankyØ, You need to read this thread before downvoting. Performance of json_encode vs serialize. http://stackoverflow.com/questions/804045/preferred-method-to-store-php-arrays-json-encode-vs-serialize – Shankar Narayana Damodaran Sep 13 '13 at 07:01

score 2 · Answer 2 · edited Jun 20 '20 at 09:12

You should create a distinct TABLE to store this kind of data.
Consists of 2 columns, corresponding record ID and the actual data.

So, your record will be looks like

this way you will be able to perform update or delete operation on the array values using conventional SQL routines, as well as selecting data based on the array values.

This is how the things done oin the real world, not in PHP sandbox.

All othe answers here are plainly wrong

BlackBonjour · Answer 3 · 2013-09-13T07:14:30.450

-1

I would use serialize/unserialize for this. You can use it like this:

Send to MySQL

<?php
    $a = array{10,20,30,40};
    $a = serialize($a);
    // your code here to send it to the mysql
?>

Get from MySQL

<?php
    // your code here to collect it from mysql
    $a = unserialize($mysql->str);
?>

The field in the MySQL should be TEXT or VARCHAR.

Regards

BlackBonjour

edited Sep 13 '13 at 07:14

answered Sep 13 '13 at 06:58

BlackBonjour

91
1
1
6

1

What about fixing the essentially flawed approach? – Your Common Sense Sep 13 '13 at 07:06

score -2 · Answer 4 · answered Sep 13 '13 at 06:54

-2

You can always serialize your array then store the result in a VARCHAR or TEXT field and after fetching you can unserialize the field.

answered Sep 13 '13 at 06:54

fabrik

14,094
8
55
71

How to store data in db in array form

4 Answers4

All othe answers here are plainly wrong

Send to MySQL

Get from MySQL