updating database with name files

mexcar

Hi all again 🙂

The second lesson 🙂 🙂
I'm trying to update a simple database (MySql, or csv file) with the names of files recently modified in a web site, but I want to do it via cron or similar (run alone).
Thats it: I put a file in the web or other put one file. Then, once a day, the scripts runs and update this file or database.

¿easy or hard?

weekender

easy, i reckon. write a php file to list all the files and last modifieds into an array, then post these via SQL into db.

then cron the file to run every 24 hours.

there's a basic plan...

mexcar

OK, thats I wanto to do, but, dou you've a little example?

(I'm just starting with this )

Thanks:rolleyes:

weekender

ok just modified this from a file within phpnuke 5.6 http://www.phpnuke.org/

<?php

//set $filedir to the directory
$filedir = dir('uploaded');

//this loops through the files in the directory, and adds 
//them to a list if they have the correct extension
//either jpg, txt or htm at present. change below
while ($file = $filedir->read()) {
    if (eregi("jpg", $file) || eregi("txt", $file) || eregi("htm", $file)) {
	$imglist .= "$file;";
    }
}

//close the directory handle
closedir($filedir->handle);

//splits the list of files into an array
$filelist = explode(";", $imglist);

//gets the number of files in the list
$numfiles = sizeof($filelist)-2;

$loop = 0;

//loops through each file, getting the filename and 
//then splitting that into name ($fileparts[0]) and
//extension ($fileparts[1]). Then prints this info out
while ($loop <= $numfiles):
	$file = $filelist[$loop];
	$fileparts = explode(".", $file);
	printf("%d\tFile: %s\nExtension: %s\n", $loop, $fileparts[0], $fileparts[1]);
	$loop++;
endwhile;

?>

that took a while, so i sure hope it helps!

adam

weekender

ok i added a bit which reads in the file last modified time, but it isn't working :rolleyes:

i think the bit that is failing is passing the file location into getmtime, but i can't get it working

if it works for you, let me know. all you have to do then is post the variables into a db instead of printing them out.

oh, and i added a bit which prints out the data in a table. The file is attached below...

weekender

i managed to fix my page...

<?php 

//set $filedir to the directory
$directory = ".";
$filedir = dir($directory); 

//this loops through the files in the directory, and adds 
//them to a list if they have the correct extension 
//either jpg, txt or htm at present. change below 
$loop = 0;
while ($file = $filedir->read()) { 
	if (eregi("jpg", $file) || eregi("txt", $file) || eregi("htm", $file)) { 
		$filestring .= "$file;";

	$fullfilename = $directory . "/" . $file;

	$modtime = date ("D dS F Y G:i T", filemtime($fullfilename));

	$modlist[$loop] = "$modtime;";
} 
$loop++;
} 

//close the directory handle 
closedir($filedir->handle); 


//splits the list of files and modified times into an array 
$filelist = explode(";", $filestring);


//gets the number of files in the list 
$numfiles = sizeof($filelist)-2; 

$loop = 0; 

print "<table width=90% border=1>\n";
//loops through each file, getting the filename and 
//then splitting that into name ($fileparts[0]) and 
//extension ($fileparts[1]). Then prints this info out
//into a table 
while ($loop <= $numfiles): 
	$file = $filelist[$loop];
	$time = $modlist[$loop]; 
	$fileparts = explode(".", $file); 
	print "\t<tr>\n";
	$fullfilename = $directory . "/" . $file;
	$modtime = date ("D dS F Y G:i T", filemtime($fullfilename));
	printf("<td>%d</td><td>%s</td><td>%s</td>", $loop, $fileparts[0], $fileparts[1]);
	print "<td>$modtime</td>";
	print "\t</tr>\n"; 
	$loop++; 
endwhile; 

?>

it works fully now, and i have attached it below...