includes/formregister.php

   1 <?php
   2 $form_name = filter_input(INPUT_POST, "name", FILTER_SANITIZE_STRING);
   3 $form_firstname = filter_input(INPUT_POST, "firstname", FILTER_SANITIZE_STRING);
   4 $form_numstreet = filter_input(INPUT_POST, "numstreet", FILTER_VALIDATE_INT);
   5 $form_street = filter_input(INPUT_POST, "street", FILTER_SANITIZE_STRING);
   6 $form_postalcode = filter_input(INPUT_POST, "postalcode", FILTER_VALIDATE_INT);
   7 $form_town = filter_input(INPUT_POST, "postalcode", FILTER_SANITIZE_STRING);
   8 $form_email = filter_input(INPUT_POST, "email", FILTER_VALIDATE_EMAIL);
   9 $form_password = filter_input(INPUT_POST, "password", FILTER_SANITIZE_STRING);
  10 $form_confirmpassword = filter_input(INPUT_POST, "confirmpassword", FILTER_SANITIZE_STRING);
  11
  12 $error_numstreet = false;
  13 $error_postalcode = false;
  14 $error_email = false;
  15 $error_password = false;
  16
  17 if (!$form_numstreet) {
  18     echo "The street number is not valid <br>" ;
  19     $error_numstreet = true;
  20 }
  21 if (!$form_postalcode) {
  22     echo "The postal code is not valid <br>";
  23     $error_postalcode = true;
  24 }
  25 if (!$form_email) {
  26     echo "The email is not valid <br>";
  27     $error_email = true;
  28 }
  29 if (strcmp($form_password, $form_confirmpassword) === 0) {
  30     echo "Password do not match <br>";
  31     $error_password = true;
  32 }
  33
  34 if (!empty($form_name) && !empty($form_firstname) && !empty($form_numstreet) && !empty($form_street) &&
  35     !empty($form_postalcode) && !empty($form_town) && !empty($form_email) && !empty($form_password)){
  36     global $connection;
  37     $sql_pquery = "select count(NumCl) from CLIENTS where EmailCl = ?";
  38     $stmt = $connection->prepare_query($sql_pquery);
  39     $stmt->bind_param("s", $form_email);
  40     //$connection->prepared_query_bind_param("s", $form_email);
  41     $connection->run_prepared_query();
  42     $connection->close_prepared_query();
  43 }
  44 ?>