Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- //Establish connection
- $dbhost = "localhost";
- $dbuser = "root";
- $dbpass = "abhishek";
- $dbname = "ITLabAssig5DB";
- $connection = mysqli_connect($dbhost, $dbuser, $dbpass, $dbname);
- //Test connection
- if(mysqli_connect_errno()) {
- die("Database connection failed: ".
- mysqli_connect_error().
- " (". mysqli_connect_errno(). ")"
- );
- }
- ?>
- <?php
- $query = "SELECT * from TagDatabase";
- $result = mysqli_query($connection, $query);
- //Test for query error
- if(!$result){
- die("Database query failed");
- }
- ?>
- <!DOCTYPE html>
- <html lang="en">
- <head>
- <title>
- PHP Code for ITLab Assig 5
- </title>
- <style>
- table {
- font-family: arial, sans-serif;
- border-collapse: collapse;
- width: 100%;
- border: 1px solid black;
- }
- td, th {
- border: 1px solid #dddddd;
- text-align: left;
- padding: 8px;
- border: 1px solid black;
- }
- tr:nth-child(even) {
- background-color: #dddddd;
- }
- </style>
- </head>
- <body>
- <table>
- <tr>
- <th>Tag Name</th>
- <th>Tag Description</th>
- </tr>
- <?php
- //use returned data(if any)
- while($row = mysqli_fetch_assoc($result)) {
- ?>
- <tr><td><?php echo $row["Name"]; ?></td>
- <td><?php echo $row["Description"]; ?></td></tr>
- <?php
- }
- ?>
- <?php
- //release returned data
- mysqli_free_result($result);
- ?>
- </table>
- </body>
- </html>
- <?php
- //Close connection
- mysqli_close($connection);
- ?>
Add Comment
Please, Sign In to add comment