Btukfyl

I need some help with my DB connection.

I've got my config.php:

namespace AppCore;





class config

{

    private $db;

    private $host;

    private $user;

    private $password;

    private $charset;

    private $opt;

    private $dsn;



    public function __construct()

    {

        $this->db = 'example';

        $this->host = '127.0.0.1';

        $this->user = 'root';

        $this->password = '';

        $this->charset = 'utf8';

        $this->dsn = "mysql:host=$this->host;DBName=$this->db;charset=$this->charset;";



        $this->opt = array(

            PDO::ATTR_ERRMODE            => PDO::ERRMODE_EXCEPTION,

            PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC,

            PDO::ATTR_EMULATE_PREPARES   => false

        );

    }



    // getters

    public function db()

    {

        return $this->db;

    }



    public function host()

    {

        return $this->host;

    }



    public function user()

    {

        return $this->user;

    }



    public function password()

    {

        return $this->password;

    }



    public function charset()

    {

        return $this->charset;

    }



    public function options()

    {

        return $this->opt;

    }



    public function dsn()

    {

        return $this->dsn;

    }

}

I chose to use a config class.

Then I do also have a DBHandler class. This is where I make my PDO connection, and probally where it goes wrong.

public function __construct()

{

    $this->config = new config();



    try {

        $this->PDO = new PDO($this->config->dsn(), $this->config->user(), $this->config->password(), $this->config->options());

    } catch (PDOException $e) {

        throw new PDOException($e->getMessage(), (int)$e->getCode());

    }

}



public static function getInstance()

{

    if (!isset(self::$instance)) {

        self::$instance = new DBHandler();

    }

    return self::$instance;

}



public function connect()

{

    return $this->PDO;

}

Then I also have a DBHelper what is basicly my CRUD class, here I write all my queries and this is the file I call in all my normal PHP files like "index.php".

Whenever I try to run a query I get an error, so I var_dumped my $db and got this error out of it:

Fatal error: Uncaught PDOException: SQLSTATE[3D000]: Invalid catalog name: 1046 No database selected in D:AppCoreDBHelper.php:28 Stack trace: #0 D:AppCoreDBHelper.php(28): PDO->prepare('SELECT * FROM u...') #1 D:AppCoreDBHelper.php(55): AppCoreDBHelper->userQuery('SELECT * FROM u...') #2 D:Appindex.php(28): AppCoreDBHelper->select('users', '*', 'userName', NULL) #3 {main} thrown in D:AppCoreDBHelper.php on line 28

Can anyone tell me where it goes wrong?