fork(1) download
copy 
  1. <?php header('content-type:text/html; charset=utf-8');?>
  2. <html>
  3. <head>
  4. <title>Регистрация</title>
  5. </head>
  6. <body>
  7.     <form action="reg.php" method="POST">
  8. 		<input type="text" name="name" placeholder="Имя" required> <br/>
  9. 		<input type="text" name="login" placeholder="Логин" required> <br/>
  10. 		<input type="password" name="pass" placeholder="Пароль (мин. 6 знаков)" min="6" required> <br/>
  11. 		<input type="password" name="confirm_pass" placeholder="Подтверждение пароля" min="6" required> <br/>
  12. 		<input type="submit" name="submit" value="Регистрация">
  13. 	</form><br/>
  14. </body>
  15. </html>
  16.  
  17.  
  18. <?php
  19. error_reporting(E_ALL);
  20. //creating a db
  21. if(!file_exists("db.db")){
  22. 	$db = sqlite_open("db.db");
  23. 	if(!$db) echo '<p style="color:red;">Таблица не создана</p>';
  24. 	//creating a table
  25. 	sqlite_query($db, "CREATE TABLE users (id INTEGER PRIMARY KEY, name TEXT, login TEXT, pass INTEGER); ");
  26. 	exit;
  27. }
  28.  
  29. //открытие БД
  30. $db = sqlite_open("db.db");
  31. //проверка полей
  32. if(isset($_POST['submit'])){
  33. 	$name = $_POST['name'];
  34. 	$login = $_POST['login'];
  35. 	$pass = $_POST['pass'];
  36. 	$confirm_pass = $_POST['confirm_pass'];
  37. 	if($pass == $confirm_pass){
  38. 		$pass = md5($pass);
  39. 		sqlite_query($db, "INSERT INTO users(id, name, login, pass) VALUES (NULL, '$name', '$login', '$pass')");
  40. 		header("Location: reg.php");
  41. 	}else
  42. 		die("Пароли не совпадают!");
  43. }
  44. //количество пользователей
  45. $users = sqlite_query($db, "SELECT * FROM users ORDER BY id DESC");
  46. echo "Всего пользователей: " .sqlite_num_rows($users). "<br/>";
  47.  
  48. //вывод записей
  49.  
  50. while ($res = sqlite_fetch_array($users)){
  51. 	echo "Имя: " .$res['name']."<br/>";
  52. 	echo "Логин: " .$res['login']."<br/>";
  53. 	echo "Пароль: " .$res['pass']."<br/>";
  54. 	echo "<hr>";
  55. }
  56.  
  57. ?>
  58.  
  59.  
  60. <html>
  61. <head>
  62. <title></title>
  63. </head>
  64. <body>
  65. <form action="reg.php" method="POST">
  66. 		<input type="text" name="login_auth" placeholder="Логин" required> <br/>
  67. 		<input type="password" name="pass_auth" placeholder="Пароль (мин. 6 знаков)" min="6" required> <br/>
  68. 		<input type="submit" name="auth" value="Авторизация">
  69. 	</form><br/>
  70. </body>
  71. </html>
  72.  
  73.  
  74. <?php
  75. error_reporting(E_ALL);
  76. if(isset($_POST['auth'])){
  77. 	$login_auth = $_POST['login_auth'];
  78. 	$pass_auth = md5($_POST['pass_auth']);
  79. 	$db = sqlite_open("db.db");
  80. 	$query = sqlite_query($db, "SELECT * FROM users WHERE login = $login_auth");
  81. 	$user_data = sqlite_fetch_array($query);
  82. 	if($user_data['pass']==$pass_auth){
  83. 		echo "Успешный вход";
  84. 	}else{
  85. 		echo "Неверный логин или пароль";
  86. 	}
  87.  
  88. }
  89. ?>
Compilation error #stdin compilation error #stdout 0s 0KB
comments (?)
stdin
copy 
Standard input is empty
compilation info 
prog.cpp:1:14: warning: character constant too long for its type [enabled by default]
prog.cpp:4:1: error: stray ‘\320’ in program
prog.cpp:4:1: error: stray ‘\240’ in program
prog.cpp:4:1: error: stray ‘\320’ in program
prog.cpp:4:1: error: stray ‘\265’ in program
prog.cpp:4:1: error: stray ‘\320’ in program
prog.cpp:4:1: error: stray ‘\263’ in program
prog.cpp:4:1: error: stray ‘\320’ in program
prog.cpp:4:1: error: stray ‘\270’ in program
prog.cpp:4:1: error: stray ‘\321’ in program
prog.cpp:4:1: error: stray ‘\201’ in program
prog.cpp:4:1: error: stray ‘\321’ in program
prog.cpp:4:1: error: stray ‘\202’ in program
prog.cpp:4:1: error: stray ‘\321’ in program
prog.cpp:4:1: error: stray ‘\200’ in program
prog.cpp:4:1: error: stray ‘\320’ in program
prog.cpp:4:1: error: stray ‘\260’ in program
prog.cpp:4:1: error: stray ‘\321’ in program
prog.cpp:4:1: error: stray ‘\206’ in program
prog.cpp:4:1: error: stray ‘\320’ in program
prog.cpp:4:1: error: stray ‘\270’ in program
prog.cpp:4:1: error: stray ‘\321’ in program
prog.cpp:4:1: error: stray ‘\217’ in program
prog.cpp:23:16: warning: character constant too long for its type [enabled by default]
prog.cpp:32:17: warning: character constant too long for its type [enabled by default]
prog.cpp:33:17: warning: multi-character character constant [-Wmultichar]
prog.cpp:34:18: warning: character constant too long for its type [enabled by default]
prog.cpp:35:17: warning: multi-character character constant [-Wmultichar]
prog.cpp:36:25: warning: character constant too long for its type [enabled by default]
prog.cpp:51:24: warning: multi-character character constant [-Wmultichar]
prog.cpp:52:28: warning: character constant too long for its type [enabled by default]
prog.cpp:53:30: warning: multi-character character constant [-Wmultichar]
prog.cpp:76:17: warning: multi-character character constant [-Wmultichar]
prog.cpp:77:23: warning: character constant too long for its type [enabled by default]
prog.cpp:78:26: warning: character constant too long for its type [enabled by default]
prog.cpp:82:16: warning: multi-character character constant [-Wmultichar]
prog.cpp:1:1: error: expected unqualified-id before ‘<’ token
prog.cpp:1:55: error: expected unqualified-id before ‘?’ token
prog.cpp:21:1: error: expected unqualified-id before ‘if’
prog.cpp:30:1: error: ‘$db’ does not name a type
prog.cpp:32:1: error: expected unqualified-id before ‘if’
stdout
copy 
Standard output is empty
https://ideone.com/KYya2A
language:
C++ (gcc 8.3)
created:
10 years ago
visibility:
public

Share or Embed source code

Discover > Sphere Engine API

The brand new service which powers Ideone!

Discover > IDE Widget

Widget for compiling and running the source code in a web browser!