1 2 3 4 5 6 7 8
| // en supposant $idpr de type int, sinon sur query et exec elle devra passer par quote
$result = $bdd->query("SELECT count(*) FROM admin WHERE idp = $idpr")->fetchColumn();
if ($result) {
$req = $bdd->prepare('UPDATE admin SET val = :repformater WHERE idp = :idpr')or die(print_r($bdd->errorInfo(), TRUE));
$req->execute(array(':idpr' => $idpr, ':repformater' => $_POST['en'])) or die(print_r($bdd->errorInfo(), TRUE));
} else {
$bdd->exec('INSERT INTO admin(idp, val) VALUES(' . $idpr . ', ' . $bdd->quote($_POST['en']) . ')') or die(print_r($bdd->errorInfo(), TRUE));
} |
Partager