0) {
echo "Return Code: " . $_FILES["file"]["error"] . "
";
} else {
echo "Upload: " . $_FILES["file"]["name"] . "
";
echo "Type: " . $_FILES["file"]["type"] . "
";
echo "Size: " . ($_FILES["file"]["size"] / 1024) . " kB
";
if (file_exists("/srv/www/li520-11.members.linode.com/public_html/MTM2/Tracks/T2014/" . $_FILES["file"]["name"])) {
echo $_FILES["file"]["name"] . " already exists. ";
} else {
move_uploaded_file($_FILES["file"]["tmp_name"],
"/srv/www/li520-11.members.linode.com/public_html/MTM2/Tracks/T2014/" . $_FILES["file"]["name"]);
echo "Stored in: " . "Tracks 2014/" . $_FILES["file"]["name"];
//This gets all the other information from the form
// connect
$q=$_GET["q"];
$con = mysqli_connect("localhost","www-data","uploads","dbTracks");
if (!$con){
die('Could not connect: ' . mysqli_error($con));
}
mysqli_select_db($con,"dbTracks");
$q = mysqli_real_escape_string($con,$q);
// Save form input
$track= mysqli_real_escape_string($con, $_POST['track']);
$maker= mysqli_real_escape_string($con, $_POST['maker']);
$type=$_POST['type'];
$size=($_FILES["file"]["size"] / 1024);
$zip=($_FILES['file']['name']);
mysqli_query($con,"INSERT INTO tracks (track, maker, type, size, file, dir, date) VALUES ('".$track."', '".$maker."', '".$type."', '".$size."', '".$zip."', 'T2014', CURDATE())");
// Close connection
mysqli_close($con);
}
}
} else {
echo "Invalid file";
}
?>
