Commit | Line | Data |
---|---|---|
6405835a | 1 | <?php |
77e90052 | 2 | |
1f4879b9 JB |
3 | /** |
4 | * [is_post_request description] | |
5 | * @return boolean [description] | |
6 | */ | |
a96fefe1 JB |
7 | function is_post_request() |
8 | { | |
6405835a JB |
9 | if (filter_input(INPUT_SERVER, 'REQUEST_METHOD') === 'POST') { |
10 | return true; | |
11 | } else { | |
12 | return false; | |
13 | } | |
14 | } | |
65fc0194 | 15 | |
1f4879b9 JB |
16 | /** |
17 | * [is_get_request description] | |
18 | * @return boolean [description] | |
19 | */ | |
a96fefe1 JB |
20 | function is_get_request() |
21 | { | |
65fc0194 JB |
22 | if (filter_input(INPUT_SERVER, 'REQUEST_METHOD') === 'GET') { |
23 | return true; | |
24 | } else { | |
25 | return false; | |
26 | } | |
27 | } | |
a96fefe1 | 28 | |
1f4879b9 JB |
29 | /** |
30 | * [chk_account description] | |
31 | * @param [type] $email [description] | |
32 | * @return [type] [description] | |
33 | */ | |
a96fefe1 JB |
34 | function chk_account($email) |
35 | { | |
36 | global $connection; | |
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(); | |
33eb6f2a | 44 | if (!empty($row[0][0])) { |
a96fefe1 JB |
45 | return true; |
46 | } else { | |
47 | return false; | |
48 | } | |
49 | } | |
50 | ||
1f4879b9 JB |
51 | /** |
52 | * [chk_password description] | |
53 | * @param [type] $email [description] | |
54 | * @param [type] $password [description] | |
55 | * @return [type] [description] | |
56 | */ | |
a96fefe1 JB |
57 | function chk_password($email, $password) |
58 | { | |
59 | global $connection; | |
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(); | |
33eb6f2a | 67 | if (password_verify($password, $row[0][0])) { |
a96fefe1 JB |
68 | return true; |
69 | } else { | |
70 | return false; | |
71 | } | |
72 | } | |
73 | ||
1f4879b9 JB |
74 | /** |
75 | * [get_client_id description] | |
76 | * @param [type] $email [description] | |
77 | * @return [type] [description] | |
78 | */ | |
33eb6f2a JB |
79 | function get_client_id($email) |
80 | { | |
81 | global $connection; | |
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(); | |
89 | return $row[0][0]; | |
90 | } | |
91 | ||
1f4879b9 JB |
92 | /** |
93 | * [nb_booked description] | |
94 | * @param [type] $client_id [description] | |
95 | * @param [type] $flight_id [description] | |
96 | * @return [type] [description] | |
97 | */ | |
22f1dc64 | 98 | function nb_booked($client_id, $flight_id, $class_name) |
33eb6f2a JB |
99 | { |
100 | global $connection; | |
22f1dc64 | 101 | $sql_pquery = "select SUM(NbPlaces) from RESERVATIONS where NumCl = ? and NumVol = ? and Classe = ?"; |
33eb6f2a | 102 | $connection->prepare_query($sql_pquery); |
22f1dc64 | 103 | $connection->prepared_query_bind_param("iss", array($client_id, $flight_id, $class_name)); |
33eb6f2a JB |
104 | $connection->run_prepared_query(); |
105 | $connection->get_pquery_result(); | |
106 | $row = $connection->get_result_array(); | |
107 | $connection->close_prepared_query(); | |
108 | return $row[0][0]; | |
109 | } | |
110 | ||
1f4879b9 JB |
111 | /** |
112 | * [chk_logged_in description] | |
113 | * @return [type] [description] | |
114 | */ | |
a96fefe1 JB |
115 | function chk_logged_in() |
116 | { | |
db6cae90 | 117 | if (isset($_SESSION['email']) && isset($_SESSION['IP_address'])) { |
a96fefe1 JB |
118 | return true; |
119 | } else { | |
120 | return false; | |
121 | } | |
122 | } | |
123 | ||
1f4879b9 JB |
124 | /** |
125 | * [redirect description] | |
126 | * @param [type] $url [description] | |
127 | * @param [type] $delay [description] | |
128 | * @return [type] [description] | |
129 | */ | |
a96fefe1 JB |
130 | function redirect($url, $delay) |
131 | { | |
132 | header("refresh:$delay; url=$url"); | |
133 | } | |
134 | ||
6405835a | 135 | ?> |