[Resolved] reading text file, explode then outputting...?

vaaaska

This is a very simple thing to do, and I've done it before. I'm trying to take a spreadsheed which has been converted to a .txt file and simply grab the contents the ouput them with some additional information to a webpage (so I can then cut and paste the info into phpmyadmin).

But I keep getting a parse error on line 5 - I've tried with both a fullpath and also just the document name (which is located in the same folder at the script).

Anybody see something I'm missing - I'm stumped...ack.

// get file and contents
$filename = "/path/a.txt";
$handle = fopen($filename, "rb");
// the line below this is LINE 5
$contents = fread($handle, filesize ($filename));
fclose ($handle);
// get the rows
$stuff = explode("/n", $contents);
$n = count($stuff);
// loop the data into a nicer format
$s = "";
for($i=0; $i<$n; $i++) {
$s. = "INSERT INTO TABLE VALUES (" . $stuff[$i] . ")\n";
}
echo $s;

bubblenut

File permissions?

vaaaska

Nope, checked em.

Could it possibly be from the file itself? It's basically a CSV file but saved to txt format.

The file is only 32kb.

Been messing around with file(), file_get_contents(), readfile() and I get the same error message. I've even retyped all the code just in case there was some straggling snippet of hidden whatever, but no luck.

Am I on crack today?

vaaaska

Well, after all that, I'm still not sure what the problem is (on my dev server). But I tossed the script onto the web server and was able to get it rolling.

Wish I could figure out the problem (server config) but I need to get this thing out of my hiar. So, it's resolved sorta.

Thanks B

bubblenut

To try and isolate exactly where the error is

// get file and contents
$filename = "/path/a.txt";
$handle = fopen($filename, "rb") or die("Failed fopen with $filename");
// the line below this is LINE 5
$contents = fread($handle, filesize ($filename)) or die("Failed fread with ".filesize($filename));
fclose ($handle);
// get the rows
$stuff = explode("/n", $contents);
$n = count($stuff);
// loop the data into a nicer format
$s = "";
for($i=0; $i<$n; $i++) {
$s. = "INSERT INTO TABLE VALUES (" . $stuff[$i] . ")\n";
}
echo $s;

Does it show that I'm grabbing at straws? Have you had this working on the same server before?

sidney

{edit} sorry just spoted the bit wher you say youve tryed file allready [end]

// get file and contents as array of rows
$filename = "/path/a.txt";
$stuff = file($filename); 
$n = count($stuff); 
// loop the data into a nicer format 
$s = ""; 
for($i=0; $i<$n; $i++) { 
$s. = "INSERT INTO TABLE VALUES (" . $stuff[$i] . ")\n"; 
} 
echo $s;

vaaaska

Originally posted by bubblenut
Have you had this working on the same server before?

Well, basically, yes.

I have a series of similar things running on my dev server without any problems. I'm rather stumped now that I think about it even more. Of course, I've already finished the task at hand...but you know, I wish I knew so I could handle it next time around...

Oh well...

bubblenut

Just to clarify is the error happening on the call to fopen or fread?

vaaaska

Ok...problem is at fopen...hmmm...so it's really a path problem...

$filename = "/path/a.sql";
$handle = fopen($filename, "rb") or die ("Failed at fopen");
$contents = fread($handle, filesize ($filename)) or die ("Failed at fread");
fclose ($handle);
$stuff = explode("\n", $contents);
$s = "";
foreach ($stuff as $value) {
echo "INSERT INTO test VALUES (NULL,\"" . $value . ")\n";
}

I don't know why I always forget to toss the error message in there...could have made this easier to deal with...I'll keep on plugging away at this now...thanks...v