使用php在单行中附加多个值

Question

I have a table called user having 3 columns namely id, name and phone no.

i want insert data like below clip.

+----+---------------+---------------------+-     
| id | name          | phone no            |      
+----+---------------+---------------------+-     
| 1  |  mahadev      |   +91 XXXXX         |      
| 2  |  swamy        |   +91 YYYYY         |      
|    |               |   +91 ZZZZZ         |      
| 3  |  charlie      |   +91 AAAAA         |      
|    |               |                     |      
+----+---------------+---------------------+-     

Here question is how can i add more than one values (one by one) to same row as showing id = 2 in above clip.

Could anyone please help me on this?

Thanks in advance.

Answer 1

One possible solution could be creating an array of that data and then storing it with serialize() function.

Small example:

$phones_array = array('phone_a' => '+91 YYYYY', 'phone_b' => '+91 ZZZZZ');

serialize($phones_array);

Now your data are serialized into a string, trying var_dump($phones_array) you should get:

string 'a:2:{s:7:"phone_a";s:9:"+91 YYYYY";s:7:"phone_b";s:9:"+91 ZZZZZ";}' (length=66)

You can now insert this value into your table

You can retrieve this data with:

unserialize($phones_array);