所以我找到了这个简单的支持票PHP代码,我在我的网站上实现了它。
manageTickets.php向我显示了客户的门票。我可以点击故障单标题导航到viewticket.php?id =“ticketid”它在我的localhost上正确显示,如下所示:http://puu.sh/nwaQy/6eae16d699.png
因此,出于某种原因,它不会运行我认为的PHP代码。
所有其他php工作得很好,就在这个页面上。
managetickets.php
$SQLGetTickets = $odb -> prepare("SELECT users.username,
tickets.ticketID,
tickets.ticketTitle,
(SELECT ticketResponses.time FROM `ticketResponses` WHERE ticketResponses.ticketID = tickets.ticketID ORDER BY ticketResponses.time DESC LIMIT 1) AS lastResponseTime
FROM `tickets`
INNER JOIN `users` ON tickets.userID = users.ID
WHERE
tickets.ticketStatus = 1 AND
(SELECT ticketResponses.userID FROM `ticketResponses` WHERE ticketResponses.ticketID = tickets.ticketID ORDER BY ticketResponses.time DESC LIMIT 1) = tickets.userID");
$SQLGetTickets -> execute();
while($getInfo = $SQLGetTickets -> fetch(PDO::FETCH_ASSOC))
{
$username = $getInfo['username'];
$ticketID = $getInfo['ticketID'];
$title = htmlspecialchars($getInfo['ticketTitle']);
$lastResponseTime = $getInfo['lastResponseTime'];
$responseDate = date('d/m/y H:i', $lastResponseTime);
echo '
' . $username . ' ' . $title . '' . $responseDate . '';}
?>
所有帮助将不胜感激!