1#@!#!123s

��JFIF�� 1#@!#!123s

: G: / PleskVhosts / par-ken.com / mahasagarseeds.com / admin /

Filename : fetch_products.php

back

<?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>';
    }
}

?>