Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- session_start();
- $host = 'localhost'; // адрес сервера
- $database = 'baza2'; // имя базы данных
- $user = 'root'; // имя пользователя
- $password = ''; // пароль
- $link = mysql_connect($host, $user, $password) // подключаемся к серверу и базе данных
- or die("Ошибка " . mysqli_error($link)); // если по какой то причине не произошло подключение к серверу выводится ошибка
- $bdlink = mysql_select_db($database,$link);
- $login = (int)$_SESSION['login'];
- $password = (int)$_SESSION['password'];
- $email = (int)$_SESSION['email'];
- $sql = mysql_query("
- SELECT COUNT(*) FROM `users`
- WHERE `login` = {$login}
- AND `email` = {$email}
- ");
- $row = mysql_fetch_row($sql);
- if($row[0] == 1)
- {
- $_SESSION['check_exist_user'] = 1;
- header("Location: index.php");
- }else {
- $sql = mysql_query(
- "
- INSERT INTO `users`(`login`,`password`,`email`)
- VALUES(
- {$login},
- {$password},
- {$email}
- )
- "
- );
- $_SESSION['check_exist_user'] = 0;
- header("Location: index.php");
- }
- echo mysql_error();
- ?>
- !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
- <?php
- session_start();
- $host = 'localhost'; // адрес сервера
- $database = 'baza2'; // имя базы данных
- $user = 'root'; // имя пользователя
- $password = ''; // пароль
- $link = mysql_connect($host, $user, $password) or die("Ошибка " . mysqli_error($link));
- $bdlink = mysql_select_db($database,$link);
- $login = $_POST['i1'];
- $password = $_POST['i2'];
- $email = $_POST['i3'];
- if(isset($_POST['reg'])){
- $_SESSION['login'] = $login;
- $_SESSION['password'] = $password;
- $_SESSION['email'] = $email;
- header("Location: reg.php");
- }else{
- $sql = mysql_query("SELECT COUNT(*) FROM `users` WHERE `login` = '{$login}'");
- $sql = mysql_query(
- "SELECT COUNT(*) FROM `users`
- WHERE
- `login` = '{$login}'
- AND `password` = '{$password}'
- AND `email` = '{$email}'"
- );
- $row = mysql_fetch_row($sql);
- if($row[0] == 0){
- $_SESSION['proverka'] = 2;
- header("Location: index.php");
- }else {
- $_SESSION['login'] = $login;
- $_SESSION['proverka'] = 1;
- header("Location: index.php");
- }}
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement