PHP - Sms Sender To Mysql Users

I have an auctions website and I want to create a feature that is similar to ebay in which users will receive an email if one of the auctions they are watching will end in less than 3 hours. I will be using a cron job to call up this page every 15 minutes. When the cron job executes, I would like it to send 1 email per auction to every user that has that auction on their watchlist if the auction will be ending in 3 hours. I don't know whether it needs to be a separate email for each user or one mass email where their emails are hidden.

The 4 tables in my database we are concerned about are "auctions, "users, "watchlists" and "products."

I am trying to use the script phpMailer to execute the code because I heard it was the best one. Anways here is what I have so far. I am missing alot because I had no clue what to do.


<?php
require("class.phpmailer.php");


$holder = mysql_connect("localhost", "user", "password");
mysql_select_db("database", $holder);

// NEED TO FIX THIS // Need to get ALL of the auction id's where the end time is less than 3 hours and the notification hasn't already been sent //
$auctionid = mysql_query("SELECT id FROM auctions WHERE DATE_ADD(NOW(), INTERVAL 3 HOUR) <= end_time AND notification = 0", $holder);

// get the auction title of  EACH of the auctions selected above which is not stored in the auctions table but in the products table..will be used for body of email /// AGAIN, NEED THIS TO GET ME ALL OF THE NAMES OF AUCTIONS THAT ARE ENDING IN 3 HOURS//
$auctiontitle = mysql_query("SELECT name FROM products LEFT JOIN auctions ON auctions.product_id=products.id WHERE auctions.id = $auctionid", $holder);

// PROBABLY NEED TO FIX THIS // Need to get ALL of the email addresses  who have ANY of the above auction ids on their watchlist //
$email = mysql_query("SELECT email FROM users LEFT JOIN watchlists ON users.id=watchlists.user_id WHERE watchlists.auction_id = $auctionid", $holder);

// Update the auctions table. Turn notification to 1 so the notification for that auction can't be sent again // AGAIN NEED THIS FOR ALL OF THE AUCTIONS ENDING IN 3 HOURS //
$query1="UPDATE auctions SET notification = '1' WHERE id = '$auctionid'";
mysql_query($query1) or die(mysql_error());



$mail = new PHPMailer();

$mail->From = "no-reply@domain.com";
$mail->FromName = "Site Name";


// Getting and error message for the foreach but I saw a similar example and this is what I was told to do // NEED THIS TO ADD EACH OF THE EMAIL ADDRESSES INDIVIDUALLY //
foreach ( $email as $recipients ) {
$mail->AddAddress ($recipients);
}
$mail->WordWrap = 50;                                 // set word wrap to 50 characters
$mail->IsHTML(true);                                  // set email format to HTML

$mail->Subject = "Your Watched Auction is Ending Soon";

// Sample Body // WANT TO DISPLAY THE TITLE OF THE AUCTION (NAME OF PRODUCT) FOR THE AUCTION ID USING $auctiontile FROM ABOVE //
$mail->Body    = "Your auction titled $auctiontile is ending soon";

// Same as above //
$mail->AltBody = Your auction titled $auctiontile is ending soon";


if(!$mail->Send())
{
   echo "Message could not be sent.";
   echo "Mailer Error: " . $mail->ErrorInfo;
   exit;
}

echo "Message has been sent";


?>

Hello fellow PHP Freaks 

Is there a way to assign mysql access privileges using a php script? Maybe when your registering a user and assign them a role, depending on the role, they get certain privileges on the db...
I need help.

Thank you in advance.

Hi All,

I've searched long and hard accross the web for an answer to this and finnally given in and requesting help. Here's what i have, i have a database setup and working fine. What i would like to do is for an administrator to be able to update my users details. It may sound odd, why don't you let your users update their own details? Well the administrators are dispatchers if you like, and my users are the 'dispatchees', for want of a better word. So i would like my administrators to be able to dispatch my users with routes and my users be able to see the routes that have been dispatched to them. I've setup a login area and a page that pulls there routes off the database, depending on their login details, i.e. jack will see his routes and jill will see her's independantly. This works by me editing the appropriate columns/rows of my database using phpmyadmin. What i'd like now is for administrators (who are directed to a seperate page, with more controls) to be able to do the same as me (updating the database) but by using a php form/script.

