Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $servername = "localhost";
- $username = "root";
- $password = "";
- $dbname = "week05";
- //--------------------- Create connection ---------------------
- $conn = new mysqli($servername, $username, $password, $dbname);
- //---------------------- Check connection ---------------------
- if ($conn->connect_error) {
- die("Connection failed: " . $conn->connect_error);
- }
- //--------------------------- SELECT --------------------------
- $sql = "SELECT * FROM description";
- $result = mysqli_query($conn,$sql);
- if($result) {
- $no=0;
- while ($row=mysqli_fetch_assoc($result))
- {
- $no++;
- //-------------------------------------------------------------
- ?>
- <tr>
- <td><?php echo $no; ?></td>
- <td><?php echo $row["studentid"]; ?></td>
- <td><?php echo $row["fname"]; ?></td>
- <td><?php echo $row["lname"]; ?></td>
- <td><a class='btn btn-primary' href="week04_3.php?id=<?php echo $row["studentid"]; ?>" role='button'><span class="glyphicon glyphicon-edit"></span></a>
- <a class='btn btn-primary' href="delete.php?id=<?php echo $row["studentid"]; ?>" role='button'><span class='glyphicon glyphicon-trash'></span></a>
- </td>
- </tr>
- <?php
- }
- }
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement