[Project_webapp.git] / includes / formmodify.php

<?php
$form_flight_id = filter_input(INPUT_POST, "flight_id", FILTER_SANITIZE_STRING);
$form_nb_place = filter_input(INPUT_POST, "nb_place", FILTER_VALIDATE_INT);
$form_class_name = filter_input(INPUT_POST, "class_name", FILTER_SANITIZE_STRING);

global $connection;
$client_id = get_client_id($_SESSION['email']);
$sql_pquery = "update RESERVATIONS
                   set NbPlaces = ?, Classe = ?
                   where NumCl = ? and NumVol = ?";
$connection->prepare_query($sql_pquery);
$connection->prepared_query_bind_param("isis", array($form_nb_place, $form_class_name, $client_id, $form_flight_id));
$connection->run_prepared_query();
$connection->close_prepared_query();
echo "Modifications enregistre&#769;es. <br>";
redirect("index.php?page=reservations", 3);
?>
Commit	Line	Data
c49f7219 JB	1	<?php
	2	$form_flight_id = filter_input(INPUT_POST, "flight_id", FILTER_SANITIZE_STRING);
	3	$form_nb_place = filter_input(INPUT_POST, "nb_place", FILTER_VALIDATE_INT);
	4	$form_class_name = filter_input(INPUT_POST, "class_name", FILTER_SANITIZE_STRING);
	5
	6	global $connection;
	7	$client_id = get_client_id($_SESSION['email']);
	8	$sql_pquery = "update RESERVATIONS
	9	set NbPlaces = ?, Classe = ?
	10	where NumCl = ? and NumVol = ?";
	11	$connection->prepare_query($sql_pquery);
	12	$connection->prepared_query_bind_param("isis", array($form_nb_place, $form_class_name, $client_id, $form_flight_id));
	13	$connection->run_prepared_query();
	14	$connection->close_prepared_query();
	15	echo "Modifications enregistrées. <br>";
	16	redirect("index.php?page=reservations", 3);
	17	?>