Image Upload and Insert Text Into the Database

[cmccomas]

I'm looking to setup a way to upload images via my CMS to my server.

Also, I'd like to be able to enter some info about the image in the database. Basically, the info I'd like entered into the database is:

image_name
image_description
image_location (where it was uploaded, /main/ or /sub/ or /player/)
image_upload_date

Can anyone point me in the right direction?

[cmccomas]

I actually have the code that uploads the images. Now I just need to know how/where to insert the info that I'd like and then how/where to insert that info into the DB, along with uploading the image.

<?php
//edit this
$_max_file_size = '9999999999'; //file size in bytes.
$upload_dir = "Gallery/"; //upload folder..chmod to 777
$_i = "8";                //number of files to upload at one time
//end edit 

echo "Maximum file size : " . $_max_file_size/1000 . "KB<br>";
echo "<form enctype='multipart/form-data' action='?do=upload' method='post'>";
echo "<input type='hidden' name='MAX_FILE_SIZE' value='" . $_max_file_size , "'>";
echo "Choose your file(s): <br>";
//show number of files to select
For($i=0; $i <= $_i-1;$i++) 
{
echo "<input name='file" . $i . "' type='file'><br>";
}
echo "<input type='submit' value='Upload File'>";
echo "</form>";

if($_GET['do'] == 'upload')
{
//upload all the fields until done
For($i=0; $i <= $_i-1; $i++) 
{
//create a random number
$_random = rand(1, 1000000);
//file with the upload folder
$target_path = $upload_dir . $_random . basename($_FILES['file' . $i]['name']);
//actual file name with the random number
$_file_name = $_random . basename($_FILES['file' . $i]['name']);

//do not upload the 'left blank' fields
if(basename($_FILES['file' . $i]['name']) != '')
{

if(move_uploaded_file($_FILES['file' . $i]['tmp_name'], $target_path)) 
{
     //uploaded successfuly
    $_uploaded=1;
} 
else
{
    //error uploading
    $_error=1;
}
}
else
{
$_check=$_check+1;
}

}

//file(s) did upload
if($_uploaded == '1')
{
$_uploaded=0;
echo "The file(s) have been uploaded.<br>";
}
//file uploaded?
if($_error == '1')
{
$_error=0;
echo "There was an error uploading some of the file(s), please try again! Maybe the file size. Maximum file size is " . $_max_file_size/1000 . "KB<br>";
}
//user selected a file?
if($_check == $_i)
{
$_check=0;
echo "Select a file first than click 'Upload File'<br>";
}
}
?>