if (isset($_GET['product_id'])) {
    $the_product_id = mysqli_real_escape_string($connection, $_GET['product_id']);
}

$query = "SELECT * FROM products WHERE product_id = {$the_product_id} AND product_status = 'published'";
            $select_breadcrumb = mysqli_query($connection, $query);

            while ($row = mysqli_fetch_assoc($select_breadcrumb)) {
                $product_id = $row['product_id'];
}