SiteLock SQL注入& XSS扫描失败

Question

您好，我购买了SiteLock，他们说我的网站SQL注入和XSS扫描失败

SQLInjection: URL:https://www.sitename.com/product.php?id=1描述:注入点: GET；注入参数: id；注入类型:数字

XSS扫描: URL:https://www.sitename.com/product.php?id=1描述:id

我不知道怎么收集它，有人能帮我吗？

下面是我的php函数从数据库中拉出数据。

function get_products_in_cat_page(){

$query = query(" SELECT * FROM products WHERE product_category_id = " . escape_string($_GET['id']) . "  ");
confirm($query);

if(mysqli_num_rows($query) == 0) {

set_message("Will update soon the new products");

} else {

while($row = fetch_array($query)) {

$product_image = display_image($row['product_s_image1']);
$product_image2 = display_image($row['product_s_image2']);
if ($row['product_quantity'] < 1) {
    $outofstock = "<div class='sale-flash out-of-stock'>Out of Stock</div>";
} else {
    $outofstock = "";
}

$product = <<<DELIMETER

<div class="product clearfix" style="padding:8px;">
    <div class="product-image">
        <a href="product.php?id={$row['product_id']}"><img src="images/{$product_image}" alt="{$row['product_title']}" class="selected"></a>
        <a href="product.php?id={$row['product_id']}"><img src="images/{$product_image2}" alt="{$row['product_title']}"></a>
        {$outofstock}
        <div class="product-overlay">
            <a href="include/ajax/quick_view.php?id={$row['product_id']}" class="add-to-cart" data-lightbox="ajax"><i class="icon-shopping-cart"></i><span>Quick View</span></a>
            <a href="product.php?id={$row['product_id']}" class="item-view"><i class="icon-zoom-in2"></i><span> More info.</span></a>
        </div>
    </div>
    <div class="product-desc center">
        <a href="product.php?id={$row['product_id']}">
        <div class="product-title"><h3 style="font-size:15px;">{$row['product_title']}</h3></div>
        </a>
        <div class="product-price">&#36;{$row['product_price']}</div>
        <div class="product-rating">

        </div>
    </div>
</div>


DELIMETER;

echo $product;

} 
}


}

Answer 1

mysqli_real_escape_string运行得更好，但在您的示例中，将$_GET‘is’转换为integer就足够了

WHERE product_category_id = ".(int)$_GET['id']