I'd like to be able to select the routes from a second table on the same database if possible, to try and keep everything tidy. So my dispatcher would select Route001 from a drop down list, this would fill in the text fields next to the route field with From To, so my dispatcher would know what route001 actually is from/ too, choose a username (now being driven from my other table) and hit dispatch. My user would login to their area, hit view dispatched routes and it would display Route 001 with the correct information.

The login area was a downloaded script i modified to suit and is called Login-Redirect_v1.31_FULL

Many thanks in advance, hope you can sort of understand what i want 

Josh

PHP/MySQL ability:Novice

Hello   I am trying to work out how many regular users I have to my site and how long those users tend to be users..   So, I have a table that logs every time a user visits my site and logs in, it stores the date / time as a unix timestamp and it logs their user id.   I started by getting the id's of any user who logs in more than 5 times in a specified period, but now I want to extend that...  

 
SELECT userID as user, count(userID) as logins FROM login_history where timestamp > UNIX_TIMESTAMP('2014-06-01 00:00:00') and timestamp < UNIX_TIMESTAMP('2014-07-01 00:00:00') group by user having logins > 5;
 

Hi I have sms website and i have add one button to my all single post button is working but the problem is the send button is going on another page i have create this code

<form action="http://uksmsserver.ismspoetry.com/" method="post"> <input name="go-content" type="hidden" value="<?php echo $new_content; ?>" /><div id="button"><input type="submit" value="Send this Sms to Mobile" /></div></form>

but i want to do i Wanna send single sms to This Page I have add This Sender In Iframe  And The Sender Scprit is showing on this page  http://ismspoetry.co...united-kingdom/
so i want to do if someone click on send sms to mobile button the msg goes will be on this sender if some one know please let me know thanks

I want to be able to reply to the sender of the information ( the guy who fills the form online ).

your help is much appreciated. here's the code


<?php
if(isset($_POST['submit'])) {

$from = 'From: contactform@nisbetplantation.com'; 
$to = "reservations@nisbetplantation.com";
$subject  =  "Website Contact Form"; 
$name_field = $_POST['name'];
$email_field  = $_POST['email'];
$address_field = $_POST['address'];
$address2_field = $_POST['address2'];
$city_field = $_POST['city'];
$state_field = $_POST['state'];
$zip_field =$_POST['zip'];
$company_field =$_POST['company'];
$IATA_field =$_POST['IATA'];
$phone_field =$_POST['phone'];
$fax_field =$_POST['fax'];
$mail_from="$email";
$response1_field =$_POST['response1'];
$areacode_field =$_POST['areacode'];
$comments_field =$_POST['comments'];
 
$body = "From: $name_field\n E-Mail: $email_field\n Address:\n $address_field Address2:\n $address2_field City:\n $city_field State:\n $state_field Zip:\n $zip_field Company:\n $company_field IATA:\n $IATA_field Phone:\n $phone_field Fax:\n $fax_field Visited Resort:\n $response1_field Area code:\n $areacode_field Comments:\n $comments_field'";
 
echo  "Your Information has been submitted to $to!";
mail($to, $subject, $body);

} else {

echo "Please try again after some time...";

}
?>

in my php mail i use this code:
$success = mail($EmailFrom, $Subject, $Body2, "From: <$EmailTo>");


and here are the variables for emial from and email to,
$EmailFrom = Trim(stripslashes($_POST['email'])); 
$EmailTo = "info@mydomain.co";


when the email is received the sender just appears as info@mydomain.co how can i have it say MSUKGroup Auto Responder or something? instead of just repeat the address?

well... some part works! when i check my email, it says "nobody" instead of the senders email and it is not showing the right subject and the company field wont show up


here is my html code

thanks ~

Code


Quote

<form action="contact.php" method="POST" id="contactform">
            <ol>
              <li>
                <label for="name">First Name <span class="red">*</span></label>
                <input id="name" name="name" class="text" />
              </li>
              <li>
                <label for="email">Your email <span class="red">*</span></label>
                <input id="email" name="email" class="text" />
              </li>
              <li>
                <label for="company">Company</label>
                <input id="company" name="company" class="text" />
              </li>
              <li>
                <label for="subject">Subject</label>
                <input id="subject" name="subject" class="text" />
              </li>
              <li>
                <label for="message">Message <span class="red">*</span></label>
                <textarea id="message" name="message" rows="6" cols="50"></textarea>
              </li>
              <li class="buttons">
                <input type="image" name="imageField" id="imageField" src="images/send.gif" class="send" />
                <div class="clr"></div>
              </li>
          </ol>
        </form>




