I made a class that connects to a database but how to use it?

Question

I have a file that contains all the information for my database. I have another file that uses this information. And I have a function that is suppose to gather information from the database but I need to use mysqli_query.

How do I do this? mysqli_query expects two things:

the query
the connection to the database

But my connection to the database is a separate function.

private $db;

//put your code here
// constructor
function __construct() {
    require_once 'DB_Connect.php';
    // connecting to database
    $this->db = new DB_Connect();
    $this->db->connect();
}

// destructor
function __destruct() {

}

public function isUserExisted($email) {
    $result = mysqli_query(

What goes here?

        ,"SELECT email from users WHERE email = '$email'");
    $no_of_rows = mysqli_num_rows($result);
    if ($no_of_rows > 0) {
    // user existed 
    return true;
    } else {
    // user not existed
    return false;
    }
}

Try the documentation: http://php.net/manual/en/mysqli.query.php — Matthew, Oct 02 '13 at 02:05
Does this answer your question? [How to include a PHP variable inside a MySQL statement](https://stackoverflow.com/questions/7537377/how-to-include-a-php-variable-inside-a-mysql-statement) — Dharman, Jan 04 '20 at 21:06

score -1 · Answer 1 · answered Jul 20 '15 at 05:27

-1

$result = mysqli_query($this->db->connect(),"SELECT email from users WHERE email = '$email'");

answered Jul 20 '15 at 05:27

Ronny Morán

513
6
9

3

a short explanation would be useful – Ophir Yoktan Jul 20 '15 at 05:38

score -2 · Answer 2 · edited Jun 02 '22 at 12:14

You Should initiate connection object and use it for query Your Construct Function should be like this

function __construct() {
          require_once 'DB_Connect.php';
           $db = new DB_Connect;
           $this->db_con = $db->connect();
       }

and then you can call anywhere in class like this:

$result = $this->db_con->query("select * from users Where username ='$username' and pass='$hashedpassword'");

I made a class that connects to a database but how to use it?

2 Answers2