[ciapug] classes

[carl-olsen at mchsi.com]

Here is my database class:

abstract class DB
{
	protected $conn;
	public function __construct()
	{
		$host = "host";
		$user = "user";
		$password = "password";
		$dbname = "dbname";
		$this->conn = new mysqli($host, $user, $password, $dbname);
		if(mysqli_connect_errno())
		{
			throw new Exception("Unable to connect to the server: " . mysqli_connect_error());
		}
	}
	public function __destruct()
	{
		if($this->conn)
		{
			$this->conn->close();
		}
	}
}

Here is my photo class:

require_once('class.DB.php');
final class Photo extends DB
{
	public function __construct()
	{
		parent::__construct();
	}
	public function photo($id)
	{
	}
	public function photos($gallery_id)
	{
	}
	public function insert($gallery_id,$photo_name,$photo_order)
	{
	}
	public function update($gallery,$photo_id)
	{
	}
	public function delete($photo_id)
	{
	}
	public function sort($photo_order,$photo_id)
	{
	}
	public function __destruct()
	{
		parent::__destruct();
	}
}