| Server IP : 104.21.73.108 / Your IP : 216.73.216.59 Web Server : Apache/2 System : Linux cat167-197.static.lnwhostname.com 5.10.0-20-amd64 #1 SMP Debian 5.10.158-2 (2022-12-13) x86_64 User : paphayomho ( 1042) PHP Version : 5.6.40 Disable Function : exec,system,passthru,shell_exec,proc_close,proc_open,dl,popen,show_source,posix_kill,posix_mkfifo,posix_getpwuid,posix_setpgid,posix_setsid,posix_setuid,posix_setgid,posix_seteuid,posix_setegid,posix_uname MySQL : ON | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : /home/paphayomho/domains/paphayomhospital.go.th/private_html/PCU2566/admin/CRUD/ |
Upload File : |
<?php
require_once("connection.php");
$query = "SELECT *, students.student_id AS stud, borrow.status AS barstat FROM borrow LEFT JOIN students ON students.id=borrow.student_id LEFT JOIN books ON books.id=borrow.book_id GROUP BY date_borrow ORDER BY date_borrow DESC ";
$result = mysqli_query($con,$query);
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<meta http-equiv="X-UA-Compatible" content="ie=edge">
<link rel="stylesheet" a href="CSS/bootstrap.css"/>
<title>View Records</title>
</head>
<body class="bg-dark">
<div class="container">
<div class="row">
<div class="col m-auto">
<div class="card mt-5">
<table class="table table-bordered">
<tr>
<td> User ID </td>
<td> User Name </td>
<td> User Email </td>
<td> User Age </td>
<td> Edit </td>
<td> Delete </td>
</tr>
<?php
while($row=mysqli_fetch_assoc($result))
{
$UserID = $row['student_id'];
$UserName = $row['firstname'];
$UserEmail = $row['lastname'];
$UserAge = $row['address'];
?>
<tr>
<td><?php echo $UserID ?></td>
<td><?php echo $UserName ?></td>
<td><?php echo $UserEmail ?></td>
<td><?php echo $UserAge ?></td>
<td><a href="edit.php?GetID=<?php echo $UserID ?>">Edit</a></td>
<td><a href="delete.php?Del=<?php echo $UserID ?>">Delete</a></td>
</tr>
<?php
}
?>
</table>
</div>
</div>
</div>
</div>
</body>
</html>