Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $dbhost = "localhost";
- $dbname = "test";
- $dbusername = "root";
- $dbpass = "";
- try {
- $DBH = new PDO("mysql:host=$dbhost;dbname=$dbname", $dbusername, $dbpass);
- }
- catch(PDOException $db) {
- echo $db->getMessage();
- }
- if (isset($_POST['submit'])) {
- $title = $_POST['title'];
- $message = $_POST['message'];
- try {
- $STH = $DBH->prepare("INSERT INTO example (title, message) values (:title, :message)");
- $STH->bindParam(':title', $title);
- $STH->bindParam(':message', $message);
- $STH->execute();
- }
- catch(PDOException $db) {
- echo $db->getMessage();
- }
- echo "Данные введены успешно";
- }
- if (isset($_POST['print'])) {
- $STH = $DBH->query('SELECT title, message from example');
- }
- ?>
- <!DOCTYPE html>
- <html>
- <head>
- <title></title>
- </head>
- <body>
- <form action="action.php" method="POST">
- <p>Заголовок<input type="text" name="title"/></p>
- <p>Сообщение<textarea name="message"></textarea></p>
- <input type="submit" name="submit" value="Оправить" />
- <p><input type="submit" name="print" value="Вывести"</p></br>
- <?php while ($row = $STH->fetch(PDO::FETCH_ASSOC)):
- echo $row['title'] . "</br>";
- echo $row['message'] . "</br>";
- endwhile;
- ?>
- </form>
- </body>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement