$error = true; $error_messages[] = 'email is not set'; } if (!isset($_POST['password'])) { $error = true; $error_messages[] = 'password is not set'; } if (strlen($_POST['password']) < 3 || strlen($_POST['password']) > 30) { $error_messages[] = 'Ivalid password length'; $error = true; } if (!filter_var($_POST['email'], FILTER_VALIDATE_EMAIL)) { $error_messages[] = 'You have entered an invalid email'; $error = TRUE; } if (!CheckForValidData(strtolower($_POST['password']))) { $error_messages[] = 'You have entered an invalid password'; $error = TRUE; } $email = $mysqli->real_escape_string(trim($_POST['email'])); $password = $mysqli->real_escape_string(trim($_POST['password'])); if (!$error) { $sql = "SELECT email FROM users WHERE email = '" . $email . "'"; $query = $mysqli->query($sql); $isExistUser = $query->num_rows >= 1 ? TRUE : FALSE; if ($isExistUser) { $error_messages[] = 'email already exist!'; $error = TRUE; } else { $sql = 'INSERT INTO users (email, password) VALUES ("' . $email . '", "' . md5($password) . '");'; $query = $mysqli->query($sql);
<div><input type="submit" value="Sign Up" name="register"> <input type="reset" value="Clear"></div> </form><br> <?php if (isset($_POST['register'])) { // Нормализация на данните $username = strtolower(trim($_POST['username'])); $password = $_POST['password']; $error = FALSE; // Валидация на данните if (!CheckForValidData($username)) { echo '<div class="error">- You have entered an invalid name!</div>'; $error = TRUE; } if (!CheckForValidData($password)) { echo '<div class="error">- You have entered an invalid password!</div>'; $error = TRUE; } if (!$error) { // Извличане на името $sql = "SELECT username, password FROM users WHERE username = '******'"; $query = mysqli_query($CONNECTION, $sql); if (!HasErrorWithDataBase($query)) { exit; } // Проверка за грешки $isExistUser = mysqli_num_rows($query) >= 1 ? TRUE : FALSE; // Връща броя намерени имена if ($isExistUser) { echo '<div class="error">- Username already exist!</div>';
<div><input type="submit" value="Sign Up" name="register"> <input type="reset" value="Clear"></div> </form><br> <?php if (isset($_POST['register'])) { // Нормализация на данните $username = trim($_POST['username']); $password = $_POST['password']; $error = FALSE; // Валидация на данните if (!CheckForValidData(strtolower($username))) { echo '<div class="error">- You have entered an invalid name!</div>'; $error = TRUE; } if (!CheckForValidData(strtolower($password))) { echo '<div class="error">- You have entered an invalid password!</div>'; $error = TRUE; } if (!$error) { // Извличане на името $sql = "SELECT username, password FROM users WHERE username = '******'"; $query = mysqli_query($CONNECTION_USERS, $sql); if (HasErrorWithDataBase($query)) { exit; } // Проверка за грешки $isExistUser = mysqli_num_rows($query) >= 1 ? TRUE : FALSE; // Връща броя намерени имена if ($isExistUser) { echo '<div class="error">- Username already exist!</div>';