Guest User

Untitled

a guest
Nov 19th, 2017
99
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.71 KB | None | 0 0
  1. `
  2. <div id="pole">
  3. <input class="name" id="name" type="text" name="name" required placeholder=" " />
  4. <br />
  5. <input class="email" id="email" type="text" name="email" placeholder=" " />
  6. <textarea class="message" id="message" type="text" name="message" required placeholder=" "></textarea>
  7. <br />`
  8.  
  9. <?
  10. $name = $_POST["name"];
  11. $email = $_POST["email"];;
  12. $message = $_POST["message"];
  13. $date = $_POST["date"];
  14. $date = date("y.m.d");
  15.  
  16. $host = 'localhost';
  17. $db_user = 'root';
  18. $db_pass = '';
  19. $db_name = 'form';
  20.  
  21. $connect = mysql_connect($host, $db_user, $db_pass) or die("Ошибка: " . mysql_error());
  22. mysql_select_db($db_name) or die("Ошибка");
  23. mysql_set_charset('utf8');
  24.  
  25. if (isset($message) && $message != '') {
  26. $query = 'INSERT INTO messages (name, email, msg, date) VALUES ("' . $name . '", "' . $email . '", "' . $message . '", "' . $date . '")';
  27. mysql_query($query) or die("Ошибка:" . mysql_error());
  28. }
  29. echo '<br />';
  30. $query = 'SELECT * FROM messages ORDER BY id DESC LIMIT 10';
  31. $result = mysql_query($query) or die("Ошибка: " . mysql_error());
  32. while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
  33. echo '<ol>';
  34. echo '<li>';
  35. echo '<div id="com">';
  36. echo '<div id="name1">';
  37. echo '<label><h5>' . $row["name"] . '</h5></label>';
  38. echo '</div>';
  39. echo '<div id="date" align="right">';
  40. list($y, $m, $d) = explode ("-", $row['date']);
  41. echo '<label><h5>' . $d.".".$m.".".$y . '</h5></label>';
  42. echo '</div>';
  43. echo '<div id="line">';
  44. echo '</div>';
  45. echo '<div id="text1">';
  46. echo '<label><p>' . $row["msg"] . '</p></label>';
  47. echo '</div>';
  48. echo '</li>';
  49. echo '</ol>';
  50. }
  51. mysql_free_result($result);
  52. mysql_close($connect);
  53. ?>
Add Comment
Please, Sign In to add comment