hi i am using oophp to create a registration and login system, i am trying to check if an email or username already exists in the database, but when i try and call the database class i keep getting these errors, any help would be appreciated.
Notice: Undefined variable: Database in C:\Users\josh\xampp-win32-1.8.3-5-VC11\xampp\htdocs\oop_system\include\class.user.php on line 14
Notice: Trying to get property of non-object in C:\Users\josh\xampp-win32-1.8.3-5-VC11\xampp\htdocs\oop_system\include\class.user.php on line 14
Fatal error: Call to a member function query() on a non-object in C:\Users\josh\xampp-win32-1.8.3-5-VC11\xampp\htdocs\oop_system\include\class.user.php on line 14
user class
<?php
include "db_config.php";
class User{
/*** for registration process ***/
public function reg_user($name,$username,$password,$email){
$password = md5($password);
$sql="SELECT * FROM users WHERE uname='$username' OR uemail='$email'";
//checking if the username or email is available in db
$check = $Database->getConnection->query($sql) ;
$count_row = $check->num_rows;
//if the username is not in db then insert to the table
if ($count_row == 0){
$sql1="INSERT INTO users SET uname='$username', upass='$password', fullname='$name', uemail='$email'";
$result = mysqli_query($this->db,$sql1) or die(mysqli_connect_errno()."Data cannot inserted");
return $result;
}
else { return false;}
}
}
?>
db_config class
<?php
/*
* Mysql database class - only one connection alowed
*/
class Database {
private $_connection;
private static $_instance; //The single instance
private $_host = "localhost";
private $_username = "root";
private $_password = "";
private $_database = "oop";
/*
Get an instance of the Database
@return Instance
*/
public static function getInstance() {
if(!self::$_instance) { // If no instance then make one
self::$_instance = new self();
}
return self::$_instance;
}
// Constructor
private function __construct() {
$this->_connection = new mysqli($this->_host, $this->_username,
$this->_password, $this->_database);
// Error handling
if(mysqli_connect_error()) {
trigger_error("Failed to conencto to MySQL: " . mysql_connect_error(),
E_USER_ERROR);
}
}
// Magic method clone is empty to prevent duplication of connection
private function __clone() { }
// Get mysqli connection
public function getConnection() {
return $this->_connection;
}
}
?>