Untitled

index.php

<!DOCTYPE HTML>

<html lang="pl">
<head>
	<meta charset="UTF-8"/>
	<meta http-equiv="X-UA-Compatible" content="IE=edge, chrome=1"/>
	<link  href="style.css" rel="stylesheet" type="text/css"/>

</head>
<body>

<h1>Lista ksiazek</h1>

<?php

		include ('baza.php');

		$tbl = $pdo->query ('SELECT * FROM `regal`');

		echo '<table border="3pxl">';
			echo '<tr>';

				echo '<th>Autor</th>';
				echo '<th>Tytul</th>';
				echo '<th>Recenzja</th>';
				echo '<th>Opcje</th>';
			echo '</tr>';


		foreach ($tbl ->fetchAll() as $value){

			echo '<tr>';

				echo '<td>' . $value[ 'autor' ] . '</td>';
				echo '<td>' . $value[ 'tytul' ] . '</td>';
				echo '<td>' . $value[ 'recenzja' ] . '</td>';
				echo '<td>' . $value[ 'id' ] . '</td>';


			echo '</tr>';

		echo '</table>';


		}

?>


</body>
</html>

baza.php

<?php

	require_once "connect.php";

	try{

	$pdo = new PDO('mysql: host='.$host.'; dbname='.$db_name.';port='.$port, $db_user, $db_password );

	 $pdo->setAttribute( PDO::ATTR_DEFAULT_FETCH_MODE, PDO::FETCH_ASSOC );


	} catch(PDOException $e){
		echo 'Polaczenie nie moglo zostac utworzone <br/>';
	}


?>

connect.php

<?php

	$host = "localhost";
	$db_user = "root";
	$db_password = "";
	$db_name = "ksiazki";
	$port="";

?>