<?php
include 'connection.php'; // Include your database connection

if(isset($_POST['category'])) {
    $category = mysqli_real_escape_string($conn, $_POST['category']);

    // Fetch products based on selected category
    $query = "SELECT id, title FROM productpage WHERE category = '$category'";
    $result = mysqli_query($conn, $query);

    echo '<option value="">Select Product</option>';
    while ($row = mysqli_fetch_assoc($result)) {
        echo '<option value="'.$row['id'].'">'.$row['title'].'</option>';
    }
}

?>
