我有以下代码,它从数据库中获取并显示数据表。在每个用户旁边,我有“查看”链接,它显示详细信息页面。
if ($role == 'Manager' && isset($_GET['click'])){
if ($_GET['click'] == 'ViewRequests'){
$sql="SELECT users.user_id, users.first_name, users.middle_name, users.last_name, request.emp_id, request.location, request.asset_kind, request.Status
FROM users
INNER JOIN request ON users.user_id=request.emp_id AND users.role IN ('Employee','Admin') AND request.Status='Request';";
$records=mysql_query($sql);
ViewRequest($records);
}}
function ViewRequest($records){
echo "
View Requests
User idEmployee NameLocationAsset KindStatus ";while ($row=mysql_fetch_assoc($records)){
echo "
";echo "
".$row['user_id']."";echo "
".$row['first_name']." ".$row['middle_name']." ".$row['last_name']."";echo "
".$row['location']."";echo "
".$row['asset_kind']."";echo "
".$row['Status']."";echo "
VIEW";}echo "
";}echo "";当用户点击“查看”链接时,它应显示每个用户的特定信息。我怎么能在PHP中实现这个?..我知道我必须使用SESSION但是如何?我应该通过查询或新变量或什么?