<?php
require('config.php');
$ang = $_POST["ang"];
$svk = $_POST["svk"];
$zaner = $_POST["zaner"];
$cas = $_POST["cas"];
$format = $_POST["format"];
$titulky = $_POST["titulky"];
$meno = $_POST["meno"];
$csfd = $_POST["csfd"];
if(!empty($_POST)) {
$ang = $_POST["ang"];
$svk = $_POST["svk"];
$zaner = $_POST["zaner"];
$cas = $_POST["cas"];
$format = $_POST["format"];
$titulky = $_POST["titulky"];
$meno = $_POST["meno"];
$csfd = $_POST["csfd"];
}else{
$query = "INSERT INTO filmy (ang, svk, zaner, cas, format, titulky, meno, csfd ) VALUES('$ang','$svk','$zaner','$cas','$format','$titulky','$meno','$csfd')";
mysql_query($query) or die(mysql_error());
echo "Pridanie do databázy prebehlo úspešne <b>$svk</b>.";
?>
<div align="center"><div id="form">
<form action="zadat.php" method="POST">
<fieldset><legend> Všetko treba vyplniť </legend>
<table width="400" border="0" align="center">
<tr>
<td width="150" align="left"><p><label>Anglický názov</label></p></td>
<td width="250" align="left"><input type='text' size='25' maxlength='50' name='ang' autocomplete="off" value="" tabindex="1" /></td>
</tr>
<tr>
<td width="150" align="left"><p><label>SK/CZ názov</label></p></td>
<td width="250" align="left"><input type="text" size="25" maxlength="50" name="svk" autocomplete="off" class="field" value="" tabindex="1" /></td>
</tr>
<tr>
<td width="150" align="left"><p><label>Žáner</label></p></td>
<td width="250" align="left"><select name="zaner" class="form" autocomplete="off">
<option value=Akcný>Akčný</option>
<option value=Komédia>Komédia</option>
<option value=Thriller>Thriller</option>
<option value=Horor>Horor</option>
<option value=Dráma>Dráma</option>
<option value=Dobrodružný>Dobrodružný</option>
<option value=Romantický>Romantický</option>
<option value=Krimi>Krimi</option>
<option value=Vojenský>Vojenský</option>
<option value=Historický>Historický</option>
<option value=Dokumentárny>Dokumentárny</option>
<option value=Western>Western</option>
<option value=Mysteriózny>Mysteriózny</option>
<option value=Sci-fi>Sci-fi</option>
<option value=Animovaný>Animovaný</option>
<option value=Fantasy>Fantasy</option>
<option value=Porno>Porno</option>
<option value=Seriál>Seriál</option>
</select></td>
</tr>
<tr>
<td width="150" align="left"><p><label>Čas</label></p></td>
<td width="250" align="left"><input type="text" size="25" maxlength="10" name="cas" autocomplete="off" class="field" value="" tabindex="1" /></td>
</tr>
<tr>
<td width="150" align="left"><p><label>Formát</label></p></td>
<td width="250" align="left"><select name="format" class="form" autocomplete="off">
<option value=XVID>XVID</option>
<option value=DVD>DVD</option>
</select></td>
</tr>
<tr>
<td width="150" align="left"><p><label>Titulky</label></p></td>
<td width="250" align="left"><select name="titulky" class="form" autocomplete="off">
<option value=nie>nie</option>
<option value=áno>áno</option>
</select></td>
</tr>
<tr>
<td width="150" align="left"><p><label>CSFD</label></p></td>
<td width="250" align="left"><input type="text" size="25" maxlength="100" name="csfd" autocomplete="off" class="field" value="" tabindex="1" /></td>
</tr>
<tr>
<td width="150" align="left"><p><label>Pridal</label></p></td>
<td width="250" align="left"><select name="meno" class="form" autocomplete="off">
<option value=vladopt>vladopt</option>
<option value=tomik>tomik</option>
<option value=mato>mato</option>
<option value=joseph>joseph</option>
</select></td>
</tr>
<tr>
<td width="150" align="left"> </td>
<td width="250" align="right"><input type="submit" value="Enter" class="submit" tabindex="4" />
</td>
</tr>
</table>
</form>
</fieldset>
</div></div>
<?php
}
?>
1. proti útokom mi to netreba zabezpečiť je to len taká sieťová db.
2. uzatvoril som to, ale robí stále to isté čo aj predtým, pridáva aj po refreshnutí a príchode na web.
3.použil som...
... neukrižuj ma iba sa učím v mysql ... vďaka za radu do mojej budúcnosti 
