For Each Statement

[crawfd]

I'm creating folder names based upon a path field from my select statement which seems to work. I also want to copy any zipfiles from my vault location and place it under my zips directory. So I want the respective path folder created below to contain its separate copied zip file and I can only imagine accomplishing this by a for each statement. Any help would be appreciated.

• Justin

$query = "SELECT id, name, session, product, path, zipfile from catalog, products WHERE session='$ses' AND catalog.product=products.id";
$res=mysql_query($query) or die("SQL: $query<br />\nError: ".mysql_error()); 
$num_rows = mysql_num_rows($res); 

echo "<b>$name</b>, your templates are ready for download!<br><br>";


while ($rowp=mysql_fetch_array($res)){

 $productfolder = "zips/$rowp[path]";
 mkdir($productfolder, 0700);

 copy("zips/vault/$rowp[zipfile]", "zips/$rowp[path]");

}

[gammaster]

Hi!
I can see you have some poor array indexes 🙂

$productfolder = "zips/$rowp[path]";

//should be
$productfolder = 'zips/'.$rowp['path'];

but im not sure thats the problem.

if the path 'zips/dir1/dir2' already exists an you only creates the 'newDir' your method shouldn`t be a problem.

But if it`s only the 'zips' directory that exists you should try this:

while ($rowp = mysql_fetch_array($res)) { 
     $folders       = explode('/', $rowp[path]);
     $productfolder = 'zips';
     $zipFile = $rowp[zipfile];

 foreach($folders as $folder) {
    $productfolder.= '/'.$folder;
    if(!is_dir($productfolder))
       mkdir($productfolder, 0700);
    }

 copy('zips/vault/'.$zipFile, $productfolder.'/'.$zipFile); 
   }

I haven`t tested this, but i hope it helps.

Sorry for my poooor english..

[crawfd]

Ahh that worked, I owe you a beer, thanks