如何在功能中连接数据库？ [英] How to connect database in function?

问题描述

我尝试使用函数创建登录页面。但是，得到了错误 -

I trying to make login page using function. But, got folling error-

Notice: Undefined variable: conn in F:\xampp\htdocs\bcci\admin_panel\class\adminLogin.php on line 7

我的尝试：



这个是adminlogin.php页面。

What I have tried:

This is adminlogin.php page.

<?php
	include('includes/dbconfig.php');
 
	function adminLogin($username, $userpass, $userstatus) {
		
		$sql = "SELECT * FROM admin	WHERE username='$username'";
		$result = $conn->query($sql);
		$row = $result->fetch_assoc();
		if($row['userpass'] == $userpass && $row['userstatus'] == $userstatus){
			$_SESSION['username'] =  $username;
			header('Location:home.php');
		}else{
			$error_msg = '
							<div class="alert alert-danger alert-dismissible" role="alert">
							  <button type="button" class="close" data-dismiss="alert" aria-label="Close"><span aria-hidden="true">×</span></button>
							  Warning! User name and Password does not match.
							</div>
						';
		}
	}
?>

这是dbconfig.php页面。

This is dbconfig.php page.

<?php
// this will avoid mysql_connect() deprecation error.
 //error_reporting( ~E_DEPRECATED & ~E_NOTICE );
$dbhost = "localhost";

$dbuser = "root";

$dbpass = "";
$dbname = "xyz";
$conn= mysqli_connect($dbhost,$dbuser,$dbpass) or die('cannot connect to the server'); 
mysqli_select_db($conn, $dbname) or die('database selection problem');
session_start();
?>

推荐答案

用户名，

userpass，

userstatus）{

userstatus) {

这篇关于如何在功能中连接数据库？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！