<?php /* session_start(); if(!isset($_SESSION['user'])){ header('location: login.php'); exit("Need to login to the system touse this function."); } */ define('DB_SERVER', 'localhost'); define('DB_NAME', 'sm'); define('DB_USER', 'root'); define('DB_PASS', ''); BD::connect(); class bd { public static $con; public static function connect() { BD::$con = mysqli_connect(DB_SERVER, DB_USER, DB_PASS, DB_NAME); if (!bd::$con) { echo "Error: No se pudo conectar a MySQL." . PHP_EOL; exit; } mysqli_set_charset(BD::$con, "utf8"); } public static function cast_query_results($rs) { $fields = mysqli_fetch_fields($rs); $data = array(); $types = array();
function proverka_danux() { if (isset($_POST['fio'])) { $this->fio = $_POST['fio']; if ($this->fio == '') { unset($this->fio); } } if (isset($_POST['mail'])) { $this->mail = $_POST['mail']; if ($this->mail == '') { unset($this->mail); } } if (isset($_POST['login'])) { $this->login = $_POST['login']; if ($this->login == '') { unset($this->login); } } if (isset($_POST['pass'])) { $this->pass = $_POST['pass']; if ($this->pass == '') { unset($this->pass); } } if (isset($_POST['pass1'])) { $this->pass1 = $_POST['pass1']; if ($this->pass1 == '') { unset($this->pass1); } } if ($this->pass == $this->pass1) { $this->pass2 = $this->pass; } else { exit("Пароли не совпадают, повторите попытку!"); } if (empty($this->login) or empty($this->pass2) or empty($this->fio) or empty($this->mail)) { exit("Вы ввели не всю информацию, пожалуйста заполните все поля!"); } $this->login = stripslashes($this->login); $this->login = htmlspecialchars($this->login); $this->login = trim($this->login); $this->mail = trim($this->mail); if (!preg_match('/^([a-z0-9])(\\w|[.]|-|_)+([a-z0-9])@([a-z0-9])([a-z0-9.-]*)([a-z0-9])([.]{1})([a-z]{2,4})$/is', $_POST['mail'])) { return false; } if (strlen($_POST['login']) < 5) { return false; } // не меньше 4 символов логин $this->pass2 = stripslashes($this->pass2); $this->pass2 = htmlspecialchars($this->pass2); $this->pass2 = trim($this->pass2); if (strlen($_POST['pass']) < 5) { return false; } //не меньше 5 символов пароль $this->pass2 = password_hash($this->pass2, PASSWORD_BCRYPT); $date_reg = date('Y:m:d H:i'); $pdo = new BD(); $pdo->connect(); $res = $pdo->query("SELECT `id`, `pass`, `login` FROM `users` WHERE 'login' = '{$this->login}'"); $row = $res->fetch(); if (!empty($row['id'])) { exit("Данный пользователь уже зарегестирован!"); } else { $res1 = mysql_query("INSERT INTO user (login,pass,mail,fio,date_reg) VALUE ('{$login}', '{$pass2}','{$mail}', '{$fio}', '{$date_reg}')"); } }