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
|
<?php
.........
$modifdata = $cbd->prepare('
UPDATE tab SET
cdec=:cdec, // autoincrementation
cdet=:cdet,
cdc=:cdc,
datedec=: datefr,
m=: m,
f=:f
');
try
{
$modifdata->bindparam(':cdec', $_POST['cdec'], PDO::PARAM_INT); // entier
$modifdata->bindparam(':cdet', $_POST['cdet'], PDO::PARAM_STR); // chaine de caractéres
$modifdata->bindParam(':cdc', $_POST['cdc'], PDO::PARAM_STR); // chaine de caractéres
$modifdata->bindParam(':datedec', $datefr, PDO::PARAM_STR); // date
$modifdata->bindParam(':m', $_POST['m'], PDO::PARAM_INT); // entier
$modifdata->bindParam(':f', $_POST['f'], PDO::PARAM_INT); // entier
$modifdata->execute();
header ('location: tab.php');
}
catch ( Exception $e )
{
echo 'Erreur de requête : ', $e->getMessage();
}
?> |
Partager