Forum Moderators: coopster
<html>
<head>
<title>upload</title></head>
<body>
<?php
include_once "connection.php";
$uploadDir = 'C:/wamp/www/uploads/';
if(isset($_POST['upload']))
{
$fileName = $_REQUEST[subject_name];
$tmpName = $_FILES['userfile']['tmp_name'];
$fileSize = $_FILES['userfile']['size'];
$fileType = $_FILES['userfile']['type'];
// get the file extension first
$ext = ".pdf";
// make the file name
$uniqueName = $_REQUEST[subject_code] . $_REQUEST[year] . $_REQUEST[semester];
//the unique file name for the upload file
$filePath = $uploadDir . $uniqueName . $ext;
$result = move_uploaded_file($tmpName, $filePath);
n
if (!$result) {
echo "Error uploading file";
exit;
}
if(!get_magic_quotes_gpc())
{
$fileName = addslashes($fileName);
$filePath = addslashes($filePath);
}
$query = "INSERT INTO exam_papers (subject_code, subject_name, lecturer, department, semester, year_of_exam, file_path) ".
"VALUES ('$_REQUEST[subject_code]','$fileName','$_REQUEST[lecturer]','$_REQUEST[department]','$_REQUEST[semester]','$_REQUEST[year]', '$filePath')";
mysql_query($query) or die('Error, query failed : ' . mysql_error());
echo "<br>Files uploaded<br>";
}
?>
</body>
</html>