Newbie.........Flat File and php

[vafishing]

I am trying to load a flat file to a webpage using the following code:
$BlockedFile = fopen($BlockedFileName,"r"
a null $BlockedFile is an error
if (feof($BlockedFile)) {}
$DBLink = mysql_connect('localhost',$SVSiteDatabase,$SVDatabaseUser,$SVDatabasePasswd);
$SiteDB = mysql_select_db($SVSiteDatabase);
while (!feof($BlockedFile) {}
$RecordIn = fgets($BlockedFile);
$FirstName = addslashes(trim(substr($RecordIn,0,20)))
$SQLStmt = "select Id from Users where LastName='$LastName' and FirstName='$FirstName' and StreetAddress='$StreetAddress';
$UserResult = mysql_query($SQLStmt) or die("Unable to get User Result using '$SQLQuery'..."
$TimeStamp = date("YmsHis"
$SQLStmt = "insert into Users set LastName='$LastName', ...";
The flat file is in the form of a web page with a url of

http://www.CustomerFile.tab

My question is will I need to save this file in my home directory and save as a.tab file or should the script be able to pull the data directly from the url. When I attempt to use the code in a blank html page with embedded ?>php I do not get any errors when I load the page, however I get no data either. Any suggestions? Also will I need to pull the flat file into mysql?

 

[ArkM]

while (!feof($BlockedFile) {} - loop forever?

 

[sleipnir214]

vafishing:

Your code is such a mixture of pseudocode and real code that it's difficult to know what it is you're asking.

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!

 

[vafishing]

I got ARKM response meaning that I must adjust the curly brackets to aoid endless looping. I guess what I am looking for is a way to pull a tab delimited file "flat file" from a web site to my web site. The code needs to adjust for blanks if there are any. Essentially my tab file has some entries that have blanks. I need to account for it and need to be able to update and add records to my site

 

[sleipnir214]

No, you need to use curly brackets in some way that is meaningful.

For example, this code:

for ($counter = 1; $counter <= 10; $counter++)
{
print $counter . &quot;\n&quot;;
}

will print something like:
1
2
3
...
8
9
10


This code:

for ($counter = 1; $counter <= 10; $counter++) {}
print $counter . &quot;\n&quot;;

Will print:
11


In the second case, since you have nothing inside the brackets, the code just spins its wheels 10 times then prints the value that caused it to stop spinning its wheels.


Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!