1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55
|
function ip_per_minute()
{
global $conn;$arr = array();
$currentDateTimeP = date('Y-m-d H:i:s',time()+7);
//first query
$query="SELECT timestamp FROM event WHERE timestamp <='$currentDateTimeP' ORDER BY cid DESC LIMIT 7 ";
echo "<br>";
$stmt = $conn->prepare($query);
$stmt->execute();
$arr = array();//$i=0;
while ($row=$stmt->fetch())
{
$time=$row['timestamp'];
array_push($row,$time);
$arr[] = $row['timestamp'];
}
print_r($arr);
echo "<br>";
//return $arr;
//second query
$query2="SELECT ip_src FROM iphdr ORDER BY cid ASC LIMIT 7 ";
echo "<br>";
$stmt2 = $conn->prepare($query2);
$stmt2->execute();
$arr2 = array();//$i=0;
while ($row2=$stmt2->fetch())
{
$ip=$row2['ip_src'];
array_push($row2,$ip);
$arr2[] = $row2['ip_src'];
}
print_r($arr2);
echo "<br>";
//return $arr;
} |
Partager