[SOLVED] file extention from database

[The Little Guy]

I have file names stored in a database, and I was wondering if anyone knew how to get the extension type, basically there will be files like:

song.mp3
file.mp3
cool.jpg
awesome.jpg
sweet.mov
free.see.jpg
my.house.gif
the.song.mp3


and so on, I need to get the extension anyone know how, even if there is more than 1 decimal?

[BillyBoB]

hope this helps

[code]
<?php
$query = mysql_query("SELECT * FROM tablename");
$array = mysql_fetch_array($query);
if (in_array("mp3", $array) ) {
  echo("this is a mp3");
}
if (in_array("jpg", $array) ) {
  echo("this is a jpg");
}
?>
[/code]

[trq]

Are they always going to be 3 char extensions? Maybe...

[code]
SELECT SUBSTR(file,-3) AS extension FROM tbl;
[/code]

[trq]

[quote author=BillyBoB link=topic=118938.msg486474#msg486474 date=1166332536]
hope this helps

[code]
<?php
$query = mysql_query("SELECT * FROM tablename");
$array = mysql_fetch_array($query);
if (in_array("mp3", $array) ) {
  echo("this is a mp3");
}
if (in_array("jpg", $array) ) {
  echo("this is a jpg");
}
?>
[/code]
[/quote]

Well, that simply wont work if there is a file called jpg.gif

[BillyBoB]

yea i know thats why you shouldnt use them both in a file... i mean why?

[The Little Guy]

I was thinking maybe using strrpos, and get the position of the last . then using substr to remove everything before it.

[trq]

Yeah, that'll work. Something like...

[code]
<?php
  function getext($filename) {
    $pos = strpos(strrev($filename),'.');
    return substr($filename, -$pos);
  }
?>
[/code]

[The Little Guy]

Here is the function I ended up using:

[CODE]function getext($filename) {
$pos = strrpos($filename,'.');
$str = substr($filename, $pos);
return $str;
}[/CODE]