PHP script works on PC but not on Mac???

[white_francis]

I have a script that uploads a tab-delimited .txt file (addresses), moves a copy to a file on my server and writes a new, edited file that removes duplicate entries, removes " " from fields, and combines two fields (Address 1 & Address 2).

For some reason, it works perfectly every time when I test it at home on my PC. BUT, when I run the same script from the same server using the same .txt file at work with a Mac it doesn't work.

It does upload and move the file without a hitch. However, when it writes the new edited file it doesn't remove the duplicates, remove the " " or combine the fields. It just makes a copy of the uploaded file.

This totally baffles me as it was my newbie impression that PHP did all of its magic on the server side.

So what am I doing wrong?

Here's the part of the script that edits the file:
(NOTE- the .txt file is sorted so duplicates are always adjacent)

if ($New) { // BEGIN $New IF STATEMENT

$n=1;

$Cnt=count($Data);

	while ($n<$Cnt) { // BEGIN WHILE STATEMENT

	$p=$n-1;

	if ($Data[$n]==$Data[$p]) { // Check for duplicate

	$n++;

	} else { // If not a duplicate, clean up and write to file


	$Get=explode("\t",$Data[$n]);

		$x=0;

		while ($x<8) {

		$Get[$x]=trim($Get[$x],"\x22"); // remove quotes

		$x++;

		}

	$Move=$Get[3];

	$Get[3]="";

fwrite($New,"$Get[0]\t$Get[1]\t$Get[2] $Move\t$Get[3]\t$Get[4]\t$Get[5]\t$Get[6]\t$Get[7]");

	$n++;

	}


	} // END WHILE STATEMENT


} // END $New IF STATEMENT

[justsomeone]

I haven't any experience with macs but I do know that there are differences in how Windows and Linux format text files. Windows uses two characters ("Carriage Return" "Line Feed") to mark the end of a line, while nix just uses one ("Line Feed"). A quick google just told me that Macs use the same format as nix.

Could there be something in that? Try using a hex editor to compare "indentical" files which came from your PC and your Mac.

Could you show the code you use to read in the file? If you're somehow reading the whole file in as one line, that could explain why it doesn't spot duplicates etc

[white_francis]

I may be reading the text file in as one line. Not sure. Here's the entire script:

<?php

if ($upload=="Yes") { 

$uploadFile = $_FILES['userfile']['name'];

if (move_uploaded_file($_FILES['userfile']['tmp_name'], $uploadFile)) {

print "<h1 style=\"text-align:center\">Download Edited Address File</h1><hr>\n";

print "<p>File is valid, and was successfully uploaded.<p>\n ";

print "<!-- Here's some more debugging info:\n"; 

print_r($_FILES);

print "\n -->\n";



$file = $uploadFile;
$needle = ".";

//find length of the needle
$needle_len = strlen($needle);

//find postion
$position_num = strpos($file,$needle);

//cut the string
$file = substr("$file",0,$position_num);


$Open=fopen($uploadFile, "r");

if ($Open) { // BEGIN $Open IF STATEMENT

print "<p>File successfully opened and edited<p>";

$Data=file($uploadFile);

fclose($Open);

} else {

print "<p>Could not open file<p>";

} // END $OPEN IF STATEMENT

$Edit=$file . "-edit.txt";

$t=1;

	while(file_exists($Edit)){

	$Edit=$file . "-edit-$t.txt";

	$t++;

	}

$New=fopen($Edit,"a+");

fwrite($New,$Data[0]);

if ($New) { // BEGIN $New IF STATEMENT

$n=1;

$Cnt=count($Data);

	while ($n<$Cnt) { // BEGIN WHILE STATEMENT

	$p=$n-1;

	if ($Data[$n]==$Data[$p]) {

	$n++;

	} else {

	$Get=explode("\t",$Data[$n]);

		$x=0;

		while ($x<8) {

		$Get[$x]=trim($Get[$x],"\x22");

		$x++;

		}

	$Move=$Get[3];

	$Get[3]="";

fwrite($New,"$Get[0]\t$Get[1]\t$Get[2] $Move\t$Get[3]\t$Get[4]\t$Get[5]\t$Get[6]\t$Get[7]");

	$n++;

	}


	} // END WHILE STATEMENT


} // END $New IF STATEMENT

print "<p> &nbsp;<p><b>Control+Click to download edited file:</b> &nbsp; <a href=$Edit><b>$Edit</b></a></h2><hr>\n";

print "<p> &nbsp;<br> &nbsp; <p><a href=index.htm>Click here</a> if you'd like to upload another file.\n";

} else { 

print "<p>File not valid. Please <a href=index.htm>click here</a> to try again.\n";

print "<!--Here's some debugging info: ";

 print_r($_FILES);

print "\n -->\n";

 } 

} else {

print "<h1 style=\"text-align:center\">Upload Address File to Edit</h1><hr><p> &nbsp;<p>\n";

print "<form enctype=\"multipart/form-data\" action=\"index.htm\" method=\"post\">\n";

print "<input type=\"hidden\" name=\"MAX_FILE_SIZE\" value=\"300000\" />\n";

print "<input type=\"hidden\" name=\"upload\" value=\"Yes\" />\n";

print "Choose a file to upload: <input name=\"userfile\" type=\"file\" />\n";

print "<input type=\"submit\" value=\"Upload File\" />\n";

print "</form><h1> <br> </h1><hr>\n";

print "<h3>This program will do the following to the uploaded file:</h3>\n";

print " - Eliminate duplicate records<br>\n";
print "- Eliminate all &quot; &quot; from file<br>\n";
print " - Combine Address #1 & Address #2 Fields<br>\n";

print "<p>\n";

}

?> 

I appreciate your help!

[justsomeone]

I see that your'e using file() to load the file contents into an array. That does cause to be a bit of an issue with line endings.

From the manual :

Note: If you are having problems with PHP not recognizing the line endings when reading files either on or created by a Macintosh computer, you might want to enable the auto_detect_line_endings run-time configuration option.

Elsewhere on the manual page, someone suggests this mac-friendly function to replace fopen()

function file2($filename) {
       $fp = fopen($filename, "rb");
       $buffer = fread($fp, filesize($filename));
       fclose($fp);
       $lines = preg_split("/\r?\n|\r/", $buffer);
       return $lines;
}

[white_francis]

Ah... Thanks!

I've tested on the PC and it's working perfectly. I'll have to wait until to tomorrow to test it on the Mac at work.

I'll let you know how it turns out.

🙂

[white_francis]

Success!

Tested on the Mac and it works beautifully.

Thanks!!

[justsomeone]

delighted to help