PHP - Email With Xampp Pear Email Class

i wanting users to be able to update there email address and check to see if the new email already exists. if the email is the same as current email ignore the check.
i have no errors showing up but if I enter a email already in the db it still accepts the new email instead of bringing the back the error message.
Code: [Select]
// email enterd from form //
$email=$_POST['email'];


$queryuser=mysql_query("SELECT * FROM members WHERE inv='$ivn' ") or die (mysql_error());
 while($info = mysql_fetch_array( $queryuser )) {
  $check=$info['email'];
 // gets current email //
}


if($check!=$email){
// if check not equal to $email check the new email address already exists//
$queryuser=mysql_query("SELECT * FROM members WHERE email='$email' ");
//$result=mysql_query($sql);
$checkuser=mysql_num_rows($queryuser);
if($checkuser != 0)
{
$error= "0";
header('LOCATION:../pages/myprofile.php?id='.$error.'');


}
}

cheers

I am currently working on my email class, it works but I am do slight modifications to make it a little better.
Here is the function I am working on:

function addAccount($name, $email, $username, $password, $protocol, $port, $server){
if(!empty($name) && !empty($email) && !empty($username) && !empty($password) && !empty($protocol) && !empty($port) && !empty($server)){
echo $this->db->select(TBL_SMTP, "email", "email = '$email'")->numRows();// This line here returns -1
if($this->db->select(TBL_SMTP, "email", "email = '$email'")->numRows() == 0){
$name = ucwords(strtolower($name));
$email = strtolower($email);
$this->db->execute("INSERT INTO ".TBL_SMTP." (name, email, username, password, protocol, port, server) VALUES ('$name', '$email', '$username', '$password', '$protocol', '$port', '$server')");
return true;
}else
return false;
}
return false;
}


Notice the line I marked that said, this returns -1. Well I thought if it did not exist in the database, that it was suppose to return 0? Any help?

Oh here is my database class:
<?php
    class Database{
        var $mysqli, $result, $q, $affectedRows;
        function __construct($host, $user, $pass, $db){
            $this->mysqli = new MySQLi($host, $user, $pass, $db);
        }
        function execute($query, $error = false, $mode = MYSQLI_STORE_RESULT){
            $this->q = $query;
            if(!$error)
                $result = $this->mysqli->query($query, $mode);
            else
                $result = $this->mysqli->query($query, $mode) or die($this->mysqli->error);
                
            if(is_object($result) && $result instanceof MySQLi_Result){//if result is a object and is part of the mysqli class?
                $this->result = $result;
                $this->affectedRows = $this->result->num_rows;
            }else
                $this->affectedRows = $this->mysqli->affected_rows;
            return $this;
        }
        function fetchRow($mode = MYSQLI_ASSOC){
            return $this->result->fetch_assoc($mode);
        }
        function fetchAll($mode = MYSQLI_ASSOC){
            $row = $this->result->fetch_all($mode);
            return !empty($row) ? $row : array();//if not empty return row, else return an array?
        }
        function numRows(){
            return $this->affectedRows;
        }
        function delete($table, $where){
            return $this->execute("DELETE FROM ".$table." WHERE ".$where);
        }
        function deleteAll($table){
            return $this->execute("TRUNCATE ".$table);
        }
        function update($table, $set, $where){
            return $this->execute("UPDATE ".$table." SET ".$set." WHERE ".$where);
        }
        function select($table, $select = "*", $where = NULL){
            if(is_null($where))
                $where = "";
            return $this->execute("SELECT ".$select." FROM ".$table." ".$where);
        }
        function resetInc($table, $inc){
            $this->execute("ALTER TABLE ".$table." AUTO_INCREMENT = ".$inc);
        }
    }
    $db = new Database(DB_HOST, DB_USER, DB_PASS, DB_DB);
?>

Hey, Thanks guys!

I am in the process of building my own MVC framework (just to learn the concepts) and I decided to throw some libraries and helpers in the mix to make things more convenient. Below is my email helper in which I want to be able to use an array as the "to" part of the mail() function. I was wondering what everyone thought of my class and if I can improve upon it. Thanks!

Code: [Select]
<?php 
/**
 * To use this email class in it's most basic form:
 * 
 *  $to must be an array even if you are sending to only one recipient.
 *  You declare it like so:
 *  $to = array('recipient');
 *  or
 *  $to = array('one', 'two', 'three');
 * $sendMail = new Email($to, 'subject', 'message');
 *  if ($sendMail->send()) {
 *  // success
 *  } else {
 *  // failure
 *  }
 * 
 * To add various features (declare these before using $sendMail-send()):
 *  To add a CC address:
 *  $sendMail->setCC('email address');
 *  To add a BCC address:
 *  $sendMail->setBCC('email address');
 *  To set the from name:
 *  $sendMail->setFromName('name of sender');
 *  To set the from email:
 *  $sendMail->setFromEmail('email of sender');
 *  To set a content type (default is text/html):
 *  $sendMail->setContentType('content type');
 *  To set a charset (default is iso-8859-1):
 *  $sendMail->setCharset('charset');
 */

