explode function

Anon

one last question (i hope!)

so I have a file that a user uploads...I insert the name of the file into a mysql database, but not the file itself. I want to seperate the filename from the file extension. so i'm thinking I can use something like list ($name, $ext) = explode (".", $userfile);

my question is....when I retrieve the results using a SQL query....like, "SELECT * FROM filemanager WHERE title LIKE '$title'"
is it possible to slipt the result i get back for filename into it's name and extention? When I list the files, I list them like this

for ($x=0; $x < mysql_num_rows($resultID2); $x++)
{
$row = mysql_fetch_assoc($resultID2);
print "<center><tr>";
print "<td>" . $row[title] . "</td>";
print "<td><a href=" . $row[userfile] . ">" . $row[userfile] ."</a></td>";
print "<td>" . $row[filesize] . "</td>";
print "<td>" . $row[date] . "</td>";
print "</tr>";
}

so would something like list($name, $ext) = explode (".", $row[userfile]; work? That doesn't seem right to me..

[deleted]

I don't understand what you want to do.

A user uploads a file, you store the filename, and somehow you want to remove the extention and store it in a seperate field,
and later join the extention to the filename again?

Anon

yes, and i'll tell you why (maybe there is an easier way to do this), I have a script that will allow the user to rename the file. I've disallowed them to upload .php and other files. So, I don't want a user to upload a file , say called filename.html, and then be able to rename it to filename.php, and then run the php script. So my thought was to seperate the filename from the ext and just have them able to edit the filname.

jburfield

If you are splitting them out, I think explode will work, as you have written.

When putting them back together why not just do a concat() select in MySQL?

Select concat(filename, '.', extension) from table yadda, yadda, yadda.

That gives you the filename such as: test.jpg if it was stored in two fields in the table as 'test' and 'jpg'.

-- Jason