<?php
$target_path = "dumps/";

$target_path = $target_path . basename( $_FILES['uploadedfile']['name']); 
$_FILES['uploadedfile']['tmp_name']; 


if(move_uploaded_file($_FILES['uploadedfile']['tmp_name'], $target_path)) {
    echo "The file ".  basename( $_FILES['uploadedfile']['name']). 
    " has been uploaded";

// insert info into database ----

//---------
$user = "crimzor"; // REMOVE THIS!!!
//---------
		include ("db.php");
        $title = pg_escape_string($_POST['title']);
		$date = date("m/d/y"); 
        $description = pg_escape_string($_POST['description']);
		$filename = basename( $_FILES['uploadedfile']['name']);
        $author = $user;
        $query = "INSERT INTO dumps(title, date, description, filename, author) VALUES('". $title ."', '" . $date . "', '" . $description . "','" . $filename . "', '" . $author . "')";
        $result = pg_query($query);
        if (!$result) {
            $errormessage = pg_last_error();
            echo "Error with query: " . $errormessage;
            exit();
        }
        printf ("Values were inserted into the database");
        pg_close();

// ------------------------------

} else{
    echo "There was an error uploading the file, please try again!";
}
?>