错误：mysqli_query（）期望参数1为mysqli，给定资源 [英] Error: mysqli_query() expects parameter 1 to be mysqli, resource given

问题描述

我的登录页面出错了。

mysqli_query（）期望参数1为mysqli，资源给定。



任何人都可以给我一个解决方案。



我尝试了什么：

Hi, I'm getting an error for my login page.
mysqli_query() expects parameter 1 to be mysqli, resource given.

Can anyone give me a solution.

What I have tried:

<?php
	session_start();
 
	require_once('connectivity-sign-up.php');
 
	$errmsg_arr = array();

	$errflag = false;
 
	function clean($str) {
		echo "str: ".$str;
		$str = @trim($str);
		if(get_magic_quotes_gpc()) {
			$str = stripslashes($str);
		}
		return mysqli_real_escape_string($str);
	}
 
	$user = $_POST['user'];
	$pass = $_POST['pass'];
 
	//Input Validations
	if($user == '') {
		$errmsg_arr[] = 'Username missing';
		$errflag = true;
	}
	if($pass == '') {
		$errmsg_arr[] = 'Password missing';
		$errflag = true;
	}
 
	if($errflag) {
		$_SESSION['ERRMSG_ARR'] = $errmsg_arr;
		session_write_close();
		header("location: login.php");
		exit();
	}
 
	$qry="SELECT * FROM websiteusers WHERE user='$user' AND pass='$pass'";
	$result=mysqli_query($con, $qry);
 
	if($result) {
		if(mysqli_num_rows($result) > 0) {
			//Login Successful
			session_regenerate_id();
			$member = mysqli_fetch_assoc($result);
			$_SESSION['SESS_MEMBER_ID'] = $member['mem_id'];
			$_SESSION['SESS_FIRST_NAME'] = $member['user'];
			$_SESSION['SESS_LAST_NAME'] = $member['pass'];
			session_write_close();
			header("location: page.php");
			exit();
		}else {
			$errmsg_arr[] = 'user name and password not found';
			$errflag = true;
			if($errflag) {
				$_SESSION['ERRMSG_ARR'] = $errmsg_arr;
				session_write_close();
				header("location: sign-up.php");
				exit();
			}
		}
	}else {
		die("Query failed");
	}
?>

推荐答案

errmsg_arr = array（）;

errmsg_arr = array();

errflag = false;

函数清理（

errflag = false; function clean(

str）{
echo str：。

这篇关于错误：mysqli_query（）期望参数1为mysqli，给定资源的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！