Here is my code
<?php class my_login_class { /* public $host = "localhost"; public $username = "root"; public $host_password = ""; public $database_name = "cndesk"; public $query = ""; protected $signup_error = ""; protected $signup_error2 = ""; protected $signup_success = ""; protected $login_error = ""; protected $login_success = ""; public $sql_connect = ""; public $sql_query = ""; */ var $host = "localhost"; var $username = "root"; var $host_password = ""; var $database_name = "cndesk"; var $query = ""; var $signup_error = ""; var $signup_error2 = ""; var $signup_success = ""; var $login_error = ""; var $login_success = ""; var $sql_connect = ""; var $sql_query = ""; public function sql_connect(){ $sql_connect = mysqli_connect($this->host,$this->username,$this->host_password); } public function sql_select_db(){ mysqli_select_db(mysqli_connect($this->host,$this->username,$this->host_password), $this->database_name); } public function set_sql_query($query){ $this->query = $query; } function get_sql_query(){ $this->sql_connect(); $this->sql_select_db(); $sql_query = mysqli_query(mysqli_connect($this->host,$this->username,$this->host_password),$this->query); $row = mysqli_fetch_assoc($this->sql_query); $num_row = mysqli_num_rows($this->sql_query); if($num_row==0){ echo'Sorry no posible match!'; } } function user_signup($signup_error){ $this->signup_error = $signup_error; echo''.$this->signup_error.''; } } $new_object = new my_login_class; $new_object->set_sql_query("SELECT * FROM `online` WHERE `user_login`='user1'"); $new_object->get_sql_query(); ?>