作者st84514 ()
看板PHP
标题[请益] 用isset判断是否为空的问题
时间Tue Apr 2 13:38:20 2013
错误讯息如下:
nWarning: mysql_fetch_array() expects parameter 1 to be resource, boolean
given in /var/www/html/android_login_api/include/reward.php on line
24nnWarning: mysql_num_rows() expects parameter 1 to be resource,.....
程式码如下:
// check for post data
if (isset($_GET["M_ID"]) && isset($_GET["code"])) {
$M_ID = $_GET['M_ID'];
$code = $_GET['code'];
$result = mysql_query("SELECT sid,credit,img_url,name FROM survey_list
WHERE code = $code");
$row1 = mysql_fetch_array($result);
$credit = $row1["credit"];
$sid = $row1["sid"];
$img_url = $row1["img_url"];
$name = $row1["name"];
$check_record = mysql_query("SELECT * FROM record WHERE sid = $sid AND M_ID
= $M_ID");
$response["sid"] = $sid;
$response["M_ID"] = $M_ID;
//$response["check_record"] = mysql_num_rows($check_record);
//$response["result"] = mysql_num_rows($result);
if(mysql_num_rows($result) > 0 && mysql_num_rows($check_record) < 1) {
$user_result = mysql_query("SELECT credit FROM users WHERE M_ID = $M_ID");
$row2 = mysql_fetch_array($user_result);
$user_credit = $row2["credit"];
$Total_credit = $credit + $user_credit;
$update = mysql_query("UPDATE users SET credit = '$Total_credit' WHERE
M_ID = $M_ID");
$insert_record = mysql_query("INSERT INTO record(M_ID, sid, name, credit,
img_url) VALUES('$M_ID', '$sid', '$name', '$credit', '$img_url')");
if($update && $insert_record){
$response["success"] = 1;
$response["credit"] = $Total_credit;
}
}
else if(mysql_num_rows($result) > 0 && mysql_num_rows($check_record) > 0)//
已兑奖
{
$response["success"] = -1;
}
else{
$response["success"] = 0;
$response["message"] = "No products found";
}
echo json_encode($response);
}
我这边用isset去判断我手机使用者接收到的code值并判断是否为空,
但现在bug是就算使用者不输入任何值送出,也会出现成功讯息...
解很久解不出来...想麻烦版上前辈帮我看一下,当code值为空时,必须显示
错误讯息,感激不尽,谢谢!
--
※ 发信站: 批踢踢实业坊(ptt.cc)
◆ From: 219.85.227.70
1F:→ arrack:改成!=''如何? 04/02 13:45
3F:→ st84514:您是说哪边改成!='' 04/02 14:36
4F:→ st84514:map大,我将isset($_GET["code"])改成is null()还是错误.. 04/02 14:39
5F:→ st84514:解决了!感谢! 04/02 14:58
6F:→ MOONRAKER:有!empty()好用为何还要用 != '' 04/02 15:44