Save array in mysql database

Question

I want to save extra information before sending the total order to Paypal  For each item I have created a single column in my MySQL database where I want to store it  Now I was thinking to save it as an array which I can read later for creating a PHP page  Extra fields are taken from input form fields   By using an array can I be sure not to mixup information

User · Answer

lt  php  myArray   new array  1    2     seralizedArray   serialize  myArray     gt

User · Answer

The way things like that are done is with serializing the array  which means  making a string out of it   To better understand this  have a look on this    array   array  my    litte    array   2     serialized array   serialize  array     unserialized array   unserialize  serialized array     var dump  serialized array      gives back a string  perfectly for db saving  var dump  unserialized array      gives back the array again

User · Answer

Use the PHP function serialize   to convert arrays to strings  These strings can easily be stored in MySQL database  Using unserialize   they can be converted to arrays again if needed

User · Answer

Store it in multi valued column with a comma separator in an RDBMs table

User · Answer

You can use MySQL JSON datatype to store the array mysql gt  CREATE TABLE t1  jdoc JSON    Query OK  0 rows affected  0 20 sec  mysql gt  INSERT INTO t1 VALUES    quot key1 quot    quot value1 quot    quot key2 quot    quot value2 quot       Query OK  1 row affected  0 01 sec  To get the above object in PHP json encode   quot key1 quot   gt   quot value1 quot    quot key2 quot   gt   quot value2 quot      More in https   dev mysql com doc refman 8 0 en json html

User · Answer

To convert any array  or any object  into a string using PHP  call the serialize      array   array  1  2  3     string   serialize   array    echo  string     string will now hold a string version of the array  The output of the above code is as follows   a 3  i 0 i 1 i 1 i 2 i 2 i 3     To convert back from the string to the array  use unserialize         array will contain   1  2  3    array   unserialize   string

User · Answer

You can store the array using serialize unserialize  With that solution they cannot easily be used from other programming languages  so you may consider using json encode json decode instead  which gives you a widely supported format   Avoid using implode explode for this since you ll probably end up with bugs or security flaws   Note that this makes your table non-normalized  which may be a bad idea since you cannot easily query the data  Therefore consider this carefully before going forward  May you need to query the data for statistics or otherwise  Are there other reasons to normalize the data   Also  don t save the raw   POST array  Someone can easily make their own web form and post data to your site  thereby sending a really large form which takes up lots of space  Save those fields you want and make sure to validate the data before saving it  so you won t get invalid values

[php] Save array in mysql database

Examples related to php

Examples related to mysql

Examples related to arrays