if (empty($phone) || !validation::telephone($phone)) { $errMessagesArray["phone"] = "Vous devez fournir un numéro de téléphone valide"; $isSubmissionValid = false; } // Address check if (empty($address)) { $errMessagesArray["address"] = "Vous devez fournir une adresse valide"; $isSubmissionValid = false; } // City check if (empty($city)) { $errMessagesArray["city"] = "Vous devez fournir un nom de ville"; $isSubmissionValid = false; } // Postal check if (empty($postalCode) || !validation::codePostal($postalCode)) { $errMessagesArray["postalCode"] = "Vous devez fournir un code postal valide"; $isSubmissionValid = false; } if ($isSubmissionValid) { // Put user in database try { $database->beginTransaction(); if ($postType == 'register') { $database->requete("INSERT INTO st_authentication \n\t (matricule, password) \n\t VALUES ('" . $matricule . "',\n\t\t\t\t\t\t\t\t\t\t\t'" . md5($password) . "')"); $database->requete("INSERT INTO st_user_metadata \n\t\t\t\t\t\t\t\t\t(matricule,lastname,firstname,address,city,zipcode,tel_1,email)\n\t\t\t\t\t\t\t\t\tVALUES \n\t\t\t\t\t\t\t\t\t('" . $matricule . "',\n\t\t\t\t\t\t\t\t\t'" . $lastName . "',\n\t\t\t\t\t\t\t\t\t'" . $firstName . "',\n\t\t\t\t\t\t\t\t\t'" . $address . "',\n\t\t\t\t\t\t\t\t\t'" . $city . "',\n\t\t\t\t\t\t\t\t\t'" . $postalCode . "',\n\t\t\t\t\t\t\t\t\t'" . $phone . "',\n\t\t\t\t\t\t\t\t\t'" . $email . "')"); $database->commitTransaction(); if (config::SendEmail) { $pregArray = array(array('key' => "/@@LASTNAME@@/", 'value' => $lastName), array('key' => "/@@FIRSTNAME@@/", 'value' => $firstName)); util::sendEmail($email, 'email.txt', $pregArray, "Stationnement AEP - Creation de compte"); }