 |
|
|
";
if (!$db) /* conditional statement */
{
die('Connection to Database down: '. mysql_error()); /* print if connection is not established */
}
mysql_select_db("ScientistNet", $db);
$email =$_SESSION['email'];
$recipient2 = $_POST['to'] ;
$recipient = $rsql;
$subject = $_POST['subject'] ;
$body = $_POST['body'] ; //
//$From = "1"; //later change to session $_SESSION['sender']
$ssql =mysql_query("SELECT id
FROM Scientist
WHERE email='$email'"
)
or die(mysql_error());
$rsql =mysql_query("SELECT id
FROM Scientist
WHERE email='$recipient2'
")
or die(mysql_error());
$From= $ssql;
$sent = mail($recipient, $subject, $body, $headers) ;
$open = 'F';
// store into data
if ($_FILES["file"]["error"] > 0)
{
$sql =mysql_query("INSERT INTO Mail (id , recipient , sender , subject , body , opened)
VALUES ('$id' ,'$From' , '$recipient', '$subject' , '$body' , '$open')")
or die(mysql_error());
}
else // upload file
{
echo "Upload: " . $_FILES["file"]["name"] . " "; echo "Type: " . $_FILES["file"]["type"] . " "; echo "Size: " . ($_FILES["file"]["size"] / 1024) . " Kb "; echo "Stored in: " . $_FILES["file"]["tmp_name"]; $filename = $_FILES["file"]["name"]; // store uploading file into upload folder move_uploaded_file($_FILES["file"]["tmp_name"], "upload/" . $_FILES["file"]["name"]); echo "Stored in: " . "upload/" . $_FILES["file"]["name"]; $filepath = "upload/" . $_FILES["file"]["name"]; // store into data $sql =mysql_query("INSERT INTO Mail (id , recipient , sender , subject , body , opened ,fileName , path) VALUES ('$id' ,'$From' , '$recipient', '$subject' , '$body' , '$open' ,'$filename' , '$filepath')") or die(mysql_error()); } // check is a messge sent correctly! if($sent) {print "Message Sent!"; } else {print "Message not sent, please try againl"; } mysql_close($db); ?> |
Close |
| The Science Network, 2012© | |