[RESOLVED] uploading mp3 - log each new in MySQL

[ATS16805]

if i am uploading files to a directory... using a simple PHP file upload script... how do i put that info into MySQL for creating href's for later downloading those files-- to d/l w/out a need previous knowledge of their location or name?

in plain English-- i made this for my band mates and i to share music for rehearsal via mp3 upload/ download. obviously, if member Joe uploads file, member John knows not where it is, or what it's called. i want member John, without pre-notification from member Joe, to be able to browse our site, recognize a new file is available for download, and to be able to simply click it and get the file. there needs to be no passwords or verification here (although i realize that sort of thing is always a good idea)-- i'm only concerned w/ the very PHP function() which will i'll use to show that new file and present it for download.

the way i see it, i have at least one option, and maybe two (i'm sure there's more!):

• in the upload script file itself, provide a form for a filename $_POST data. that data goes into mysql, logged w/ an auto_increment id, and there's my record of that file-- which i know how to write code to find that data in the table.

• let some PHP function check the filename of the file being uploaded and enter it w/out user intervention into my table.

i'd prefer the latter, but i can live w/ the former.

is there anything else that i should be taking into account also?

to be honest, although i'm confident that i can allow unlimited access to this upload / download to my bandmates, i would p/w user authenticate if i knew how to do it. it's just yet another of the many little things i have yet to cover. please, if you advise it's worth it for me to take the time to learn the whole user validation process to secure this file transfer process, i'd like to hear what you have to say.

thanks!!!

[toxic_brain]

when John upload the file, u can specify where it is stored by the moveuploadedfile() in php. u also have to store this file name, location, date and time of this file.
when Joe login , ur program search in the database for all files which are newer than his previous login anh show links to them.

[ATS16805]

ah-ha! this is very awesome information!! i think this is what i am trying to do, only you've added a bonus feature for searching based on file-dates.

Let's bring Frank into the picture. Frank hasn't seen the mp3 page since mp3#1 has been uploaded. I want Frank to see all available logged mp3s now that Joe, John and I have all uploaded a few-- so, Frank needs to see them all, not just the newest.
Joe and John have been keeping track of what's there, so they will notice from their own recollection that something new is present, so i don't need to worry about searching for newer files, although I should add that nifty feature anyway as it certainly makes practical sense!

[ATS16805]

i just found this at php.net. i assume i need to put something like this in my script? does readdir() essentially eliminate the need to involve MySQL in an app such as what i've described for my mp3's?

<?php

if ($handle = opendir('/path/to/files')) {
   echo "Directory handle: $handle\n";
   echo "Files:\n";

while (false !== ($file = readdir($handle))) {
   echo "$file\n";
   }

  closedir($handle);
}

?>

EDIT: the solution is HERE

[ATS16805]

look HERE for a solution to this problem