mysql, php, mp3 - a variable problem
| From: | Ole Hornauer | Date: | Sat, 07 Jun 2003 08:35:34 +0000 |
| Subject: | mysql, php, mp3 - a variable problem | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-28396@lists.php.net to get a copy of this message | ||
hi,
i put a script together to scan a directory and its subdirectories for
all mp3 files. the tag informations and path then should be put into a
mysql database.
i included a script called mphp3.php from http://res.crea-bmb.de/mphp3/
which returns the needed tag info from one file.
the script to recursively scan a dir i got from groups.google.
using the mphp3.php with one file is simple (demo from website):
<?
include("mphp3.php");
$info = New mphp3(2);
$info->load("test.mp3");
echo $info->title." is a nice song. it's encoded with".$info->
bitrate."kbps.";
?>
my code to include the db:
<?
include("mphp3.php");
mysql_connect("192.168.100.12","user","password") or die ("no
connect
to db");
mysql_select_db("music") or die ("db does not exist");
function scan_dir($dir)
{
$info = New mphp3(2);
$handle = @opendir($dir);
while ($file = @readdir ($handle))
{
if (eregi("^\.{1,2}$",$file))
{
continue;
}
if(is_dir($dir.$file))
{
scan_dir($dir.$file."/");
}
else
{
$info->load("/".$dir.$file);
$query ="insert into mp3 (
file,
path,
artist,
title,
album)
values (
'$info2->filename',
'$dir',
'$info2->v2_artist',
'$info2->v2_title',
'$info2->v2_album');";
mysql_query($query);
}
}
@closedir($handle);
}
scan_dir("mp3/");
?>
but all it does is to put the path ($dir) into the database. everything
else is ignored. an error does not occur. since the simple demo works
fine i think its a problem with the validity of variables.
i'm new to php, so could anybody give me a hint on what mightbe wrong
with my code please?
thanx a lot