How to send register form to email within 24hours?

[mark103]

Hi guys,

I am working on my php script with the registerform so that I can send email to my clients, but the question is how I can submit the register form to be delay while it takes around 24 hours before it send the email to itself?

I am sure that it should be possible to do so, here's the code:

<?php
session_start();
    define('DB_HOST', 'localhost');
    define('DB_USER', 'myusername');
    define('DB_PASSWORD', 'mypassword');
    define('DB_DATABASE', 'mydbname');

$errmsg_arr = array();
$errflag = false;

$link = mysql_connect(DB_HOST, DB_USER, DB_PASSWORD);
if(!$link) {
  die('Failed to connect to server: ' . mysql_error());
    }

$db = mysql_select_db(DB_DATABASE);
if(!$db) {

die("Unable to select database");
    }

   function clean($var){

return mysql_real_escape_string(strip_tags($var));
    }
    $username = clean($_GET['username']);
    $password = clean($_GET['password']);
    $email = clean($_GET['email']);
    $firstname = clean($_GET['firstname']);
    $lastname = clean($_GET['lastname']);
    $country = clean($_GET['country']);


if($name == '' && $email == ''){
   // both are empty
   $errmsg_arr[] = 'Both name and email are missing. You must enter one or the other.';
   $errflag = true;
}

if($errflag) {
  $_SESSION['ERRMSG_ARR'] = $errmsg_arr;
  echo implode('<br />',$errmsg_arr);
   }
   else {
$insert = array();
if(isset($_GET['username'])) {
    $insert[] = 'username = \'' . clean($_GET['username']) .'\'';
}
if(isset($_GET['password'])) {
    $insert[] = 'password = \'' . clean($_GET['password']) .'\'';
}
if(isset($_GET['email'])) {
    $insert[] = 'email = \'' . clean($_GET['email']) . '\'';
}
if(isset($_GET['firstname'])) {
    $insert[] = 'firstname = \'' . clean($_GET['firstname']) . '\'';
}
if(isset($_GET['lastname'])) {
    $insert[] = 'lastname = \'' . clean($_GET['lastname']) . '\'';
}
if(isset($_GET['country'])) {
    $insert[] = 'country = \'' . clean($_GET['country']) . '\'';
}


if (count($insert)>0) {
   $names = implode(',',$insert);


if(isset($email)) {
   $firstname = $_GET['firstname'];
   $header .= 'From: Mysite Register <[e-mail]>' . chr(13) . chr(10); 
   $to = $email;
   $subject = "Thank you for Signing up with us";
   $message = "Dear $firstname, 

Thank you for signing up with us. We have received your request to get your confirmation code before you become an active member. Please wait within 24 hours.

Thank you for signing up with us,
The Site Team

Please do not reply to this e-mail address. Mail sent to this address cannot be answered and will returns as undelivered.";
   $header .= "MIME-Version: 1.0\l\n";
   $add = "-f". "[e-mail]";
   mail($to, $subject, $message, $header, $add);
echo "Thank you for signing up with us. Please check your email and get your confirmation code within 24 hours.";
  }
 }
}
?>

Any advice would be much appreciate.

Thanks,
Mark

[dalecosp]

Well, a simple, but pretty dumb perhaps, way to do it: [man]sleep/man for 86400 seconds...

Better to do this via cron(8) ... perhaps stick the info in a database and have cron check periodically if it needs to do anything with said data.

[dagon]

log it in a db, have a cron job run daily that checks the log with a time stamp and send as you like.

[Desdinova]

dalecosp;10973851 wrote:

Well, a simple, but pretty dumb perhaps, way to do it: [man]sleep/man for 86400 seconds...

Honestly I'm quite curious to see how this would work out! 😃

I'm guessing there'll be some issues though. Like the user waiting for the page to finish loading -- for 24 hours.

Additionally I think the server will either abort the request (timeout?) or keep the connection open (or reserved), which could create serious issues if your visitor count is relatively high, because of the max connections setting.

[mark103]

dagon;10973852 wrote:

log it in a db, have a cron job run daily that checks the log with a time stamp and send as you like.

Thanks for your help. Do you know how I can create a cron job for my php script to write into mysql database before it would send the email with register form itself?

As I am new on this so hope you can help me with this.

Cheers!

[dagon]

The cron job would send from the db, not write to it. you would modify the above to log what you need to log then a cron job to check the db and send. the script would be no different than any other except called via cron rather than by a user hitting a page.

[Desdinova]

On form submit, simply store the data in the database. Put a timestamp in the db as well for each record, so you can calculate when 24hrs have passed. Also put in a column that remembers if a user has been emailed or not.

Then create another file which would be the cronjob (for instance cron.php). In this script you query the database and get all the records with timestamp < (time() - 24hrs) and where the user has not been emailed yet. These are the records you'll need to send an email to.
Then just make sure your script does just that.

You can test the script by simply running the file in the browser.

If it works, call your hosting company, and tell them you want a cron setup for you that runs once a day. Tell them which file to run (make sure they know it's PHP), and they'll set it up for you.