Code:

ŽANR
id, naziv

FILMOVI
id, naslov, id_zanr, godina, trajanje, slika

Code:

<?php

include ("db_connection.php");

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"];
        

//  ovdje se pocinje dogadati problemi oko uploada


        $slika           = $_FILES["file"];
        $tmp_name    = $_FILES["file"]["tmp_name"];
        $ime_slike       = $_FILES["file"]['name'];
       
      
        $ext = pathinfo($ime_slike, PATHINFO_EXTENSION);
        $new_name = 'spremljene_slike'.$ext;
       
        $path = "spremljene_slike/";
       
        $nova_slika_sa_putanjom = $path.$new_name;
       


        if (move_uploaded_file($tmp_name, $nova_slika_sa_putanjom))
        {
$query  = "INSERT INTO filmovi
                          (naslov, id_zanr, godina, trajanje, slika)
                          VALUES
                          ('$naslov', '$zanr', '$godina', '$trajanje', '$path')";
                         
        $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 'Uspješno uploadana slika';
        }
        else
        {
                echo 'Slika se nije uspjela uplodati';
}
       
       
 
}
 
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>';
               
        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 = '.$new_name.' 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>';


?>