$sorgu=mysql_query("SELECT * FROM users WHERE UserName='$userName' AND Password='$password'");
if( mysql_affected_rows() )
{
**$row=mysql_fetch_array($sorgu);** /// this line is erorr
if(in_array($row["UserID"],$_SESSION["id_array"]))
{
echo "session is already open";
}
else
{
$array=array(
"id" => $row["UserID"],
"userName" => $row["UserName"],
"email" => $row["Email"],
"admin" => $row["admin"],
);
$_SESSION["login"]=true;
$_SESSION["array"][$row["UserID"]] = $array;
$_SESSION["id_array"][]=$row["UserID"];
$_SESSION["userid"] = $row["UserID"];
header("Location: index.php");
php errors(警告:mysql_fetch_array():提供的参数不是有效的MySQL结果资源
- 写回答
- 好问题 0 提建议
- 追加酬金
- 关注问题
- 邀请回答
-
1条回答 默认 最新
- dq_1984 2014-12-14 15:04关注
Use "mysql_num_rows($sorgu) > 0" instead of mysql_affected_rows() on line 2
mysql_affected_rows() is intended to check UPDATEs and INSERTs, not SELECTs.
解决 无用评论 打赏 举报
悬赏问题
- ¥15 Oracle中如何从clob类型截取特定字符串后面的字符
- ¥15 想通过pywinauto自动电机应用程序按钮,但是找不到应用程序按钮信息
- ¥15 MATLAB中streamslice问题
- ¥15 如何在炒股软件中,爬到我想看的日k线
- ¥15 seatunnel 怎么配置Elasticsearch
- ¥15 PSCAD安装问题 ERROR: Visual Studio 2013, 2015, 2017 or 2019 is not found in the system.
- ¥15 (标签-MATLAB|关键词-多址)
- ¥15 关于#MATLAB#的问题,如何解决?(相关搜索:信噪比,系统容量)
- ¥500 52810做蓝牙接受端
- ¥15 基于PLC的三轴机械手程序