<?php

/**
*
*/
class News
{

	public static function getNewsItemById($id)
	{
		$id = intval($id);
		if($id){
		$host = '';
		$dbname = '';
		$user = '';
		$password = '';

		$db = new PDO('mysql:host = $host; dbname = $dbname', $user, $password);

		var_dump($db);
		$result = $db->query('SELECT * FROM `news` WHERE `id`='.$id);

		$result = $result->fetchAll();

		print_r($result);

		$newsItem = $result->fetch();

		var_dump($newsList);
		return $newsItem;
		}
	}

	public static function getNewsList()
	{
		$host = '';
		$dbname = '';
		$user = '';
		$password = '';
		$db = new PDO("mysql:host = $host; dbname = $dbname", $user, $password);

		$newsList = array();

		$result = $db->prepare('SELECT `id`, `title`, `date`, `short_content` FROM `news` ORDER BY `date` DESC LIMIT 10');

		$i = 0;
		while ($row = $result->fetch()) {
			$newsList[$i]['$id'] = $row['$id'];
			$newsList[$i]['$date'] = $row['$date'];
			$newsList[$i]['$title'] = $row['$title'];
			$newsList[$i]['$short_content'] = $row['$short_content'];
			$i++;
			var_dump($newsList);
		}

		return $newsList;
	}

}

?>