lib/utils.php

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