[Resolved] How to put number of files in a folder in a database?

aepstar

Let say we have 3 files in folder myFolder. How can I put this number in a datbase?

I alrready can count files in a folder and that is than specified in the variable $files.

I need this in a database because i want to sort the whole table by NUMBER_OF_FILES ASC or DESC.

do i have to count the files in a folder eacht time user loads a page and than assign that number over and over again to the NUMBER_OF_FILES column? Or do I have other options?

Thank you very much!

aepstar

the number of files in the myFolder is changed like, every day

cahva

It depends on how you actually put new files to that folder. If you use some kind of upload-script to put files to that folder, you can update the database(+1) in the same script. If deleting is also made through the browser, you can minus the filecount from DB.

If you are adding files with ftp, you have to make a script that you have to run everytime you made changes to the directories.

aepstar

Thru ftp. It is no problem to run the script for me manually.

could you please give me the code? $files has to be put in NUMBER_OF_FILES 😃

TTT

10th time today.....MANUAL

$handle = opendir('yourfolder');

$count = 1;
while (false !== ($file = readdir($handle))) {
$count++;
}
echo $count;

aepstar

Originally posted by TTT
10th time today.....MANUAL

$handle = opendir('yourfolder');

$count = 1;
while (false !== ($file = readdir($handle))) {
$count++;
}
echo $count;

HEY i know how to count files. as i wrote in my previous message.

i just wanna know hot to assign the result of the count files to the databse field NUMBER_OF_FILES

cahva

TTT's example was almost correct, except that one also counts directories(.. &.).

$folder='myFolder';
$d='/home/www/'.$folder;
$files=0;
if ($dir = @opendir($d)) {
	while (($file = readdir($dir)) !== false) {
		if (is_file($file))
			$files++;			  

	}
	closedir($dir);
}

// Mysql stuff
# DB conn
$server='localhost';
$user='user';
$pass='pass';
$conn=mysql_connect($server,$user,$pass) or die(mysql_error());
mysql_select_db("db",$conn);

# Update
$query="UPDATE table_name SET NUMBER_OF_FILES='".$files."' WHERE folder_name='".$folder."'";
mysql_query($query);

aepstar

Originally posted by cahva
TTT's example was almost correct, except that one also counts directories(.. &.).

$folder='myFolder';
$d='/home/www/'.$folder;
$files=0;
if ($dir = @opendir($d)) {
	while (($file = readdir($dir)) !== false) {
		if (is_file($file))
			$files++;			  

	}
	closedir($dir);
}

// Mysql stuff
# DB conn
$server='localhost';
$user='user';
$pass='pass';
$conn=mysql_connect($server,$user,$pass) or die(mysql_error());
mysql_select_db("db",$conn);

# Update
$query="UPDATE table_name SET NUMBER_OF_FILES='".$files."' WHERE folder_name='".$folder."'";
mysql_query($query);

[/B]

thank you cahva.