Fatal error: Call to a member function prepare() on a non-object.

Question

I have a problem when i enter login details i get this error

Fatal error: Call to a member function prepare() on a non-object in C:\wamp\www\Remake Login Page\Classes\Mysql.php on line 22

Code of Mysql.php:

<?php

require_once 'includes/constants.php';

class Mysql {
private $conn;

function _construct() {
    $this->$conn = new mysqli(DB_SERVER, DB_USER, DB_PASSWORD, DB_NAME) or die 
                  ('There was a problem connecting to the database');
}

function verify_Username_and_Pass($un, $pwd) {


    $query = "SELECT *
            FROM users
            WHERE username = ? AND password = ?
            LIMIT 1";


    if($stmt = $this->conn->prepare($query)) {
        $stmt->bind_param('ss', $un, $pwd);
        $stmt->execute();


        if($stmt->fetch()) {
            $stmt->close();
            return true;
        }
    }

}

}

Hope someone can help me.

Thanks in advance.

See : http://stackoverflow.com/questions/5346186/pdo-call-to-a-member-function-prepare-on-a-non-object — Roy M J, Sep 01 '13 at 09:36

score 4 · Answer 1 · edited Jun 09 '15 at 13:01

4

A constructor methods starts with double underscore. A method with a single underscore is just normal function name.

Try this:

function __construct() {
    $this->conn = new mysqli(DB_SERVER, DB_USER, DB_PASSWORD, DB_NAME) or die('There was a problem connecting to the database');
}

edited Jun 09 '15 at 13:01

Stephan Vierkant

9,674
8
61
97

answered Sep 01 '13 at 09:36

Jasmin Mistry

1,459
1
18
23

what's the difference, double underscore? – Kevin Lynch Sep 01 '13 at 10:15
it's a constructor. single underscore is just normal function name. – Jasmin Mistry Sep 01 '13 at 10:17

score 3 · Answer 2 · answered Sep 01 '13 at 09:33

3

Your construct function needs two underscores.

answered Sep 01 '13 at 09:33

Jordi Jolink

461
3
7

score 2 · Answer 3 · answered Sep 01 '13 at 09:35

2

Your constructor should say $this->conn rather than $this->$conn.

answered Sep 01 '13 at 09:35

Annika Backstrom

13,937
6
46
52

Fatal error: Call to a member function prepare() on a non-object.

3 Answers3