<?php
include ("db_connection.php");
error_reporting(E_ALL ^ E_NOTICE);

if(isset($_GET["brisi"]) && $_GET["brisi"] == 1)
{
	$naslov = $_GET["naslov"];

	$query = "DELETE FROM filmovi WHERE naslov='$naslov ' LIMIT 1";
	$result = mysql_query($query);

	if($result)
	{
		//echo '<p>Film je obrisan </p>';
	}
	else
	{
		echo '<p>Pogreška kod brisanja</p>';
	}
}


if(isset($_POST["btn_save"]))

{

	$naslov      = $_POST ["naslov"];
	$zanr	 	 = $_POST ["naziv"];
	$godina   	 = $_POST ["godina"];
	$trajanje 	 = $_POST ["vrijeme_traj"];
	$slika    	 = $_POST ["file"];


	$query  = "INSERT INTO filmovi
			  (naslov, id_zanr, godina, trajanje, slika)
			  VALUES
			  ('$naslov', '$zanr', '$godina', '$trajanje', '$slika')";

	$result = mysql_query ($query) or die (mysql_error());

	if ($result)
	{


		echo 'Uspješno ste spremili podatke';
	}
	else
	{
		echo 'Došlo je do pogreške pri unosu. Pokušajte ponovno';
	}

}

echo '
	<form method="POST" action="">
	<table border="1">
	<thead>

		<tr>
			<th>Naslov:</th>
			<td><input type= "text", name="naslov" value=""/></td>
		</tr>
<tr>
			<th>Žanr:</th>
			<td><select name="naziv">
			<option value="">Odaberite žanr:</option>';

			$query  = "SELECT id, naziv
					   FROM zanr
					   ORDER BY naziv ASC";

			$result = mysql_query($query) or die(mysql_error());
			while($row = mysql_fetch_array($result))
		{
			$id_zanra  = $row["id"];
			$naziv_zanra = $row ["naziv"];
			echo '<option value="'.$id_zanra.'">'.$naziv_zanra.'</option>';
		}

	echo'
		<tr>
			<th>Godina:</th>
			<td><select name="godina">
			<option value="">Odaberite godinu:</option>';

	     for($i=1900; $i<=date("Y"); $i++)
		 {
			echo '<option value="'.$i.'">'.$i.'</option>';
		 }


	echo'
		<tr>
			<th>Trajanje:</th>
			<td><input type= "text", name="vrijeme_traj" value=""/></td>
	    </tr>';

	echo'
		<tr>
		<th>Slika:</th>
		 <td>
	    <form method="POST" action="" enctype="multipart/form-data">
	    <input type="file" name="file" value="" />
	</td>
	</tr>
</form>


		  </td>';

	echo'
		<tr>
			<th>Gumb:</th>
			<td><input type="submit" name="btn_save" value="Spremi" /></td>
	    </tr>
	</thead>
</tbody>
</form>';


echo'
<table border="1">
	<thead>
		<tr>
			<th>Slika</th>
			<th>Naslov filma</th>
			<th>Godina</th>
			<th>Trajanje</th>
			<th>Akcija</th>
		</tr>
	</thead>
	<tbody>';



	$path = "slike/";


	$query = "SELECT
			naslov, godina, trajanje, slika
			FROM filmovi
			ORDER BY naslov ASC";

	$result = mysql_query($query);

	while($row = mysql_fetch_array($result))
	{
		$slika      = $row["slika"];
		$naslov     = $row["naslov"];
		$godina     = $row["godina"];
		$trajanje   = $row["trajanje"];


	echo'

		<tr>
			<td><img src = '.$path.$slika.' alt="" width="100"></td>
			<td>'.$naslov.'</td>
			<td>'.$godina.'</td>
			<td>'.$trajanje.'</td>
			<td>
			<a href="?naslov='.$naslov.'&brisi=1" onclick="return confirm(\'Da li ste sigurni?\')">Obriši</a>
			</td>
		</tr>';

		}

	echo'
	</tbody>
</table>';





?>