here is my php

Code


<?php

if(!$_POST) exit;

$email = $_POST['email'];


//$error[] = preg_match('/\b[A-Z0-9._%-]+@[A-Z0-9.-]+\.[A-Z]{2,4}\b/i', $_POST['email']) ? '' : 'INVALID EMAIL ADDRESS';
if(!eregi("^[a-z0-9]+([_\\.-][a-z0-9]+)*" ."@"."([a-z0-9]+([\.-][a-z0-9]+)*)+"."\\.[a-z]{2,}"."$",$email )){
$error.="Invalid email address entered";
$errors=1;
}
if($errors==1) echo $error;
else{
$values = array ('name','email','message');
$required = array('name','email','message');
 
$your_email = "gilbylu@gmail.com";
$email_subject = "New Message: ".$_POST['subject'];
$email_content = "new message:\n";

foreach($values as $key => $value){
  if(in_array($value,$required)){
if ($key != 'subject' && $key != 'company') {
  if( empty($_POST[$value]) ) { echo 'PLEASE FILL IN REQUIRED FIELDS'; exit; }
}
$email_content .= $value.': '.$_POST[$value]."\n";
  }
}
 
if(@mail($your_email,$email_subject,$email_content)) {
echo 'Message sent!'; 
} else {
echo 'ERROR!';
}
}
?>

I'm having a rough time getting an AS3 application working with a PHP script.

The PHP script takes POST variables and then sends an email using SMTP.

When running it through a standard HTML form, the PHP side works perfectly.

However, when I send the exact same POST variables through AS3 to the script, I get this error.

Failed to set sender: phpemailtesting@gmail.com [SMTP: Failed to write to socket: not connected (code: -1, response: )]

So, I'm not really sure what the issue is here... Here's some code that might help.

//print_r($_POST);
require_once('Mail-1.2.0/Mail.php');

$from = isset($_POST['emailfrom']) ? $_POST['emailfrom'] : '';
$to = isset($_POST['emailsubject']) ? $_POST['emailto'] : '';
$bcc = isset($_POST['bcc'])? $_POST['bcc'] : '';
$subject = isset($_POST['emailsubject']) ? $_POST['emailsubject'] : '';
$body = isset($_POST['emailbody']) ? $_POST['emailbody'] : '';
$ssl = isset($_POST['ssl']) ? $_POST['ssl'].'://' : '';
$smtp_server = isset($_POST['smtpserver']) ? $_POST['smtpserver'] : '';
$password = isset($_POST['emailpassword']) ? $_POST['emailpassword'] : '';
$port = isset($_POST['port']) ? $_POST['port'] : '';
$success_counter = 0;
$fail_counter = 0;
$bigerror;

if($from!='' && $to!='' && $subject!='' && $body!='' && $smtp_server!='' && $password!='' && $port!='') {
if($bcc!='') {
$bcc_array = explode(',',$bcc);
}
$host = $ssl . $smtp_server;
$smtp = Mail::factory('smtp', array('host'=>$host, 'port'=>$port, 'auth'=>true, 'username'=>$from, 'password'=>$password));

$header = array('From'=>$from, 'To'=>$to, 'Subject'=>$subject);
$mail = $smtp->send($to, $header, $body);

        if (PEAR::isError($mail)) {
$bigerror = $mail->getMessage();
$fail_counter++;
           //echo("<p>Message failed".$to." :<br />" . $mail->getMessage() . "</p>");
        } else {
$success_counter++;
         //echo("<p>Message successfully sent to <b>". $to ."</b>!</p>");
        }

for($counter=0; $counter<count($bcc_array) && $counter<=99; $counter++) {
$header = array('From'=>$from, 'To'=>$bcc_array[$counter], 'Subject'=>$subject);
$mail = $smtp->send($bcc_array[$counter], $header, $body);

if (PEAR::isError($mail)) {
$bigerror = $mail->getMessage();
//echo("<p>Message failed".$bcc_array[$counter]." :<br />" . $mail->getMessage() . "</p>");
$fail_counter++;
} else {
         //echo("<p>Message successfully sent to <b>". $bcc_array[$counter] ."</b>!</p>");
$success_counter++;
}
}
//echo "<br /><br />Successful emails: " . $success_counter;
//echo "<br />Failed emails: " . $fail_counter;
echo $success_counter.",".$fail_counter.",".$bigerror;
} else {
echo "error";
//echo '<p>Some information is missing, please try again!</p>';
}


