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