Commit | Line | Data |
---|---|---|
b5f60f89 JB |
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 | ?> |