Do I use the Explode Function here?

mdojet

Hi everyone. Once again, thanks for all your help in the past but it seems new issues arise every day! I have the URL for a file that my user has uploaded to my site. I want this person to see a list of all his videos he has on my site. In one of my tables, I have saved the URL of where his videos are(I have a seperate row in my table for each URL) On the webpage I want to show him/her only the file name. I was wondering if I should use explode to extract the file name from the URL..ie...

http://www.mysite/members/videos/coolvid.mpg

all I want to display on the page is the "coolvid.mpg" part.

Thanks again
(90% done!)

Mike

mdojet

I needed to pull the file name out of a really long URL. Explode worked great after a bunch of tweaking! Here is the small script I wrote to do that!

$sql="SELECT * from comicfiles WHERE USERNAME='$session[USERNAME]'";

$result=mysql_query($sql);
while($myrow = mysql_fetch_array($result)) {

$URL=$myrow[URL];
$filename=explode('/', $URL);
print (" <br> $filename[5]"); }

Mike..

tsinka

Hi,

a more secure way:

Use parse_url to get the path and basename on the path to get the filename.

Thomas