PHP - Php: Query For Sending Email

Hallo There,

I have some code I got from the internet a while ago. The code works as follow:

1.) The script runs from the command prompt (Linux) with a contab service
2.) It executes a specified SQL query against a MySQL database server
3.) Formats the output of the result set into an html table
4.) Sends the result to an email address

I am not a programmer :-(
I have been using the code with great success for some time, but it has the following bug: On certain email clients it displays as text and not as an html email. Especially on mac operated systems and iPhones/iPADs etc.

Any assistance would be greatly appreciated.

Thanks in advance
CW

<code starts>

<?php

//define the receiver of the email
$to = 'receiver@mail.com';

//define the subject of the email
$subject = 'My Subject';

//create a boundary string. It must be unique
//so we use the MD5 algorithm to generate a random hash
$random_hash = md5(date('r', time()));

//define the headers we want passed. Note that they are separated with \r\n
$headers = "From: sernder@mail.com\r\nReply-To: noreply@mail.com";

//add boundary string and mime type specification
$headers .= "\r\nContent-Type: multipart/alternative; boundary=\"PHP-alt-".$random_hash."\"";

//define the body of the message.
ob_start(); //Turn on output buffering
?>
--PHP-alt-<?php echo $random_hash; ?>
Content-Type: text/html; charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

<h2>Some text for heading...</h2>

<?php

//Call the function like this:
echo SQLResultTable("SELECT * from table_name;");
function SQLResultTable($Query)
{
//mysql user variables
$HOST = "localhost";
$USER = "mysqluser";
$PASS = "password";
$DB = "database";

    $link = mysql_connect($HOST, $USER, $PASS) or die('Could not connect: ' . mysql_error());   //build MySQL Link
    mysql_select_db($DB) or die('Could not select database');        //select database
    $Table = "";  //initialize table variable

    $Table.= "<table border='1' style=\"border-collapse: collapse;\">"; //Open HTML Table

    $Result = mysql_query($Query); //Execute the query
    if(mysql_error())
    {
        $Table.= "<tr><td>MySQL ERROR: " . mysql_error() . "</td></tr>";
    }
    else
    {
        //Header Row with Field Names
        $NumFields = mysql_num_fields($Result);
        $Table.= "<tr style=\"background-color: #000066; color: #FFFFFF;\">";
        for ($i=0; $i < $NumFields; $i++)
        {
            $Table.= "<th>" . mysql_field_name($Result, $i) . "</th>";
        }
        $Table.= "</tr>";

        //Loop thru results
        $RowCt = 0; //Row Counter
        while($Row = mysql_fetch_assoc($Result))
        {
            //Alternate colors for rows
            if($RowCt++ % 2 == 0) $Style = "background-color: #00CCCC;";
            else $Style = "background-color: #0099CC;";

            $Table.= "<tr style=\"$Style\">";
            //Loop thru each field
            foreach($Row as $field => $value)
            {
                $Table.= "<td>$value</td>";
            }
            $Table.= "</tr>";
        }
        $Table.= "<tr style=\"background-color: #000066; color: #FFFFFF;\"><td colspan='$NumFields'>Query Returned " . mysql_num_rows($Result) . " records</td></tr>";
    }
    $Table.= "</table>";

    return $Table;
}
?>
<h2>Disclaimer</h2>
<p>

Some text ... This is my Discaimer (footer)...

</p>
--PHP-alt-<?php echo $random_hash; ?>--
<?
//copy current buffer contents into $message variable and delete current output buffer
$message = ob_get_clean();
//send the email
$mail_sent = @mail( $to, $subject, $message, $headers );
//if the message is sent successfully print "Mail sent". Otherwise print "Mail failed"
echo $mail_sent ? "Mail sent" : "Mail failed";
?>



</code ends>

From our website we are connecting to GMAIL to send our emails through SMTP. For some reason it is not sending the emails to the CC or BCC email address event though GMAIL shows it was included in the email. Am I missing something in the below code?

Code: [Select]
$currentTime = time();

$emailTo = "redbrad0@domain.com";
$emailCC = "brad@domain.com";
$emailBCC = "events@domain.com";
$emailSubject = "TEST Email at (" . $currentTime . ")";
$emailBody = "This is the body of the email";

$headers = array();
if (!empty($emailTo))
$headers['TO'] = $emailTo;
if (!empty($emailCC))
$headers['CC'] = $emailCC;
if (!empty($emailBCC))
$headers['BCC'] = $emailBCC;
if (!empty($emailSubject))
$headers['Subject'] = $emailSubject;
$headers['From'] = "events@domain.com";

$mime = new Mail_mime("\n");
$mime->setTXTBody($emailBody);
$body = $mime->get();
$headers = $mime->headers($headers);

$mail = Mail::factory('smtp',
   array ('host' => 'ssl://smtp.gmail.com',
     'auth' => true,
     'port' => 465,
     'username' => 'events@domain.com',
     'password' => 'thepasswordhere'));

try {
  $result = $mail->send($emailTo, $headers, $emailBody);
} catch (TixException $ex) {     
  echo "<font color=red>Error:" . $ex->getCode() . "</font><br>";
}

echo "Emailed at (" . $currentTime . ")<br>";
die;

Everything about the email is sending except the message text does anyone know what the issue could be?

here is the block of code that sends the email
Thanks in advance
Code: [Select]
$image = "http://www.visualrealityink.com/dev/clients/arzan/snell_form/images/email.png";
echo "got to process form";
$target_path = "upload/";                   
$path = $target_path = $target_path . basename( $_FILES['file']['name']);                 
$boundary = '-----=' . md5( uniqid ( rand() ) );

$message .= "Content-Type: application/msword; name=\"my attachment\"\n";
$message .= "Content-Transfer-Encoding: base64\n";
$message .= "Content-Disposition: attachment; filename=\"$path\"\n\n";


echo $path;
$fp = fopen($path, 'r');
do //we loop until there is no data left
{
$data = fread($fp, 8192);
if (strlen($data) == 0) break;
$content .= $data;
  } while (true);
$content_encode = chunk_split(base64_encode($content));
$message .= $content_encode . "\n";
$message .= "--" . $boundary . "\n";
$message .= $image . "<br />" . $_POST['name'] . "submitted a resume on our website. Please review the applications and contact the candidate if their resume is a fit for any open opportunities with the company. <br><br> Thank you. <br><br> SEI Team";
$headers  = "From: \"Me\"<me@example.com>\n";
$headers .= "MIME-Version: 1.0\n";
$headers .= "Content-Type: multipart/mixed; boundary=\"$boundary\"";
mail('george@visualrealityink.com', 'Email with attachment from PHP', $headers, $message);

Hi the user fill details and then the email his sent to me the only problem is that the emails keeps going to my spam, can someone help me out please I looked already php website and email format looks the same.
This is the link to my form.
http://www.people.eurico.co.uk/

here my form script
Code: [Select]
<?php

// Set email variables
$email_to = 'xxxxx@xxxxxxx.co.uk';
$email_subject = 'Call back form';

// Set required fields
$required_fields = array('fullname','email','telephone','comment');

// set error messages
$error_messages = array(
'fullname' => 'Please enter a Name to proceed.',
'email' => 'Please enter a valid Email.',
'telephone' => 'Please telephone.',
'comment' => 'Please enter your Message to continue.' 
);

// Set form status
$form_complete = FALSE;

// configure validation array
$validation = array();

// check form submittal
if(!empty($_POST)) {
// Sanitise POST array
foreach($_POST as $key => $value) $_POST[$key] = remove_email_injection(trim($value));

// Loop into required fields and make sure they match our needs
foreach($required_fields as $field) {
// the field has been submitted?
if(!array_key_exists($field, $_POST)) array_push($validation, $field);

// check there is information in the field?
if($_POST[$field] == '') array_push($validation, $field);

// validate the email address supplied
if($field == 'email') if(!validate_email_address($_POST[$field])) array_push($validation, $field);
}

// basic validation result
if(count($validation) == 0) {
// Prepare our content string
$email_content = 'peoplesmartlearning.co.uk: ' . "\n\n";

// simple email content
foreach($_POST as $key => $value) {
if($key != 'submit') $email_content .= $key . ': ' . $value . "\n";
}

// if validation passed ok then send the email
mail($email_to, $email_subject, $email_content);

// Update form switch
$form_complete = TRUE;
}
}

function validate_email_address($email = FALSE) {
return (preg_match('/^[^@\s]+@([-a-z0-9]+\.)+[a-z]{2,}$/i', $email))? TRUE : FALSE;
}

function remove_email_injection($field = FALSE) {
   return (str_ireplace(array("\r", "\n", "%0a", "%0d", "Content-Type:", "bcc:","to:","cc:"), '', $field));
}

?>
The HTML
Code: [Select]
<div class="call_us_form">
        <p class="title">WE'LL CALL YOU BACK</p>
<?php if($form_complete === FALSE): ?>
<form class="contact_form" id="fm-form" method="post" action="index.php" >
                <fieldset>
                    <div class="fm-req">
                        <label for="fm-firstname">Name</label>
 <input type="text" id="fullname" class="detail" name="fullname" value="<?php echo isset($_POST['fullname'])? $_POST['fullname'] : ''; ?>" />
<?php if(in_array('fullname', $validation)): ?><script type="text/javascript">alert("Please enter a Name"); history.back();</script><?php endif; ?>
                    </div>
               
                    <div class="fm-req">
                    <label for="fm-firstname">Email</label>
                 <input type="text" id="email" class="detail" name="email" value="
<?php echo isset($_POST['email'])? $_POST['email'] : ''; ?>" />
<?php if(in_array('email', $validation)): ?><script type="text/javascript">alert("Please enter a valid Email Address"); history.back();</script><?php endif; ?>
                    </div>
                   
<div class="fm-req">
                    <label for="fm-firstname">Number</label>
 <input type="text" id="telephone" class="detail" name="telephone" value="<?php echo isset($_POST['telephone'])? $_POST['telephone'] : ''; ?>" />
  <?php if(in_array('telephone', $validation)): ?><script type="text/javascript">alert("Please enter telephone number"); history.back();</script><?php endif; ?>
                    </div>

                    <div class="fm-req">
                        <label for="fm-lastname">Message</label>
<textarea cols="40" rows="5" id="comment" name="comment" class="mess"><?php echo isset($_POST['comment'])? $_POST['comment'] : ''; ?></textarea>
<?php if(in_array('comment', $validation)): ?><script type="text/javascript">alert("Please enter your message"); history.back();</script><?php endif; ?>
                    </div>
                <input class="submit_button" type="submit" value="Call us" />
                </fieldset>
            </form>
<?php else: ?>
<p>Thank you for your Message!</p>
<p>We will get back to you as soon as we can</p>

<script type="text/javascript">
setTimeout ('ourRedirect()', 5000)
function ourRedirect () {
location.href='index.php'
}
</script>
<?php endif; ?>

Code: [Select]
$sql="SELECT * FROM $tbl_name3 WHERE review_show='n'";
$result=mysql_query($sql);
$num_results=mysql_num_rows($result);
if($num_results > 1){
$message="You have ".$num_results." reviews unapproved.";
mail('example@example.com','GHP Reviews', $message, 'From: example@example.com');
}

$sql2="SELECT * FROM $tbl_name4 WHERE rma_issued='n'";
$result2=mysql_query($sql2);
$num_results2=mysql_num_rows($result2);
if($num_results2 > 1){
$message="You have ".$num_results2." RMA Numbers Requested.";
mail('example@example.com','GHP RMA Number Requests', $message, 'From: example@example.com');
}

The reviews email is being sent, however, the RMA email is not.

EDIT: Nevermind, $num_results and $num_results2 should have been > 0 not > 1.