I have a table called 'filename'. I try to output <a> tags in a loop from it like this:
<?php
while($sermon = mysql_fetch_assoc($sermonsQ)) {
echo '<a href="admin/'. $sermon ['filename'] . '">';
echo 'download</a></td>';
}
Current problem is, that $sermon['filename'] containts a leading path like path/test.mp3. But I need only the filename without the path, like test.mp3. How can I do this?
Use basename() for that. It will return the filename without the leading path:
basename($sermon ['filename'])
You can use path_info()
<?php
$path_parts = pathinfo('/www/htdocs/inc/lib.inc.php');
echo $path_parts['dirname'], "\n";
echo $path_parts['basename'], "\n";
echo $path_parts['extension'], "\n";
echo $path_parts['filename'], "\n"; // since PHP 5.2.0
?>
also mysql_* functions are depracated so you shouldn't use them for example to PDO or mysqli
<?php
while($sermon = mysql_fetch_assoc($sermonsQ)) {
$filename = explode('/',$sermon ['filename']);
echo '<a href="admin/'. $filename[1] . '">';
echo 'download</a></td>';
}
