<?php
//FILENAME: db.class.php

class DB{

    //Fields
    public $host;
    public $user;
    public $pass;
    private $conn;

    //Methods
    //public function __construct()
    public function DB($dbhost, $dbname, $dbuser = 'root', $dbpass = '')
    {
        $this->host = $dbhost; //Gem i klasen til seneere brug
        $this->user = $dbuser;
        $this->pass = $dbpass;

        try {
            $this->conn = new PDO("mysql:host=$dbhost;dbname=$dbname", $dbuser, $dbpass);
        } catch (PDOException $e) {
            print "Error!: " . $e->getMessage() . "<br/>";
            die();
        }

    }

    public function rawQuery($sql)
    {
        $query = $this->conn->query($sql);
        return $query->fetchAll(PDO::FETCH_OBJ);
    }

    public function query($sql, $params = false)
    {
        $query = $this->conn->prepare($sql);
        if($params){
            $query->execute($params);
        } else {
            $query->execute();
        }
        return $query->fetchAll(PDO::FETCH_OBJ);
    }

    //properties

}


//Dette er en anden side, hvor klassen bruges
require_once 'db.class.php';
$db = new DB('localhost','login');

//var_dump($db->query('SELECT * FROM users'));
//$params = array(':name'=>'Admin');
foreach($db->query('SELECT * FROM users') as $user)
{
    echo '<h1>'  .$user->username . '</h1>';
}