Directory Listing + Subdirectory

[DigitalExpl0it]

Hello everyone,

Ive created a little script that looks in a directory to specify and then gerts the file names and throws those into a database

now, im modifying the script, but not to sure on what I should do.

Im trying to specify a directory called PhotoLab

now there are alot of sub directories here

I can get the first directory (PhotoLab)

but how will I get the sub directory and its contents

<?
include('cfg.php');
$handle = opendir ('C:\\Inetpub\\wwwroot\\photolab\\');
while (false !== ($file = readdir($handle)))
{
if ($file != '.' && $file != '..' && $file != 'index.php' && $file != 'cfg.php') {

//Check new entry against records in db
$filter = $file;
$filter = "midi/80/$file";

//echo "<a href='C:\\Inetpub\\wwwroot\\photolab\\$file'>$file </a><br>";

$connect = mysql_connect($db_connetion, $db_username, $db_password) or die ("Couldnt connect");
$db = mysql_select_db($db_databse, $connect) or die ("Couldnt open Database"); 
$check_query = mysql_query("SELECT * FROM wml WHERE wml_text='$file' AND wml_link='$filter' ");
if (mysql_num_rows($check_query) == 0) {

//Do insert only if record does not yet exist
$query = mysql_query("INSERT INTO wml (wml_text,wml_link,wml_cat) VALUES ('$file','$filter','80')");
echo "Merging into Database: $file<br>";
} else {
echo "Already in Database: $file<br>";
}
}
}
closedir ($handle);
mysql_close($connect);
?>

now this script works great for only one folder an no subfolders

im trying to make it so I can get the filenames and location into a databse example:

PhotoLab
PhotoLab/John
PhotoLab/John/2001
PhotoLab/John/2002
PhotoLab/Christy/2000
PhotoLab/Christy/2001
PhotoLab/Don/2000

etc...

there could be more subdirectories than that also

in each folder there all .jpg files

any ideas?

now this is a s

[128kb_com]

A good solution would be to write a function that uses recursion to list all the directories and subdir's and so on.

There are some good examples in the manual at:
http://www.php.net/manual/en/class.dir.php

[DigitalExpl0it]

humm thanx

this might work

<?
function getDirList ($dirName) { 
$d = dir($dirName); 
while($entry = $d->read()) { 
if ($entry != "." && $entry != "..") { 
if (is_dir($dirName."/".$entry)) { 
getDirList($dirName."/".$entry); 
} else { 
echo $dirName."/".$entry."<br>"; 
} 
} 
} 
$d->close(); 
} 
getDirList("C:\\Inetpub\\wwwroot\\photolab\\"); 
?>

[DigitalExpl0it]

ok ok, this works great

only thing now, is im trying to figure out how to strip out some of the results

example:

C:\Inetpub\wwwroot\photolab\Alberto Martinez\2001 Digital photos\Homeland Line 2 10-17-2001\DCP02983.JPG

I need that to say

photolab\Alberto Martinez\2001 Digital photos\Homeland Line 2 10-17-2001\DCP02983.JPG

I just want to strip out

C:\Inetpub\wwwroot\

[lnfreish]

$fullPath = "C:\Inetpub\wwwroot\photolab\Alberto Martinez\2001 Digital photos\Homeland Line 2 10-17-2001\DCP02983.JPG";

$basePath = "C:\Inetpub\wwwroot\";
$partialPath = substr($fullPath,strlen($basePath),strlen($fullPath)-strlen($basePath));
echo $partialPath;

NOTICE:
$basePath = "C:\Inetpub\wwwroot\"; // there are two backlashes

[DigitalExpl0it]

ok I got, thanx for the help

heres the code

<?
function getDirList ($dirName) { 
$d = dir($dirName); 
while($entry = $d->read()) { 
if ($entry != "." && $entry != "..") { 
if (is_dir($dirName."\\".$entry)) { 
getDirList($dirName."\\".$entry); 
} else { 
$basePath = "C:\\Inetpub\\wwwroot\\"; 
$partialPath = substr($dirName,strlen($basePath), strlen($dirName) - strlen($basePath)); 
//$partialPath = substr($dirName,19); 
echo $partialPath."\\".$entry."<br>"; 
//echo $dirName."\\".$entry."<br>"; 
} 
} 
} 
$d->close(); 
} 

// Directory to list
getDirList("C:\\Inetpub\\wwwroot\\photolab"); 
//getDirList("."); 
?>

[DigitalExpl0it]

ok I have another little problem, this is my first time using odbc in php, how do I check to see if the data already exists?

<?
function getDirList ($dirName) { 
$d = dir($dirName); 
while($entry = $d->read()) { 
if ($entry != "." && $entry != ".." && $entry != "index.php" && $entry != "cfg.php") { 
if (is_dir($dirName."\\".$entry)) { 
getDirList($dirName."\\".$entry); 
} else { 
$basePath = "C:\\Inetpub\\wwwroot\\photolab\\"; 
$partialPath = substr($dirName,strlen($basePath), strlen($dirName) - strlen($basePath)); 

//Database Connection
$connect = odbc_connect("PHOTOS", "root", ""); 
$check_query = odbc_exec($connect,"select * from Photobase where PhotoName = $entry and PhotoLocation = $partialPath"); 
//Check to see if data exists in database
if ($check_query == 0) { 
echo "Merging: ".$partialPath."\\".$entry."<br>"; 
$resultupdate=odbc_exec($connect,"INSERT INTO Photobase(PhotoName,PhotoLocation) values('$entry','$partialPath')");
} else {
echo "Already in Database: ".$partialPath."\\".$entry."<br>";
}
} 
} 
} 
$d->close(); 
}
getDirList("C:\\Inetpub\\wwwroot\\photolab"); 
?>

if ($check_query == 0) {

doesnt work

[diego25]

Check here:
http://www.php.net/manual/en/function.odbc-num-rows.php

to see how to count the number of rows returned in an ODBC query. Make sure you read ALL the page AND the user comments.

Diego