Billed upload inkluderet i nuværede form.

tbl_user
id
firstname
lastname

tbl_img
id
name

tbl_map_user_img
id
user_id
img_id

 
tbl_user
id
firstname
lastname

tbl_img
id
name
user_id

CREATE TABLE `katinka_produkter` (
  `id` int(99) NOT NULL,
  `p_navn` varchar(99) COLLATE utf8_danish_ci DEFAULT NULL,
  `p_undertekst` varchar(99) COLLATE utf8_danish_ci DEFAULT NULL,
  `p_beskrivelse` text COLLATE utf8_danish_ci,
  `p_pris` int(99) DEFAULT NULL,
  `p_startdato` date DEFAULT NULL,
  `p_slutdato` date DEFAULT NULL,
  `p_billedlink` varchar(255) COLLATE utf8_danish_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_danish_ci;

CREATE TABLE `katinka_produkter_url` (
  `id` int(11) NOT NULL,
  `url` varchar(255) COLLATE utf8_danish_ci NOT NULL,
  `produkt_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_danish_ci;

ALTER TABLE `katinka_produkter`
  ADD PRIMARY KEY (`id`);

ALTER TABLE `katinka_produkter_url`
  ADD PRIMARY KEY (`id`);

ALTER TABLE `katinka_produkter`
  MODIFY `id` int(99) NOT NULL AUTO_INCREMENT;

ALTER TABLE `katinka_produkter_url`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

 
<?php
if (isset($_POST['opret'])) {
    $p_navn = $_POST['p_navn'];
    $p_undertekst = $_POST['p_undertekst'];
    $p_beskrivelse = $_POST['p_beskrivelse'];
    $sql = "INSERT INTO `Batinka_produkter` (`p_navn`, `p_undertekst`, `p_beskrivelse`) VALUES ('$p_navn', '$p_undertekst', '$p_beskrivelse')";

    // mysqli_query($conn, $sql);
    $conn->query($sql);

    //$product_id = mysqli_insert_id($conn);
    $product_id = $conn->insert_id;

    if ($product_id > 0) {
        // så er produktet indsat, så skal vi bare læse arrayet af billeder igennem
        $target_dir = "uploads/";
        $billedurl = $_FILES['billedurl'];
        $lng = count($billedurl['name']);
        $images_names_array = array();
        for ($i = 0; $i < $lng; $i++) {
            if ($billedurl['error'][$i] == 0) {
                $tmp_name = $billedurl['tmp_name'][$i];
                $image_name = $target_dir . "" . $billedurl['name'][$i];
                $sql = "INSERT INTO `katinka_produkter_url` (`url`, `produkt_id`) VALUES ('$image_name', $product_id)";
                $conn->query($sql);

                move_uploaded_file($tmp_name, $image_name);
            }
        }
    }
}
?>
Opret et produkt:<br><br>
<form method="post" action="<?php echo $_SERVER['PHP_SELF']; ?>" enctype="multipart/form-data">
    Produktnavn: <input type="text" name="p_navn"><br>
    Produkt undertekst: <input type="text" name="p_undertekst"><br>
    Produkt beskrivelse: <input type="text" name="p_beskrivelse"><br>
    Billed 1:<input type="file" name="billedurl[]"><br>
    Billed 2:<input type="file" name="billedurl[]"><br>
    Billed 3:<input type="file" name="billedurl[]"><br>
    Billed 4:<input type="file" name="billedurl[]"><br>
    Billed 5:<input type="file" name="billedurl[]"><br>
    <input type="submit" name="opret" value="Opret Produkt">
</form>