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
|
<?php
//model
include ("includes/session.php");
$conn = $pdo->open();
$idpr = $_POST['var1'];
$quantity = $_POST['quantity'];
$idc = $_POST['var2'];
$sql1= ("select * from listeattente where idprd= '$idpr' AND idclt= '$idc' ");
$stmt1= $conn->query($sql1)or die(print_r($stmt->errorInfo()));
$ver=$stmt1->fetch();
echo $ver['idprd'];
if( !($ver=$stmt1->fetch()){
$data = [
'idpr' => $idpr,
'idclt' => $idc,
'quantite' => $quantity,
];
$sql = "INSERT INTO listeattente(idprd, idclt, quantite, datecomm) VALUES (:idpr, :idclt, :quantite, NOW())";
$stmt= $conn->prepare($sql);
$stmt->execute($data)or die(print_r($stmt->errorInfo()));}
header("Location: single.php?idProduit=".$idpr);
$pdo->close();
?> |
