Question

php页面运行出错，求高手解决！

出错页面显示：You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

出错页面php代码：

<?
require_once ("top.php");
require_once ("foot.php");
require_once ("mem_left.php");
if(!empty($_COOKIE['uname']) && !empty($_COOKIE['uid'])){

$sql ="select count(id) as a ,sum(pprice) as b from card_cart where uid=".$_COOKIE['uid'];
$member = $mydb->getRow("select * from card_users where user_id =".$_COOKIE['uid']."");
$mcount = $mydb->getRow("select count(id) as a ,sum(pprice) as b from card_cart where uid=".$_COOKIE['uid']);

} else {
echo "<script>alert('请先登录');</script><br>";
echo "<script>location.href='index.php'</script>";
}
//setcookie("ECS","");
$key = $_REQUEST['keyword'];
require_once("./config/page.class.php");
$sqlwhere = " 1 and uid = $uid ";
$uid = $_COOKIE['uid'];
if(!empty($key)) $sqlwhere .= " and pname like '%$key%'";
$news= new page(10,$mydb->link_id,"card_cart","id",$sqlwhere,7,"keyword=$key" );
$sq=$news->display();
if($news->num=='0') { $msg="无信息!"; } else {
while(@$cartlist2=@mysql_fetch_assoc($sq)){
$cartlist2['pcount'] = $cartlist2['pprice'] * $cartlist2['pnum'];
//$cartlist2['yh']=explode($cartlist2['pgongyi']);
//$yh[] = $cartlist2['pgongyi'];
$yh[]=explode('|',$cartlist2['pgongyi']);
$cartlist[]=$cartlist2;
}
$pagelist = $news->press();
}
if($_REQUEST['action']=='del' && $_REQUEST['id']!='' && is_numeric($_REQUEST['id'])){
$ss = "delete from card_cart where id=".$_REQUEST['id']." and uid=". $_COOKIE['uid'];
$cc = $mydb->query($ss);
if($cc){
$msg="删除成功!";
echo "<script>alert('$msg');</script>";
echo "<script>location.href='cartindex.php';</script>";
} else {
$msg="删除失败!";
}
}
//print_r($yh);exit;
/*****
foreach($cartlist as $value){
$pricecount=$value[pprice]*$value[pnum];
$pricecount2[]=$pricecount;
}
****/
//require_once("./cart.class.php");
//$cart= new cart();
//$cart_info = $cart->cartAdd('s','2');
//$smarty->assign('contacts', $db->getAll($sql));
$smarty->assign("member",$member);
$smarty->assign("yh",$yh);
$smarty->assign("mcount",$mcount);
$smarty->assign("msg",$msg);
$smarty->assign("pagelist",$pagelist);
$smarty->assign("cartlist",$cartlist);
$smarty->assign("pricecount",$pricecount2);
$smarty->display("cartindex.html");
?>

Answer 1

$sql ="select count(id) as a ,sum(pprice) as b from card_cart where uid=".$_COOKIE['uid'];
应该是$_COOKIE['uid']没有值，所以sql语句结构不完整。
可以
echo $sql;return;
输出sql查看一下

Answer 2

sql语法有问题,在SQL服务器的命令行方式下检查下SQL语句是否正确.

Answer 3

看不了这么长的代码，因该是sql语句的问题，你看报错的提示，根据他来检查你的错误

Answer 4

$sql ="select count(id) as a ,sum(pprice) as b from card_cart where uid=".$_COOKIE['uid'];
我认为可能是少了引号 count('id') sum('pprice')
建议你先在phpmyadmin里测试sql语句。

Answer 5

晕