将PHP数组存储到mySQL

Question

I am trying to store some PHP arrays that come from a XML API servce into a MYSQL DB, and clear them on the session is closed or a new search is made

Have any ideea if this can be posible?

My Variables are $img[][], $name[] and $product[]->type[]->Category; and a unique variable:$searchID`

My final purpose is to store them into mySQL DB so i can create pagination system

Any advise will be much appreciated..

Answer 1

$st=$db->prepare("INSERT INTO `table` (`img`,`name`,`Category`,`searchID`) VALUES(?,?,?,?)");
$st->execute($img[x][x],$name[x],$product[x]->type[x]->Category,$searchID);

? maybe serialize() / json_encode it if its not basic variables