Commit | Line | Data |
---|---|---|
6405835a | 1 | <?php |
77e90052 | 2 | |
a96fefe1 JB |
3 | function is_post_request() |
4 | { | |
6405835a JB |
5 | if (filter_input(INPUT_SERVER, 'REQUEST_METHOD') === 'POST') { |
6 | return true; | |
7 | } else { | |
8 | return false; | |
9 | } | |
10 | } | |
65fc0194 | 11 | |
a96fefe1 JB |
12 | function is_get_request() |
13 | { | |
65fc0194 JB |
14 | if (filter_input(INPUT_SERVER, 'REQUEST_METHOD') === 'GET') { |
15 | return true; | |
16 | } else { | |
17 | return false; | |
18 | } | |
19 | } | |
a96fefe1 JB |
20 | |
21 | function chk_account($email) | |
22 | { | |
23 | global $connection; | |
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(); | |
33eb6f2a | 31 | if (!empty($row[0][0])) { |
a96fefe1 JB |
32 | return true; |
33 | } else { | |
34 | return false; | |
35 | } | |
36 | } | |
37 | ||
38 | function chk_password($email, $password) | |
39 | { | |
40 | global $connection; | |
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(); | |
33eb6f2a | 48 | if (password_verify($password, $row[0][0])) { |
a96fefe1 JB |
49 | return true; |
50 | } else { | |
51 | return false; | |
52 | } | |
53 | } | |
54 | ||
33eb6f2a JB |
55 | function get_client_id($email) |
56 | { | |
57 | global $connection; | |
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(); | |
65 | return $row[0][0]; | |
66 | } | |
67 | ||
68 | function nb_booked($client_id, $flight_id) | |
69 | { | |
70 | global $connection; | |
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(); | |
78 | return $row[0][0]; | |
79 | } | |
80 | ||
a96fefe1 JB |
81 | function chk_logged_in() |
82 | { | |
db6cae90 | 83 | if (isset($_SESSION['email']) && isset($_SESSION['IP_address'])) { |
a96fefe1 JB |
84 | return true; |
85 | } else { | |
86 | return false; | |
87 | } | |
88 | } | |
89 | ||
90 | function redirect($url, $delay) | |
91 | { | |
92 | header("refresh:$delay; url=$url"); | |
93 | } | |
94 | ||
6405835a | 95 | ?> |