OK, normally I do not respond to my own posts, but I have been shown that I
did not get the whole script. So here it is:
for ($i=0; $i<$number_of_alerts; $i++) {
// Split each line
$line = explode(" ", $ipfwlog[$i]);
$line[1] = intval($line[1]);
$IPFWsql = "INSERT INTO Firewall_Logs (month, date, time, fw_name, kernel,
fw_engine, rule_number, action, protocol, src_ip_port, dst_ip_port,
direction, via, interface) VALUES ('$line[0]', '$line[1]', '$line[2]',
'$line[3]', '$line[4]', '$line[5]', '$line[6]','$line[7]', '$line[8]',
'$line[9]', '$line[10]', '$line[11]', '$line[12]')";
$results = mysql_query($IPFWsql) or die ("Could not execute query");
}
Again, any help with this issue is appreciated.
Thanks,
Ron Clark
"Ron Clark" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Hello all,
>
> I have a php script that reads a flat text file with fields seperated by a
> space. I explode them into an array just fine, but when I try then to load
> that array into a mysql database, it doesn't work. Here is my script:
>
> for ($i=0; $i<$number_of_alerts; $i++) {
> // Split each line
> $line = explode(" ", $ipfwlog[$i]);
>
> $line[1] = intval($line[1]);
>
> $IPFWsql = "INSERT INTO Firewall_Logs (month, date, time, fw_name, kernel,
> fw_engine, rule_number, action, protocol, src
> $results = mysql_query($IPFWsql) or die ("Could not execute query");
>
> }
>
> Any ideas why this does not work? I am completely stuck.
>
> Thanks in advance,
> RonC
>
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