Then, the AS if anybody's interested in seeing it.

Code: [Select]
//Create loader to load emailer.php
var loader:URLLoader = new URLLoader(); 
var request:URLRequest = new URLRequest("http://tendollartools.com/testmail/emailer.php"); 

//Create POST variables
var variables:URLVariables = new URLVariables(); 
variables.emailfrom = preferences["smtpLogin"];
variables.emailto = preferences["smtpLogin"];
variables.smtpserver = preferences["smtpServer"];
variables.emailpassword = preferences["smtpPassword"];
variables.ssl = preferences["smtpSSL"];
variables.port = preferences["smtpPort"];
variables.bcc = emails;
variables.emailsubject = preferences["emailSubject"];
variables.emailbody = preferences["emailBody"];

//Set method to POST and set variables as the vars to send to emailer.php
request.method = URLRequestMethod.POST;
request.data = variables; 

//Load emailer.php and run the onEmailComplete function when finished loading
loader.dataFormat = URLLoaderDataFormat.TEXT;
loader.addEventListener(Event.COMPLETE, onEmailComplete); 
loader.load(request);
The preferences object has all the correct information in it... so this is where I'm confused. Why will the exact same POST information work from an HTML form, but not when sent through AS?

hello PHP geniuses! I am new to this whole thing... so please be patient with me
I have a form that is working great.... there are just a couple of things that I would like it to do that I can't figure out. PHP is still a mystery to me, but I am trying to learn. If I include the code, I am hoping someone can help.
I would like to know if I can
1. cc the sender the form details
2. pull form data to create the subject line

This is a HiQform, with attachments...

My HTML:
Code: [Select]
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Studio Job Ticket</title>
<link rel="stylesheet" type="text/css" href="view.css" media="all">
<script type="text/javascript" src="view.js"></script>
<script type="text/javascript" src="calendar.js"></script>

</head>
<body id="main_body" >

<img id="top" src="top.png" alt="">
<div id="form_container">

  <h1><a>Studio Job Ticket</a></h1>
  <form id="studio job ticket" class="appnitro" enctype="multipart/form-data" method="post" action="HiQFM.php">
<div class="form_description">
        <input type=hidden name="recipient" value="dayle_sheward@rogers.com,dayle.sheward@juniperpark.com">
        <input type="hidden" name="redirect" value="http://dayle.me/form/thankyou.html">
        <input type="hidden" name="form_format" value="html">
        <input type="hidden" name="MAX_FILE_SIZE" value="1000000">
        <input type="hidden" name="path_to_file" value="http://dayle.me/form/TEMP_FILES">
        <input type="hidden" name="subject" value="Studio Job Ticket">
        <input type=hidden name="style_sheet" value="view.css">
       
<br />
          <h2>Studio Job Ticket</h2>
<p>The purpose of this form is to ensure the Juniper Park Studio receives all
  necessary
  files and information needed for dockets to be done in timely and
  accurate fashion.
  Please provide as <br />
  much information
  as possible.</p>
<p>Once this job ticket is received, you will be contacted by phone or email, confirming
    your job is <br />
    in progress, with a rough estimate on when you can expect the first proof. </p>
        </div>
    <ul >
<li class="description" id="li_1" >
    <label class="description" for="account manager">Account Manager</label>
  <span>
  <input id="first name" name= "first name" class="element text" maxlength="255" size="10" value=""/>
  <label>First</label>
      </span> <span>
  <input id="last name" name= "last name" class="element text" maxlength="255" size="14" value=""/>
  <label>Last</label>
   </span> </li>
<li id="li_2" >
    <label class="description" for="email">Email</label>
    <div>
  <input id="email" name="email" class="element text" type="text" maxlength="255" value=""/>
      </div>
  </li>
<li id="li_3" >
<label class="description" for="job">Job</label>
  <span>
  <input id="client" name= "client" class="element text" maxlength="255" size="8" value=""/>
<label>Client</label>
      </span> <span>
    <input id="brand" name= "brand" class="element text" maxlength="255" size="14" value=""/>
    <label>Brand</label>
      </span> </li>
