3 function is_post_request()
5 if (filter_input(INPUT_SERVER
, 'REQUEST_METHOD') === 'POST') {
12 function is_get_request()
14 if (filter_input(INPUT_SERVER
, 'REQUEST_METHOD') === 'GET') {
21 function chk_account($email)
24 $sql_pquery = "select count(NumCl) from CLIENTS where EmailCl = ?";
25 $connection->prepare_query($sql_pquery);
26 $connection->prepared_query_bind_param("s", array($email));
27 $connection->run_prepared_query();
28 $connection->get_pquery_result();
29 $row = $connection->get_result_array();
30 $connection->close_prepared_query();
31 if (!empty($row[0][0])) {
38 function chk_password($email, $password)
41 $sql_pquery = "select PasswordCl from CLIENTS where EmailCl = ?";
42 $connection->prepare_query($sql_pquery);
43 $connection->prepared_query_bind_param("s", array($email));
44 $connection->run_prepared_query();
45 $connection->get_pquery_result();
46 $row = $connection->get_result_array();
47 $connection->close_prepared_query();
48 if (password_verify($password, $row[0][0])) {
55 function get_client_id($email)
58 $sql_pquery = "select NumCl from CLIENTS where EmailCl = ?";
59 $connection->prepare_query($sql_pquery);
60 $connection->prepared_query_bind_param("s", array($email));
61 $connection->run_prepared_query();
62 $connection->get_pquery_result();
63 $row = $connection->get_result_array();
64 $connection->close_prepared_query();
68 function nb_booked($client_id, $flight_id)
71 $sql_pquery = "select SUM(NbPlaces) from RESERVATIONS where NumCl = ? and NumVol = ?";
72 $connection->prepare_query($sql_pquery);
73 $connection->prepared_query_bind_param("is", array($client_id, $flight_id));
74 $connection->run_prepared_query();
75 $connection->get_pquery_result();
76 $row = $connection->get_result_array();
77 $connection->close_prepared_query();
81 function chk_logged_in()
83 if (isset($_SESSION['email']) && isset($_SESSION['IP_address'])) {
90 function redirect($url, $delay)
92 header("refresh:$delay; url=$url");