Index.php :
<?php
// index.php
// create a droptdown menu and upload form
// connect upload file name to the dropdown menu field.
// Chris Anthony MA 8/6/2012
//
// Connect to MySQL Database
include('../../conect.php');
//dropdown box of spec see
// http://www.learnphp.co/creating-an-html ... using-php/
// for example code.
// query the database for the spec.
$sql = "SELECT * FROM `canthony`.`spec` AS `spec`";
$query = mysql_query($sql);
while ( $results[] = mysql_fetch_object ( $query ) );
array_pop ( $results );
// print_r_html($results);
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<html lang="en">
<head>
<title>Uploading files</title>
</head>
<body>
<h1>Uploading files</h1>
<hr> <!-- Makes a Horizontal line accross the page -->
<!-- Form for selecting spec and file to upload to the operation_manuals table
spec to spec and upload to manual_name field.
-->
<form action='upload.php' method='post' enctype='multipart/form-data'>
File: <input type='file' name='upload'> <!-- Uploads file -->
<!-- Drop down menu -->
<select name="spec_drop">
<?php foreach ( $results as $option ) : ?>
<option value="<?php echo $option->spec; ?>"><?php echo $option->spec ; ?></option>
<?php endforeach; ?>
</select>
<input type='submit' name='submit' value='Upload File Now'> <!-- Submit button -->
</form>
</body>
</html>
upload.php :<?php
//upload.php
// Takes file from index.html form and adds the upload date to the file
// and places the file into the documents folder.
// The documents folder must already exist.
// Chris Anthony MA 8/2/2012
//
//
// Connect to MySQL Database
include('../conect.php');
// Pull upload form index.html
if($_POST['submit']){
// Assign uploaded file information to Variables.
// Upload listed in this array is the same name as the input name in the form.
$name = $_FILES['upload']['name'];
$temp = $_FILES['upload']['tmp_name'];
$type = $_FILES['upload']['type'];
$size = $_FILES['upload']['size'];
// Validate variables for error checking echo "$name<br />$temp<br />$type<br />$size";
// File types allowed to be uploaded (.pdf, doc, .docx, .xls, .xtsx, .jpg, and .jpeg)
if(($type == 'application/pdf') || ($type == 'application/msword') || ($type == 'application/vnd.openxmlformats-officedocument.wordprocessingml.document') || ($type == 'application/vnd.ms-excel') || ($type == 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet') || ($type == 'image/jpg') || ($type == 'image/jpeg')){
// Limit file size to 300mb $size is the max file size alloud.
if($size <= 314572800){
// echo "The file: $name size is $size";
// Todays date mm_dd_yyyy_
$todaysDate = date("m_j_Y_");
//add the date to the begining of the file name.
$newfile = $todaysDate.$name;
// echo $newfile;
// Move file from memory to documents folder located in the same location as this file.
move_uploaded_file($temp,"documents/$newfile");
// echo "<img src='$newfile'>";
// Places the upload as a link into a variable
$link = "<a href='documents/$newfile'>$newfile</a>";
// Make Link or way to test $link variable
echo $link;
// Place write to MySQL. Write $newfile to a database field.
// query database to pull spec from Chris Anthony
$sql = "SELECT `contacts`.`first_name` AS `Chris`, `contacts`.`last_name` AS `Anthony`, `spec`.`spec` FROM `canthony`.`projectcontact` AS `projectcontact`, `canthony`.`contacts` AS `contacts`, `canthony`.`project_spec` AS `project_spec`, `canthony`.`spec` AS `spec`, `canthony`.`project` AS `project` WHERE `projectcontact`.`Contacts_ID` = `contacts`.`ID` AND `project_spec`.`spec` = `spec`.`spec` AND `project_spec`.`Project_ID` = `project`.`Project_ID` AND `projectcontact`.`Project_ID` = `project`.`Project_ID`";
$result = mysql_query($sql);
}else{
// File is bigger the 300mb warning
echo "The file: $name is to big....<br />The size is $size and need to be less than 300mb";
}
}else{
// File type not allowed warning
echo "This type $type is not allowed";
}
}else{
// forces back to index.html when trying to open upload.php from browser URL
header("Location: index.html");
}
?>
