how to save the array data into mysql database

Question

stated array getting set of combinations....please help me and let me know how to save list of record into mysql database.....database contains three fields (set1 set2 set3)...

regards,

$array1 = array('rough', 'smooth', 'coarse'); 
$array2 = array('shiny', 'matte', 'rough'); 
$array3 = array('very large', 'large', 'medium', 'small'); 

$array=array_merge($array1,$array2,$array3); 

$combinations=array(); 
for($x=0;$x<(count($array)-2);$x++) { 
$a=$array[$x]; 
for ($y=$x+1;$y<count($array);$y++) { 
    $b=$array[$y]; 
    for ($z=$y+1;$z<count($array);$z++) { 
        $c=$array[$z]; 
        $combinations[]="$a, $b, $c"; 
    } 
} 
}

Consider more normalization. If the data is ever queried or is part of business rules it is usually the appropriate route. Otherwise, the keyword is "serialize". — user166390
– user166390, Commented Apr 12, 2012 at 3:51

Ignacio Vazquez-Abrams · Accepted Answer · 2012-04-12 03:42:40Z

2

The easiest way is to just use json_encode() to turn the array into JSON before storing. This way the data can be available to other processes and languages with minimal hassle.

answered Apr 12, 2012 at 3:42

Ignacio Vazquez-Abrams

804k160 gold badges1.4k silver badges1.4k bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Blake Hancock · Accepted Answer · 2012-04-12 03:48:57Z

1

You can use the serialize function to turn the array into a string.

Once retrieved, you can then use the unserialize function to turn it back into an array.

answered Apr 12, 2012 at 3:48

Blake Hancock

412 bronze badges

Collectives™ on Stack Overflow

how to save the array data into mysql database

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related