createProductProcess.php

<?php
    include "connection.php";
    session_start();    
    $product_name = $_POST['product_name'];
    $product_pict = $_FILES['product_pict']['name'];
    $category_code = $_POST['category_code'];
    $unit_price = $_POST['unit_price'];
    $product_stock = $_POST['product_stock'];
    $vendor_id = $_SESSION['user_id'];
    $product_desc = $_POST['product_desc'];    
    
    $target_path="uploads/product_pict/";
    $target_path = $target_path . basename($product_pict);

    move_uploaded_file($_FILES['product_pict']['tmp_name'], $target_path);    

    $query = "INSERT INTO products (product_name, product_pict, category_code, unit_price, product_stock, vendor_id, product_desc) VALUES
                ('$product_name', '$product_pict', '$category_code', $unit_price, $product_stock, $vendor_id, '$product_desc')";
    
    if (mysqli_query($connect, $query)) {                     
        echo "<script>alert('Alhamdulillah udah bisa'); window.location.href='homeVendor.php'</script>";
    } else {        
        echo mysqli_error($connect);
        //echo "<script>alert('Gaiso su." .  mysqli_error($connect) . "'); window.location.href='createProduct.html'</script>";
    }
?>