警告：mysqli_error（）预计参数1是mysqli的，在给定的/home/digibeem/public_html/forgot_pass.php线56串 [英] Warning: mysqli_error() expects parameter 1 to be mysqli, string given in /home/digibeem/public_html/forgot_pass.php on line 56
本文介绍了警告：mysqli_error（）预计参数1是mysqli的，在给定的/home/digibeem/public_html/forgot_pass.php线56串的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！
问题描述
这是我的编码：forgot_pass.php的
＆LT; PHP
include_once（php_includes / check_login_status.php）;
//如果用户已登录，报头weenis远
如果（$ user_ok ==真）{
标题（位置：user.php的U =$ _ SESSION [用户名]）;
出口（）;
}
？＆GT;＆LT; PHP
// AJAX调用这个code执行
如果（使用isset（$ _ POST [E））{
$ E = mysqli_real_escape_string（$ db_conx，$ _ POST ['E']）;
$的SQL =SELECT ID，用户名用户的电子邮件WHERE ='$ e和激活='1'LIMIT 1;
$查询= mysqli_query（$ db_conx，$ SQL）;
$其行= mysqli_num_rows（$查询）;
如果（$ numRows行大于0）{
而（$行= mysqli_fetch_array（$查询，MYSQLI_ASSOC））{
的$ id = $行[身份证];
$ U = $行[用户名];
}
$ emailcut = SUBSTR（$ E，0,4）;
$ randNum =兰特（10000,99999）;
$ tempPass =$ emailcut $ randNum
$ hashTempPass =的MD5（$ tempPass）;
$ SQL =UPDATE USEROPTIONS SET temp_pass ='$ hashTempPass其中username ='$ U限制1;
$查询= mysqli_query（$ db_conx，$ SQL）;
$到=$ E;
从$ =auto_responder@digibeem.com;
$标题=从：从$ \\ N的;
$标题=MIME-版本：1.0 \\ n。
$标题=内容类型：text / html的;字符集= ISO-8859-1 \\ N。
$主题=DigiBeem账户临时密码申请;
$味精='＆LT; H2＆GT;你好'$ U'＆LT; / H2＆GT;＆LT; P＆gt;这是从digibeem的自动消息。如果您最近并未启动忘记密码的过程，请忽略此电子邮件＆LT; / P＆GT;＆LT; P＆gt;您指出您忘记了登录密码。我们可以生成一个临时密码，供您使用登录，然后登录后，你可以改变你的密码，以任何你喜欢＆LT; / P＆GT;＆LT; P＆gt;您点击链接后下方的密码登陆将是：＆LT峰; br /><b>'.$tempPass.'</b></p><p><a HREF =http://www.digibeem.com/forgot_pass.php?u '。$ U'=＆安培; p ='$ hashTempPass。'＆gt;接着点击此处申请以下到您的帐户中所示的临时密码; / A＆GT;＆LT; / p＆GT;＆LT; p＆GT;如果你不这样做点击该邮件中的链接，没有任何更改将在您的账户中支付。为了设置您的登录密码到临时密码，您必须点击上面的链接＆LT; / P＆GT;';
如果（电子邮件（$到，$主题，$味精，$头））{
回声成功;
出口（）;
}其他{
回声email_send_failed
出口（）;
}
}其他{
回声no_exist
}
出口（）;
}
？＆GT;＆LT; PHP
// EMAIL链接点击调用这个code执行
如果（使用isset（$ _ GET ['U']）及和放大器;使用isset（$ _ GET ['P']））{
$ U = preg_replace（'＃[^ A-Z0-9]＃I'，''，$ _GET ['U']）;
$ temppasshash = preg_replace（'＃[^ A-Z0-9]＃I'，''，$ _GET ['P']）;
如果（strlen的（$ temppasshash）小于10）{
出口（）;
}
$的SQL =SELECT ID FROM USEROPTIONS其中username ='$ U'AND temp_pass ='$ temppasshashLIMIT 1;
$查询= mysqli_query（$ db_conx，$ SQL）;
$其行= mysqli_num_rows（$查询）;
如果（$其行== 0）{
标题（位置：？。message.php味精=没有匹配与系统中的临时密码的用户名，我们无法进行）;
出口（）;
}其他{
$行= mysqli_fetch_row（$查询）;
的$ id = $行[0];
$ SQL =更新用户设置密码='$ temppasshash'WHERE ID ='$ ID和用户名='$ U限制1;
$查询= mysqli_query（$ db_conx，$ SQL）;
$ SQL =UPDATE USEROPTIONS SET temp_pass =''其中username ='$ U限制1;
$查询= mysqli_query（$ db_conx，$ SQL）;
标题（位置：login.php中）;
出口（）;
}
}
？＆GT;
！＆LT; DOCTYPE HTML PUBLIC - // W3C // DTD XHTML 1.0 Strict标准// ENhttp://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd\">
＆LT; HTML的xmlns =http://www.w3.org/1999/xhtmlXML：LANG =ENLANG =ENGT＆;
＆LT; HEAD＆GT;
＆LT; META HTTP-EQUIV =Content-Type的CONTENT =text / html的;字符集= UTF-8/＆GT; ＆LT;标题＆GT;密码恢复和LT; /标题＆GT; ＆LT;！ - CSS - ＆GT;
＆LT;链接rel =stylesheet属性HREF =CSS / style.css文件类型=文/ CSS媒体=屏幕/＆GT;
＆LT;！ - [如果IE 6] GT;
＆LT;链接rel =stylesheet属性类型=文/ CSS媒体=屏幕上的href =CSS / IE-hacks.css/＆GT;
＆LT;脚本类型=文/ JavaScript的SRC =JS / DD_belatedPNG.js＆GT;＆LT; / SCRIPT＆GT;
＆LT;脚本＆GT;
/ *例* /
DD_belatedPNG.fix（'*'）;
＆LT; / SCRIPT＆GT;
百分比抑制率ENDIF] - GT！;
＆LT;！ - [如果IE 7＆GT;
＆LT;链接rel =stylesheet属性HREF =CSS / IE7-hacks.css类型=文/ CSS媒体=屏幕/＆GT;
百分比抑制率ENDIF] - GT！;
＆LT;！ - [如果IE 8]＆GT;
＆LT;链接rel =stylesheet属性HREF =CSS / IE8-hacks.css类型=文/ CSS媒体=屏幕/＆GT;
百分比抑制率ENDIF] - GT！;
＆LT;！ - 完CSS - ＆GT; ＆LT;！ - prettyPhoto - ＆GT;
＆LT;链接rel =stylesheet属性HREF =JS / prettyPhoto / CSS / prettyPhoto.css类型=文/ CSS媒体=屏幕/＆GT;
＆LT;！ - 完prettyPhoto - ＆GT; ＆LT;！ - JS - ＆GT;
＆LT;脚本类型=文/ JavaScript的SRC =JS / jquery_1.4.2.js＆GT;＆LT; / SCRIPT＆GT;
＆LT;脚本类型=文/ JavaScript的SRC =JS / jqueryui.js＆GT;＆LT; / SCRIPT＆GT;
＆LT;脚本类型=文/ JavaScript的SRC =JS / easing.js＆GT;＆LT; / SCRIPT＆GT;
＆LT;脚本类型=文/ JavaScript的SRC =JS / jquery.cycle.all.js＆GT;＆LT; / SCRIPT＆GT;
＆LT;脚本类型=文/ JavaScript的SRC =JS /提示/ jquery.tools.min.js＆GT;＆LT; / SCRIPT＆GT;
＆LT;脚本类型=文/ JavaScript的SRC =JS / filterable.pack.js＆GT;＆LT; / SCRIPT＆GT;
＆LT;脚本类型=文/ JavaScript的SRC =JS / prettyPhoto / JS / jQuery的prettyPhoto.js。＆GT;＆LT; / SCRIPT＆GT;
＆LT;脚本类型=文/ JavaScript的SRC =JS / chirp.js＆GT;＆LT; / SCRIPT＆GT;
＆LT;脚本类型=文/ JavaScript的SRC =JS / jquery.tabs / jquery.tabs.pack.js＆GT;＆LT; / SCRIPT＆GT;
＆LT;脚本类型=文/ JavaScript的SRC =JS / custom.js＆GT;＆LT; / SCRIPT＆GT;
＆LT;！ - 完JS - ＆GT; ＆所述;！ - 的Cufón - ＆GT;
＆LT;脚本SRC =JS /的Cufón-yui.js类型=文/ JavaScript的＆GT;＆LT; / SCRIPT＆GT;
＆LT;脚本SRC =JS /字体/自由的-neue_400.font.js类型=文/ JavaScript的＆GT;＆LT; / SCRIPT＆GT;
＆LT;！ - /的Cufón - ＆GT; ＆LT;！ - 快鱼 - ＆GT;
＆LT;链接rel =stylesheet属性类型=文/ CSS媒体=屏幕上的href =CSS /快鱼-custom.css/＆GT;
＆LT;脚本类型=文/ JavaScript的SRC =JS /快鱼-1.4.8 / JS / hoverIntent.js＆GT;＆LT; / SCRIPT＆GT;
＆LT;脚本类型=文/ JavaScript的SRC =JS /快鱼-1.4.8 / JS / superfish.js＆GT;＆LT; / SCRIPT＆GT;
＆LT;！ - 完快鱼 - ＆GT; ＆LT;！ - 标签 - ＆GT;
＆LT;链接rel =stylesheet属性HREF =CSS / jquery.tabs.css类型=文/ CSS媒体=打印，投影屏/＆GT;
＆LT;！ - 其他IE / Win的具体样式表（条件注释） - GT;
＆LT;！ - [如果LTE IE 7＆GT;
＆LT;链接rel =stylesheet属性HREF =CSS / jquery.tabs-ie.css类型=文/ CSS媒体=投影屏幕＆GT;
百分比抑制率ENDIF] - GT！;
＆LT;！ - 完标签 - ＆GT;
＆LT;风格类型=文/ CSS＆GT;
#forgotpassform {
的margin-top：24px的;
}
#forgotpassform＆GT; DIV {
的margin-top：12px的;
}
#forgotpassform＆GT;输入{
宽度：250像素;
填充：的3px;
背景：＃F3F9DD;
}
#forgotpassbtn {
字体大小：15像素;
填充：10px的;
}
＆LT; /风格＆GT;
＆LT;脚本SRC =JS / main.js＆GT;＆LT; / SCRIPT＆GT;
＆LT;脚本SRC =JS / ajax.js＆GT;＆LT; / SCRIPT＆GT;
＆LT;脚本＆GT;
功能forgotpass（）{
。变种E = _（电子邮件）值;
如果（E ==）{
_（身份）的innerHTML =输入您的电子邮件地址。;
}其他{
。_（forgotpassbtn）的style.display =无;
。_（身份）的innerHTML ='请稍候......;
VAR阿贾克斯= ajaxObj（POST，forgot_pass.php）;
ajax.onreadystatechange =功能（）{
如果（ajaxReturn（阿贾克斯）==真）{
VAR响应= ajax.responseText;
如果（响应==成功）{
_（forgotpassform）的innerHTML ='＆LT; H3＆GT;第2步：检查您的电子邮件收件箱几分钟＆LT; / H3＆GT;＆LT; P＆GT;如果你喜欢，你可以关闭此窗口或标签＆LT; / P＆GT;' ;
}否则如果（响应==no_exist）{
。_（身份）的innerHTML =对不起，该电子邮件地址是不是在我们的制度;
}否则如果（响应==email_send_failed）{
。_（身份）的innerHTML =邮件功能无法执行;
}其他{
。_（身份）的innerHTML =发生未知错误;
}
}
}
ajax.send（E =+ e）条;
}
}
＆LT; / SCRIPT＆GT;
＆LT; /头＆GT;
＆LT;身体GT; ＆LT;！ - 头文件 - ＆GT;＆LT; PHP的包括的header.php'＆GT;＆LT; - ！完头文件 - ＆GT; ＆所述;！ - 主 - ＆GT;
＆LT; DIV ID =主＆GT; ＆LT;！ - 包装 - ＆GT;
＆LT; DIV CLASS =包装＆GT; ＆LT;！ - 内容 - ＆GT;
＆LT; DIV CLASS =内容＆GT;
＆LT; DIV CLASS =冠军保持者＆GT;
＆LT;跨度类=标题＆GT;＆LT; H2＆GT;密码恢复角落...＆LT; / H＆GT;＆LT; / SPAN＆GT;
＆LT;跨度类=字幕＆GT;＆LT; B＆GT;＆LT; / B＆GT;＆LT; / SPAN＆GT; ＆LT; / DIV＆GT;
＆LT;！ - 岗位 - ＆GT;
＆LT; DIV ALIGN =中心＆GT;
＆LT; H3＆GT;生成temorary登录密码＆LT; / H3 GT＆;
＆LT;表ID =forgotpassform的onsubmit =返回false;＆GT;
＆LT; DIV＆步骤1：输入您的电子邮件地址＆LT; / DIV＆GT;
＆LT;输入ID =电子邮件类型=文本的onfocus =_（'状态'）的innerHTML ='';。 MAXLENGTH =88＆GT;
＆LT; BR /＆GT;＆LT; BR /＆GT;
＆LT;按钮ID =forgotpassbtn的onclick =forgotpass（）＆GT;生成临时登录密码＆LT; /按钮＆GT;
＆LT; p = ID状态＆GT;＆LT; / P＆GT;
＆LT; /表及GT;
＆LT; / DIV＆GT;
＆LT;！ - 完帖子 - ＆GT; ＆LT;！ - 侧栏 - ＆GT; ＆LT;！ - 完栏 - ＆GT;
＆LT; / DIV＆GT;
＆LT;！ - ENDS内容的博客 - ＆GT; ＆LT; DIV CLASS =影子除法＆GT;＆LT; / DIV＆GT;
＆LT; / DIV＆GT;
＆LT;！ - 完主包装 - ＆GT;
＆LT; / DIV＆GT;
＆LT;！ - 完主 - ＆GT;＆LT;？PHP的包括footer_social.php'＆GT？; ＆LT; - ！开始的Cufón - ＆GT;
＆LT;脚本类型=文/ JavaScript的＆GT; Cufon.now（）; ＆LT; / SCRIPT＆GT;
＆LT;！ - 完开始的Cufón - ＆GT; ＆LT; /身体GT;
＆LT; / HTML＆GT;
以上编码编码忘记密码的系统，我试图，但得到失败。这是行中没有。 55，请告诉我如何做这个工作，因为我真的很烦恼这个问题，请请请，如果可能的话请你建议我改变，包括任何一列没有。或者一些文本行。
$其行= mysqli_num_rows（$查询）;
当我加入了行
$查询= mysqli_query（$ db_conx，$ SQL）或trigger_error（查询失败的SQL：$ sql中 - 错误：.mysqli_error（$ db_conx），E_USER_ERROR）;
在显示如下文字的所有行：
$查询= mysqli_query（$ db_conx，$ SQL）;
我得到了下面的实际错误显示我的网页上这一行：
致命错误：查询失败！ SQL：SELECT ID FROM USEROPTIONS WHERE
用户名='Nishchey'AND temp_pass ='c83a525311b0a36f96c45c2afa69fd36
LIMIT 1 - 错误：未知列'temp_pass'在'where子句中
在线56 /home/digibeem/public_html/forgot_pass.php解决方案
致命错误：查询失败！ SQL：SELECT ID FROM USEROPTIONS其中username ='Nishchey'AND temp_pass ='c83a525311b0a36f96c45c2afa69fd36'LIMIT 1 - 错误：where子句在线56未知列'temp_pass在/home/digibeem/public_html/forgot_pass.php
这意味着在一个名为您的数据库表
USEROPTIONS没有任何名为列temp_pass。请发表您的数据库表
USEROPTIONS，我可以告诉你更多。This is my coding: of forgot_pass.php
<?php include_once("php_includes/check_login_status.php"); // If user is already logged in, header that weenis away if($user_ok == true){ header("location: user.php?u=".$_SESSION["username"]); exit(); } ?><?php // AJAX CALLS THIS CODE TO EXECUTE if(isset($_POST["e"])){ $e = mysqli_real_escape_string($db_conx, $_POST['e']); $sql = "SELECT id, username FROM users WHERE email='$e' AND activated='1' LIMIT 1"; $query = mysqli_query($db_conx, $sql); $numrows = mysqli_num_rows($query); if($numrows > 0){ while($row = mysqli_fetch_array($query, MYSQLI_ASSOC)){ $id = $row["id"]; $u = $row["username"]; } $emailcut = substr($e, 0, 4); $randNum = rand(10000,99999); $tempPass = "$emailcut$randNum"; $hashTempPass = md5($tempPass); $sql = "UPDATE useroptions SET temp_pass='$hashTempPass' WHERE username='$u' LIMIT 1"; $query = mysqli_query($db_conx, $sql); $to = "$e"; $from = "auto_responder@digibeem.com"; $headers ="From: $from\n"; $headers .= "MIME-Version: 1.0\n"; $headers .= "Content-type: text/html; charset=iso-8859-1 \n"; $subject ="DigiBeem Account Temporary Password Request"; $msg = '<h2>Hello '.$u.'</h2><p>This is an automated message from digibeem. If you did not recently initiate the Forgot Password process, please disregard this email.</p><p>You indicated that you forgot your login password. We can generate a temporary password for you to log in with, then once logged in you can change your password to anything you like.</p><p>After you click the link below your password to login will be:<br /><b>'.$tempPass.'</b></p><p><a href="http://www.digibeem.com/forgot_pass.php?u='.$u.'&p='.$hashTempPass.'">Click here now to apply the temporary password shown below to your account</a></p><p>If you do not click the link in this email, no changes will be made to your account. In order to set your login password to the temporary password you must click the link above.</p>'; if(mail($to,$subject,$msg,$headers)) { echo "success"; exit(); } else { echo "email_send_failed"; exit(); } } else { echo "no_exist"; } exit(); } ?><?php // EMAIL LINK CLICK CALLS THIS CODE TO EXECUTE if(isset($_GET['u']) && isset($_GET['p'])){ $u = preg_replace('#[^a-z0-9]#i', '', $_GET['u']); $temppasshash = preg_replace('#[^a-z0-9]#i', '', $_GET['p']); if(strlen($temppasshash) < 10){ exit(); } $sql = "SELECT id FROM useroptions WHERE username='$u' AND temp_pass='$temppasshash' LIMIT 1"; $query = mysqli_query($db_conx, $sql); $numrows = mysqli_num_rows($query); if($numrows == 0){ header("location: message.php?msg=There is no match for that username with that temporary password in the system. We cannot proceed."); exit(); } else { $row = mysqli_fetch_row($query); $id = $row[0]; $sql = "UPDATE users SET password='$temppasshash' WHERE id='$id' AND username='$u' LIMIT 1"; $query = mysqli_query($db_conx, $sql); $sql = "UPDATE useroptions SET temp_pass='' WHERE username='$u' LIMIT 1"; $query = mysqli_query($db_conx, $sql); header("location: login.php"); exit(); } } ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>Password Recovery</title> <!-- CSS --> <link rel="stylesheet" href="css/style.css" type="text/css" media="screen" /> <!--[if IE 6]> <link rel="stylesheet" type="text/css" media="screen" href="css/ie-hacks.css" /> <script type="text/javascript" src="js/DD_belatedPNG.js"></script> <script> /* EXAMPLE */ DD_belatedPNG.fix('*'); </script> <![endif]--> <!--[if IE 7]> <link rel="stylesheet" href="css/ie7-hacks.css" type="text/css" media="screen" /> <![endif]--> <!--[if IE 8]> <link rel="stylesheet" href="css/ie8-hacks.css" type="text/css" media="screen" /> <![endif]--> <!-- ENDS CSS --> <!-- prettyPhoto --> <link rel="stylesheet" href="js/prettyPhoto/css/prettyPhoto.css" type="text/css" media="screen" /> <!-- ENDS prettyPhoto --> <!-- JS --> <script type="text/javascript" src="js/jquery_1.4.2.js"></script> <script type="text/javascript" src="js/jqueryui.js"></script> <script type="text/javascript" src="js/easing.js"></script> <script type="text/javascript" src="js/jquery.cycle.all.js"></script> <script type="text/javascript" src="js/tooltip/jquery.tools.min.js"></script> <script type="text/javascript" src="js/filterable.pack.js"></script> <script type="text/javascript" src="js/prettyPhoto/js/jquery.prettyPhoto.js"></script> <script type="text/javascript" src="js/chirp.js"></script> <script type="text/javascript" src="js/jquery.tabs/jquery.tabs.pack.js"></script> <script type="text/javascript" src="js/custom.js"></script> <!-- ENDS JS --> <!-- Cufon --> <script src="js/cufon-yui.js" type="text/javascript"></script> <script src="js/fonts/bebas-neue_400.font.js" type="text/javascript"></script> <!-- /Cufon --> <!-- superfish --> <link rel="stylesheet" type="text/css" media="screen" href="css/superfish-custom.css" /> <script type="text/javascript" src="js/superfish-1.4.8/js/hoverIntent.js"></script> <script type="text/javascript" src="js/superfish-1.4.8/js/superfish.js"></script> <!-- ENDS superfish --> <!-- tabs --> <link rel="stylesheet" href="css/jquery.tabs.css" type="text/css" media="print, projection, screen" /> <!-- Additional IE/Win specific style sheet (Conditional Comments) --> <!--[if lte IE 7]> <link rel="stylesheet" href="css/jquery.tabs-ie.css" type="text/css" media="projection, screen"> <![endif]--> <!-- ENDS tabs --> <style type="text/css"> #forgotpassform{ margin-top:24px; } #forgotpassform > div { margin-top: 12px; } #forgotpassform > input { width: 250px; padding: 3px; background: #F3F9DD; } #forgotpassbtn { font-size:15px; padding: 10px; } </style> <script src="js/main.js"></script> <script src="js/ajax.js"></script> <script> function forgotpass(){ var e = _("email").value; if(e == ""){ _("status").innerHTML = "Type in your email address"; } else { _("forgotpassbtn").style.display = "none"; _("status").innerHTML = 'please wait ...'; var ajax = ajaxObj("POST", "forgot_pass.php"); ajax.onreadystatechange = function() { if(ajaxReturn(ajax) == true) { var response = ajax.responseText; if(response == "success"){ _("forgotpassform").innerHTML = '<h3>Step 2. Check your email inbox in a few minutes</h3><p>You can close this window or tab if you like.</p>'; } else if (response == "no_exist"){ _("status").innerHTML = "Sorry that email address is not in our system"; } else if(response == "email_send_failed"){ _("status").innerHTML = "Mail function failed to execute"; } else { _("status").innerHTML = "An unknown error occurred"; } } } ajax.send("e="+e); } } </script> </head> <body> <!-- HEADER --><?php include 'header.php' ?><!-- ENDS HEADER --> <!-- MAIN --> <div id="main"> <!-- wrapper --> <div class="wrapper"> <!-- content --> <div class="content"> <div class="title-holder"> <span class="title"><h2>Password Recovery Corner...</h2></span> <span class="subtitle"><b></b></span> </div> <!-- POSTS --> <div align="center"> <h3>Generate a temorary log in password</h3> <form id="forgotpassform" onsubmit="return false;"> <div>Step 1: Enter Your Email Address</div> <input id="email" type="text" onfocus="_('status').innerHTML='';" maxlength="88"> <br /><br /> <button id="forgotpassbtn" onclick="forgotpass()">Generate Temporary Log In Password</button> <p id="status"></p> </form> </div> <!-- ENDS POSTS --> <!-- sidebar --> <!-- ENDS sidebar --> </div> <!-- ENDS content-blog --> <div class="shadow-divider"></div> </div> <!-- ENDS main-wrapper --> </div> <!-- ENDS MAIN --> <?php include 'footer_social.php' ?> <!-- start cufon --> <script type="text/javascript"> Cufon.now(); </script> <!-- ENDS start cufon --> </body> </html>The above coding is coding for forgot password system, what i was trying but got failed. And this is line no. 55, Please tell me how to make this working, as i am really very troubled with this problem, Please Please Please and if possible then would you please suggest me changes including either row no. or some text in row.
$numrows = mysqli_num_rows($query);when i added the line
$query = mysqli_query($db_conx, $sql) or trigger_error("Query Failed! SQL: $sql - Error: ".mysqli_error($db_conx), E_USER_ERROR);before all the lines showing the text as below:
$query = mysqli_query($db_conx, $sql);i got this line displayed on my page below the actual error:
Fatal error: Query Failed! SQL: SELECT id FROM useroptions WHERE username='Nishchey' AND temp_pass='c83a525311b0a36f96c45c2afa69fd36' LIMIT 1 - Error: Unknown column 'temp_pass' in 'where clause' in /home/digibeem/public_html/forgot_pass.php on line 56
解决方案Fatal error: Query Failed! SQL: SELECT id FROM useroptions WHERE username='Nishchey' AND temp_pass='c83a525311b0a36f96c45c2afa69fd36' LIMIT 1 - Error: Unknown column 'temp_pass' in 'where clause' in /home/digibeem/public_html/forgot_pass.php on line 56
It means in your db table named
useroptionsthere is not any column namedtemp_pass.Please post your db table
useroptions, and I can tell you more.这篇关于警告：mysqli_error（）预计参数1是mysqli的，在给定的/home/digibeem/public_html/forgot_pass.php线56串的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
查看全文
