Forum Moderators: coopster
<?php
if(substr_count($_SERVER["QUERY_STRING"], "uploadfile") >=1 && $submit) {
/*--------------------------------------------------*/
MYSQL_CONNECT($db_host,$db_username,$db_password);
MYSQL_SELECT_DB($database);
/*--------------------------------------------------*/
PRINT ("<FORM ACTION='$_SERVER[PHP_SELF]?uploadfile' NAME='uploadfile' METHOD='post' AUTOCOMPLETE='off' ENCTYPE=\"multipart/form-data\">
<TABLE CLASS='formtable'>
<TR>
<TD CLASS='formtable'>File:</TD><TD CLASS='formtable'><INPUT CLASS='login' TYPE='FILE' NAME='upload_file' ACCEPT='image/*'><BR></TD>
</TR>
<TR>
<TD CLASS='formtable'>Category:</TD>
<TD CLASS='formtable'>
<SELECT CLASS='login' NAME='upload_category'>
<OPTION VALUE=''>Category...
<OPTION VALUE='gallery'>Gallery
<OPTION VALUE='equipment'>Equipment
<OPTION VALUE='personnel'>Personnel<BR>
</SELECT>
</TD>
</TR>
<TR>
<TD CLASS='formtable'> </TD>
<TD CLASS='formtable'>
<INPUT CLASS='login' TYPE='SUBMIT' NAME='submit' VALUE='Upload'>
<INPUT CLASS='login' TYPE='RESET' NAME='reset' VALUE='Clear'>
</TD>
</TR>
</TABLE>
</FORM>");
/*--------------------------------------------------*/
MYSQL_CLOSE();
/*--------------------------------------------------*/
} elseif(substr_count($_SERVER["QUERY_STRING"], "uploadfile") >=1 && $submit) {
/*--------------------------------------------------*/
MYSQL_CONNECT($db_host,$db_username,$db_password);
MYSQL_SELECT_DB($database);
/*--------------------------------------------------*/
if(!empty($_FILES[upload_file])) {
$uploaddir = "../../images/$upload_category/";
$upload_name = $_FILES["upload_file"]["name"];
if (move_uploaded_file($_FILES[upload_file][tmp_name], $uploaddir . $_FILES[upload_file][name])) {
$query = ("INSERT INTO `gallery` (`imagepath`, `imagename`) VALUES ('$upload_category', '$upload_name');");
$result = MYSQL_QUERY($query);
PRINT ("<CENTER>The file $upload_name was successfully uploaded!</CENTER>");
} else {
PRINT ("<CENTER>The file $upload_name failed to upload!</CENTER>");
}
}
/*--------------------------------------------------*/
MYSQL_CLOSE();
/*--------------------------------------------------*/
?>