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
|
for ($i=0 ;$i < $nbArticles ; $i++)
{
echo"<tr>";
echo "<td>".htmlspecialchars($_SESSION['panier']['nom'][$i])."</td>";
echo "<td><input type=\"text\" size=\"4\" name=\"q[]\" value=\"".htmlspecialchars($_SESSION['panier']['quantite'][$i])."\"/></center></td>";
echo "<td>".htmlspecialchars($_SESSION['panier']['prix'][$i])."</td>
</tr>";
}
$time = new DateTime();
$time = $time->format('Y-m-d H:i:s');
$montant=MontantGlobal();
$query=$db->prepare('INSERT INTO panier(panier_nom,id_client,panier_quantite,time,montant,actif)
VALUES(:panier_nom,:id,:panier_quantite,:time,:montant,:actif)');
$query->bindValue(':panier_nom',$_SESSION['panier']['nom'][$i], PDO::PARAM_STR);
$query->bindValue(':id', $_SESSION['id'], PDO::PARAM_INT);
$query->bindValue(':panier_quantite', $_SESSION['panier']['quantite'][$i], PDO::PARAM_INT);
$query->bindValue(':montant',$montant, PDO::PARAM_INT);
$query->bindValue(':time', $time, PDO::PARAM_INT);
$query->bindValue(':actif', $actif=1, PDO::PARAM_INT);
$query->execute()or die(print_r($query->errorInfo())); |
Partager