Guest User

Untitled

a guest
Dec 27th, 2017
348
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.65 KB | None | 0 0
  1. <html>
  2. <body>
  3. <form action="info.php" method="POST">
  4. Department: <input type="text" name="department"><br><br>
  5. Subname: <input type="text" name="subname"><br><br>
  6. Labels: <input type="text" name="labels"><br><br>
  7. Pagerduty: <input type="text" name="pagerduty"><br><br>
  8. Description: <input type="text" name="description"><br><br>
  9. <input type="submit" value="Submit" name="submit">
  10. </form>
  11. </body>
  12. </html>
  13.  
  14. <?php
  15. $hostname = "localhost";
  16. $username = "root";
  17. $password = "xxxxxxxxxxx";
  18. $db = "dora";
  19. $dbconnect=mysqli_connect($hostname,$username,$password,$db);
  20. if ($dbconnect->connect_error) {
  21. die("Database connection failed: " . $dbconnect->connect_error);
  22. }
  23. if(isset($_POST['submit'])) {
  24. $department=$_POST['department'];
  25. $subname=$_POST['subname'];
  26. $labels=$_POST['labels'];
  27. $pagerduty=$_POST['pagerduty'];
  28. $description=$_POST['description'];
  29. $query = "INSERT INTO dora (department, subname, labels, pagerduty, description)
  30. VALUES ('$department', '$subname', '$labels', '$pagerduty', '$description')";
  31. if (!mysqli_query($dbconnect, $query)) {
  32. die('An error occurred when submitting your review.');
  33. } else {
  34. echo "Thanks for your review.";
  35. }
  36. }
  37. ?>
  38.  
  39. <html>
  40. <body>
  41. <?php
  42. $hostname = "localhost";
  43. $username = "root";
  44. $password = "xxxxxxxx";
  45. $db = "dora";
  46. $dbconnect=mysqli_connect($hostname,$username,$password,$db);
  47. if ($dbconnect->connect_error) {
  48. die("Database connection failed: " . $dbconnect->connect_error);
  49. }
  50. ?>
  51. <table border="1" align="center">
  52. <tr>
  53. <td>Department</td>
  54. <td>Subname</td>
  55. <td>Labels</td>
  56. <td>Pagerduty</td>
  57. <td>Description</td>
  58. </tr>
  59. <?php
  60. $query = mysqli_query($dbconnect, "SELECT * FROM dora")
  61. or die (mysqli_error($dbconnect));
  62.  
  63. while ($row = mysqli_fetch_array($query)) {
  64. echo
  65. "<tr>
  66. <td>{$row['department']}</td>
  67. <td>{$row['subname']}</td>
  68. <td>{$row['labels']}</td>
  69. <td>{$row['pagerduty']}</td>
  70. <td>{$row['description']}</td>
  71. </tr>n";
  72. }
  73. ?>
  74. </table>
  75. </body>
  76. </html>
  77.  
  78. +-------------+--------------+------+-----+---------+----------------+
  79. | Field | Type | Null | Key | Default | Extra |
  80. +-------------+--------------+------+-----+---------+----------------+
  81. | TAB_ID | int(11) | NO | PRI | NULL | auto_increment |
  82. | department | varchar(200) | YES | | NULL | |
  83. | subname | varchar(200) | YES | | NULL | |
  84. | labels | varchar(200) | YES | | NULL | |
  85. | pagerduty | varchar(200) | YES | | NULL | |
  86. | description | varchar(200) | YES | | NULL | |
  87. +-------------+--------------+------+-----+---------+----------------+
Add Comment
Please, Sign In to add comment