fork download
copy 
  1. <!DOCTYPE HTML>
  2. <html>
  3.   <head>
  4.     <title>Гостевая книга</title>
  5.     <meta charset="UTF-8">
  6.   </head>
  7.   <body>
  8.     <?php
  9.       $user = 'test';
  10.       $password = 'test';
  11.       $db = new PDO('mysql:host=127.0.0.1;dbname=testdb', $user, $password);
  12.       $db->exec("SET NAMES utf8");
  13.  
  14.  
  15.       if ($_SERVER['REQUEST_METHOD'] === 'POST') {
  16.         $username = htmlspecialchars($_POST['username']);
  17.         $message = htmlspecialchars($_POST['message']);
  18.  
  19.         if ($username != "" && $message != "") {
  20.           $stmt = $db->prepare('INSERT INTO posts SET username = ?, message = ?');
  21.           $stmt->execute(array($username, $message));
  22.         }
  23.       }
  24.  
  25.  
  26.       $stmt = $db->query('SELECT username, message FROM posts');
  27.       $rows = $stmt->fetchAll(PDO::FETCH_ASSOC);
  28.  
  29.       foreach($rows as $row) {
  30.         echo "<div style='margin-bottom: 10px;'>
  31.                 <div>{$row['username']}</div>
  32.                 <div>{$row['message']}</div>
  33.               </div>";
  34.       }
  35.     ?>
  36.  
  37.     <form method="POST" action="<?= $_SERVER['PHP_SELF'] ?>">
  38.       <div>
  39.         <label>Введите Ваше имя:</label><br>
  40.         <input type="text" name="username">
  41.       </div>
  42.  
  43.       <div>
  44.         <label>Введите сообщение:</label><br>
  45.         <input type="text" name="message">
  46.       </div>
  47.  
  48.       <input type="submit" name="okbutton" value="Отправить">
  49.     </form>
  50.   </body>
  51. </html>
Runtime error #stdin #stdout #stderr 0.01s 20520KB
comments (?)
stdin
copy 
Standard input is empty
stdout
copy 
<!DOCTYPE HTML>
<html>
  <head>
    <title>Гостевая книга</title>
    <meta charset="UTF-8">
  </head>
  <body>
stderr
copy 
PHP Fatal error:  Uncaught exception 'PDOException' with message 'could not find driver' in /home/0hCThi/prog.php:11
Stack trace:
#0 /home/0hCThi/prog.php(11): PDO->__construct('mysql:host=127....', 'test', 'test')
#1 {main}
  thrown in /home/0hCThi/prog.php on line 11
https://ideone.com/7A7OAG
language:
PHP (php 7.3.5)
created:
11 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!