Я сталкиваюсь с mysqli_error(), ожидающим, что параметр 1 будет mysqli, ноль, заданный кем-нибудь, может мне помочь? [за ⇐ Php

[Гость]

I am facing mysqli_error() expects parameter 1 to be mysqli, null given in anyone can help me? I have a separate file for database details and object class where i create 2 class first one for insert, delete, update sql query & second one is for login, register. i am new here please this code and answer me.

Код: Выделить всё

$localpath= $_SERVER['HTTP_HOST'];
if($localpath=='localhost') {
define('LOCAL_MODE', true);

}else {
define('LOCAL_MODE', false);
}

if (LOCAL_MODE) {
define("HOST", "localhost");
define("USERNAME", "root");
define("PASSWORD", "");
define("DATABASE", "office-oms");

}else {
define("HOST", "localhost");
define("USERNAME", "root");
define("PASSWORD", "test@$");
define("DATABASE", "office-oms");
}

// Include the database configuration file
require_once 'db.php';
// Create the database connection
$obj = new DB(HOST, USERNAME, PASSWORD, DATABASE);
$objlogin = new LOGIN(HOST, USERNAME, PASSWORD, DATABASE);

class DB {
private $host;
private $username;
private $password;
private $database;
private $connection;

public function __construct($host, $username, $password, $database) {
$this->host = $host;
$this->username = $username;
$this->password = $password;
$this->database = $database;
$this->connect();
}
private function connect() {
$this->connection = mysqli_connect($this->host, $this->username, $this->password, $this->database);
if (!$this->connection) {
die("Connection failed: " . mysqli_connect_error());
}
}
public function query($sql = "") {
$query = mysqli_query($this->connection, $sql);
if (!$query) {
die("Query failed: " .  mysqli_error($this->connection));
}
return $query;
}
}
// ------------------------------------------Login-signup-Start------------------------------------------

class LOGIN extends DB {
private $adminname;
private $adminemail;
private $adminpass;

public function signup($adminname, $adminemail, $adminpass) {
$erroeempt=" ";
$dataexist=" ";
$datasuccess=" ";
if (isset($_REQUEST["adminsignup"])) {
if ($adminname == "" ||  $adminemail == "" || $adminpass == "") {
$erroeempt = ' Please Fill all fields ';
} else {
// Check value already exit or not
$checkdataquery = $this->query("SELECT adminacc_email FROM adminacctb WHERE adminacc_email ='$adminemail'");
if (mysqli_num_rows($checkdataquery) > 0) {
$dataexist = 'Data Already Exist';
//echo(""); // Refresh the page after deletion
} else {
$datasuccess = 'Data successfully Submitted';
$runquery = $this->query("INSERT INTO adminacctb (adminacc_name, adminacc_email, adminacc_pass) VALUES ('$adminname', '$adminemail', '$adminpass')");
echo '';
echo 'setTimeout(redirect, 2000);';
echo 'function redirect() { window.location.href = "login.php"; }';
echo '';

}
}

return array('emptdata' => $erroeempt, 'datanotexist' => $dataexist, 'datasuccessful' => $datasuccess);
}
}

public function login($adminemail, $adminpass) {
$erroeempt=" ";
$datasuccess=" ";
$wrongvalue=" ";
$checksession="";
if (isset($_REQUEST["adminlogin"])) {
if($_REQUEST["adminemail"] == "" || $_REQUEST["adminpass"] == "") {
$erroeempt=' Please Fill all fields ';
}else {
$loginrunquery = $this->query("SELECT * FROM adminacctb WHERE adminacc_email ='$adminemail' and  adminacc_pass='$adminpass'");
$num = $this->numRows($loginrunquery);
if ($num == 0) {
$wrongvalue = ' Wrong Email or Password';
}else {
$_SESSION["is_admin_login"] = 'true';
//$row=mysqli_fetch_array($loginrunquery);
$checksession= $_SESSION["is_admin_login"];
if($checksession == 'true'){
$datasuccess = 'Login successfully Created';
echo '';
echo 'setTimeout(redirect, 2000);';
echo 'function redirect() { window.location.href = "dashboard.php"; }';
echo '';
}
else {
header('Location: login.php');
exit;
}

}
}
return array('emptdata' => $erroeempt, 'wrongvalue' =>$wrongvalue, 'datasuccessful' => $datasuccess);
}
}

public function signupuser($userusrname, $userusremail, $userusrpass) {
$erroeempt=" ";
$dataexist=" ";
$datasuccess=" ";
if (isset($_REQUEST["usersignup"])) {
if ($userusrname == "" ||  $userusremail == ""  || $userusrpass == "") {
$erroeempt = ' Please Fill all fields ';
} else {
// Check value already exit or not
$checkdataquery = $this->query("SELECT useracc_email FROM useracctb WHERE useracc_email ='$userusremail'");
if (mysqli_num_rows($checkdataquery) > 0) {
$dataexist = 'Data Already Exist';
//echo(""); // Refresh the page after deletion
} else {
$datasuccess = 'Data successfully Submitted';
$runquery = $this->query("INSERT INTO useracctb (useracc_name, useracc_email, useracc_pass) VALUES ('$userusrname', '$userusremail', '$userusrpass')");
echo '';
echo 'setTimeout(redirect, 2000);';
echo 'function redirect() { window.location.href = "login.php"; }';
echo '';

}
}

return array('emptdata' => $erroeempt, 'datanotexist' => $dataexist, 'datasuccessful' => $datasuccess);
}
}

public function loginuser($userusremail, $userusrpass) {
$erroeempt=" ";
$datasuccess=" ";
$wrongvalue=" ";
$checksession="";
if (isset($_REQUEST["userlogin"])) {
if($userusremail == "" || $userusrpass == "") {
$erroeempt=' Please Fill all fields ';
}else {
$loginrunquery = $this->query("SELECT * FROM useracctb WHERE useracc_email ='$userusremail' and  useracc_pass='$userusrpass'");
$num = $this->numRows($loginrunquery);
if ($num == 0) {
$wrongvalue = ' Wrong Email or Password';
}else {
$_SESSION["is_user_login"] = 'true';
// $row=mysqli_fetch_array($runquery);
$checksession= $_SESSION["is_user_login"];
if($checksession == 'true'){
$datasuccess = 'Login successfully Created';
echo '';
echo 'setTimeout(redirect, 2000);';
echo 'function redirect() { window.location.href = "'.$localpath.'/office-staff"; }';
echo '';
}
else {
header('Location: login.php');
exit;
}

}
}
return array('emptdata' => $erroeempt, 'wrongvalue' =>$wrongvalue, 'datasuccessful' => $datasuccess);
}
}
}
// ------------------------------------------Login-signup-End------------------------------------------

Источник: https://stackoverflow.com/questions/781 ... n-in-anyon