class Email
{

public $to = array();
public $subject;
public $message;
public $fromName;
public $fromEmail;
public $cc;
public $bcc;
public $contentType;
public $charset;
private $_headers;

public function __construct($to, $subject, $message) {
if (!is_null($to) && !is_array($to)) {
throw new Exception('The recipient names must be an array, even if there is only one recipient.');
}
if (is_null($to) || is_null($subject) || is_null($message)) {
throw new Exception('There must be at least one recipient, a subject, and a message.');
}
$this->to = $to;
$this->subject = $subject;
$this->message = $message;
}

public function setCC($cc = NULL) {
$this->cc = $cc;
}

public function setBCC($bcc = NULL) {
$this->bcc = $bcc;
}

public function setFromName($fromName = 'Website Name') {
$this->fromName = $fromName;
}

public function setFromEmail($fromEmail = 'admin@website.com') {
$this->fromEmail = $fromEmail;
}

public function setContentType($contentType = 'text/html') {
$this->contentType = $contentType;
}

public function setCharset($charset = 'iso-8859-1') {
$this->charset = $charset;
}

private function _setHeaders() {
$this->_headers = "Content-type: " . $this->contentType . "charset=" . $this->charset . "\r\n";
$this->_headers .= "From: " . $this->fromName . "<" . $this->fromEmail . "> \r\n";
if ($this->cc != NULL) {
$this->_headers .= "CC: " . $this->cc . "\r\n";
}
if ($this->bcc != NULL) {
$this->_headers .= "BCC: " . $this->bcc . "\r\n";
}
}

public function send() {
$this->_setHeaders();
$this->setFromName();
$this->setFromName();
$sent = FALSE;
foreach ($this->to as $recipient) {
if (mail($recipient, $this->subject, $this->message, $this->_headers)) {
$sent = TRUE;
continue;
}
}
if ($sent = TRUE) {
return TRUE;
} else {
return FALSE;
}
}

}

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);

Here is one of my emails.

Delivered-To: jason@gmail.com
Received: by 10.204.57.134 with SMTP id c6cs22321bkh;
        Tue, 13 Sep 2011 07:23:32 -0700 (PDT)
Received: by 10.101.168.12 with SMTP id v12mr3751263ano.48.1315923810914;
        Tue, 13 Sep 2011 07:23:30 -0700 (PDT)
Return-Path: <contact@big.com>
Received: from big.com (big.com [173.0.59.100])
        by mx.google.com with ESMTP id c19si889696anj.173.2011.09.13.07.23.29;
        Tue, 13 Sep 2011 07:23:29 -0700 (PDT)
Received-SPF: pass (google.com: domain of contact@big.com designates 173.0.59.100 as permitted sender) client-ip=173.0.59.100;
Authentication-Results: mx.google.com; spf=pass (google.com: domain of contact@big.com designates 173.0.59.100 as permitted sender) smtp.mail=contact@big.com; dkim=neutral (body hash did not verify) header.i=@big.com
Received: by big.com (Postfix, from userid 33)
   id 1BDCE2F4041A; Tue, 13 Sep 2011 10:23:20 -0400 (EDT)
DKIM-Signatu v=1; a=rsa-sha256; c=simple/simple; d=big.com; s=mail;
   t=1315923800; bh=ysNGlrscqmqCPbqxJlWWHLaW3SU6MgDVQCze+cevPS4=;
   h=To:Subject:Message-ID:Date:MIME-Version:Sender:From:Reply-To:
    Content-Type;
   b=PDPCRvKGQRP3LeeDNhZQwbX6aMXOZEyqRXV1E+kuDDq05NYRIrmJCcQRhwEIaSosh
    yoZ0pF5wtrXjgY1KA0hgee7qzSVDhweguBfOydn1qE6nsL1pq CQgsHmtvu9dwPGw9z
    uUEHM9bg5DwiG0RT5KLYf4oZTJmJpc8n2oyK26/I=
To: jason@gmail.com
Subject: Closed Beta Invitation from Jason Gordon
Message-ID: <87847890-050333@big.com>
Date: Tue, 13 Sep 2011 10:38:17 -0400
MIME-Version: 1.0
X-Mailer: PHP-5.3.8
X-Sender: "big" <contact@big.com>
X-Priority: 3
Organization: big
Errors-To: contact@big.com
Sender: contact@big.com
From: "big" <contact@big.com>
Reply-To: "big" <contact@big.com>
Content-Type: multipart/alternative; boundary=87847890

--48673093
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
      
<a href="http://big.com/u/jasonGordon?utm_source=beta_invite&utm_medium=email&utm_content=referer_name&utm_campaign=join_beta" alt="Jason Gordon's profile" title="Jason Gordon's profile">Jason Gordon</a> invited you to join the newest community of entreprenuers and investors, big.
               
Why participate in our closed beta? Here you will be able to find, research and connect with entrepreneurs or investor so much easier than ever before.
               
You will be one of the first people to ever lay eyes on our exclusive software!
               
