asked on

help with modifying a PHP upload script

hello, I wonder if i could get some help modifying this upload script please.

At the moment I have it so a user can upload a document to the server.

What i need to be able to do now though is

1. The user selects a course from a dropdown list on the form, and then uploads the document. That dropdown list is populated from a table in my mysql database called leaders. the column names are ID, course , email.

2. When a user selects a course from the dropdown list and submits the document, i would like to send an email to the address attached to course, and in the email there will be a link to the new uploaded document on the server.

As i say the uploading of the document works at the moment but need some help modifying it with the above modifications. Could somebody help me please?.

Regards,

LPHP

<?PHP
require_once("Session.class");
$sess = new Session();
if($sess->getVariable("auth") != "yes")
{
	header("Location: ../login-OOtest.php");
	exit();
}
include('header.html');
 
echo("<center><h1>Paper Submissions</h1>");
echo("Please rename paper to delegate name. i.e joe_bloggs.pdf");
echo("<br />");
echo("<form action=\"./upload1.php\" method=\"post\" enctype=\"multipart/form-data\"/>");
echo("<label for=\"file\">Select a file:</label>
	  <input type=\"file\" name=\"userfile\" id=\"file\"/>
	  <button>Upload File</button></center>");
 
 
 include('footer.html');
?>
 
<?PHP
 
 
// Configuration - Options
// These will be the types of file that will pass the validation.
	$allowed_filetypes = array('.doc','.txt','.pdf');
// Maximum filesize in BYTES.
	$max_filesize = 2000000;
// The place the files will be uploaded to (currently /uploads/ directory).
    $upload_path = './uploads/';
// Get the name of the file (including file extension).
   	$filename = $_FILES['userfile']['name'];
// Get the extension from the filename.
   	$ext = substr($filename, strpos($filename,'.'), strlen($filename)-1);
 
// Check if the filetype is allowed, if not DIE and inform the Delegate.
   if(!in_array($ext,$allowed_filetypes))
      die('The file you attempted to upload is not allowed.');
 
// Check the filesize, if it is too large then DIE and inform the Delegate.
   if(filesize($_FILES['userfile']['tmp_name']) > $max_filesize)
      die('The file you attempted to upload is too large.');
 
// Check if we can upload to the specified path, if not DIE and inform the Delegate.
   if(!is_writable($upload_path))
      die('You cannot upload to the specified directory, please CHMOD it to 777.');
 
// Upload the file to your specified path.
   if(move_uploaded_file($_FILES['userfile']['tmp_name'],$upload_path . $filename))
         echo 'Your file upload was successful, view the file <a href="' . $upload_path . 			                 $filename . '" title="Your File">here</a>';
// It worked.
      else
// It failed :(.
         echo 'There was an error during the file upload.  Please try again.';
 
?>

Open in new window

Bobaran98

There are several components to getting you where you want to go. I assume you can get into your database and generate the drop-down <select> menu. The code below assumes you named that field "courseID"

The tricky thing here-- what I'm assuming you're mainly asking about-- is the mail component of it. If not, let me know. What's tricky is that it all depends on how your mail server is setup. Are you using shared hosting? Do you have a dedicated server? Does your domain, in fact, have its own separate mail server?

The code below is fairly standard and may work as is. If not, you can try:

removing the ini_set lines (try leaving each in by itself, or removing both)
try just your domain name-- www.mydomainname.com-- rather than mail
if you have your address setup in Outlook or another mail client, check your settings and see what your outgoing server is; that server name should work in the SMTP line

Note that this function is more likely to work if you're sending and receiving messages within the same domain. If you have problems getting it going, try testing it in just a simple script where you do nothing but call the mail() function using constant values (in other words, remove anything else from your code that may be causing a problem.

I know that's a bit wide open. Let me know if it helps!

<?php
 
// Upload the file to your specified path.
   if(move_uploaded_file($_FILES['userfile']['tmp_name'],$upload_path . $filename)) {
         echo 'Your file upload was successful, view the file <a href="' .
			 $upload_path . $filename . '" title="Your File">here</a>';
 
		$course_details = mysql_query("SELECT * FROM leaders WHERE ID=" .
			$_REQUEST['courseID']);
 
		$email_message = "A user has just submitted a file for the course " . 
			mysql_result($course_details,0,"course") .
			".  That file can be downloaded here: " . 
			"http://www.mydomainname.com/uploads/" . $filename
		
		$email_address = mysql_result($course_details,0,"email");
 
		// mydomainname.com is your domain and joe@mydomainname.com is your email
		ini_set ("sendmail_from","joe@mydomainname.com");
		ini_set("SMTP","mail.mydomainname.com");
		mail($email_address, "joe@mydomainname.com", "New File Upload!", $email_message);
 
// It worked.
   }  else {
// It failed :(.
         echo 'There was an error during the file upload.  Please try again.';
   }
 
 
 
 
 
?>