<?php
$host='mysql.hostinger.ru';
$db='u884898754_daym';
$user='u884898754_302';
$pass='20061971';
$dsn = "mysql:host=$host;dbname=$db";
$opt = array(
    PDO::ATTR_ERRMODE            => PDO::ERRMODE_EXCEPTION,
    PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC
);
$pdo = new PDO($dsn, $user, $pass, $opt);



echo "<form method='GET' action='index.php'><input type='submit' name='student' value='Вывод студентов'></input></form>";


if(isset($_GET['student']))
{
	$f1 = $pdo -> Query("select Imya as Имя, Familiya as Фамилия, Otchestvo as Отчество, Pol as Пол, Sem_pol as Семейное положение from students");

	echo "<table cellpadding=4 cellspacing=1 border=1 style=\"border-collapse: collapse; border: 1px thin black;\"";
	echo "<tr><td>Имя</td>  <td>Фамилия</td>  <td>Отчество</td>  <td>Пол</td>  <td>Год</td>  <td>Страна</td></tr>";
	while($f1content = $f1 -> fetch(PDO::FETCH_ASSOC))
	{


		echo "<tr><td>".$f1content['Имя']."</td><td>".$f1content['Фамилия']."</td><td>".$f1content['Отчество']."</td><td>".$f1content['Пол']."</td><td>".$f1content['Семейное положение']."</td><td>";
	}
	echo "</table><br>";
}