set email
Posted: Wed Jun 10, 2009 5:08 pm
help
i want someone to be able to write an email and choose a time and date for it to be sent can someone help me on where to start.
here is what i need in my form
E-Mail to sent to:
Message:
Date of time to be sent :
i want to have a slider for the user to set a date,
i want this to be inserted into a database which will send the email to the recipient on the time and date they specified.
Can someone just give me some help on where to start.
so far ive got this
<?php
include "conninfo.php";//connects to my database
$timenow = time();
$query = mysql_query("SELECT * FROM send WHERE time='$timenow';");
while($query=mysql_fetch_array($query);) {
$to = "samuelrweast@hotmail.com";
$email = $query['email'];
$message = $query['message'];
$subject = = $query['subject'];
$time = = $query['time'];
$headers = //Include header info here..
mail($to, $email, $subject, $message, $time, $headers, -$from);
}
?>
//this is the form
<form method="POST" action="insert.php">
E-Mail:
<input type="text" name="email" id="email" size="19"><br>
<br>
<br>
Message:<br>
<textarea rows="9" name="message" id="message" cols="30"></textarea><br>
<br>
Subject:
<input type="text" name="subject" id="subject" size="19"><br>
<br>
Message to be sent after :
Days: <br>
<input type="text" name="day" id="min" size="10"><br>
<br>
Hours: <br>
<input type="text" name="hrs" id="hrs" size="10"><br>
<br>
Minutes: <br>
<input type="text" name="min" id="min" size="10"><br>
<br>
<input type="submit" value="Submit" name="submit">
</form>
//and this is the insert.php
<?php
include "conninfo.php";
$email = $_POST["email"];
$message = $_POST["message"];
$subject = $_POST["subject"];
$min = $_POST["min"];
$hrs = $_POST["hrs"];
$day = $_POST["day"];
if($min == 0) { $min='1'; }
if($hrs == 0) { $hrs='1'; }
if($day == 0) { $day='1'; }
$date = 60*$min*$hrs*$day;
$time = time() + $date;
$query = "INSERT INTO send (email, message, subject, time) VALUES ('$email', '$message', '$subject', '$time')";
mysql_query($query) or die('Error, insert query failed');
?>
i want someone to be able to write an email and choose a time and date for it to be sent can someone help me on where to start.
here is what i need in my form
E-Mail to sent to:
Message:
Date of time to be sent :
i want to have a slider for the user to set a date,
i want this to be inserted into a database which will send the email to the recipient on the time and date they specified.
Can someone just give me some help on where to start.
so far ive got this
<?php
include "conninfo.php";//connects to my database
$timenow = time();
$query = mysql_query("SELECT * FROM send WHERE time='$timenow';");
while($query=mysql_fetch_array($query);) {
$to = "samuelrweast@hotmail.com";
$email = $query['email'];
$message = $query['message'];
$subject = = $query['subject'];
$time = = $query['time'];
$headers = //Include header info here..
mail($to, $email, $subject, $message, $time, $headers, -$from);
}
?>
//this is the form
<form method="POST" action="insert.php">
E-Mail:
<input type="text" name="email" id="email" size="19"><br>
<br>
<br>
Message:<br>
<textarea rows="9" name="message" id="message" cols="30"></textarea><br>
<br>
Subject:
<input type="text" name="subject" id="subject" size="19"><br>
<br>
Message to be sent after :
Days: <br>
<input type="text" name="day" id="min" size="10"><br>
<br>
Hours: <br>
<input type="text" name="hrs" id="hrs" size="10"><br>
<br>
Minutes: <br>
<input type="text" name="min" id="min" size="10"><br>
<br>
<input type="submit" value="Submit" name="submit">
</form>
//and this is the insert.php
<?php
include "conninfo.php";
$email = $_POST["email"];
$message = $_POST["message"];
$subject = $_POST["subject"];
$min = $_POST["min"];
$hrs = $_POST["hrs"];
$day = $_POST["day"];
if($min == 0) { $min='1'; }
if($hrs == 0) { $hrs='1'; }
if($day == 0) { $day='1'; }
$date = 60*$min*$hrs*$day;
$time = time() + $date;
$query = "INSERT INTO send (email, message, subject, time) VALUES ('$email', '$message', '$subject', '$time')";
mysql_query($query) or die('Error, insert query failed');
?>