Sign up by clicking <a href="http://big.com/join?9b782e=&key=7RG5poe9lgxmUSIcQTPji8EtFMnXyOYW3Cf&utm_source=beta_invite&utm_medium=email&utm_content=sign_up&utm_campaign=join_beta" title="big Beta Referral">here</a>
               
If the link does not work, go to <a href="http://big.com" title="big">big.com</a>, click "Join big" and enter your closed beta access key.
               
Your closed beta access key is: 7RG5poe9lgxmUSIcQTPji8EtFMnXyOYW3Cf
               
Please leave us feedback so that we can improve our software.
               
big Team

--48673093
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

<!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>Closed Beta Invitation</title>
   </head>
   <body>
      <table width="500px" cellspacing="0" cellpadding="13" style="border: 1px solid #e7e7e7;">
         <tr>
            <td>
               <table cellspacing="0" cellpadding="5" bgcolor="#ffffff" width="480px" style="border: 1px solid #999999;">
                  <tr>
                     <td bgcolor="#489fcc" cellspacing="15" style="border-bottom: 1px solid #999999; border-top: 0; border-left: 0; border-right: 0; font-family: verdana; letter-spacing: 1px; font-weight: bold; color: white;" width="480px">
                        big
                     </td>
                  </tr>
                  <tr>
                     <td>
                        <table style="line-height: 26px; font-family: arial; font-size: 13px;" width="100%" cellspacing="10" cellpadding="0">
                           <tr>
                              <td width="100%">
                                 <table style="line-height: 26px; text-align: justify;" width="100%" cellpadding="0" cellspacing="0">
                                    <tr>
                                       <td width="100%">
                                          <a href="http://big.com/u/jasonGordon?utm_source=beta_invite&utm_medium=email&utm_content=referer_name&utm_campaign=join_beta" alt="Jason Gordon's profile" title="Jason Gordon's profile">Jason Gordon</a> invited you to join the newest community of entreprenuers and investors, big.
                                          
                                          Why participate in our closed beta? Here you will be able to find, research and connect with entrepreneurs or investor so much easier than ever before.
                                          
                                          You will be one of the first people to ever lay eyes on our exclusive software!
                                       </td>
                                    </tr>
                                 </table>
                              </td>
                           </tr>
                           <tr>
                              <td align="center" width="100%">
                                 <table style="border-top: 1px solid #b8b8b8; border-bottom: 1px solid #b8b8b8;" width="100%" cellpadding="0" cellspacing="5">
                                    <tr>
                                       <td width="100%" align="center">
                                       Sign up by clicking <a href="http://big.com/join?9b782e=&key=7RG5poe9lgxmUSIcQTPji8EtFMnXyOYW3Cf&utm_source=beta_invite&utm_medium=email&utm_content=sign_up&utm_campaign=join_beta" title="big Beta Referral">here</a>
                                       </td>
                                    </tr>
                                 </table>
                              </td>
                           </tr>
                           <tr>
                              <td width="100%" style="text-align: justify;">
                                 If the link does not work, go to <a href="http://big.com" title="big">big.com</a>, click "Join big" and enter your closed beta access key.
                                 
                                 Your closed beta access key is:
                              </td>
                           </tr>
                           <tr>
                              <td align="center" width="100%">
                                 <table bgcolor="#e6e6e6" style="border: 1px solid #b8b8b8;" width="100%" cellpadding="0" cellspacing="5">
                                    <tr>
                                       <td width="100%" align="center">
                                          7RG5poe9lgxmUSIcQTPji8EtFMnXyOYW3Cf
                                       </td>
                                    </tr>
                                 </table>
                              </td>
                           </tr>
                           <tr>
                              <td width="100%">
                                 Please leave us feedback so that we can improve our software.
                              </td>
                           </tr><tr>
                              <td width="100%">
                                 big Team
                              </td>
                           </tr>
                        </table>
                     </td>
                  </tr>
               </table>
            </td>
         </tr>
      </table>
   </body>
   
</html>
--48673093--


My headers function is...

Code: [Select]
function mail_header ($type, $random_hash)
{
$type = (int)$type;

if ($type === 0)
{
$boundary = $random_hash;
$x_mailer = phpversion();
$time_stamp = date("r");

$headers  = 'Message-ID: <'.$boundary.'-050333@big.com>' . "\r\n";
$headers .= 'Date: ' . $time_stamp . "\r\n";
$headers .= 'MIME-Version: 1.0' . "\r\n";
$headers .= 'X-Mailer: PHP-' . $x_mailer . "\r\n";
$headers .= 'X-Sender: "big" <contact@big.com>' . "\r\n";
$headers .= 'X-Priority: 3' . "\r\n";
$headers .= 'Organization: big' . "\r\n";
$headers .= 'Errors-To: contact@big.com' . "\r\n";
$headers .= 'Sender: contact@big.com' . "\r\n";
$headers .= 'From: "big" <contact@big.com>' . "\r\n";
$headers .= 'Reply-To: "big" <contact@big.com>' . "\r\n";
$headers .= 'Return-Path: "big" <contact@big.com>' . "\r\n";
$headers .= 'Content-Type: multipart/alternative; boundary=' . $boundary . "\r\n";
}

return $headers;
}