Re: special character in filename

I can't explain why addslashes() didn't work (incorrect placement in the script, perhaps), but take a look at htmlspecialchars() and htmlentities(). They're long shots, but they might help. Edward Dudlik Becoming Digital www.becomingdigital.com ----- Original Message ----- From: "Ole Hornauer" <ohorn77@gmx.de> To: <php-db@lists.php.net> Sent: Sunday, 08 June, 2003 13:14 Subject: [PHP-DB] special character in filename hi, since i got my mp3 code somewhat working (was my fault, sorry guys), i encountered another problem that i simply cant solve on my own. im scanning mp3 files in a directory to put the data into a mysql database. everything works fine except that those files that have inverted commas (maybe also other special characters?) as part of the filename are being ignored by the script. i tried to use addslashes() but that didn't help either. i included a test (echo $dir.$file) to see what exactly would be inside the variables. but it looked ok. could anybody give me a hint? i just dont get it. here is my code. i included mphp3.php from http://res.crea-bmb.de/mphp3/ to scan for mp3 tags: <? include("mphp3.php"); mysql_connect("192.168.100.12","user","password") or die ("Keine Verbindung moeglich"); mysql_select_db("mp3") or die ("Die Datenbank existiert nicht"); scan_dir("mp3/"); echo "Fertig"; function scan_dir($dir) { $handle = @opendir($dir); while ($file = @readdir ($handle)) { if (eregi("^\.{1,2}$",$file)) { continue; } if(is_dir($dir.$file)) { scan_dir($dir.$file."/"); } else { $info = New mphp3(2); echo $dir.$file; $info->load($dir.$file); $abfrage ="insert into mp3 ( file, path, artist, title, album) values ( '$file', '$dir', '$info->v2_artist', '$info->v2_title', '$info->v2_album');"; mysql_query($abfrage); } } @closedir($handle); } ?> -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php