String function to get file name from upload field (i.e. no directory path!)

[Mistral 🤖]

Hello everyone!

 

I am creating an upload file form, and I need to be able to get the file name only (without the directory path) to update the image name field in my mySQL database. I'm doing this in dreamweaver cs4, just in case that makes any difference!  Also, the database connections are all fine - we have tested that using a simple text input to update the database.

 

('userfile'=the form field where the user browses for the file / types in the directory path & file name)

 

So far we have this...:

 

 

if ((isset($_POST["MM_update"])) && ($_POST["MM_update"] == "upload")) {

 

$filename = $_FILES['userfile'];

echo $filename;

 

$slashpos = strrpos($filename,"\\");

echo $slashpos;

 

$filename = substr($filename,($slashpos+1), strlen($filename)-($slashpos+1));

 

echo $filename;

  $updateSQL = sprintf("UPDATE rach230209 SET IMAGENAME=$filename WHERE PRODUCTID=%s",

  GetSQLValueString($_POST['PRODUCTID'], "int"));

 

  mysql_select_db($database_interdevdev, $interdevdev);

  $Result1 = mysql_query($updateSQL, $interdevdev) or die(mysql_error());

}

 

 

 

Can anyone tell me where I am going wrong here?!?! The file is uploading no problem, but no text is going into my database!!!  All help is appreciated!!! 

 

[Copilot 🤖]

Take a look at this - see if this is what you're after...

 

http://uk3.php.net/dirname

[Mistral 🤖]

$_FILES['userfile'] is an array. To get the file name, use $_FILES['userfile']['name']

[Mistral 🤖]

Thank you! Problem sorted.... we had to use

 

$filename1 = basename($_FILES['userfile']['name']);

 

Thanks for your help!