<?php

$ime = $_POST["ime"];
$godina_produkcije = $_POST["godina_produkcije"];
$ocjena = $_POST["ocjena"];

$servername = "127.0.0.1";
$username = "root";
$password = "";

// Create connection
$conn = mysqli_connect($servername, $username, $password);

// Check connection
if (!$conn) {
    die("Connection failed: " . mysqli_connect_error());
}
echo "Connected successfully";

// Create database
$sql = "CREATE DATABASE kino";
if (mysqli_query($conn, $sql)) {
    echo "Database created successfully";
} else {
    echo "Error creating database: " . mysqli_error($conn);
}

// Odabir baze
mysqli_select_db($conn, "kino");

// sql to create table
$sql = "CREATE TABLE filmovi (
id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
ime VARCHAR(15) NOT NULL,
godina_produkcije VARCHAR(4) NOT NULL,
ocjena FLOAT
)";

if (mysqli_query($conn, $sql)) {
    echo "Table filmovi created successfully";
} else {
    echo "Error creating table: " . mysqli_error($conn);
}

// Insert data
$sql = "INSERT INTO filmovi (ime, godina_produkcije, ocjena)
VALUES ('$ime', '$godina_produkcije', '$ocjena')";

if (mysqli_query($conn, $sql)) {
    echo "New record created successfully";
} else {
    echo "Error: " . $sql . "<br>" . mysqli_error($conn);
}

// Select data
$sql = "SELECT ime, godina_produkcije FROM filmovi WHERE godina_produkcije < 1987";
$result = mysqli_query($conn, $sql);

if (mysqli_num_rows($result) > 0) {
    // output data of each row
    while($row = mysqli_fetch_assoc($result)) {
        echo "Ime filma: " . $row["ime"]. " - " . $row["godina_produkcije"]. "<br>";
    }
} else {
    echo "0 results";
}

// sql to delete a record
$sql = "DELETE FROM filmovi WHERE godina_produkcije = 1991";

if (mysqli_query($conn, $sql)) {
    echo "Record deleted successfully";
} else {
    echo "Error deleting record: " . mysqli_error($conn);
}

// Select data
$sql = "UPDATE filmovi SET ocjena='10' WHERE ocjena=1";

if (mysqli_query($conn, $sql)) {
    echo "Record updated successfully";
} else {
    echo "Error updating record: " . mysqli_error($conn);
}

mysqli_close($conn);
?>