我有这段代码,在"从博客中选择*,其中PostID="。
如何分别获取每一行,以便按PostID获取postedBY,标题,日期,内容
<?php
try{
$Blog = $conn->prepare("SELECT * FROM Blogi WHERE PostID=");
$Blog->execute();
}catch(PDOException $e){
echo $e->getMessage();
}
$fetch = $Blog->fetchAll();
$usercount = $Blog->rowCount();
if($usercount > 0){
foreach($fetch as $f){
$PostID = $f['PostID'];
$PostedBY = $f['PostedBY'];
$Title = $f['Title'];
$Date = $f['Date'];
$Content = $f['Content'];
}
}else{
session_destroy();
header('location: index.php');
}
?>
我的英语很差,所以我不知道有人能理解这一点。
如何进一步做这个 postID=" 到他将开始工作?
你已经在 foreach 循环中完成了它...因此,为输出添加一行,例如...此外,您不会向查询发送任何 PostID 值,请确保您正在为其发送值。
foreach($fetch as $f){
$PostID = $f['PostID'];
$PostedBY = $f['PostedBY']
$Title = $f['Title'];
$Date = $f['Date'];
$Content = $f['Content'];
echo $PostID . " " . $Title . " " . $Date . " " . $Content . "<br />";
}