fork download
  1. <?php header('content-type:text/html; charset=utf-8');?>
  2. <form action="reg.php" method="POST">
  3. <input type="text" name="name" placeholder="Имя" required> <br/>
  4. <input type="text" name="login" placeholder="Логин" required> <br/>
  5. <input type="password" name="pass" placeholder="Пароль (мин. 6 знаков)" min="6" required> <br/>
  6. <input type="password" name="confirm_pass" placeholder="Подтверждение пароля" min="6" required> <br/>
  7. <input type="submit" name="submit" value="Регистрация">
  8. </form><br/>
  9.  
  10.  
  11. <?php
  12. //creating a db
  13. if(!file_exists("db.db")){
  14. $db = sqlite_open("db.db");
  15. if(!$db) echo '<p style="color:red;">Таблица не создана</p>';
  16. //creating a table
  17. sqlite_query($db, "CREATE TABLE users (id INTEGER PRIMARY KEY, name TEXT, login TEXT, pass INTEGER); ");
  18. }
  19.  
  20. //открытие БД
  21. $db = sqlite_open("db.db");
  22.  
  23. if(isset($_POST['submit'])){
  24. $name = $_POST['name'];
  25. $login = $_POST['login'];
  26. $pass = $_POST['pass'];
  27. $confirm_pass = $_POST['confirm_pass'];
  28. if($pass == $confirm_pass){
  29. $pass = md5($pass);
  30. sqlite_query($db, "INSERT INTO users(id, name, login, pass) VALUES (NULL, '$name', '$login', '$pass')");
  31. }else
  32. die("Пароли не совпадают!");
  33. }
  34. //количество пользователей
  35. $users = sqlite_query($db, "SELECT * FROM users");
  36. echo "Всего пользователей: " .sqlite_num_rows($users). "<br/>";
  37.  
  38. //вывод записей
  39. while ($res = sqlite_fetch_array($users)){
  40. echo "Имя: " .$res['name']."<br/>";
  41. echo "Логин: " .$res['login']."<br/>";
  42. echo "Пароль: " .$res['pass']."<br/>";
  43. echo "<hr>";
  44. }
  45.  
  46.  
  47. ?>
Runtime error #stdin #stdout #stderr 0.01s 20568KB
stdin
Standard input is empty
stdout
<form action="reg.php" method="POST">
<input type="text" name="name" placeholder="Имя" required> <br/>
<input type="text" name="login" placeholder="Логин" required> <br/>
<input type="password" name="pass" placeholder="Пароль (мин. 6 знаков)" min="6" required> <br/>
<input type="password" name="confirm_pass" placeholder="Подтверждение пароля" min="6" required> <br/>
<input type="submit" name="submit" value="Регистрация">
</form><br/>


stderr
PHP Fatal error:  Call to undefined function sqlite_open() in /home/b4j9MQ/prog.php on line 15