Re: [PHP-DB] special character in filename

[Becoming Digital]

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" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
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





-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php