Questions regarding subfolder creation.

[Dolemite50]

Hi,..

First off I suppose my question is "how many files is too many to have in the same directory?" I currently have a folder where mems can upload pics and it is growing to have over 10,000 images in the same folder. (I know,..oops) 🙂

The paths are stored in a mysql db along with other info so seperating them shouldn't be too much of a problem. I would like to create folders named after the user_name column.
So if I have a table that stores user_name, image_path, image_caption and would like to create subfolders by user_name, how would I go about this?

$getInfo = "SELECT user_name, image_path, image_caption FROM picTable GROUP BY user_name";
$rs = mysql_query($getInfo, $conn) or die(mysql_error());
while($row = mysql_fetch_assoc($rs)){
$user_name= $row['user_name'];
$image_path= $row['image_path'];
$image_caption= $row['image_caption'];

....and then? I'm sure theres a "move" command in there somewhere,...

Thank you very much. I'm pretty nervous about this one so I'm hoping to hear from somebody with experience. 🙂

[Azala]

mkdir() will make the desired sub folder you want, check it out in the php manual.

rename() can be used to move a file easily.

is_file() is good to call before a rename to make sure there's no files already existing with the same name as the one you are moving

chmod() can be used to chmod the directory you made

mkdir($_SERVER['DOCUMENT_ROOT'].$row['image_path'].$row['user_name']); // remember to add / to this if they don't exist in the path info already
chmod($_SERVER['DOCUMENT_ROOT']."/pathtoimageroot/".$row['user_name'],0777); // change mod to whatever you need of course

if (! is_file($_SERVER['DOCUMENT_ROOT'].$row['image_path'].$row['user_name'].$row['image_caption']))
     rename($_SERVER['DOCUMENT_ROOT'].$row['image_path'].$row['image_caption'], $_SERVER['DOCUMENT_ROOT'].$row['image_path'].$row['user_name'].$row['image_caption']);
else
     // some error as the destination file already exists...

It's up to you to add the desired checks on mkdir etc to make sure the dir was created and so on...this should get you started anyhow.