Guest User

Untitled

a guest
Jan 22nd, 2018
67
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.10 KB | None | 0 0
  1. <?php
  2. session_start();
  3. $title = $_POST['title'];
  4. $text = $_POST['text'];
  5.  
  6. $servername = "localhost";
  7. $username = "root";
  8. $password = "";
  9. $dbname = "p1";
  10.  
  11. $conn = new mysqli($servername, $username, $password,$dbname);
  12.  
  13. if ($conn->connect_error) {
  14. die("Connection failed: " . $conn->connect_error);
  15. }
  16. echo "Connected successfully";
  17. if ($_SESSION['login'] == true){
  18. $sql = "INSERT INTO `ticket` (title,text) VALUE ('$title','$text')";
  19. $result = $conn->query($sql);
  20. echo "<br>Sent successfully";
  21. }
  22. else {
  23. echo "<br>Sent failed";
  24. }
  25. ?>
  26.  
  27. <?php
  28. session_start();
  29. $servername = "localhost";
  30. $username = "root";
  31. $password = "";
  32. $dbname = "p1";
  33.  
  34. $conn = new mysqli($servername, $username, $password,$dbname);
  35.  
  36. if ($conn->connect_error) {
  37. die("Connection failed: " . $conn->connect_error);
  38. }
  39. echo "Connected successfully";
  40. $sql = "SELECT * FROM ticket";
  41. $result = $conn->query($sql);
  42. if ($result->num_rows > 0) {
  43. while($row = $result->fetch_assoc()) {
  44. echo "<br>User: " . $row["username"]. "<br>Title " . $row["title"]. "
  45. <br>Text: " . $row["text"]."<br>";
  46. }
  47. } else {
  48. echo "<br>There is no ticket submited";
  49. }
  50. $conn->close();
  51. ?>
Add Comment
Please, Sign In to add comment