PHP(MySQL)错误:“警告:mysql_num_rows()期望参数1为资源"; [英] PHP (MySQL) error : "Warning: mysql_num_rows() expects parameter 1 to be resource"
本文介绍了PHP(MySQL)错误:“警告:mysql_num_rows()期望参数1为资源";的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
Possible Duplicate:
mysql_fetch_array() expects parameter 1 to be resource, boolean given in select
if (!empty($_POST)){
$email_to=$_POST['email_to'];
$email_to=mysql_real_escape_string($_POST['email_to']);
$sql = "UPDATE `cosmos`.`members` SET `conf` = '2' WHERE `members`.`email` = '$email_to';";
$result=mysql_query($sql) or trigger_error(mysql_error().$sql);
$count=mysql_affected_rows($result); // line 20
if($count==1){
$rows=mysql_fetch_array($result);
$unique=$rows['u_code'];
$name=$rows['username'];
// ---------------- SEND MAIL FORM ----------------
$to=$email_to;
$subject="Your Account Password Request! - Cosmos";
$header="from: Tayal's/Cosmos <cosmos@gmail.com>";
$messages= "Hey $name ,\r\n";
$messages.="You recently requested a new password";
$messages.="<br /><a href='confirm.php?uid" . $unique . "'>Confirmation Link</a> \r\n";
$sentmail = mail($to,$subject,$messages,$header);
echo $messages;
} else {
echo "Not found your email in our database";
}
}
警告:mysql_affected_rows()期望参数1为资源,在第20行的C:\ wamp \ www \ a \ l \ forget.php中给出布尔值
Warning: mysql_affected_rows() expects parameter 1 to be resource, boolean given in C:\wamp\www\a\l\forget.php on line 20
推荐答案
$result=mysql_query($sql);
到
$result=mysql_query($sql) or trigger_error(mysql_error().$sql);
然后再次运行
然后
$email_to=$_POST['email_to'];
到
$email_to=mysql_real_escape_string($_POST['email_to']);
哦,是的,还有引号
这篇关于PHP(MySQL)错误:“警告:mysql_num_rows()期望参数1为资源";的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文