Job.php


<?php
	class Job{
		private $db;

		public function __construct(){
			$this->db = new Database;
		}

		//Get all jobs
		public function getAllJobs(){
			$this->db->query("SELECT jobs.*, categories.name AS cname FROM jobs
				INNER JOIN categories
				ON jobs.category_id = categories.id
				ORDER BY post_date DESC
				");
		//assign result set
		$results = $this->db->resultSet();

		return $results;
		}
	}
?>


Database.php<?php
class Database{
	private $host = DB_HOST;
	private $user = DB_USER;
	private $pass = DB_PASS;
	private $dbname = DB_NAME;

	private $dbh;
	private $err;
	private $stmt;

	public function __construct(){
		//Set DSN
		$dsn = 'mysql:host' . $this->host . ';dbname=' . $this->dbname;

		//set options
		$options = array(
			PDO::ATTR_PERSISTENT => true,
			PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION
		);

		//PDO Instance

		try{
			$this->dbh = new PDO($dsn, $this->user, $this->pass, $options);
		}catch(PDOException $e) {
			$this->error = $e->getMessage();
		}
	}

	public function query($query){
		$this->stmt = $this->dbh->prepare($query);
	}

	public function bind($param,$value,$type = null){
		if(is_null($type)){
			switch(true){
				case is_int ($value):
				$type = PDO::PARAM_INT;
				break;

				case is_bool ($value) :
				$type = PDO::PARAM_BOOL;
				break;

				case is_null ($value):
				$type = PDO::PARAM_NULL;
				break;
				default:
					$type = PDO::PARAM_STR;
			}
		}
		$this->stmt->bindValue($param,$value,$type);
	}

	public function execute(){
		return $this->stmt->execute();
	}

	public function resultSet(){
		$this->execute();
		return $this->stmt->fetchAll(PDO::FETCH_OBJ);
	}

	public function single(){
		$this->execute();
		return $this->stmt->fetchAll(PDO::FETCH_OBJ);
	}
}