<?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}')");
}
}
