<?php
error_reporting(E_ALL);

class Db
{
	const host  = 'localhost';
	const user = 'root';
	const password = '';
	const db = 'db_realty';


	public static function connect_db()
	{
		$link = mysqli_connect(self::host, self::user, self::password, self::db);

		/* проверка соединения */
		if (mysqli_connect_errno())
		{
			printf("Не удалось подключиться: %s\n", mysqli_connect_error());
			exit();
			return;
		}

		/* изменение набора символов на utf8 */
		if (!mysqli_set_charset($link, "utf8"))
		{
			printf("Ошибка при загрузке набора символов utf8: %s\n", mysqli_error($link));
			exit();
			return;
		}
		return $link;
	}
}

class Get_All_Object
{
	public static function get_all_object($link)
	{
		$sql = "SELECT `realty`.`id` ,`realty_type`.`type`, `realty`.`title`, `realty`.`address`, `realty`.`price` FROM `realty` LEFT JOIN `realty_type` ON realty.type_id = realty_type.type_id";
		$res = mysqli_query($link, $sql) or die(mysqli_error($link));

		while ($row = mysqli_fetch_assoc($res))
		{
			$realty[] = $row;
		}
		return $realty;
	}
}

$link = Db::connect_db();
$realty = Get_All_Object::get_all_object($link);
?>

	<table style="border-collapse: collapse; width: 60%">
    <thead>
        <tr>
            <th style="border: 1px solid black;">Тип</th>
            <th style="border: 1px solid black;">Недвижимость</th>
            <th style="border: 1px solid black;">Адрес</th>
            <th style="border: 1px solid black;">Цена</th>
            <th style="border: 1px solid black;"></th>
        </tr>
    </thead>
    <tbody>
	<?
	foreach($realty as $key => $massiv)
	{
	?>
	<tr>
		<td style="border: 1px solid black;">
			<?echo $realty[$key]['type'];?>
		</td>
		<td style="border: 1px solid black;">
			<?echo $realty[$key]['title'];?>
		</td>
		<td style="border: 1px solid black;">
			<?echo $realty[$key]['address'];?>
		</td>
		<td style="border: 1px solid black;">
			<?echo $realty[$key]['price'];?>
		</td>
		<td style="border: 1px solid black;">
			<a href = "view.php?id=<?=$realty[$key]['id']?>">подробнее</a>
		</td>
	</tr>
	<?
	}
	?>