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
|
<?php include("connection_sql.php"); ?>
<?php include("bbcode.php"); ?>
<?php
// Récupération des paramètres POST
$id = $_POST["id"];
$reference = $_POST["reference"];
$titre = htmlspecialchars($_POST["titre"], ENT_QUOTES);
$description = str_replace("\n", '<br/>',$_POST["description"]);
?>
<?php
$req1 = $bdd->prepare ('UPDATE ma_table SET reference=:reference, titre=:titre, description=:description, date_insertion=CURDATE(), timestamp=NOW() WHERE reference = :reference') or die(print_r($bdd->errorInfo()));
$req1->execute(array(
'reference' => $reference,
'titre' => $titre,
'description' => $description
));
if($req1) {
echo '<p>Modification réussie !</p>';
}
else {
echo '<p>Échec à la modification.</p>';
}
$req1->closeCursor();
//On met à jour la référence
$req2 = $bdd->prepare('UPDATE ma_table SET reference=99999 WHERE reference=:reference') or die(print_r($bdd->errorInfo()));
$req2->execute(array('reference' => $reference));
$req2->closeCursor();
$req3 = $bdd->prepare('UPDATE ma_table SET reference=reference+1 WHERE reference<:reference') or die(print_r($bdd->errorInfo()));
$req3->execute(array('reference' => $reference));
$req3->closeCursor();
$req4 = $bdd->prepare('UPDATE ma_table SET reference=1 WHERE reference>=99999') or die(print_r($bdd->errorInfo()));
$req4->execute(array('reference' => $reference));
$req4->closeCursor();
?> |
Partager