4 * [is_post_request description]
5 * @return boolean [description]
7 function is_post_request()
9 if (filter_input(INPUT_SERVER
, 'REQUEST_METHOD') === 'POST') {
17 * [is_get_request description]
18 * @return boolean [description]
20 function is_get_request()
22 if (filter_input(INPUT_SERVER
, 'REQUEST_METHOD') === 'GET') {
30 * [chk_account description]
31 * @param [type] $email [description]
32 * @return [type] [description]
34 function chk_account($email)
37 $sql_pquery = "select count(NumCl) from CLIENTS where EmailCl = ?";
38 $connection->prepare_query($sql_pquery);
39 $connection->prepared_query_bind_param("s", array($email));
40 $connection->run_prepared_query();
41 $connection->get_pquery_result();
42 $row = $connection->get_result_array();
43 $connection->close_prepared_query();
44 if (!empty($row[0][0])) {
52 * [chk_password description]
53 * @param [type] $email [description]
54 * @param [type] $password [description]
55 * @return [type] [description]
57 function chk_password($email, $password)
60 $sql_pquery = "select PasswordCl from CLIENTS where EmailCl = ?";
61 $connection->prepare_query($sql_pquery);
62 $connection->prepared_query_bind_param("s", array($email));
63 $connection->run_prepared_query();
64 $connection->get_pquery_result();
65 $row = $connection->get_result_array();
66 $connection->close_prepared_query();
67 if (password_verify($password, $row[0][0])) {
75 * [get_client_id description]
76 * @param [type] $email [description]
77 * @return [type] [description]
79 function get_client_id($email)
82 $sql_pquery = "select NumCl from CLIENTS where EmailCl = ?";
83 $connection->prepare_query($sql_pquery);
84 $connection->prepared_query_bind_param("s", array($email));
85 $connection->run_prepared_query();
86 $connection->get_pquery_result();
87 $row = $connection->get_result_array();
88 $connection->close_prepared_query();
93 * [nb_booked description]
94 * @param [type] $client_id [description]
95 * @param [type] $flight_id [description]
96 * @return [type] [description]
98 function nb_booked($client_id, $flight_id)
101 $sql_pquery = "select SUM(NbPlaces) from RESERVATIONS where NumCl = ? and NumVol = ?";
102 $connection->prepare_query($sql_pquery);
103 $connection->prepared_query_bind_param("is", array($client_id, $flight_id));
104 $connection->run_prepared_query();
105 $connection->get_pquery_result();
106 $row = $connection->get_result_array();
107 $connection->close_prepared_query();
112 * [chk_logged_in description]
113 * @return [type] [description]
115 function chk_logged_in()
117 if (isset($_SESSION['email']) && isset($_SESSION['IP_address'])) {
125 * [redirect description]
126 * @param [type] $url [description]
127 * @param [type] $delay [description]
128 * @return [type] [description]
130 function redirect($url, $delay)
132 header("refresh:$delay; url=$url");