<?php

$dbhost = '';
$dbuser = '';
$dbpass = '';
$conn = mysql_connect($dbhost, $dbuser, $dbpass) or die ('Error connecting to mysql');

$dbname = 'filedir';
mysql_select_db($dbname);

$fol = "C:/wamp/www/mp3/";

function listdir($dir='$fol') {
    if (!is_dir($dir)) {
        return false;
    }

    $files = array();
    listdiraux($dir, $files);

    return $files;
}

function listdiraux($dir, &$files) {
    $handle = opendir($dir);
    while (($file = readdir($handle)) !== false) {
        if ($file == '.' || $file == '..') {
            continue;
        }
        $filepath = $dir == '.' ? $file : $dir . '/' . $file;
        if (is_link($filepath))
            continue;
        if (is_file($filepath))
            $files[] = $filepath;
        else if (is_dir($filepath))
            listdiraux($filepath, $files);
    }
    closedir($handle);
}

$files = listdir('.');
sort($files, SORT_LOCALE_STRING);

$folraw = rawurlencode ($fol);

foreach ($files as $f) {
$query = "INSERT INTO files (folder, file) VALUES ('$folraw', '$f');";
mysql_query($query) or die('Error, insert query failed - ' . mysql_error());

    }

?>