我有一个功能来显示表中的所有数据.行返回的数量是正确的(基于编辑n删除按钮),但不显示该值.
public function viewAll()
{
$sql = "SELECT 'id','titleAnn','dateOpen','dateClose' FROM annoucement";
$query = mysql_query($sql);
while($row = mysql_fetch_array($query))
{
$id = $row['id'];
$title = $row['titleAnn'];
$dateOpen = $row['dateOpen'];
$dateClose = $row['dateClose'];
echo '
<?php echo $title ?><?php echo $dateOpen ?><?php echo $dateClose ?> ';}
$this->numrows= mysql_num_rows($query);
}
按钮旁边只显示空格
解决方法:
你在回声中回应PHP ….连接和echo如下:
public function viewAll()
{
$sql = "SELECT 'id','titleAnn','dateOpen','dateClose' FROM annoucement";
$query = mysql_query($sql);
while($row = mysql_fetch_array($query))
{
$id = $row['id'];
$title = $row['titleAnn'];
$dateOpen = $row['dateOpen'];
$dateClose = $row['dateClose'];
echo '
'.$title.''.$dateOpen.''.$dateClose.' ';}
$this->numrows= mysql_num_rows($query);
}
标签:php,mysql,oop
来源: https://codeday.me/bug/20190722/1504713.html