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..
$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