if(isset($_POST["getProduct"])){
    if ($stmt = $con->prepare ("SELECT * FROM products WHERE 'product_id'=? AND 'product_cat'=? AND 'product_brand'=? AND 'product_title'=? AND 'product_price'=? AND 'product_desc'=? AND 'product_image'=? AND 'product_keywords'=? AND 'product_subdesc'=? ORDER BY RAND() LIMIT 0,6")){

    $pid= "product_id";
    $pcat= "product_cat";
    $pbrand = "product_brand";
    $ptitle = "product_title";
    $pprice = "product_price";
    $pdesc = "product_desc";
    $pimage = "product_image";
    $pkeywords = "product_keywords";
    $psubdesc = "product_subdesc";

    $stmt->bind_param("iiisissss", $pid, $pcat, $pbrand, $ptitle, $pprice, $pdesc, $pimage, $pkeywords, $psubdesc);
    $stmt->execute();
    $stmt->bind_result($pid, $pcat, $pbrand, $ptitle, $pprice, $pdesc, $pimage, $pkeywords, $psubdesc);

    while ($stmt->fetch()) {