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 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60
|
if (isset($_FILES['photo1'], $_FILES['photo2'])) {
$msg_err = array();
//
$photo1 = $_FILES['photo1'];
$photo2 = $_FILES['photo2'];
// 1ère image
$verif = verif_photo($photo1);
if ($verif === TRUE) {
move_photo($photo1);
}
else {
$msg_err[] = $verif;
}
// 2ème image
$verif = verif_photo($photo2);
if ($verif === TRUE) {
move_photo($photo2);
}
else {
$msg_err[] = $verif;
}
//
}
$arriere=$photo1 ;
$image=$photo2;
$query = $db->prepare('INSERT INTO types (designation,image)
VALUES (:designation,:image)');
$query->bindvalue(':designation', $designation, pdo::PARAM_STR);
$query->bindvalue(':image', $image, pdo::PARAM_STR);
$query->execute() or die(print_r($db->errorinfo()));
$id_articles = $db->lastInsertId();
$query = $db->prepare('INSERT INTO articles (id_articles,nom,lien,prix,stock,arriere,machine, description)
VALUES (:id_articles,:nom,:lien,:prix,:stock,:arriere,:machine,:description)');
$query->bindvalue(':nom', $nom, pdo::PARAM_STR);
$query->bindvalue(':lien', $lien, pdo::PARAM_STR);
$query->bindvalue(':prix', $prix, pdo::PARAM_INT);
$query->bindvalue(':stock', $stock, pdo::PARAM_INT);
$query->bindvalue(':arriere', $arriere, pdo::PARAM_STR);
$query->bindvalue(':machine', $machine, pdo::PARAM_STR);
$query->bindvalue(':description', $description, pdo::PARAM_STR);
$query->bindValue(':id_articles', (int) $id_articles, PDO::PARAM_INT);
$query->execute() or die(print_r($db->errorinfo()));
} |
Partager