Kristoff1875

Going to give it a go now. Cheers

So it's as I guessed at earlier. it's because of the header? Many thanks berridgeab, will give it a try.

Still nothing, not sure why. No error either.

As shown above, i'm using this to call the page with the email: <? // Connects to your Database mysql_connect("localhost", "***", "***") or die(mysql_error()); mysql_select_db("***") or die(mysql_error()); $data = mysql_query("SELECT * FROM completed WHERE followupsent='0000-00-00 00:00:00' AND DATE(valuesent) < DATE_SUB( NOW(), INTERVAL 7 DAY )") or die(mysql_error()); while($info = mysql_fetch_array( $data )) { $id = $info['id']; header ("Location: followupemailauto.php?id=$id"); } ?> Then on "followupemailauto.php" : <? $id = $_GET['id']; $pagefrom = $_SERVER['HTTP_REFERER']; // . (!empty($info['contactother']) ? // Connects to your Database mysql_connect("localhost", "***", "***") or die(mysql_error()); mysql_select_db("***") or die(mysql_error()); $data = mysql_query("SELECT * FROM completed WHERE id='$id'") or die(mysql_error()); if($info = mysql_fetch_array( $data )) if ($info['valuation'] != ""){ $body='***email content***'; $subject = 'Subject'; $message = $body; $headers = 'MIME-Version: 1.0' . "\r\n"; $headers .= 'Content-type: text/html; charset=iso-8859-1' . "\r\n"; $headers .= 'From: **** <noreply@****.com>' . "\r\n"; mail( $info['email'],$subject,$message,$headers ); mysql_connect("localhost", "***", "***") or die(mysql_error()); mysql_select_db("***") or die(mysql_error()); $update = mysql_query("UPDATE completed SET followupsent = NOW() WHERE id = '$id'") or die(mysql_error()); } ?> Works perfect, no errors when you go to the page that is being called in the cron job, but the cron job doesn't seem to be processing it. As I said before, i'm new to using Cron Jobs, could it be because i'm setting a header where the actual process takes place?

That was the entire error message. I've spoken to my hosting who have given me a new line, which isn't emailing any error messages, but is not running the script as it does when I open the page manually. Stumped!!

Out of ideas regarding the cron jobs thing so any help appreciated. The closest I think i've got is: PHP: Error parsing /home/****/followup.php on line 4 Which I guess was reading the file but not properly? Line 4 is: mysql_connect("localhost", "***", "***") or die(mysql_error());

Right, got the php to run correctly and find the requested rows that are older than a week and only if the initial email has already been sent. Tested in browser it works properly and sends the email. Tried to put it in to cron jobs in cpanel using the following: php -q /home/***/followup.php where *** = full path but i'm getting an email coming through saying "No input file specified." Any ideas? It's the correct file name and i'm fairly sure the directory is correct as I was getting "Not a directory" before?

I'm an idiot, just spotted info/data doesn't match up! Edit: Right, I think the code i'm using for week old dates is wrong. Going to look for the correct way.

Hi i'm having a go at this, but getting no output from the emails. Currently including the email file in to the file that processes the request that will be called in the CRON JOB, but I think there must be a better way of doing what i'm doing. Is there a way to say foreach row, send the email? Must be a better way of doing what i'm doing as it seems so long way round! See below for what i'm currently doing: <? // Connects to your Database mysql_connect("localhost", "****", "****") or die(mysql_error()); mysql_select_db("****") or die(mysql_error()); $data = mysql_query("SELECT * FROM completed WHERE followupsent='0000-00-00 00:00:00' AND valuesent = DATE_SUB(NOW(), INTERVAL 7 DAY)") or die(mysql_error()); while($info = mysql_fetch_array( $data )) { include 'followupemail.php?id='.$data['id'].''; } ?> followupsent is by default 0000-00-00 00:00:00 so i'm checking to make sure the follow up has not been sent yet, and then checking valuesent to see if it's 7 days since the first email was sent.

Awesome thanks. I pretty much have the emails in their own files, just that there is the code telling the email to send etc. I'll look in to cron jobs tomorrow. Can I still use a button on the admin side to send the initial email?

I send the NOW time and date to the database when the first email is sent. I've used Cron Jobs before but never set something up in a script that i've done myself. If I set up a cron job for it, would I just tell it to run the page that sends the email for each member that it needs to? Thanks for the advice, I thought it'd be cron jobs, but never used it on my own script!

Hi, I currently have a page in an admin section, with members details, and 2 buttons. When you set a value in a field, then click the first button, it navigates to a php page which sends a HTML email to the member's email address with the value from the field and then directs back to the previous page. The second button when clicked, does the same, but with a different email. This is a follow up email, a reminder, to the first. My dilemma is, how would I get the follow up email to send automatically 7 days after the first email is sent? Is there a way? Many thanks in advance!

