Advertisement
Guest User

Untitled

a guest
Jun 11th, 2018
87
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.99 KB | None | 0 0
  1. <?php session_start(); ?>
  2. <?php
  3. $servername = "localhost";
  4. $username = "root";
  5. $password = "";
  6. $dbname = "lab14";
  7.  
  8. $conn = new mysqli($servername, $username, $password, $dbname);
  9.  
  10. if ($conn->connect_error)
  11. {
  12. die("Connection failed: " . $conn->connect_error);
  13. }
  14.  
  15. $sql = "SELECT * FROM gmail WHERE wlasciciel = '".$_SESSION["nick"]."' or odbiorca = '".$_SESSION["nick"]."'";
  16.  
  17. $result = $conn->query($sql);
  18.  
  19.  
  20. if ($result->num_rows > 0)
  21. {
  22. echo " '<br>' ";
  23. echo "<table>";
  24. echo "<tr> <td> tutyl</td> <td> tresc</td> <tr>";
  25.  
  26.  
  27. while($row = $result->fetch_assoc())
  28. {
  29. $id = $row["id"];
  30. echo "<tr data-id ='$id' >";
  31.  
  32. echo " <td> {$row["tytul"]} </td> <td> {$row["tresc"]} </td> ";
  33. echo "</tr>";
  34. }
  35.  
  36. echo "</table>";
  37. } else
  38. {
  39. echo "0 results";
  40. }
  41. mysqli_close($conn);
  42. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement