index.php
<?php
if(!defined('ROOT'))
{
define('ROOT','C:/Apache/htdocs/website/inc');
}
require_once ROOT. '/config/db.php';
require_once ROOT. '/library/classes/class.User.php';
$checkUser = new userFunction();
if($_SERVER["REQUEST_METHOD"] == "POST")
{
$username = $_POST["username"];
$password = $_POST["password"];
$user = $checkUser->userLogin($username, $password);
if($user)
{
echo "Succes";
}
else
{
echo "Failed";
}
}
db.php
<?php
class dbConnect
{
function __construct()
{
require_once('config.php');
$connection = mysqli_connect(hostname, username, password);
mysqli_select_db($connection, database);
if (!$connection)
{
die('Could not connect to the database because: ' .mysqli_connect_error());
}
return $connection;
}
public function Close()
{
mysqli_close();
}
}
?>
class.User.php
<?php
if(!defined('ROOT'))
{
define('ROOT','C:/Apache/htdocs/website/inc');
}
require_once ROOT. '/config/db.php';
session_start();
class userFunction
{
protected $connection;
function __construct()
{
$this->connection = new dbConnect();
}
function __destruct()
{
}
public function userRegister($username, $password, $checkpassword)
{
$password = md($password);
if ($password == $checkpassword)
{
$insert = "INSERT INTO users (Username, Password) VALUES ('$username','$password')";
$data = mysqli_query($connection, $insert);
return $data;
}
}
public function userLogin($username, $password)
{
$result = mysqli_query($this->connection, "SELECT * FROM users WHERE LOWER (Username) = LOWER ('$username') AND Password = '$password'");
$dataResult = mysqli_fetch_array($result);
$row = mysqli_num_rows($result);
if($row == 1)
{
$data = array();
$data['loggedIn'] = true;
$data['Username'] = $dataResult["Username"];
$data['id'] = $dataResult["userID"];
$data['loginDate'] = time();
$data['lastAccess'] = time();
$data['rememberMe'] = $rememberMe;
$data['ip'] = $ip;
$data['via'] = $via;
return TRUE;
}
else
{
return FALSE;
}
}
public function isUserExist($username)
{
$result = mysqli_query($connection, "SELECT * FROM users WHERE LOWER (Username) = LOWER ('$username')");
$row = mysqli_num_rows($result);
if ($row > 0)
{
return TRUE;
}
else
{
return FALSE;
}
}
}
When i use userLogin function (on index.php) i recive this errors:
Warning: mysqli_query() expects parameter 1 to be mysqli, object given in ...\class.User.php on line 35
Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, null given in ...\class.User.php on line 36
Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, null given in ...\class.User.php on line 37 Failed
How can i solve this?