1 2 3 4 5 6 7 8 9 10 11 12 13
| $result = $bdd->query ("SELECT count(*) FROM admin WHERE idp= $idpr ")->fetchColumn();
$repformate=mysql_escape_string($_POST['en']);
if(!empty($result))
{
$req = $bdd->prepare('UPDATE admin SET val = :repformater WHERE idp = :idpr')or die(print_r($bdd->errorInfo()));
$req->execute(array(':idpr' => $idpr, ':repformater' => $repformate)) or die(print_r($bdd->errorInfo()));
unset($_POST);
}
else
{
$bdd->exec("INSERT INTO admin(idp,val) VALUES('$idpr','$repformate')") or die(print_r($bdd->errorInfo()));
unset($_POST);
} |
Partager