php array data in mysql -

i new mysql , php. need put array php data table:

the array looks this:

$memberdata     key    value     apple  5     banana 8     salmon 3     candle 4     ..........     , 100 more... 

my mysql table looks this:

membertable     id(int11)=pk    memid(int11)      stuff(varchar)     value(int2)     1               23                apple              5     2               23                banana             8     3               23                salmon             3     4               23                candle             4     5               45                banana             1     6               45                apple              9 

so each member; here member 23 , 45 can have same stuff other values, every member have 1 php array of data. (mysql id auto increment).

my question: there possibility store array directly mysql table...? in book read make foreach loop , in loop open connection database... thought maybe time consuming:

book example:

$cxn = mysqli_connect($host,$user,$pass,$dbname); $memid = "23"; $query_pre = "insert membertable ('memid','stuff','value') values ("; foreach ($memberdata $stuff => $value) {  $query = $query_pre . "$memid,$stuff,$value)";   $result = mysqli_query($cxn, $query) or die ("couldn't execute query"); }   

regards, thijs

well that's strange book. although idea in general right, particular code contains both php , mysql errors.

it should (not tested):

$cxn = mysqli_connect($host,$user,$pass,$dbname); $memid = "23"; $prequery = array(); foreach ($memberdata $stuff => $value) {   $stuff = mysqli_real_escape_string($stuff);   $value = mysqli_real_escape_string($value);   $prequery[] = "($memid,'$stuff','$value')";  }  $query = "insert membertable (memid,stuff,value) values ".implode(",",$prequery); $result = mysqli_query($cxn, $query) or die (mysqli_error($cxn).$query);