<li id="li_4" >
  <label class="description" for="media type">Media Type</label>
  <div>
    <select class="element select medium" id="media type" name="media type">
      <option value=""selected="selected"></option>
      <option value="Award Work" >Awards Work</option>
      <option value="Collateral" >Collateral</option>
      <option value="OOH" >OOH</option>
              <option value="Print" >Print</option>
      <option value="Retouching" >Retouching</option>
              <option value="Photography" >Photography</option>
        </select>
      </div>
  </li>
<li id="li_5" >
          <label class="description" for="docket">Docket (work cannot start without this)</label>
          <div>
          <input id="docket" name="docket" class="element text" type="text" maxlength="255" value=""/>
          </div>
        </li>
<li id="li_6" >
  <label class="description" for="job">Creative Team</label>
  <span>
    <input id="AD" name= "AD" class="element text" maxlength="255" size="14" value=""/>
    <label>AD</label>
      </span> <span>
      <input id="Writer" name= "Writer" class="element text" maxlength="255" size="14" value=""/>
      <label>Writer</label>
      </span></li>
<li id="li_7" >
<label class="description" for="Supplied">Additional Information to Supply</label>
<span>
<input id="copy deck" name="copy deck" class="element checkbox" type="checkbox" value="1" />
<label class="choice" for="element_6_1">Copy Deck</label>
<input id="spec sheet" name="spec sheet" class="element checkbox" type="checkbox" value="1" />
<label class="choice" for="element_6_2">Spec Sheet</label>
<input id="ma" name="ma" class="element checkbox" type="checkbox" value="1" />
<label class="choice" for="element_6_3">MA</label>
        <input id="creative files" name="creative files" class="element checkbox" type="checkbox" value="1" />
<label class="choice" for="element_6_3">Creative Files</label>
  Please specify location files:</span></li>
<li >
  <div>
        <input id="creative file location" name="creative file location" class="element text" type="text" maxlength="255" value=""/>
        or<br />
        <input id="emailedYN" name="emailedYN" class="element checkbox" type="checkbox" value="1" />
        <label class="choice" for="emailedYN">Check if to be Emailed</label>
          </div>
          </li> <li id="li_7" >
<label class="description" for="upload">Upload a File </label>
<div>
  <input id="attachment" name="attachment[]" class="element file" type="file"/>
</div>
      </li> <li id="li_3" >
<label class="description" for="due date">Due Date </label>
<span>
<input id="element_3_1" name="MM" class="element text" size="2" maxlength="2" value="" type="text"> /
<label for="element_3_1">MM</label>
</span>
<span>
<input id="element_3_2" name="DD" class="element text" size="2" maxlength="2" value="" type="text"> /
<label for="element_3_2">DD</label>
</span>
<span>
<input id="element_3_3" name="YYYY" class="element text" size="4" maxlength="4" value="" type="text">
<label for="element_3_3">YYYY</label>
</span>

<span id="calendar_3">
<img id="cal_img_3" class="datepicker" src="calendar.gif" alt="Pick a date.">
</span>
<script type="text/javascript">
Calendar.setup({
inputField : "element_3_3",
baseField    : "element_3",
displayArea  : "calendar_3",
button : "cal_img_3",
ifFormat : "%B %e, %Y",
onSelect : selectDate
});
</script>
<li id="li_10" >
<label class="description" for="element_10">Production Details</label>

<div class="left">
<input id="trim" name="trim" class="element text" value="" type="text">
<label for="trim">Trim Size (width x height)</label>
</div>

<div class="right">
<input id="live" name="live" class="element text" value="" type="text">
<label for="live">Live (width x height)</label>
</div>

<div class="left">
<input id="bleed" name="bleed" class="element text" value="" type="text">
<label for="bleed">Bleed (width x height)</label>
</div>

<div class="right">
<input id="#mechanicals" name="#mechanicals" class="element text" value="" type="text">
<label for="#mechanicals"># of Mechanicals
    (if multiple, please provide a MA or spreadsheet)</label>
</div>
        <div class="left">
<input id="die line" name="die line" class="element text" value="" type="text">
<label for="die line">Die Line</label>
</div>

<div class="right">
<input id="PU docket" name="PU docket" class="element text" value="" type="text">
<label for="PU docket">Pick-Up docket</label>
</div>
       

<div class="left">
<input id="FilesReq" name="FilesReq" class="element text" maxlength="15" value="" type="text">
<label for="FilesReq">To supply raw collected files or PDFX1a</label>
</div>

