这是哪里错了

FROMmembersORDER 这里没发现吗

... FROM members ORDER BY username LIMIT 0,5

<?php
require_once("common.inc.php");
require_once("config.php");
require_once("Member.class.php");$start = isset($_GET["start"])?(int)$_GET["start"]:0;
$order = isset($_GET["order"])?preg_replace("/[^a-zA-Z]/","",$_GET["order"]):"username";
list($members,$totalRows) = Member::getMembers($start,PAGE_SIZE,$order);
displayPageHeader("View book club members");
?>
<h2>Displaying members<?php echo $start+1?>-<?php echo min(
$start+PAGE_SIZE,$totalRows)?>of<?php echo $totalRows?></h2>

<table cellspacing="0" style="width: 30em; border:1px solid #666;">
<tr>
<th><?php if($order != "username"){?><a href="view_members.php?
order=username"><?php }?>Username <?php if($order != "username")
{?></a><?php } ?></th>
<th><?php if($order != "firstname"){?><a href="view_members.php?
order=firstname"><?php }?>First name <?php if($order != "firstname")
{?></a><?php } ?></th>
<th><?php if($order != "lastname"){?><a href="view_members.php?
order=lastname"><?php }?>Last name <?php if($order != "lastname")
{?></a><?php } ?></th>
</tr>

<?php
$rowCount = 0;
foreach($members as $member){
$rowCount++;
?>
<tr<?php if($rowCount %2 == 0)echo 'class="alt"'?>>
<td><a href="view_member.php?memberId=<?php echo $member->getValueEncoded("id")?>">
<?php echo $member->getValueEncoded("username")?></a></td>
<td><?php echo $member->getValueEncoded("firstname")?></td>
<td><?php echo $member->getValueEncoded("lastname")?></td>
</tr>
<?php
}
?>
</table>

<div style="width: 30em; margin-top:20px; text-align:center;">
<?php if($start>0){?>
<a href="view_members.php?start=<?php echo max($start-PAGE_SIZE,0)?>&
order=<?php echo $order?>">Previous page</a><?php }?>
 
<?php if($start + PAGE_SIZE<$totalRows) {?>
<a href="view_members.php?start=<?php echo min($start + PAGE_SIZE,$totalRows) ?>&order=<?php echo $order?>">Next page</a>
<?php }?>
</div>

<?php
displayPageFooter();
?>

等级：Blank
#4 得分：0 回复于： 2013-11-15 15:40:40
<?php
require_once("common.inc.php");
require_once("config.php");
require_once("Member.class.php");$start = isset($_GET["start"])?(int)$_GET["start"]:0;
$order = isset($_GET["order"])?preg_replace("/[^a-zA-Z]/","",$_GET["order"]):"username";
list($members,$totalRows) = Member::getMembers($start,PAGE_SIZE,$order);
displayPageHeader("View book club members");
?>
<h2>Displaying members<?php echo $start+1?>-<?php echo min(
$start+PAGE_SIZE,$totalRows)?>of<?php echo $totalRows?></h2><table cellspacing="0" style="width: 30em; border:1px solid #666;">
<tr>
<th><?php if($order != "username"){?><a href="view_members.php?
order=username"><?php }?>Username <?php if($order != "username")
{?></a><?php } ?></th>
<th><?php if($order != "firstname"){?><a href="view_members.php?
order=firstname"><?php }?>First name <?php if($order != "firstname")
{?></a><?php } ?></th>
<th><?php if($order != "lastname"){?><a href="view_members.php?
order=lastname"><?php }?>Last name <?php if($order != "lastname")
{?></a><?php } ?></th>
</tr><?php
$rowCount = 0;
foreach($members as $member){
$rowCount++;
?>
<tr<?php if($rowCount %2 == 0)echo 'class="alt"'?>>
<td><a href="view_member.php?memberId=<?php echo $member->getValueEncoded("id")?>">
<?php echo $member->getValueEncoded("username")?></a></td>
<td><?php echo $member->getValueEncoded("firstname")?></td>
<td><?php echo $member->getValueEncoded("lastname")?></td>
</tr>
<?php
}
?>
</table><div style="width: 30em; margin-top:20px; text-align:center;">
<?php if($start>0){?>
<a href="view_members.php?start=<?php echo max($start-PAGE_SIZE,0)?>&
order=<?php echo $order?>">Previous page</a><?php }?>
 
<?php if($start + PAGE_SIZE<$totalRows) {?>
<a href="view_members.php?start=<?php echo min($start + PAGE_SIZE,$totalRows) ?>&order=<?php echo $order?>">Next page</a>
<?php }?>
</div><?php
displayPageFooter();
?>

报错的代码没有贴出来，
list($members,$totalRows) = Member::getMembers($start,PAGE_SIZE,$order);要看getMembers函数里面是如何写的。

FROMmembersORDER !!
难道是没有空格的原因一坨拉出来了?

<?php
require_once"DataObject.class.php";
class Member extends DataObject{
protected $data = array(
"id"=>"",
"username"=>"",
"password"=>"",
"firstName"=>"",
"lastName"=>"",
"joinDate"=>"",
"gender"=>"",
"favoriteGenre"=>"",
"emailAddress"=>"",
"otherInterests"=>""
);
private $_genres = array(
"crime"=>"Crime",
"horror"=>"Horror",
"thriller"=>"Thriller",
"romance"=>"Romance",
"sciFi"=>"Sci-Fi",
"adventure"=>"Adventure",
"nonFiction"=>"Non-Fiction"
);
public static function getMembers($startRow,$numRows,$order){
$conn = parent::connect();
$sql = "SELECT SQL_CALC_FOUND_ROWS * FROM".TBL_MEMBERS."ORDER BY $order LIMIT :startRow,:numRows";

try{
$st = $conn->prepare($sql);
$st->bindValue(":startRow",$startRow,PDO::PARAM_INT);
$st->bindValue(":numRows",$numRows,PDO::PARAM_INT);
$st->execute();
$members = array();
foreach($st->fetchAll() as $row){
$members[] = new Member($row);
}
$st = $conn->query("SELECT found_rows() AS totalRows");
$row = $st->fetch();
parent::disconnect($conn);
return array($members,$row["totalRows"]);
}catch(PDOException $e){
parent::disconnect($conn);
die("Query failed:".$e->getMessage());
}
}

public static function getMember($id){
$conn = parent::connect();
$sql = "SELECT * FROM". TBL_MEMBERS. " WHERE id = :id";
try{
$st = $conn->prepare($sql);
$st->bindValue(":id",$id,PDO::PARAM_INT);
$st->execute();
$row = $st->fetch();
parent::disconnect($conn);
if($row) return new Member($row);
}catch(PDOException $e){
parent::disconnect($conn);
die("Query failed:".$e->getMessage());
}
}

public function getGenderString(){
return($this->data["gender"]=="f")?"Female":"Male";
}
public function getFavoriteGenreString(){
return ($this->_genres[$this->data["favouriteGenre"]]);
}
}
?>

$sql = "SELECT SQL_CALC_FOUND_ROWS * FROM ".TBL_MEMBERS." ORDER BY $order LIMIT :startRow,:numRows"; //复制这句试试

前两个错误是说你的父类DataObject的connect() 和 disconnect() 不是静态方法，不能以静态方式调用。解决办法：在connect() 和 disconnect()前面加上 static 关键字。第三个是说mydatabase.members 表不存在，检查一下吧。

你在那句sql语句里改了什么，好像看不到有改过的痕迹

from 后面和order 前面各加了一个空格

基本的sql语法，同学，该看书了。

调试易

这是哪里错了

解决方案 »