Advertisement
Guest User

Untitled

a guest
Feb 8th, 2016
74
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.34 KB | None | 0 0
  1. <?php
  2. $dbhost = "localhost";
  3. $dbname = "test";
  4. $dbusername = "root";
  5. $dbpass = "";
  6. try {
  7.     $DBH = new PDO("mysql:host=$dbhost;dbname=$dbname", $dbusername, $dbpass);
  8. }
  9. catch(PDOException $db) {
  10.     echo $db->getMessage();
  11. }
  12.  
  13. if (isset($_POST['submit'])) {
  14.     $title = $_POST['title'];
  15.     $message = $_POST['message'];
  16.     try {
  17.         $STH = $DBH->prepare("INSERT INTO example (title, message) values (:title, :message)");
  18.         $STH->bindParam(':title', $title);
  19.         $STH->bindParam(':message', $message);
  20.         $STH->execute();
  21.     }
  22.     catch(PDOException $db) {
  23.         echo $db->getMessage();
  24.     }
  25.     echo "Данные введены успешно";
  26. }
  27. if (isset($_POST['print'])) {
  28.     $STH = $DBH->query('SELECT title, message from example');
  29.  
  30. }
  31.  
  32. ?>
  33. <!DOCTYPE html>
  34. <html>
  35. <head>
  36.     <title></title>
  37. </head>
  38. <body>
  39. <form  action="action.php" method="POST">
  40.     <p>Заголовок<input type="text" name="title"/></p>
  41.     <p>Сообщение<textarea name="message"></textarea></p>
  42.     <input type="submit" name="submit" value="Оправить" />
  43.     <p><input type="submit" name="print" value="Вывести"</p></br>
  44.     <?php   while ($row = $STH->fetch(PDO::FETCH_ASSOC)):
  45.     echo $row['title'] . "</br>";
  46.     echo $row['message'] . "</br>";
  47.     endwhile;
  48.     ?>
  49. </form>
  50. </body>
  51. </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement