DB class wont load

Question

I'm trying to connect using a simle db class. For some reason it only print out "Initiate DB class"

test.php

include 'db.class.php';
echo 'Initiate DB class';
$db = new DB();
echo 'DB class did load';

db.class.php

class DB extends mysqli {
private static $instance = null;
private function __construct () {
    parent::init();
    $host = 'localhost'; 
    $user = 'root'; 
    $pass = 'MY_PASS';
    $dbse = 'MY_DB';
    parent::real_connect($host, $user, $pass, $dbse);
    if (0 !== $this->connect_errno):
        die('MySQL Error: '. mysqli_connect_error());
        //throw new Exception('MySQL Error: '. mysqli_connect_error());
    endif;
    }
    public function fetch ($sql, $id = null, $one = false) {
        $retval = array();
        if ($res = $this->query($sql)):
            $index = 0;
            while ($rs = $res->fetch_assoc()):
                if ($one):
                    $retval = $rs; break;
                else:
                    $retval[$id ? $rs[$id] : $index++] = $rs;
                endif;
            endwhile;
            $res->close();
        endif;
        return $retval;
    }

}

I have tried to search my log files for error but they come out empty.

Might consider that as well. But right now I'm just trying to find what I do wrong here. — Andreas
Add this to the top of your script ini_set('display_errors', '1'); error_reporting(E_ALL); and run it again. That should (hopefully) print out any errors. — Josh J

Y.Hermes Y.Hermes · Accepted Answer · 2015-10-08T14:32:13

Try this:

Db_class:

class Db_class{
/***********************CONNECT TO DB*********************/
public function db_connect(){
    $user       = '***';
    $db         = '***';
    $password   = '***';
    $host       = '***';

    try {
        $dbh = new PDO("mysql:host=$host;dbname=$db", $user, $password);
    }
    catch(PDOException $err) {
        echo "Error: ".$err->getMessage()."<br/>";
        die();
    }
    return $dbh;
}
/******************PREPARE AND EXECUTE SQL STATEMENTS*****/
public function query($statement){
    $keyword = substr(strtoupper($statement), 0, strpos($statement, " "));
    $dbh = $this->db_connect();     
    if($dbh){
        try{
            $sql = $dbh->prepare($statement);
            $exe = $sql->execute();
        }
        catch(PDOException $err){
            return $err->getMessage();
        }
        switch($keyword){
            case "SELECT": 
                $result = array();
                while($row = $sql->fetch(PDO::FETCH_ASSOC)){
                    $result[] = $row;
                }
                return $result;
                break;
            default: 
                return $exe;
                break;
        }
    }
    else{
        return false;
    }
}

Other PHP:

    $db = new Db_class();

    $sql = "SQL STATEMENT";
    $result = $db->query($sql);

DB class wont load

3 Answers