eian@php

hi to all... does anybody has an idea of parsing the filename of the textfile and its contents and insert to database.. example.. format of the filename: [date] [cod] [time] 201089 1-111 93300.txt contents of the text file: 12345 John Robinson 54321 Robert svenson the table where the information should be inserted has this fields.. name of table: logs [iD] [name] [date] [time] say for example the parsing is done..it should look like this. [iD] [name] [date] [code] [time] 12345 John Robinson 2010-8-9 1-111 9:33:00 54321 Robert Svenson 2010-8-9 1-111 9:33:000 how can i do that?? can somebody help me? thanks.

PROBLEM SOLVED SIR! I go through the code and it now looks like this: <?php mysql_connect("localhost","root",""); mysql_select_db("personss"); $textFileName = $_POST['textFileName']; $myFile = "$textFileName"; $fh = fopen($myFile, 'r'); $theData = fread($fh, filesize($myFile)); fclose($fh); $person = explode("\r\n", $theData); $count = 0; foreach($person as $i => $line) { $nameParts = explode(" ", $line); $q = "insert into logged (btaddress, btname, logtime, date, subjectCode) values ('" . implode("','",$nameParts) . "')"; $rw = mysql_query($q) or die("Problem with the query: $q<br>" . mysql_error()); $nameParts = explode("", $line); $count++; } ?>

Hi to all!! I am still new to php.. I need help in reading my text file and inserting it to mysql database. My text file contains 5 fields and has several rows.. The format of my text file: 1 romeo 8877 2010-07-07 abc1 2 nick 7686 2010-07-07 abc2 3 mark 5456 2010-07-07 abc3 4 karm 3432 2010-07-07 abc4 The first field is an INTEGER, the second third fifth fields are VARCHAR and the fourth field is a DATE. I am having trouble with my php code.. My code is this: <?php mysql_connect("localhost","root",""); mysql_select_db("personss"); $textFileName = $_POST['textFileName']; $myFile = "$textFileName"; $fh = fopen($myFile, 'r'); $theData = fread($fh, filesize($myFile)); fclose($fh); $person = explode("\n", $theData); $count = 0; foreach($person as $i => $line) { $nameParts = explode(" ", $person[$count]); $q = "insert into logged (id, name, num, datess, letters) values ('" . implode("','",$nameParts) . "')"; $rw = mysql_query($q) or die("Problem with the query: $q<br>" . mysql_error()); } ?> This code can insert to the database but it only inserts the first row and it loops the insert according to how many rows there are in the text file..For example in my text file there are are 4 rows, it inserts the first row: 1 romeo 8877 2010-07-07 abc1 4times..If there are 6 rows, 6 times the first row will also be inserted.. What i need Sir's is that i need to be able to insert the rows line by line.. if there are 4 rows, i need to insert them all in the database.. Please help me to fix the code.