<div class="right">
<select class="element select medium" id="delivery" name="delivery" onClick='alert("Please provide all deliverable details, such as FTP/emails etc.; info in the ADDITIONAL INFO area below.")'>
<option value="" selected="selected"></option>
<option value="File Cargo" >File Cargo</option>
<option value="FTP" >FTP</option>
<option value="Email" >Email</option>
<option value="Temp Folder" >Temp Folder</option>
<option value="Disk" >Disk</option>


</select>
<label for="deliverable info">Deliverable Info</label>
</div>
</li>
</li>
<li id="li_13" >
  <label class="description" for="Additional">Additional Info</label>
  <div>
    <textarea id="Additional" name="Additional" class="element textarea medium"></textarea>
      </div>
  </li>
    </ul>
<p>
<label for="userCopyMe">Check the box if you wish to be sent a copy of this message</label>
<br />
<input type="checkbox" name="userCopyMe" id="userCopyMe" value="1" <?php if ($userCopyMe == "1") { echo "checked=\"checked\""; }?> />
</p>
    <li class="buttons" id="saveForm">
              <input type="reset" value="Reset" >
      <input id="saveForm" class="button_text" type="submit" name="submit" value="Submit" onclick="verify();">
    </li>
    </ul>
  </form>
<div id="footer"></div>
</div>
<img id="bottom" src="bottom.png" alt="">
</body>
    <name="form_delivery" value="digest"/>
</form>
</html>
Thanks in advance!

EDIT: pinche code tags.

what line of code should i add in order to be able to reply to the sender of contact form. right now its showing the last email created in the server.

heres the code

<?php

$where_form_is="http://".$_SERVER['SERVER_NAME'].strrev(strstr(strrev($_SERVER['PHP_SELF']),"/"));

// Checkbox handling
$field_1_opts = $_POST['field_1'][0].",". $_POST['field_1'][1];

