Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- function getMessages(){
- $servername = 'localhost';
- $username = 'root';
- $password = '';
- $dbname = 'login3';
- $conn = new mysqli($servername, $username, $password, $dbname);
- $conn->query("set names utf8");
- $sql = "SELECT time_format(ido, '%T') as ido, uzeno, uzenet FROM uzenetek order by ido desc";
- $result = $conn->query($sql);
- $uzenetek = [];
- if ($result->num_rows > 0) {
- while ($row = $result->fetch_assoc()) {
- $uzenetek[] = $row;
- }
- }
- return $uzenetek;
- }
- $uzenetek = getMessages();
- function saveMessage($uzeno,$uzenet){
- $servername = 'localhost';
- $username = 'root';
- $password = '';
- $dbname = 'login3';
- $conn = new mysqli($servername, $username, $password, $dbname);
- $conn->query("set names utf8");
- $sql = "INSERT INTO uzenetek (uzeno, uzenet)
- VALUES('$uzeno','$uzenet')";
- return ($conn->query($sql) === TRUE);
- }
- if (isset($_POST['uzeno']) && isset($_POST['uzenet'])){
- saveMessage($_POST['uzeno'],$_POST['uzenet']);
- }
- ?>
- <!DOCTYPE html>
- <html>
- <head>
- <title>Title</title>
- <meta charset="UTF-8" />
- <style type="text/css">
- .header {
- text-align: center;
- border-bottom: 1px solid silver;
- }
- .uzenetek {
- font-size: 22px;
- height: 650px;
- overflow: auto;
- }
- ul li {
- list-style-type: none;
- margin-top: 8px;
- }
- input[type='text']{
- padding:4px;
- width: 48%;
- }
- .uzen {
- margin-top: 16px;
- padding: 8px;
- width : 100%;
- }
- </style>
- </head>
- <body>
- <div class="kontener">
- <div class="header">
- <h1>Messages</h1>
- </div>
- <div class="uzenetek">
- <ul>
- <?php
- foreach ($uzenetek as $uzenet){
- echo $uzenet['ido'];
- }
- ?>
- <!--<li>[15:39:22] <b>Jenő</b>: Itt lesznek az üzenetek</li>-->
- </ul>
- </div>
- <div class="uzeno-input">
- <form action="" method="post">
- <input type="text" name="uzeno" placeholder="Ki vagy?"></input>
- <input type="text" name="uzenet" placeholder="Mit üzensz?"></input><br>
- <input type="submit" name="uzen" value="Kiteszem a falra" class="uzen"></input>
- </form>
- </div>
- </div>
- </body>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement