i have some problems with my log file. i want to get some data from my log file. here is my log file

192.168.0.2 - - [14/Dec/2008:23:22:51 +0700] "GET /favicon.ico HTTP/1.1" 404 287 "-" "Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.8.0.7) Gecko/20061011 Fedora/1.5.0.7-7.fc6 Firefox/1.5.0.7"

192.168.0.2 - - [14/Dec/2008:23:22:58 +0700] "GET /icons/powered_by_fedora.png HTTP/1.1" 200 3034 "http://www.fedora.net.id/" "Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.8.0.7) Gecko/20061011 Fedora/1.5.0.7-7.fc6 Firefox/1.5.0.7"

192.168.0.2 - - [14/Dec/2008:23:22:58 +0700] "GET /icons/apache_pb2.gif HTTP/1.1" 200 2414 "http://www.fedora.net.id/" "Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.8.0.7) Gecko/20061011 Fedora/1.5.0.7-7.fc6 Firefox/1.5.0.7"

192.168.0.2 - - [14/Dec/2008:23:22:58 +0700] "GET / HTTP/1.1" 403 3956 "-" "Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.8.0.7) Gecko/20061011 Fedora/1.5.0.7-7.fc6 Firefox/1.5.0.7"

192.168.0.2 - - [14/Dec/2008:23:22:58 +0700] "GET /favicon.ico HTTP/1.1" 404 291 "-" "Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.8.0.7) Gecko/20061011 Fedora/1.5.0.7-7.fc6 Firefox/1.5.0.7"

i want to get the bold data. can anybody help me?

    You might be able to use say, [man]preg_match_all/man for this.

      laserlight;10897313 wrote:

      You might be able to use say, [man]preg_match_all/man for this.

      i try like this

      <?php //-- 
$host = 'localhost';
$user = 'root';
$pass = 'mysql';
$mydb = 'layanan_server';
$conn = mysql_connect("$host","$user","$pass");
$db_con = mysql_select_db($mydb,$conn);


function parsingThenInputIntoDB($kalimat){ 
     $result=explode(" ",$kalimat); 
     $ip=$result[6]; 
     $tanggal = $result[2];
     $bulan = $result[1];
     $tahun = $result[4];

 mysql_query("INSERT INTO ftp(ip,tanggal,bulan,tahun) VALUES('$ip','$tanggal','$bulan','$tahun')"); 
} 

$kalimat2 = file('ftp.txt'); 

foreach($kalimat2 as $kalimat) 
parsingThenInputIntoDB($kalimat);
?>
        Write a Reply...