mail("randy@reefsclub.com","Invitation - Form submission","Form data:

rooms: $field_1_opts
First Name: " . $_POST['fname'] . "
Last Name: " . $_POST['lname'] . "
Your Email: " . $_POST['email'] . " 
Phone Number: " . $_POST['pnumber'] . "
Request your arrival date: " . $_POST['field_2'] . "
Request your departure date: " . $_POST['field_3'] . "
Please send me an ownership package: " . $_POST['field_4'] . "

",$headers); include ("confirm.html");

?>

I would like to send a copy of the mail contents to sender. The mail is sent to me but not the sender. Below is my code but not sure where the error in code is  . Any help would be great

Thanks

 

<?php
 
if(isset($_POST['g-recaptcha-response']) && !empty($_POST['g-recaptcha-response']))
if(empty($_POST[‘g-recaptcha-response’])){
$errMsg = 'Please check the robot checkbox.';
} else if(isset($_POST[‘g-recaptcha-response’]) && !empty($_POST[‘g-recaptcha-response’]))
  {
        $secret = 'secret code';
        $verifyResponse = file_get_contents('https://www.google.com/recaptcha/api/siteverify?secret='.$secret.'&response='.$_POST['g-recaptcha-response']);
        $responseData = json_decode($verifyResponse);
        if($responseData->success)
        {
            $succMsg = 'Your contact request have submitted successfully.';
        }
        else
        {
            $errMsg = 'Robot verification failed, please try again.';
        }
   }
if(isset($_POST['email'])) {
 
    // EDIT THE 2 LINES BELOW AS REQUIRED
    $email_to = "email@gmail.com";
    $email_subject = "Online Contact Form";
   $email_subject2 = "Please find a copy of the contact form you submitted";

    function died($error) {
        // your error code can go here
        echo "We are very sorry, but there were error(s) found with the form you submitted. ";
        echo "These errors appear below.<br /><br />";
        echo $error."<br /><br />";
        echo "Please go back and fix these errors.<br /><br />";
        die();
    }
 
 
    // validation expected data exists
    if(!isset($_POST['first_name']) ||
        !isset($_POST['last_name']) ||
        !isset($_POST['email']) ||
        !isset($_POST['telephone']) ||
        !isset($_POST['comments'])) {
        died('We are sorry, but there appears to be a problem with the form you submitted.');       
    }
 
     
 
    $first_name = $_POST['first_name']; // required
    $last_name = $_POST['last_name']; // required
    $email_from = $_POST['email']; // required
    $telephone = $_POST['telephone']; // not required
    $comments = $_POST['comments']; // required
 
    $error_message = "";
    $email_exp = '/^[A-Za-z0-9._%-]+@[A-Za-z0-9.-]+\.[A-Za-z]{2,4}$/';
 
  if(!preg_match($email_exp,$email_from)) {
    $error_message .= 'The Email Address you entered does not appear to be valid.<br />';
  }
 
    $string_exp = "/^[A-Za-z .'-]+$/";
 
  if(!preg_match($string_exp,$first_name)) {
    $error_message .= 'The First Name you entered does not appear to be valid.<br />';
  }
 
  if(!preg_match($string_exp,$last_name)) {
    $error_message .= 'The Last Name you entered does not appear to be valid.<br />';
  }
 
  if(strlen($comments) < 2) {
    $error_message .= 'The Comments you entered do not appear to be valid.<br />';
  }
 
  if(strlen($error_message) > 0) {
    died($error_message);
  }
 
    $email_message = "Form details below.\n\n";
 
     
    function clean_string($string) {
      $bad = array("content-type","bcc:","to:","cc:","href");
      return str_replace($bad,"",$string);
    }
 
     
 
    $email_message .= "First Name: ".clean_string($first_name)."\n";
    $email_message .= "Last Name: ".clean_string($last_name)."\n";
    $email_message .= "Email: ".clean_string($email_from)."\n";
    $email_message .= "Telephone: ".clean_string($telephone)."\n";
    $email_message .= "Comments: ".clean_string($comments)."\n";
 
// create email headers
$headers = 'From: '.$email_from."\r\n".
$headers2 = "From:" . $email_to;
'Reply-To: '.$email_from."\r\n" .
'X-Mailer: PHP/' . phpversion();
@mail($email_from, $email_subject2, $email_message, $headers2);
@mail($email_to, $email_subject, $email_message, $headers);
header("Location: contact-thank-you.html"); 
?>
 
 
Thank you for contacting us. We will be in touch with you very soon.
 
<?php
 
}
?>

Edited August 15, 2020 by bizstorm

I'm using the php mail function and sending to Gmail accounts it shows "Unknown Sender"

This is my header:
Code: [Select]
$headers = "From: XXXXX\r\nReply-To: XXXX@XXXXX.com";
$headers .= "\r\nContent-Type: text/html; charset='iso-8859-1' Content-Transfer-Encoding: 7bit";

I read somewhere that removing the "\r" would work but no luck...

any  help would be awesome

I have a mysql table which will store users email addresses (each is unique and is the primary field) and a timestamp. 
I have added another column called `'unique_code' (varchar(64), utf8_unicode_ci)`.

What I would very much appreciate assistance with is;

a) Generating a 5 digit alphanumeric code, ie: 5ABH6 
b) Check all rows the 'unique_code' column to ensure it is unique, otherwise re-generate and check again 
c) Insert the uniquely generated 5 digit alphanumeric code into `'unique_code'` column, corresponding to the email address just entered. 
d) display the code on screen.

What code must I put and where?


**My current php is as follows:**

Code: [Select]
    require "includes/connect.php";
   
    $msg = '';
   
    if($_POST['email']){
   
    // Requested with AJAX:
    $ajax = ($_SERVER['HTTP_X_REQUESTED_WITH']  == 'XMLHttpRequest');
   
    try{
    if(!filter_input(INPUT_POST,'email',FILTER_VALIDATE_EMAIL)){
    throw new Exception('Invalid Email!');
    }
   
    $mysqli->query("INSERT INTO coming_soon_emails
    SET email='".$mysqli->real_escape_string($_POST['email'])."'");
   
    if($mysqli->affected_rows != 1){
    throw new Exception('You are already on the notification list.');
    }
   
    if($ajax){
    die('{"status":1}');
    }
   
    $msg = "Thank you!";
   
    }
    catch (Exception $e){
   
    if($ajax){
    die(json_encode(array('error'=>$e->getMessage())));
    }
   
    $msg = $e->getMessage();
    }
    }

Hi all, I am wondering what the best way to do this is...

Take GoDaddy for example, if your domain is about to expire you will get an automatic email.

I am wanting to do something similar, If someone orders a Soap Dispenser, I want to send an email (if they accept to receiving emails on the order) each month asking/reminding them to top up on soap.

I have been reading but cant find anything adequate, I have seen something about Cron Jobs, but never heard of this before, please could you point me in the right direction.

Thanks in advance.

Peter