我在我刚买的网站上找到了这个源代码。只是想知道这个脚本是否安全?有人能给我解释一下吗?
<?php
if($_GET['map_loc']) {
$code = $_GET['map_loc'];
$result= mysql_query("SELECT ttc.continent_id, ttc.continent_id, c.name FROM territories_to_continents ttc
INNER JOIN continents c
ON ttc.continent_id = c.continent_id
WHERE ttc.code = '$code'
LIMIT 1;
");
$row = mysql_fetch_array($result);
$mapLoc = $row['name'];
}
?>发布于 2014-04-22 19:06:07
绝对不安全..。mysql_*是旧的,不应该使用。您应该使用PDO或mysqli,在下面的示例中,我演示了如何使用mysqli来完成。
<?php
if(isset($_GET['map_loc'])) {
$code = $_GET['map_loc'];
$query = "SELECT ttc.continent_id, ttc.continent_id, c.name FROM territories_to_continents ttc
INNER JOIN continents c
ON ttc.continent_id = c.continent_id
WHERE ttc.code = ?
LIMIT 1";
if($stmt = $mysqli->prepare($query)){
$stmt->bind_param('s', $code);
$stmt->execute();
$stmt->bind_result($ttc.continent_id1, $ttc.continent_id2, $mapLoc);
$stmt->fetch();
$stmt->free_result();
$stmt->close();
}
}
?>你绝对应该看看这个著名的帮助问题:How can I prevent SQL injection in PHP?
https://stackoverflow.com/questions/23227745
复制相似问题