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
| function modificationEq($description, $ageMinEq, $ageMaxEq, $dateDebutEq, $dateFinEq ){
require(__DIR__ . "/../../config/config.php");
try{
// les 3 varibales sont les mêmes que dans le dossier config
$dbh = new PDO($info,$user,$passwordDB);
$dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$statement = "UPDATE stg_equestre SET description = :newDescription";
$statementPlanning = "UPDATE eq_planning SET age_min = :newAgeMin, age_max= :newAgeMax, date_debut = :newDateDebutEq, date_fin = :newDateFinEq";
$result = $dbh -> prepare($statement);
$resultPlanning = $dbh -> prepare($statementPlanning);
$result -> execute([':newDescription' => $description])/*':id' => $id]*/;
$resultPlanning -> execute([':newAgeMin' => $ageMinEq,
':newAgeMax' => $ageMaxEq,
':newDateDebutEq' => $dateDebutEq,
':newDateFinEq' => $dateFinEq
]);
}catch( Exeption $e){
echo $e->getMessage();
} |
Partager