<?php
$root = "localhost";
$username = "root";
$pass = "";
$db = "ta";
$conn = mysqli_connect($root, $username, $pass, $db);

mysqli_set_charset($conn,"utf8");

##OPEN FILE
$f = fopen("kwerendy.txt","r");
echo fread($f,filesize("kwerendy.txt"));
##END OPEN FILE

##CREATE QUERY
$zadanie1 = "select id, imie, wlasciciel from zwierzeta where rodzaj = 1;";

$z1 = mysqli_query($conn, $zadanie1);

$zadanie2 = "select id, imie, wlasciciel from zwierzeta where rodzaj = 2;";
$z2 = mysqli_query($conn, $zadanie2);

$zadanie3 = "select imie, telefon, szczepienie, opis from zwierzeta;";
$z3 = mysqli_query($conn, $zadanie3);
##END CREATE QUERY

##ZADANIE 1
	echo "<b>Zadanie. 1</b>";
	while($row=mysqli_fetch_row($z1)){
	echo "<p>$row[0]<br>$row[1]<br>$row[2]<br></p>";
}
##END ZADANIE 1

##ZADANIE 2
	echo "<b>Zadanie. 2</b>";
	while($row=mysqli_fetch_row($z2)){
	echo "<p>$row[0]<br>$row[1]<br>$row[2]<br></p>";
}
##END ZADANIE 2

##ZADANIE 3
	echo "<b>Zadanie. 3</b>";
	while($row=mysqli_fetch_row($z3)){
	echo "<p>Pacjent: $row[0]<br>Telefon właściciela: $row[1]<br>Ostatnie szczepienie: $row[2]<br>Informacje: $row[3]<br></p><hr />";
}
##END ZADANIE 3


mysqli_close($conn);
?>