Call to undefined method DB::quote()

Question

I get an error when i go to index.php:

Fatal error: Call to undefined method DB::quote() in C:\xampp\htdocs\barafranca.nl\config\main_functions.php on line 10

The weird thing is that when i test this (php code on index.php) in the main_functions.php everything works as it should. But when include main_functions.php on my index.php page, and use the getAccountQuery function, it can't find the methhods of my Db() object anymore.

PHP_VERSION: 5.5.30.

Db.php:

<?php 
class Db {
    // The database connection
    protected static $connection;

    /**
     * Connect to the database
     * 
     * 
     */
    public function connect() {    
        // Try and connect to the database
        if(!isset(self::$connection)) {
            self::$connection = mysqli_connect('localhost', 'root', '', 'bfr');
        }

        // If connection was not successful, handle the error
        if(self::$connection === false) {
            // Handle error - notify administrator, log to a file, show an error screen, etc.
            //return false;
            return mysqli_connect_error();
        }
        return self::$connection;
    }

    /**
     * Query the database
     *
     * @param $query The query string
     * @return mixed The result of the mysqli::query() function
     */
    public function query($query) {
        // Connect to the database
        $connection = $this -> connect();

        // Query the database
        $result = $connection -> query($query);

        return $result;
    }

    /**
     * Fetch rows from the database (SELECT query)
     *
     * @param $query The query string
     * @return bool False on failure / array Database rows on success
     */
    public function select($query) {
        $rows = array();
        $result = $this -> query($query);
        if($result === false) {
            return false;
        }
        while ($row = $result -> fetch_assoc()) {
            $rows[] = $row;
        }
        return $rows;
    }

    /**
     * Fetch the last error from the database
     * 
     * @return string Database error message
     */
    public function error() {
        $connection = $this -> connect();
        return $connection -> error;
    }

    /**
     * Quote and escape value for use in a database query
     *
     * @param string $value The value to be quoted and escaped
     * @return string The quoted and escaped string
     */
    public function quote($value) {
        $connection = $this -> connect();
        return "'" . $connection -> real_escape_string($value) . "'";
    }
}
?>

main_functions.php

<?php
include("Db.php");

function getAccountQuery($username)
{
    // Database object
    $db = new Db();    

    // Quote and escape parameter value
    $username = $db -> quote($username);
    $sql = "SELECT * FROM `users` WHERE username=". $username;
    $result = $db -> select($sql);

    // If result matched $username, table row must be 1 row

    if(!empty($result)) 
    {
        echo "NOT EMPTY";
        return $result[0];
    }else {
        return null;
    }
}

function getOnlineUsersCount($con)
{
    $usersOnlineNow = $con->query("SELECT * FROM users WHERE online >= NOW()-500");
    return $usersOnlineNow->num_rows;
}
?>

index.php

<?php
include("config/config.php");
include("config/main_functions.php");

session_start();

$test = getAccountQuery("Nick");
echo $test;

?>

config.php

<?php
$siteName = "CrimeGame";
$siteDomain = "CrimeGame.nl";
$siteMail = "admin@CrimeGame.nl";
?>

DIRECTORY INFO:

I haven't included it because it is out of scope, but i will add it then ;) — NickGames, Aug 04 '16 at 12:17
Am I the only one who finds it weird that the error mentions `DB` while the class name is `Db` ? — apokryfos, Aug 04 '16 at 12:17
and funny enough for you to mention *"is out of scope"*. Could be a variable scope issue here. — Funk Forty Niner, Aug 04 '16 at 12:17
It is really weird indeed that the error sais DB. I copied everything here so there could be no typo or something :O — NickGames, Aug 04 '16 at 12:19
@NickGames You said earlier that `quote()` should be automatically quoting that string and you're doing `WHERE username=". $username` - what does var_dump reveal for that query? — Funk Forty Niner, Aug 04 '16 at 12:20
The point is there's nothing wrong with the query, because when i put the piece of code (that is currently on the index.php page) on the main_functions.php page outside the function, everything workst as it should. — NickGames, Aug 04 '16 at 12:24
*"outside the function"* ...then it's a variable scope as I said earlier. Here http://stackoverflow.com/questions/16959576/reference-what-is-variable-scope-which-variables-are-accessible-from-where-and - @NickGames — Funk Forty Niner, Aug 04 '16 at 12:25
not a fix but you should always use session_start() once at the first line of your PHP page, or put it in config.php — Sjoerd de Wit, Aug 04 '16 at 12:26
@NickGames You need to check that link I gave you above where I edited and added http://stackoverflow.com/questions/16959576/reference-what-is-variable-scope-which-variables-are-accessible-from-where-and — Funk Forty Niner, Aug 04 '16 at 12:26
@SjoerddeWit : Why `session_start()` ? He didn't used anywhere session in code. — Nana Partykar, Aug 04 '16 at 12:27
You're right it is best practice to put the session_start at line 1, did that now, thank you but it didn't have any effect on my problem — NickGames, Aug 04 '16 at 12:28
`session_start` is used only when you have session variables, so that you dont lose their value....why should he use it here — Luthando Ntsekwa, Aug 04 '16 at 12:28
but it is declared in index.php just not as the first line, which is bad practice. — Sjoerd de Wit, Aug 04 '16 at 12:29
[Remember this earlier?](http://stackoverflow.com/questions/38766993/call-to-undefined-method-dbquote#comment64905325_38766993) I had a feeling that was it. *"Spidey sense"* — Funk Forty Niner, Aug 04 '16 at 12:29

Call to undefined method DB::quote()

0 Answers0