only uploading 1 line from file problem!

trendMM

I'm currently working on a php upload script where the user uploads a text file exported from excel. They input multiple products into it and then upload the txt file to the server when they're done. I have it TRUNCATE the table everytime so the DB is emptied when the file is upload. That way the file and the website run inline with each other. No onto my problem. For some reason it's only taking the first line thats inside the text file and not taking the other rows. I don't know if I made an error and for some reason it's not looping through to get the 2nd row and so on but if someone could please look at my code and let me know what's wrong with it that'd be great. Thanks in advance!

<?

break;
case  "force_import":

$hmm = $_REQUEST['upfile'];

$uploaddir = '/home/xxxx/www/nhr/cms/upload/';
$uploadfile = $uploaddir . basename($_FILES['upfile']['name']);

if (move_uploaded_file($_FILES['upfile']['tmp_name'], $uploadfile)) {
 $upstatus = "File was successfully uploaded.";
} else {
 $upstatus = "File was not uploaded. Please try again.";
}

// Include config file
include('common.php');

$link = dbConnect();

$query = "TRUNCATE TABLE training";
$result = mysql_query($query);

if (!$result) {
fail ("Error querying database");
}

// Fetch the current time
$posted = time();

$lines = file ($uploadfile);

 foreach ($lines as $line_num => $line) 

 { 

$pieces = explode("|",  $line);

$query = "INSERT INTO training (title, lprice, wprice, image, features, audio, oview, compat, posted) 
          VALUES('$pieces[0]', '$pieces[1]', '$pieces[2]', '$pieces[3]', '$pieces[4]', '$pieces[5]', '$pieces[6]', '$pieces[7]', $posted)"; 

// Execute Query 
$result = @mysql_query($query) or die ("Error: $query" . mysql_error()); 


}

?>

Installer

What do you get with

echo nl2br(file_get_contents($uploadfile));

trendMM

Wierd, for some reason it's not realizing that there is a new line in the file for another product and it's adding the first column of the new row to the last column of the first row. So the problem all along is that it's not picking up more than one line or anything like that. Any ideas on what I can do? For an output of what I'm talking about check out this link...

http://www.evanbartlett.com/nhr/

If you notice in the Compatibility section that there is a product title at the very end of the section. Compat is the last column within the excel file and title is the first. That's what I'm talking about. I don't think its more of a php problem than an excel problem because I've done Excel PHP before and am using the same excel file.

Any help would be greatly appreciated!

Thanks in advance!

Installer

I suggested the above code to check two possibilities:
- the client side is not adding a newline to the end of each row, or
- the client side is uploading only one row.

It looks like the first is more likely, although I can't say for sure that that's your problem--just that it's a possibility. Adding the code I suggested should confirm it or rule it out.

trendMM

yeah i checked the file that excel is outputting and its looking like its not creating a newline for every row for some reason and its just putting them all in the same line, therefore php isn't processing it how i need. i guess i'll try and fix the excel output code and let you know if this fixes the problem. thanks a lot!