X-Git-Url: https://git.piment-noir.org/?a=blobdiff_plain;f=lib%2Futils.php;h=9955458cffd1c7b8420082dec60dd75c1ceb7496;hb=01135b89a6848059df608e8c23e8684233772b4f;hp=d937db729cb9f78b9bd54109c811136289de9e18;hpb=65fc0194b3ae059f212c577db4f4a8fec43069d6;p=Project_webapp.git

diff --git a/lib/utils.php b/lib/utils.php
index d937db7..9955458 100644
--- a/lib/utils.php
+++ b/lib/utils.php
@@ -1,5 +1,11 @@
 <?php
-function is_post_request() {
+
+/**
+ * [is_post_request description]
+ * @return boolean [description]
+ */
+function is_post_request()
+{
     if (filter_input(INPUT_SERVER, 'REQUEST_METHOD') === 'POST') {
         return true;
     } else {
@@ -7,11 +13,123 @@ function is_post_request() {
     }
 }
 
-function is_get_request() {
+/**
+ * [is_get_request description]
+ * @return boolean [description]
+ */
+function is_get_request()
+{
     if (filter_input(INPUT_SERVER, 'REQUEST_METHOD') === 'GET') {
         return true;
     } else {
         return false;
     }
 }
+
+/**
+ * [chk_account description]
+ * @param  [type] $email [description]
+ * @return [type]        [description]
+ */
+function chk_account($email)
+{
+    global $connection;
+    $sql_pquery = "select count(NumCl) from CLIENTS where EmailCl = ?";
+    $connection->prepare_query($sql_pquery);
+    $connection->prepared_query_bind_param("s", array($email));
+    $connection->run_prepared_query();
+    $connection->get_pquery_result();
+    $row = $connection->get_result_array();
+    $connection->close_prepared_query();
+    if (!empty($row[0][0])) {
+        return true;
+    } else {
+        return false;
+    }
+}
+
+/**
+ * [chk_password description]
+ * @param  [type] $email    [description]
+ * @param  [type] $password [description]
+ * @return [type]           [description]
+ */
+function chk_password($email, $password)
+{
+    global $connection;
+    $sql_pquery = "select PasswordCl from CLIENTS where EmailCl = ?";
+    $connection->prepare_query($sql_pquery);
+    $connection->prepared_query_bind_param("s", array($email));
+    $connection->run_prepared_query();
+    $connection->get_pquery_result();
+    $row = $connection->get_result_array();
+    $connection->close_prepared_query();
+    if (password_verify($password, $row[0][0])) {
+        return true;
+    } else {
+        return false;
+    }
+}
+
+/**
+ * [get_client_id description]
+ * @param  [type] $email [description]
+ * @return [type]        [description]
+ */
+function get_client_id($email)
+{
+    global $connection;
+    $sql_pquery = "select NumCl from CLIENTS where EmailCl = ?";
+    $connection->prepare_query($sql_pquery);
+    $connection->prepared_query_bind_param("s", array($email));
+    $connection->run_prepared_query();
+    $connection->get_pquery_result();
+    $row = $connection->get_result_array();
+    $connection->close_prepared_query();
+    return $row[0][0];
+}
+
+/**
+ * [nb_booked description]
+ * @param  [type] $client_id [description]
+ * @param  [type] $flight_id [description]
+ * @return [type]            [description]
+ */
+function nb_booked($client_id, $flight_id)
+{
+    global $connection;
+    $sql_pquery = "select SUM(NbPlaces) from RESERVATIONS where NumCl = ? and NumVol = ?";
+    $connection->prepare_query($sql_pquery);
+    $connection->prepared_query_bind_param("is", array($client_id, $flight_id));
+    $connection->run_prepared_query();
+    $connection->get_pquery_result();
+    $row = $connection->get_result_array();
+    $connection->close_prepared_query();
+    return $row[0][0];
+}
+
+/**
+ * [chk_logged_in description]
+ * @return [type] [description]
+ */
+function chk_logged_in()
+{
+    if (isset($_SESSION['email']) && isset($_SESSION['IP_address'])) {
+        return true;
+    } else {
+        return false;
+    }
+}
+
+/**
+ * [redirect description]
+ * @param  [type] $url   [description]
+ * @param  [type] $delay [description]
+ * @return [type]        [description]
+ */
+function redirect($url, $delay)
+{
+    header("refresh:$delay; url=$url");
+}
+
 ?>