<?php
class News_Manager {
	var $title;
	var $date;
	var $content;
	var $author;
	var $email;

	public static function findAll() {
		//Hämtar ut nyhetsdata samt författardata från databasen
		$db = new Database();  //Skapa anslutning till databasen
		$db->connectDB();
		$db->select();
		return $res = $db->getResult();
	}
	public function getTitle($args) {
		//Hämtar titel
		$this->title = $args["titel"];
		return $this->title;
	}
	public function getDate($args) {
		//Hämtar datum
		$this->date = $args["datum"];
		return $this->date;
	}
	public function getAuthor($args) {
		//Hämtar författare samt epost
		$this->date = $args["datum"];
		return $this->date;
	}
}

class Database {

	private $db_host = "127.0.0.1";
	private $db_user = "test";
	private $db_pass = "sVcvLjUVYEh93EuP";
	private $db_name = "netconsult";
	private $db_table = "nyhet";

	public function connectDB(){
		$myconn = mysql_connect($this->db_host,$this->db_user,$this->db_pass);
		if($myconn) $seldb = mysql_select_db($this->db_name,$myconn);

	}

	public function select(){
		$sql = "SELECT * FROM " . $this->db_table . " ORDER BY id DESC;";
		$query = mysql_query($sql);
        if($query)
        {
            $this->numResults = mysql_num_rows($query);
            for($i = 0; $i < $this->numResults; $i++)
            {
                $r = mysql_fetch_array($query);
                $key = array_keys($r);
                for($x = 0; $x < count($key); $x++)
                {
                    // Sanitizes keys so only alphavalues are allowed
                    if(!is_int($key[$x]))
                    {
                        if(mysql_num_rows($query) > 1)
                            $this->result[$i][$key[$x]] = $r[$key[$x]];
                        else if(mysql_num_rows($query) < 1)
                            $this->result = null;
                        else
                            $this->result[$key[$x]] = $r[$key[$x]];
                    }
                }
            }
            return true;
        }
        else
        {
            return false;
        }

	}

    public function getResult()
    {
        return $this->result;
    }
}