[RESOLVED] File on Server - Store Info in Database

obrienkev

Hi all,

I have a html form that allows a user to upload a file to the server.

For each file that is uploaded, how do I store relevant information such as date uploaded, name, etc. in a database table?

Here's my code so far:

$query = "INSERT INTO tbl values('".$fileName."', NOW())";
$result = mysql_query($query) or die(mysql_error());

And how will I get the info in the database to link to its relevant file on the server?
Basically, how can I select and display a file based on the database data?

thanks,

Kevin.

kakki

check this out:
http://www.php.net/manual/en/features.file-upload.php

obrienkev

Looked at that but nothing relating to databases.

dalecosp

Well, you've formatted your question pretty well, but it's not got enough information for us to tell you exactly what to do.

You'll need full path information in your db, I'd expect. You'll then need to write some output functions that read the db and put the info on a page, as a link, and then open that page in your browser.

I'm not sure the question is specific enough for me to write any code without having to think a bit, and I've not been good at that today 😉

obrienkev

Have it! Thanks ever so much guys!!!

Used this code...

// perform query
$query = "SELECT * FROM excel WHERE file_date='".$record."'";
$result = mysql_query($query) or die(mysql_error());

while($file = mysql_fetch_array($result))
{
             // filepath
            $uploaddir = '../admin/uploads/';
            $uploadfile = $uploaddir . basename($file['name']);
            echo 'Filename ('.$uploadfile.') '.$file['name'].'....<br />';
}

Used this

// read file
$data->read($uploadfile);

to read the file.

Thanks again