<?php
	$db_host = "localhost";
	$db_name = "ict_php1";
	$db_username = "root";
	$db_password = "";

	try	{
		$pdo = new PDO("mysql:host=$db_host; dbname=$db_name", $db_username, $db_password);
		$pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
		$pdo->setAttribute(PDO::ATTR_DEFAULT_FETCH_MODE, PDO::FETCH_OBJ);

		if ($pdo) {
			$first_name = "Jadranka";
			$last_name = "Djukic";
			$email = "jadranka.djukic@ict.edu.rs";
			$password = md5("Password1");
			$insert_user_query = "INSERT INTO `user` (`first_name`, `last_name`, `email`, `password`) VALUES ('$first_name', '$last_name', '$email', '$password')";
			$pdo->query($insert_user_query);
			$user_id = $pdo->lastInsertId();
			echo $user_id;

			$select_users_query = "SELECT * FROM `user`";
			$users = $pdo->query($select_users_query);

			if ($users->rowCount() > 0) {
				foreach ($users as $user) {
					echo $user->email ."<br/>";
				}
			} else {
				echo "404 not found";
			}

			$pdo = null;
		}
	}
	catch (PDOException $e) {
		echo $e->getMessage();
	}
?>