<?php

include "../database.php";

$sql_bacheca    = "SELECT * FROM bacheca ORDER BY id DESC LIMIT 1";
$result_bacheca = mysqli_query($con, $sql_bacheca);
$bacheca        = mysqli_fetch_assoc($result_bacheca);

for ($i = 0; $i < 10; $i++) {
    if (isset($_FILES['file' . $i]['name'])) {
        $filename = $_FILES['file' . $i]['name'];
        $location = "../../../attachments/Pub-" . $bacheca['id'] . "_" . $filename;
        $extension = pathinfo($location, PATHINFO_EXTENSION);
        $extension = strtolower($extension);
        $response = array();
        $status   = 0;

        if (move_uploaded_file($_FILES['file' . $i]['tmp_name'], $location)) {

            $status                = 1;
            $response['path']      = $location;
            $response['extension'] = $extension;

            $sql_insert = "INSERT INTO bacheca_attachments VALUES (NULL," . $bacheca['id'] . ",'Pub-" . $bacheca['id'] . "_" . $filename . "','" . $_FILES['file' . $i]['type'] . "','" . $_FILES['file' . $i]['size'] . "')";
            $con->query($sql_insert);
        }
        $response['status'] = $status;
    }
}

echo json_encode($response);
exit;
echo 0;