Store A Multi Dimensional Array In Mysql Database - Printable Version +- CodeIgniter Forums (https://forum.codeigniter.com) +-- Forum: Archived Discussions (https://forum.codeigniter.com/forumdisplay.php?fid=20) +--- Forum: Archived Development & Programming (https://forum.codeigniter.com/forumdisplay.php?fid=23) +--- Thread: Store A Multi Dimensional Array In Mysql Database (/showthread.php?tid=54781) |
Store A Multi Dimensional Array In Mysql Database - El Forum - 09-24-2012 [eluser]rochellecanale[/eluser] hey guys just want to ask how can i store a multidimensional array in mysql database. Right now i can view my array. Here's my code in viewing. Code: $products = unserialize($this->session->userdata('product_list')); Now i want to put my information in the database. My simple output is like this: Product ID: 19 //id 19 //id TEST PRODUCT 7 //name N/A //description 5.00 //price 1 //qty 5 //total amount TEST2012-64654 //code Product ID: 20 //id 20 //id TEST PRODUCT 8 //name N/A //description 5.00 //price 1 //qty 5 //total amount TEST2012-43672 //code how can i store these values in my sales table? It is layout like this. ID | FKPROD_ID | NAME | DESC | PRICE | QTY | AMOUNT |