Perfect thank you.

Ah ok, so does it doesn't grab the results from the xml? As the page that calls the page that has the code above, then calls the results as follows: $xml = simplexml_load_string($str); $vrm = (string)$xml->DataArea->Vehicles->Vehicle->VRM_Curr; $make = (string)$xml->DataArea->Vehicles->Vehicle->DVLA_Make; $model = (string)$xml->DataArea->Vehicles->Vehicle->DVLA_Model; So would that mean the way that handles need changing?

It may also be important to mention i'm posting the url with the username etc at the end, for example: url1?strUserName=username&strPassword=password&etc

Here's what i've tried: $feeds = array('url1?','url2?'); $fields = array( 'strUserName'=>urlencode('username'), 'strPassword'=>urlencode('password'), 'strClientRef'=>urlencode('ref'), 'strClientDescription'=>urlencode('desc'), 'strKey1'=>urlencode('key'), 'strVersion'=>urlencode('version'), 'strVRM'=>urlencode($vrm) ); foreach($fields as $key=>$value) { $fields_string .= $key.'='.$value.'&'; } rtrim($fields_string,'&'); do { $ch = curl_init(); curl_setopt($ch,CURLOPT_CONNECTTIMEOUT,1); // 1 second timeout I'm impatient curl_setopt($ch,CURLOPT_URL,current($feeds)); curl_setopt($ch,CURLOPT_RETURNTRANSFER,TRUE); curl_setopt($ch,CURLOPT_POST,count($fields)); curl_setopt($ch,CURLOPT_POSTFIELDS,$fields_string); $result = curl_exec($ch); } while( $result === FALSE && next($feeds) !== FALSE ); curl_close($ch); $str = ob_get_contents(); ob_end_clean(); The errors etc are handled by the next page: But seemingly it's not grabbing any info with what i'm using.

I normally would have tried before doing anything, but was on hold with Go Daddy for half an hour and had literally just been connected as I read your post.

Well, thanks for the great help (genuine) and the snooty follow up (sarcasm)!

Will that only try the second if the first doesn't work? Thanks

Currently using the following which is working fine: //set POST variables $url = 'primaryurl.com'; $fields = array( 'strUserName'=>urlencode('***'), 'strPassword'=>urlencode('***'), 'strClientRef'=>urlencode('***'), 'strClientDescription'=>urlencode('***'), 'strKey1'=>urlencode('***'), 'strVersion'=>urlencode('***'), 'strVRM'=>urlencode(***) ); //url-ify the data for the POST foreach($fields as $key=>$value) { $fields_string .= $key.'='.$value.'&'; } rtrim($fields_string,'&'); //open connection $ch = curl_init(); //set the url, number of POST vars, POST data curl_setopt($ch,CURLOPT_URL,$url); curl_setopt($ch,CURLOPT_POST,count($fields)); curl_setopt($ch,CURLOPT_POSTFIELDS,$fields_string); //execute post $result = curl_exec($ch); How would I go about adding in a backup url incase the first is down? Can I add it to the $url tag? Or would I be best to add $backupurl and then using it in the following part: //set the url, number of POST vars, POST data curl_setopt($ch,CURLOPT_URL,$url); curl_setopt($ch,CURLOPT_POST,count($fields)); curl_setopt($ch,CURLOPT_POSTFIELDS,$fields_string); Saying if $url gives a response then use it, if not then use $backupurl? Any help appreciated massively.

Yep, I know that. Sorry, like I said, it's nearly 6.30am now, I should get some sleep and carry on tomorrow! I did of course know they need quotes, but I couldn't take in what you actually meant!

I'm going to blame the fact that it's just turning 6am here as to the reason that I don't really grasp that question completely!!

Right, whatever i've done differently (Thanks to you!) is now meaning the implode function is working and when echoed is showing a list that i'm seperating with commas. So do I just add "$implodedvalue" to the database where I want the results?

I tried the implode function and it just failed on me before. Do I do it just before I send the data to the database? As I'm passing these details to the final page of a multipage form using a session. So at the moment I have: $_SESSION['damage'] =$_POST['damage']; So $_SESSION['damage'] is holding the array. Should I strip it out of there and then work with $damage again?

Haha, now I just feel dumb. The difference using echo $damage[0]; and echo $damage; is massive!! My issue with that kind of still stands now though, in that when submitted to the database, it'll still submit as "Array". From my understanding (that may be wrong!) I think I need to extract everything from inside the array before I post it to the database? Or would I just set a foreach statement and say "foreach $damage[] send to this field"?