Advertisement
Guest User

Untitled

a guest
Nov 21st, 2016
113
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.06 KB | None | 0 0
  1. <?php
  2.  
  3. function getMessages(){
  4. $servername = 'localhost';
  5. $username = 'root';
  6. $password = '';
  7. $dbname = 'login3';
  8.  
  9. $conn = new mysqli($servername, $username, $password, $dbname);
  10. $conn->query("set names utf8");
  11.  
  12. $sql = "SELECT time_format(ido, '%T') as ido, uzeno, uzenet FROM uzenetek order by ido desc";
  13. $result = $conn->query($sql);
  14. $uzenetek = [];
  15.  
  16. if ($result->num_rows > 0) {
  17. while ($row = $result->fetch_assoc()) {
  18. $uzenetek[] = $row;
  19. }
  20. }
  21. return $uzenetek;
  22. }
  23.  
  24. $uzenetek = getMessages();
  25.  
  26.  
  27. function saveMessage($uzeno,$uzenet){
  28. $servername = 'localhost';
  29. $username = 'root';
  30. $password = '';
  31. $dbname = 'login3';
  32.  
  33. $conn = new mysqli($servername, $username, $password, $dbname);
  34. $conn->query("set names utf8");
  35. $sql = "INSERT INTO uzenetek (uzeno, uzenet)
  36. VALUES('$uzeno','$uzenet')";
  37. return ($conn->query($sql) === TRUE);
  38. }
  39.  
  40. if (isset($_POST['uzeno']) && isset($_POST['uzenet'])){
  41. saveMessage($_POST['uzeno'],$_POST['uzenet']);
  42.  
  43. }
  44.  
  45. ?>
  46.  
  47. <!DOCTYPE html>
  48. <html>
  49. <head>
  50. <title>Title</title>
  51. <meta charset="UTF-8" />
  52. <style type="text/css">
  53. .header {
  54. text-align: center;
  55. border-bottom: 1px solid silver;
  56. }
  57.  
  58. .uzenetek {
  59. font-size: 22px;
  60. height: 650px;
  61. overflow: auto;
  62. }
  63.  
  64. ul li {
  65. list-style-type: none;
  66. margin-top: 8px;
  67.  
  68. }
  69.  
  70. input[type='text']{
  71. padding:4px;
  72. width: 48%;
  73. }
  74.  
  75. .uzen {
  76. margin-top: 16px;
  77. padding: 8px;
  78. width : 100%;
  79. }
  80.  
  81.  
  82. </style>
  83.  
  84. </head>
  85. <body>
  86. <div class="kontener">
  87. <div class="header">
  88. <h1>Messages</h1>
  89. </div>
  90. <div class="uzenetek">
  91. <ul>
  92. <?php
  93. foreach ($uzenetek as $uzenet){
  94. echo $uzenet['ido'];
  95. }
  96.  
  97. ?>
  98.  
  99. <!--<li>[15:39:22] <b>Jenő</b>: Itt lesznek az üzenetek</li>-->
  100. </ul>
  101. </div>
  102. <div class="uzeno-input">
  103. <form action="" method="post">
  104. <input type="text" name="uzeno" placeholder="Ki vagy?"></input>
  105. <input type="text" name="uzenet" placeholder="Mit üzensz?"></input><br>
  106. <input type="submit" name="uzen" value="Kiteszem a falra" class="uzen"></input>
  107. </form>
  108. </div>
  109. </div>
  110. </body>
  111. </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement