<?php
try
{
$bdd=new pdo('mysql:host=localhost;dbname=***','root','');
}
catch (Exception $e)
{
die ('Erreur:'.$e->getmessage());
}
$req1=$bdd->prepare('select etat from etat_recap where n_dossier =:n_doosier');
$req1->execute(array('n_dossier'=>$_POST['n_dossier']));
$donne = $req1->fetch()
if($donne['etat'] == "INSTANCE")
{
$req1->closeCursor();
$req2=$bdd->prepare('update etat_recap set date_decision =:date_decision,decision_crp =:decision_crp,etat_dossier =:decision_crp');
$req2->execute(array('date_decision'=>$_POST['date_decision'],'decision_crp'=>$_POST['decision_crp'],'etat_dossier'=>$_POST['decision_crp']));
$req2->closeCursor();
}
else
{
une autre requete insertion
}
?>
salahcc