function testArray($array)
{
foreach ($array as $name => $value) {
if (is_array($value) === true) {
testArray($value);
} else {
return testHelper($value);
}
}
}
<?php
require_once 'DetectInjection.php';
$get = testArray($_GET);
$post = testArray($_POST);
$cookie = testArray($_COOKIE);
$query = $_GET['query'];
$logfile = 'log.log';
//file_put_contents($logfile, '\n QUERY: ' . $query, FILE_APPEND | LOCK_EX);
$conn_string = "";
$conn = pg_connect($conn_string);
if (!$conn) {
echo "An error occurred.\n";
exit;
}
if ($get > 0 || $post > 0 || $cookie > 0) {
$data[] = 'SQL Attack attempt detected';
$data[] = 'Aborting operation';
} else {
preg_match('/(limit)\\s\\d(((\\,\\s)|(\\s\\,\\s)|(\\s\\,))\\d)?/i', $query, $matches);
//1
if (!$matches) {
$query = $query . ' limit 1000';
}
$result = pg_query($conn, $query);
$data = array();
while ($row = pg_fetch_row($result)) {
$data[] = $row;
}
}
//file_put_contents($logfile, '\n data lenght: ' . count($data), FILE_APPEND | LOCK_EX);