Jedijon Posted November 18, 2018 Share Posted November 18, 2018 <?php $con=mysqli_connect("IP","Username","Password","Database"); // Check connection if (mysqli_connect_errno()) { echo "Failed to connect to MySQL: " . mysqli_connect_error(); } $result = mysqli_query($con,"SELECT * FROM support"); echo "<table border='1'> <tr> <th>Name</th> <th>Email</th> <th>Priority</th> <th>Type</th> <th>Subject</th> <th>Message</th> </tr>"; while($row = mysqli_fetch_array($result)) { echo "<tr>"; echo "<td>" . $row['name'] . "</td>"; echo "<td>" . $row['email'] . "</td>"; echo "<td>" . $row['priority'] . "</td>"; echo "<td>" . $row['type'] . "</td>"; echo "<td>" . $row['subject'] . "</td>"; echo "<td>" . $row['message'] . "</td>"; echo "</tr>"; } echo "</table>"; mysqli_close($con); ?> Link to comment Share on other sites More sharing options...
requinix Posted November 18, 2018 Share Posted November 18, 2018 Quote How to add a delete button to this I suggest using code. Try it yourself. If you have specific questions or problems then post what you've done for it. Link to comment Share on other sites More sharing options...
Jedijon Posted November 18, 2018 Author Share Posted November 18, 2018 Thank you for all the help Link to comment Share on other sites More sharing options...
requinix Posted November 18, 2018 Share Posted November 18, 2018 FYI sarcasm doesn't translate well over the internet unless you lay it on really thick. Don't know where to start? Wrap the whole table in a <form> that will post back to this same page. In each row, add a <button> named "delete" with a value that is unique for the row - so you know what to delete. To handle the delete, check $_POST for the delete button. If present you'll know which row to delete. Delete it. Link to comment Share on other sites More sharing options...
Jedijon Posted November 18, 2018 Author Share Posted November 18, 2018 Thank you IĀ figure it out Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.