1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26
| $query = $db->prepare('INSERT INTO articles
(nom,lien,designation,image_arriere,agrandissement,heure,image,machine, description)
VALUES(:nom,:lien,:designation,:arriere,:zoom,:date,:image,:machine,:description)');
$query->bindvalue(':nom', $nom, pdo::PARAM_STR);
$query->bindvalue(':lien', $lien, pdo::PARAM_STR);
$query->bindvalue(':designation', $designation, pdo::PARAM_STR);
$query->bindvalue(':arriere', $arriere, pdo::PARAM_STR);
$query->bindvalue(':zoom', $zoom, pdo::PARAM_STR);
$query->bindvalue(':date', $date, pdo::PARAM_STR);
$query->bindvalue(':image', $image, pdo::PARAM_STR);
$query->bindvalue(':machine', $machine, pdo::PARAM_STR);
$query->bindvalue(':description', $description, pdo::PARAM_STR);
$query->execute() or die(print_r($db->errorinfo()));
$_SESSION['id_articles']=$db->lastInsertId();
$query = $db->prepare("SELECT id_tailles FROM taille");
$query->execute() or die(print_r($db->errorinfo()));
while($data=$query->fetch()){
$query = $db->prepare('INSERT INTO identification
(id_article,id_taille,prix,quantite)
VALUES (:id_articles,:id_tailles,:prix,:stock)');
$query->bindValue(':id_articles',$_SESSION['id_articles'], PDO::PARAM_INT);
$query->bindvalue(':id_tailles', $id_tailles, pdo::PARAM_INT);
$query->bindvalue(':prix', $prix, pdo::PARAM_INT);
$query->bindvalue(':stock', $stock, pdo::PARAM_INT);
$query->execute() or die(print_r($db->errorinfo()));
} |
Partager