Advertisement
Guest User

DAMIR2

a guest
Jan 26th, 2018
89
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.74 KB | None | 0 0
  1. <?php
  2. session_start();
  3. $host = 'localhost'; // адрес сервера
  4. $database = 'baza2'; // имя базы данных
  5. $user = 'root'; // имя пользователя
  6. $password = ''; // пароль
  7. $link = mysql_connect($host, $user, $password) // подключаемся к серверу и базе данных
  8. or die("Ошибка " . mysqli_error($link)); // если по какой то причине не произошло подключение к серверу выводится ошибка
  9. $bdlink = mysql_select_db($database,$link);
  10.  
  11. $login = (int)$_SESSION['login'];
  12. $password = (int)$_SESSION['password'];
  13. $email = (int)$_SESSION['email'];
  14. $sql = mysql_query("
  15. SELECT COUNT(*) FROM `users`
  16. WHERE `login` = {$login}
  17. AND `email` = {$email}
  18. ");
  19. $row = mysql_fetch_row($sql);
  20. if($row[0] == 1)
  21. {
  22. $_SESSION['check_exist_user'] = 1;
  23. header("Location: index.php");
  24. }else {
  25. $sql = mysql_query(
  26. "
  27. INSERT INTO `users`(`login`,`password`,`email`)
  28. VALUES(
  29. {$login},
  30. {$password},
  31. {$email}
  32. )
  33. "
  34. );
  35. $_SESSION['check_exist_user'] = 0;
  36. header("Location: index.php");
  37. }
  38. echo mysql_error();
  39. ?>
  40.  
  41.  
  42. !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
  43.  
  44.  
  45.  
  46. <?php
  47. session_start();
  48. $host = 'localhost'; // адрес сервера
  49. $database = 'baza2'; // имя базы данных
  50. $user = 'root'; // имя пользователя
  51. $password = ''; // пароль
  52. $link = mysql_connect($host, $user, $password) or die("Ошибка " . mysqli_error($link));
  53. $bdlink = mysql_select_db($database,$link);
  54. $login = $_POST['i1'];
  55. $password = $_POST['i2'];
  56. $email = $_POST['i3'];
  57. if(isset($_POST['reg'])){
  58. $_SESSION['login'] = $login;
  59. $_SESSION['password'] = $password;
  60. $_SESSION['email'] = $email;
  61. header("Location: reg.php");
  62. }else{
  63. $sql = mysql_query("SELECT COUNT(*) FROM `users` WHERE `login` = '{$login}'");
  64. $sql = mysql_query(
  65. "SELECT COUNT(*) FROM `users`
  66. WHERE
  67. `login` = '{$login}'
  68. AND `password` = '{$password}'
  69. AND `email` = '{$email}'"
  70. );
  71. $row = mysql_fetch_row($sql);
  72. if($row[0] == 0){
  73. $_SESSION['proverka'] = 2;
  74. header("Location: index.php");
  75. }else {
  76. $_SESSION['login'] = $login;
  77. $_SESSION['proverka'] = 1;
  78. header("Location: index.php");
  79. }}
  80.  
  81. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement