PHP (MySQL) 错误:“警告:mysql_num_rows() 期望参数 1 为资源" [英] PHP (MySQL) error : "Warning: mysql_num_rows() expects parameter 1 to be resource"

问题描述

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) 或 trigger_error(mysql_error().$sql);$count=mysql_affected_rows($result);//第 20 行如果($count==1){$rows=mysql_fetch_array($result);$unique=$rows['u_code'];$name=$rows['用户名'];//---------------- 发送邮件表格 ----------------$to=$email_to;$subject=您的帐户密码请求！- 宇宙"；$header="来自:Tayal's/Cosmos ";$messages= "嘿 $name ,\r\n";$messages.=您最近申请了一个新密码";$messages.="<br/><a href='confirm.php?uid".$独特的.</a>确认链接</a>\r\n";$sentmail = mail($to,$subject,$messages,$header);回声 $messages;}   别的 {echo "在我们的数据库中未找到您的电子邮件";}}

<块引用>

警告:mysql_affected_rows() 期望参数 1 是资源，布尔值在 C:\wamp\www\a\l\forget.php 第 20 行

解决方案

$result=mysql_query($sql);

到

$result=mysql_query($sql) 或 trigger_error(mysql_error().$sql);

然后再次运行

然后

$email_to=$_POST['email_to'];

到

$email_to=mysql_real_escape_string($_POST['email_to']);

哦，是的，还有引号

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 <[e-mail]>"; 
    $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";
    }


}

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);

to

$result=mysql_query($sql) or trigger_error(mysql_error().$sql);

and run it again

and then

$email_to=$_POST['email_to'];

to

$email_to=mysql_real_escape_string($_POST['email_to']);

oh yes, and there is also quotes

这篇关于PHP (MySQL) 错误:“警告:mysql_num_rows() 期望参数 1 为资源"的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！