Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <html>
- <body>
- <form action="info.php" method="POST">
- Department: <input type="text" name="department"><br><br>
- Subname: <input type="text" name="subname"><br><br>
- Labels: <input type="text" name="labels"><br><br>
- Pagerduty: <input type="text" name="pagerduty"><br><br>
- Description: <input type="text" name="description"><br><br>
- <input type="submit" value="Submit" name="submit">
- </form>
- </body>
- </html>
- <?php
- $hostname = "localhost";
- $username = "root";
- $password = "xxxxxxxxxxx";
- $db = "dora";
- $dbconnect=mysqli_connect($hostname,$username,$password,$db);
- if ($dbconnect->connect_error) {
- die("Database connection failed: " . $dbconnect->connect_error);
- }
- if(isset($_POST['submit'])) {
- $department=$_POST['department'];
- $subname=$_POST['subname'];
- $labels=$_POST['labels'];
- $pagerduty=$_POST['pagerduty'];
- $description=$_POST['description'];
- $query = "INSERT INTO dora (department, subname, labels, pagerduty, description)
- VALUES ('$department', '$subname', '$labels', '$pagerduty', '$description')";
- if (!mysqli_query($dbconnect, $query)) {
- die('An error occurred when submitting your review.');
- } else {
- echo "Thanks for your review.";
- }
- }
- ?>
- <html>
- <body>
- <?php
- $hostname = "localhost";
- $username = "root";
- $password = "xxxxxxxx";
- $db = "dora";
- $dbconnect=mysqli_connect($hostname,$username,$password,$db);
- if ($dbconnect->connect_error) {
- die("Database connection failed: " . $dbconnect->connect_error);
- }
- ?>
- <table border="1" align="center">
- <tr>
- <td>Department</td>
- <td>Subname</td>
- <td>Labels</td>
- <td>Pagerduty</td>
- <td>Description</td>
- </tr>
- <?php
- $query = mysqli_query($dbconnect, "SELECT * FROM dora")
- or die (mysqli_error($dbconnect));
- while ($row = mysqli_fetch_array($query)) {
- echo
- "<tr>
- <td>{$row['department']}</td>
- <td>{$row['subname']}</td>
- <td>{$row['labels']}</td>
- <td>{$row['pagerduty']}</td>
- <td>{$row['description']}</td>
- </tr>n";
- }
- ?>
- </table>
- </body>
- </html>
- +-------------+--------------+------+-----+---------+----------------+
- | Field | Type | Null | Key | Default | Extra |
- +-------------+--------------+------+-----+---------+----------------+
- | TAB_ID | int(11) | NO | PRI | NULL | auto_increment |
- | department | varchar(200) | YES | | NULL | |
- | subname | varchar(200) | YES | | NULL | |
- | labels | varchar(200) | YES | | NULL | |
- | pagerduty | varchar(200) | YES | | NULL | |
- | description | varchar(200) | YES | | NULL | |
- +-------------+--------------+------+-----+---------+----------------+
Add Comment
Please, Sign In to add comment