[ELV1I2]

It's fair to say that I'm able to make script that is able to force the PHP to read CSV file, explode and insert into mySQL table but I have this situation:
A user wish to insert some data on remote web server using CSV file from his computer. Each time CSV file has different name (bill_001.txt, bill_002.txt...) and depends of application that is making CSV file.
I never knows what name will be each time when reading CSV file is demanding!? I know to make script where is in some variable name of CSV file but I would like to make script where is possible to use forms and nice Browse button for selection and another button for processing CSV file!
I tried and I still doing it but I'm unable how to get name of selected file...
here is some piece of code which I found somewhere but unable to properly use; also, how to put filter for files with extension like *.txt!?

PHP Code:

<form enctype="multipart/form-data" action="process_file.php" method="POST">

<input type="hidden" name="MAX_FILE_SIZE" value="50000" />

Choose a file: <input name="uploadedfile" type="file" /><br />

<input type="submit" value="Process this file" />

</form> 

Thanks for your help.

[ELV1I2]

Uuuh, I found the answer how to get name of file that a user selected in Browse dialog:

PHP Code:

$nsf=$_FILES['uploadedfile']['name'];  

echo 'You selected: ' . $nsf; 

but still I don't know how to "filter" in browse dialog only those files with one or few extensions (TXT, LST, ME..., just to avoid that user choose wrong file type?

[Nico]

PHP Code:

if (!in_array(strtolower(end(explode('.', $nfs))), array('txt', 'lst')))
{
    exit('Invalid extension.');
} 

[mab]

Here is a link to a javascript that allows you to check the file name extension in the form before the file is uploaded - http://willmaster.com/blog/javascrip...xtensions.html

To check file name extension or the file type the browser detected after the file is uploaded, use information from the $_FILES[...]['name'] (edit: using the code Nico posted) and $_FILES[...]['type'] elements.

[ELV1I2]

Originally Posted by Nico

PHP Code:

if (!in_array(strtolower(end(explode('.', $nfs))), array('txt', 'lst')))
{
    exit('Invalid extension.');
} 

Thanks Nico, I couldn't never remember such way of coding. Your solution is not quite what I thought but it's usefully. I adopted it. Just a small error in your code (name of variable):

PHP Code:

if (!in_array(strtolower(end(explode('.', $nsf))), array('txt', 'lst')))
{
    exit('Invalid extension.');
} 

Thanks mab, I'll check also JavaScript solution...

[ELV1I2]

I made it and script is working fine on my computer in local environment but problem is that php script is working fine if CSV file is inside virtual folder where scripts are! If I try to pick a one CSV file from different position on my local disk I got error that can't find file!? It seems to me that I must at first to upload CSV file into folder of web server on Web and then to read from it..? As I'm using free php & MySQL server on Web it's impossible and uncomfortable...
I thought that this thing is simple: pick a file, detect his name, read it, explode into fields and insert fields into table of DB
But it looks no more so simply. What now?