index.php

<!DOCTYPE html>
<html lang="cs-cz">
	<head>
		<meta http-equiv="Content-Type" content="text/html; charset=UTF-8"/>
		<title>Registrace uživatele</title>
	</head>
	<body>
		<h1>Registrace uživatele</h1>
		<?php
		require_once('Db.php');
		Db::connect('localhost', 'NazevDatabaze', 'LogonName', 'Heslo');

		if ($_POST)
		{
			$datum = date("Y-m-d H:i:s", strtotime($_POST['datum_narozeni']));
			Db::query('
				INSERT INTO I2D_uzivatele (jmeno, prijmeni,	datum_narozeni, email, telefon)
				VALUES (?, ?, ?, ?, ?)
			', $_POST['jmeno'], $_POST['prijmeni'], $datum, $_POST['email'], $_POST['telefon']);
			echo('<p>Byl jste úspěšně zaregistrován.</p>');
		}

		$uzivatele = Db::queryAll('
			SELECT *
			FROM I2D_uzivatele
		');
		echo('<h2>Uživatelé</h2><table border="1">');
		foreach ($uzivatele as $u)
		{
			echo('<tr><td>' . htmlspecialchars($u['jmeno']));
			echo('</td><td>' . htmlspecialchars($u['prijmeni']));
			$datum = date("d.m.Y", strtotime($u['datum_narozeni']));
			echo('</td><td>' . htmlspecialchars($datum));
			echo('</td><td>' . htmlspecialchars($u['pocet_clanku']));
      echo('</td><td>' . htmlspecialchars($u['email']));
      echo('</td><td>' . htmlspecialchars($u['telefon']));
			echo('</td></tr>');
		}
		echo('</table>');

		?>
		<h2>Nový uživatel</h2>
		<form method="post">
			Jméno:<br />
			<input type="text" name="jmeno" required /><br />
			Příjmení:<br />
			<input type="prijemni" name="prijmeni" required/><br />
			Datum narození:<br />
			<input type="text" name="datum_narozeni" required/><br /><br />
      E-mail:<br />
      <input type="email" name="email" required/><br />
      Telefon:<br />
      <input type="tel" name="telefon" required/><br /> <br />
			<input type="submit" value="Registrovat" />
		</form>

	</body>
</html>