Er denne funktion sikret ordentligt mod MySQL-injection?
HejsaJeg har lavet denne lille funktion til at generere insert queries. Jeg vil gerne have sikret mine queries mod MySQL injection og andre angreb. Er de forholdsregler jeg tager her nok?
<?php
function _insertQuery($val, $_table)
{
$query = "INSERT INTO ";
$column = " ".mysql_escape_string(htmlentities(strip_tags($_table)))." (";
$data = "VALUES (";
foreach ( $val as $key => $value ) {
if (strlen($key) > 0 && strlen($value) > 0)
{
$column .= " ".mysql_escape_string(htmlentities(strip_tags($key))).",";
$data .= "'".mysql_escape_string(htmlentities(strip_tags($value)))."',";
}
}
$column = rtrim($column, ",");
$data = rtrim($data, ",");
$query = $query . $column . ") " . $data . ") ";
return $query;
}
?>
Mvh
