PHP - Problem With Email Message Body

Hi guys,

I have written a script that opens up my gmail messages via IMAP stores them in an array.  However, I have thousands of emails, so this is taking forever.  Is there a faster way of doing this?

Here's my code

Code: [Select]
<?php
//lets get those emails

/* connect to gmail */
$hostname = '{imap.gmail.com:993/imap/ssl}INBOX';
$username = 'info@***********.com';
$password = '******';

/* try to connect */
$inbox = imap_open($hostname,$username,$password) or die('Cannot connect to Gmail: ' . imap_last_error());

/* grab emails */
$emails = imap_search($inbox,'ALL');

/* if emails are returned, cycle through each... */
if($emails) {
  

  /* for every email... */
  foreach($emails as $email_number) {
    
    $message = imap_fetchbody($inbox,$email_number,2);
  }
  
} 

/* close the connection */
imap_close($inbox);
?>

Hey guys,

I know nothing of PHP so please bare with me as I try to explain my problem.

My company collects sales leads that are emailed through to a CRM system (GoldMine). We are currently in the process of moving our website from a shared windows server to a dedicated linux server and it seems to be causing a problem with the form, or at least PHP behind it. The guy who handed the initial set up has mysteriously disapeared so we're in a bit of a fix.

I'm not specifically looking for a solution, more of an idea of where to go from here. I'm not sure wether the problem lies in the PHP itself or something else.. like the server for example. I was hoping someone here might be able to point me in the right direction somewhat.

Anyway, the problem is that while testing the form on the new server the email is sent and our CRM picks it up but cannot read because a newly appeared line has been inserted at the top of the body. This does not appear when filling in the form currently live on our site (windows server).

the line is:

Code: [Select]
Content-Type: text/x-gm-impdata
As far as I'm aware this content-type is necessary for our CMR to recognize and read the email, but it shouldn't be showing up in the body of the mail.

The full on send PHP is:

Code: [Select]
<?php

$redirectURL = "http://www.website.co.uk/confirmation_page.htm";

function Decode($strValueIn)
{
//Do not modify this function!
$intX = 0;
$intY = 0;
$Temp = "";
$Mod = "";
$intMod =0;
$intTemp = 0;
$ValueOut = "";
$intY = 1;
$strValueOut="";
for ($intX=1; $intX<=((strlen($strValueIn)/2)/2); $intX=$intX+1)
  {

    $strTemp="";
    $strMod="";
    if (($intX % 2)==0)
    {

      $strMod=substr(substr($strValueIn,$intY-1,4),0,2);
      $strTemp=substr(substr($strValueIn,$intY-1,4),strlen(substr($strValueIn,$intY-1,4))-(2));
    }
      else
    {

      $strMod=substr(substr($strValueIn,$intY-1,4),strlen(substr($strValueIn,$intY-1,4))-(2));
      $strTemp=substr(substr($strValueIn,$intY-1,4),0,2);
    } 

    $intMod=hexdec($strMod);
    $intTemp=hexdec($strTemp);
    $intTemp=$intTemp-$intMod;
    $strValueOut=$strValueOut.chr($intTemp);
    $intY=$intY+4;

  } 

  return $strValueOut;



}

if ($_POST["GMsubmit"]!="")
{
$Body = "";

$Notes = "";

$SendToEmail = Decode($_POST["SendToEmail"]);
//$SMTP = Decode($_POST["SMTP"]); //Your SMTP data may have to be set set on the Apache Server, and this variable is not used.
$OnNewSendGMEmail = $_POST["OnNewSendGMEmail"];
if ($OnNewSendGMEmail!="")
{$OnNewSendGMEmail = Decode($OnNewSendGMEmail);}
else 
{$OnNewSendGMEmail = "";}

if ($_POST["OnDUPSendGMEmail"]!="")
{$OnDUPSendGMEmail = Decode($_POST["OnDUPSendGMEmail"]);}
else 
{$OnDUPSendGMEmail = "";}
if ($_POST["OnNewAttachTrack"]!="")
{$OnNewAttachTrack = Decode($_POST["OnNewAttachTrack"]);}
else 
{$OnNewAttachTrack = "";}
if ($_POST["OnDupAttachTrack"]!="")
{$OnDupAttachTrack = Decode($_POST["OnDupAttachTrack"]);}
else 
{$OnDupAttachTrack = "";}
if ($_POST["Word"]!="")
{$Password = Decode($_POST["Word"]);}
else 
{$Password = "";}
if ($_POST["DupLogic"]!="")
{$DupLogic = Decode($_POST["DupLogic"]);}
else 
{$DupLogic = "";}

$OutputAs = $_POST["OutPutAs"];
$DuplicateCount=0;
$XML = "<gmdata>";

if ($_POST["DuplicateCount"]!="") 
{
$DuplicateCount =intval($_POST["DuplicateCount"]);

}
if ($DuplicateCount >0 || $OnNewSendGMEmail!="" || $OnDUPSendGMEmail!="" ||
$OnNewAttachTrack!="" || $OnDupAttachTrack!="")
{
$Body = $Body."[Instructions]\r\n";
$XML = $XML."<Instructions>";
if ($DuplicateCount > 0)
{
for($counter=0; $counter < $DuplicateCount; $counter++)
{
$RealCount=$counter+1;
$str = "DuplicateChecking$RealCount";
eval("\$str = \"$str\";");
$Body = $Body."DupCheck".$RealCount."=".$_POST[$str]."\r\n";
//print($str.":".$_POST[$str].";");
$tempVal = $_POST[$str];
if ($tempVal==="EMAIL")
{
$XML = $XML."<DupCheck>EA1</DupCheck>";
}
else
{
if ($tempVal==="WEBSITE")
{
$XML = $XML."<DupCheck>WS1</DupCheck>";
}
else
{
$XML = $XML."<DupCheck>".htmlspecialchars($_POST[$str])."</DupCheck>";
}
}
}
if ($DupLogic !="")
{$Body = $Body."DupLogic=OR\r\n";}
}
if ($OnNewSendGMEmail!="")
{
$Body = $Body."OnNewSendGMEmail=".$OnNewSendGMEmail."\r\n";
$XML = $XML."<OnNewSendGMEmail>".htmlspecialchars($OnNewSendGMEmail)."</OnNewSendGMEmail>";

}
if ($OnDUPSendGMEmail!="")
{
$Body = $Body."OnDUPSendGMEmail=".$OnDUPSendGMEmail."\r\n";
$XML = $XML."<OnDupSendGMEmail>".htmlspecialchars($OnDUPSendGMEmail)."</OnDupSendGMEmail>";

}
if ($OnNewAttachTrack!="")
{
$comma =strpos($OnNewAttachTrack, ",");
$Body = $Body."OnNewAttachTrack=".$OnNewAttachTrack."\r\n";
if ($comma =="")
{
$XML = $XML."<OnNewAttachTrack>".htmlspecialchars($OnNewAttachTrack)."</OnNewAttachTrack>";
}
else
{
list($track, $user) = split(',', $OnNewAttachTrack,2);
$XML = $XML."<OnNewAttachTrack User=".chr(34).htmlspecialchars($user).chr(34).">".htmlspecialchars($track)."</OnNewAttachTrack>";
}
}
if ($OnDupAttachTrack!="")
{
$comma =strpos($OnDupAttachTrack, ",");
$Body = $Body."OnDupAttachTrack=".$OnDupAttachTrack."\r\n";
if ($comma =="")
{
$XML = $XML."<OnDupAttachTrack>".htmlspecialchars($OnDupAttachTrack)."</OnDupAttachTrack>";
}
else
{
list($track, $user) = split(',', $OnDupAttachTrack,2);
$XML = $XML."<OnDupAttachTrack User=".chr(34).htmlspecialchars($user).chr(34).">".htmlspecialchars($track)."</OnDupAttachTrack>";
}


}
if ($Password!="")
{
$Body = $Body."Password=".$Password."\r\n";
$XML = $XML."<Password>".htmlspecialchars($Password)."</Password>";

}
if ($DupLogic!="")
{
$XML = $XML."<DupLogic>OR</DupLogic>";
}
else
{
$XML = $XML."<DupLogic>AND</DupLogic>";
}

$XML = $XML."</Instructions>";
}
$Body = $Body."[Data]\r\n";
$XML = $XML."<accounts><account>";
$Phone = "";
$EA = "";
$WS = "";
$PR = "";
while(list($key,$value)= each($_POST)) 
{
eval("$\$key = \"$value\";");
{


if ($key!="GMsubmit" && $key!="SMTP" && $key!="OnNewSendGMEmail" &&
$key!="OnDUPSendGMEmail" && $key!="OnNewAttachTrack" &&
$key!="OnDupAttachTrack" && $key!="SendToEmail" && $key!="DuplicateCount" && $key!="Word" &&
strpos($key, "DuplicateChecking") === false && $key!="OutPutAs" && $key!="DupLogic" && strpos($key, "pretty_") === false)

{


if($value!="")
{

if ($key=="UHCUSTDESC" || $key=="UHDESCGOOD" || $key=="UHPI")
{
$value = str_replace("\r\n","<br/>",$value);
$NoteHeader = "";
if ($key=="UHCUSTDESC") { $NoteHeader = "<strong>Customer Description</strong><br/><br/>"; }
if ($key=="UHDESCGOOD") { $NoteHeader = "<strong>Descriptions of Goods</strong><br/><br/>"; }
if ($key=="UHPI")       { $NoteHeader = "<strong>Packing Information</strong><br/><br/>"; }
$Notes = $Notes.$NoteHeader.$value."<br/><br/>";
}


$Body = $Body.$key."=".$value."\r\n";

if (substr($key,0,5)!="PHONE" && substr($key,0,3)!="FAX" && substr($key, 0, 5)!="EMAIL" && substr($key,0, 7)!="WEBSITE")
      
{

$PR = $PR."<property name=".chr(34).$key.chr(34)." db_name=".chr(34).$key.chr(34).">";
$PR = $PR."<property_string>".htmlspecialchars($value)."</property_string>";
$PR = $PR."</property>";
}
else
{
if(substr($key,0,5)=="PHONE")
{

$Phone = $Phone."<phone international=".chr(34)."0".chr(34)." type=".chr(34).$key.chr(34)." source_fld=".chr(34).$key.chr(34).">";
$Phone = $Phone."<properties><property name=".chr(34)."phone_number".chr(34)."><property_string>".$value."</property_string></property></properties>";
$Phone = $Phone."</phone>";
}
elseif(substr($key,0,3)=="FAX")
{
$Phone = $Phone."<phone international=".chr(34)."0".chr(34)." type=".chr(34).$key.chr(34)." source_fld=".chr(34).$key.chr(34).">";
$Phone = $Phone."<properties><property name=".chr(34)."phone_number".chr(34)."><property_string>".$value."</property_string></property></properties>";
$Phone = $Phone."</phone>";
}
elseif(substr($key,0,7)=="WEBSITE")
{
$WS = $WS."<website primary=".chr(34)."1".chr(34)." id=".chr(34)."WS1".chr(34).">";
$WS = $WS."<properties><property name=".chr(34)."web_site".chr(34)."><property_string>".$value."</property_string></property></properties>";
$WS = $WS."</website>";
}
elseif(substr($key,0,5)=="EMAIL")
{
$EA = $EA."<email primary=".chr(34)."1".chr(34)." id=".chr(34)."EA1".chr(34).">";
$EA = $EA."<properties><property name=".chr(34)."email_address".chr(34)."><property_string>".$value."</property_string></property></properties>";
$EA = $EA."</email>";
}

}
}

}
}

}
if ($PR !="")
{$XML = $XML."<properties>".$PR."</properties>";}
if($Phone!="")
{
$XML = $XML."<phone_numbers>".$Phone."</phone_numbers>";
}
if($EA!="")
{
$XML = $XML."<emails>".$EA."</emails>";
}
if($WS!="")
{
$XML = $XML."<websites>".$WS."</websites>";
}
$XML = $XML."</account></accounts></gmdata>";
$ToSubject="Web Import";

//The PHP built in function mail() will not raise or cause errors if it fails - so be sure that your PHP server is setup correctly!

if( $OutputAs!="INI")
{
$Body = $XML;
}
//ini_set("SMTP", Decode($SMTP));

$Body = $Body."UHSUBDATE=".date("d/m/Y")."\r\n";
$Body = $Body."NOTES=".$Notes;


if(mail(Decode($SendToEmail), $ToSubject, $Body, "From: GoldMine WebImport <no-reply@frontrange.com>\r\n\r\nContent-Type: text/x-gm-impdata\r\n\r\n" )) 
{
//print "Your data has been recorded successfully!\r\n\r\n<!--\r\n".Decode($SendToEmail)."\r\n".$ToSubject."\r\n".$Body."\r\n\r\n".$OutputAs."\r\n\r\n-->";
header("location: ".$redirectURL);
}
else
{
print("There was a mailer failure.\r\n\r\n<!--\r\n".$Body."\r\n\r\n-->");}
}
else
{
echo "There was no form data passed.";
}
?>

Line 294 contains the text that's appearing in the email.

Any ideas would be very, very much appreciated.

Hi all

I have a script that creates an email message, but I want to add a link to it to take the user to PayPal. Here's my code:

   $headers  = "MIME-Version: 1.0\n";
            $headers .= "Content-type: text/html; charset=utf-8\n";
            $headers .= "From: '".$_SERVER['HTTP_HOST']." Booking System' <info@".$_SERVER['HTTP_HOST']."> \n";
            $subject = "Booking Confirmed!";   
            $message = "Dear ".$name.",<br /> <br /> This is confirmation of your booking. <br />";
            $message .= "<table cellspacing=0 cellpadding=4 border=0>";
            $message .= "<tr><td>Date</td><td>Time From</td><td>Time To</td></tr>";
            $message .= $tempVar;
            $message .= "</table>";
            $message .="<br />Reservation Status: Confirmed<br/>";
            $message .="<br /><br />Kind Regards, <br /> ".$_SERVER['HTTP_HOST']." Team";
            mail($email,$subject,$message,$headers);   

Can anyone help me add a line to the above to add the link in?

Many thanks
Pete

I have a registration form on my website and after Registration I want the user to activate first his account. I don't have problem on sending this email to the user. What I want to appear is like this..

GoodDay "username",

Blah Blah!

how can you actually do that? I know that you can do that through session variables but the thing is email's can't accept scripts on sending emails. how can I get the value from a session variable for example and convert it to plain html text so that i can OUTPUT it to the email.. HELP PLEASE!

Hi there everyone!

I'm trying my best to Google my way through this issue, but have run into an issue I can't out-Google. I'm trying to write a script that is receiving an email, breaking it apart into it's various components and then storing into a database. I would like to sto

from name
from email
to name
to email
subject
headers
body

Here's what I've cobbled together from various tutorials and demo's:

$fd = fopen("php://stdin", "r");
$email_content = "";
while (!feof($fd)) {
    $email_content .= fread($fd, 1024);
}
fclose($fd);

//split the string into array of strings, each of the string represents a single line, received
$lines = explode("\n", $email_content);
 
// initialize variable which will assigned later on
$from = "";
$subject = "";
$headers = "";
$message = "";
$is_header= true;
 
//loop through each line
for ($i=0; $i < count($lines); $i++) {
    if ($is_header) {
        // hear information. instead of main message body, all other information are here.
        $headers .= $lines[$i]."\n";
 
        // Split out the To portion
        if (preg_match("/^To: (.*)/", $lines[$i], $matches)) {
            $to = $matches[1];
        }
        $toregexp = '/To:\s*(([^\<]*?) <)?<?(.+?)>?\s*\n/i';
        if(preg_match($toregexp, $email_content, $to_dissection)) {
            $toname = $to_dissection[2];
            $toemail = $to_dissection[3];
        }
        // Split out the subject portion
        if (preg_match("/^Subject: (.*)/", $lines[$i], $matches)) {
            $subject = $matches[1];
        }
        //Split out the sender information portion
        if (preg_match("/^From: (.*)/", $lines[$i], $matches)) {
            $from = $matches[1];
        }
        $fromregexp = '/From:\s*(([^\<]*?) <)?<?(.+?)>?\s*\n/i';
        if(preg_match($fromregexp, $email_content, $from_dissection)) {
            $fromname = $from_dissection[2];
            $fromemail = $from_dissection[3];
        }
    } else {
        // content/main message body information
        $message .= $lines[$i]."\n";
    }
    if (trim($lines[$i])=="") {
        // empty line, header section has ended
        $is_header = false;
    }
}

My issues are many. I've got from and to names that don't reflect the true data,
the from address will be the original sender and not the most recent sender if
it's forwarded and finally, the body is showing up empty. Clearly, I'm not handling this properly. With all the trouble-ticket like systems out there, there has to be a fairly bulletproof method of handling this, doesn't there?  I'm thinking I've gone about this totally the wrong way.

Any help would be greatly appreciated!

 

Hi all,

I am just starting out in the world of php and have got this far with a lot of googling.  But I'm really stuck with this part now.

I have a function that works perfectly for display on a page, eg <?php echo quickquote(); ?>

function quickquote() {
global $db;
global $cart;
$cart = $_SESSION['cart'];
if ($cart) {
$items = explode(',',$cart);
$contents = array();
foreach ($items as $item) {
$contents[$item] = (isset($contents[$item])) ? $contents[$item] + 1 : 1;
}
$quickquote[] = 'Quote Required:<br />';
foreach ($contents as $id=>$qty) {
$sql = 'SELECT * FROM products WHERE id = '.$id;
$result = $db->query($sql);
$row = $result->fetch();
extract($row);
$quickquote[] = ''.$qty.'';
$quickquote[] = ' x ';
$quickquote[] = '' . $model . '';
$quickquote[] = ' (' . $type . '- ';
$quickquote[] = ''. $basin . '- ';
$quickquote[] = ''. $top . ')';
$quickquote[] = '<br />';
}
$quickquote[] = 'End of Quick Quote Request';
} else {
$quickquote[] = 'The quote cart is empty.';
}
return join('',$quickquote);

}

However, i am trying to include this in an email message:

if(!$error)
{
$messages="From: $email <br>";
$messages.="Name: $name <br>";
$messages.="Email: $email <br>";
$messages.="Phone: $phone <br>";
$messages.="Message: $message <br>";
$messages.="Quick Quote Request: $quickquote <br>";

$mail = mail($to,$subject,$messages,$headers);

The email also works perfectly with the exception that the data is not there from $quickquote.

I've tried all sorts of variations and suggested solutions from the web but nothing I've tried has been successful so far.

It's amazing that I've got this far so I don't want to give up on it, but I'm just completely stumped ...

All information and help very much appreciated.

Cheers
K

Hi I built a really simple customer review form https://kickasssoftwear.uk/dev/reviews.html (it's only been optimised for mobile view so far) and it works using the php mail script on this page https://kickasssoftwear.uk/dev/empty2.php - the emails are being sent to me and the format of the emails is OK, and the form redirects to the empty2 page with a mailsent message in the address bar.

I know I can leave that page as is and write a nice thank you message in the html - but what I really want to do is have the customers name there too, Thanks 'name' your review has been sent,

but I can't get it to work - it's been 4 whole days now and I really need to eat & sleep! Please if anyone has suggestions or advice for a noob, please help. Thanks

Hi

I have a problem with parsing a query into the email message. Where messege shuld be a complete resoult of a query.

Please take a look on code below:

Code: [Select]
$message = "\r\n" .
                    'Order details:' .
                    '<br><br><table><tr><td>Name</td><td>Amount</td><td>Unit</td><td>Price</td><td>Total</td></tr>' . "\r\n";

/// till here is fine

$result2 = mysql_query("SELECT * FROM orderslist WHERE supplier='$supplier'") or die(mysql_error());
$data = array();
$data['' . $row2['id']] = $_POST['' . $row2['id']];
$value = $_POST['' . $row2['id']];

while($row2=mysql_fetch_array($result2))
{
$value = $_POST['' . $row2['id']];
if ( $value == ""){

}
else {
$total = $value * $row2['price'];

/// this part below i have a problem with do not now how to join this part with the top part ($message)

echo "
<tr>
    <td class='H4'><strong>$row2[name]</strong></td>
<td class='H4' align='center'>$value</td>
<td class='H4'>$row2[unit]</td>
<td class='H4'>$row2[price]</td>
<td class='H4'>$total</td></tr>";
}
 }
echo "</table>";


I think that has something to do with "\r\n"  and dots, but i do not get that fully. If someone could help me on this one will be gratefull.

Thank you very much in advance.

I have a bit of php code to send me an email when someone logs in to my site. I want to include the person's name and two other bits from my database, but I can't get the formatting correct. I keep getting errors when I try to load the page. Here's the code which obviously has mistakes. The first code works, it's the second one that does not work for the $message line .

if (mysql_num_rows($exe) == 1) {
		  	$message_m = "Someone with RefCode ".$RefC." has viewed the homepage for the first time.";
			mail("ray.fellers@gmail.com", "Good News! Someone just logged in to view the home page", $message_m);
		  	setcookie("has_entered_correct_refcode", "true", time()+27000000, "/");
		  	setcookie("has_entered_correct_refcode_value", $_POST["refcode"], time()+27000000, "/");
		  	header("Location: /index.php");
		  	die();

if (mysql_num_rows($exe) == 1) {
		  	$message_m =" "'.$_POST['fname'].'," with RefCode "'.$RefC.'," and refund amount of "'.$_POST['refvalact'].'," has viewed the homepage.";
			mail("ray.fellers@gmail.com", "Good News! Someone just logged in to view the home page", $message_m);

		  	setcookie("has_entered_correct_refcode", "true", time()+27000000, "/");
		  	setcookie("has_entered_correct_refcode_value", $_POST["refcode"], time()+27000000, "/");
		  	header("Location: /index.php");
		  	die();
		  }

Thanks for any help to resolve this.

Ok i am stuck, i created a php script that draws data from a mysql dB into a php page. How can I send the page as the body in email? I do not need to preview the page, but can send it without ever viewing if that helps. When I put my code into a variable it does nothing. Is it caching? Should I load the results into mysql then send?please advise..

I have an auto responder in a php order form with the phrase "Our web sites uses a secure order form for customers to purchase products, and services..."  When the message is sent, the word 'services'  comes out like this: "...products, and 1s."  Each instance of the word 'services' is changed to '1s'. Any ideas?

Hi, I got this script which I would like to send a message to all email addresses in the database or send to approved members only. Once I got the first part of this script working I can get the rest to work when sending to approved members.

Here is the form which passes the message to the script.

Code: [Select]
<?php 

include_once("data/server.php");

$all = 'unchecked';
$approved = 'unchecked';


if (isset($_POST['Submit1'])) {

$selected_radio = $_POST['Mailto'];

if ($selected_radio == 'all') {
$all = 'checked';

}
else if ($selected_radio == 'approved') {
$approved = 'checked';
}
}

?>

<div id="pageNav">
    <div id="sectionLinks"> <a href="admin.php?cmd=database&username=admin">Database</a> <a href="admin.php?cmd=uploads&username=admin">Uploads</a> <a href="admin.php?cmd=editTemplate&username=admin">Templates </a> <a href="admin.php?cmd=email&username=admin">Email</a> <a href="admin.php?cmd=messaging&username=admin">Messaging</a> <a href="admin.php?cmd=protected&username=admin">Protected Directory</a> <a href="admin.php?cmd=filesanddir&username=admin">Files and Directories</a> <a href="admin.php?cmd=usertracking&username=admin">User Tracking</a> <a href="admin.php?cmd=advanced&username=admin">Advanced</a> <a href="admin.php?cmd=uploads&username=admin">Uploads</a> <a href="admin.php?cmd=subscriptions&username=admin">Subscriptions</a> <a href="admin.php?cmd=applications&username=admin">Applications</a> <a href="admin.php?cmd=searchForms&username=admin">Search Form Builder</a> <a href="admin.php?cmd=categories&username=admin">Categories</a> <a href="admin.php?cmd=phpBB&username=admin">phpBB</a> <a href="admin.php?cmd=mySQL&username=admin">MySQL</a></div>
  </div>
  <div id="content">
   
    <div class="page">


<form action=templates/admin/msgtest.php method=POST>
<table>
<tr>
<td>Your Message:</td>
<tr><td>&nbsp;</td><td>&nbsp;</td></tr>
<tr><td><TEXTAREA NAME="message" COLS=40 ROWS=6></TEXTAREA></td></tr>
</table>
<table>
<tr>
<td><input type = 'Radio' Name ='Mailto' value= 'yes'
<?PHP print $all; ?>
</td>
<td>Send Message to all members</td>
</tr>
<tr>
<td><input type = 'Radio' Name ='Mailto' value= 'yes'
<?PHP print $approved; ?>
</td>
<td>Send Message to Approved members only</td>
</tr>
<tr><td colspan=2><input type=submit name=submit value=Submit></td></tr>
</table>
</form>



</table>
    </div>
   
  </div> 
</div>



And here is the code I have got so far but it doesnt work

Code: [Select]
<?php

include_once("../../data/server.php");
include("../../data/mysql.php");

if (isset($_POST['Submit1'])) {

$selected_radio = $_POST['Mailto'];

if ($selected_radio == 'all') {

$mysqlPassword = (base64_decode($mysqlpword));

$con = mysql_connect("$localhost", "$mysqlusername", "$mysqlPassword") or die(mysql_error());
mysql_select_db("$dbname", $con) or die(mysql_error());

 $q2 = "select * from games_newsletter ";
$result = mysql_query("SELECT email FROM profiles");   
 
while ($email = mysql_fetch_assoc($result)) {

$to = $email;
$subject = "Test Message";
$body = "This is a test message";
 $headers = "From: payments@tropicsbay.co.uk\r\n" .
     "X-Mailer: php";
 if (mail($to, $subject, $body, $headers)) {
   
// Redirect back to manage page
header("Location: admin.php?cmd=messaging");


} else {

echo "Approval Message Failed";

}
}
mysql_close($con);
}
}

?>
As always, any help is much appreciated

Paul

Hi all

I have a script that I have patched together and got to work in pieces.  I'm up to the last part.  I have the form working and emailing.  It also will upload an image by itself and put it in a folder.  Now i just need to tie those together and have the image put in the email as an attachment then deleted from server.

I have it at a stage where it sends me the users details.. and it tries to send the photo but it comes through as junk txt.  I think its the MIME encoding stuff that I have wrong.. not sure?

Here's what I have so far.

Code: [Select]

$attachment = $path_of_uploaded_file;
$fileatt = $attachment; // Path to the file                 
$fileatt_type = "application/octet-stream"; // File Type
    $start= strrpos($attachment, '/') == -1 ? strrpos($attachment, '//') : strrpos($attachment, '/')+1;
$fileatt_name = substr($attachment, $start, strlen($attachment)); // Filename that will be used for the file as the attachment

    $file = fopen($fileatt,'rb');
$data = fread($file,filesize($fileatt));
fclose($file);

$semi_rand = md5(time());
$mime_boundary = "==Multipart_Boundary_x{$semi_rand}x";
$headers = "\nMIME-Version: 1.0\n" .
            "Content-Type: multipart/mixed;\n" .
            " boundary=\"{$mime_boundary}\"";

$email_message .= "This is a multi-part message in MIME format.\n\n" .
                "--{$mime_boundary}\n" .
                "Content-Type:text/html; charset=\"iso-8859-1\"\n" .
               "Content-Transfer-Encoding: 7bit\n\n" .

$data = chunk_split(base64_encode($data));
$email_message .= "--{$mime_boundary}\n" .
                  "Content-Type: {$fileatt_type};\n" .
                  " name=\"{$fileatt_name}\"\n" .
                  "Content-Disposition: attachment;\n" .
                  " filename=\"{$fileatt_name}\"\n" .
                  "Content-Transfer-Encoding: base64\n\n" .
                 $data . "\n\n" .
                  "--{$mime_boundary}--\n";
     
// create email headers
$headers .= 'From: '.$email_from."\r\n".
'Reply-To: '.$email_from."\r\n" .
'X-Mailer: PHP/' . phpversion();

@mail($email_to, $email_subject, $email_message, $headers); 



Thanks

Wolfsta

Os I've developed a Message board. A user writes a message and then it appears on the message board. However When the user enters a message it isn't inserted into the MySql.

Also when the messages are entered manually directly into the MySql table they dont show on the site.
Can anyone see the problem.

The code is in 3 php scripts.

messageboard.php
<?php
;
session_start();
//this checks to see if the $_SESSION variable has been not set 
//or if the $_SESSION variable has been not set to true
//and if one or the other is not set then the user gets
//sent to the login page
if (!isset($_SESSION['username'])) {
    header('Location: http://kaaleigh.byethost15.com/login.php');
}




?>




<HTML>
<head><title>Message Board - Logged In</title>
<link rel='stylesheet' href='layout.css'>
</head>
<body bgcolor="#fd8ecf">
<center><img src="headerpage.jpg"></center>

<div class="navbar">
<div class="button"><a href="index.html">Home</a></div>
<div class="button"><a href="news.html">News</a></div>
<div class="button"><a href="gallery.html">Gallery</a></div>
<div class="button"><a href="videos.html">Videos</a></div>
<div class="button"><a href="contact.html">Contact</a></div>
<div class="button"><a href="links.html">Links</a></div>
<div class="button"><a href="msg.html">Message  Kaaleigh</a></div>

</div>

<div class="frame">

<frameset cols="25%,75%" noresize="noresize">

<?php
session_start();

$username = $_SESSION['username'];
$password = $_SESSION['password'];

  if(isset($_SESSION['username']) && isset($_SESSION['password'])) {
    
  echo " <b>Welcome ".$username." <br><br></b>";
  }

    else {
    echo "Welcome Guest! <br> <a href=login.php>Login</a> | <a href=register.php>Register</a>";
    }

?>


<?php
mysql_connect("****************", "**********", "*********");
mysql_select_db("**************");
?>






<form action="message.php" method="POST">
Your Name: <input type="text" name="author"><br>
Message:<br><textarea cols="60" rows="5" name="message"></textarea><br>
<input type="submit" value="Post Message">
</form>



<hr>


<?php
// I am selecting everything from the messages section in the database and ordering them newest to oldest.
$sql = mysql_query("SELECT * FROM messages ORDER BY posted DESC");
 
// Now I am getting my results and making them an array
while($r = mysql_fetch_array($sql)) {
 
$posted = date("jS M Y h:i",$r[posted]);

// End of Array
}
?>


</body>


</html>

message.php
<?php
mysql_connect("*************", "*************", "**********");
mysql_select_db("**************");
$time = time();
mysql_query("INSERT INTO messages VALUES(NULL,'$_POST[message]','$_POST[author]','0','$time')");
echo "Message Posted.<br><a href='messageboard.php'>Return</a>";

msg.php

<?php
mysql_connect("********", "********", "*************");
mysql_select_db("**************");
echo "<a href='messageboard.php'>Go Back...</a>";
$sql = mysql_query("SELECT * FROM messages WHERE id = '$_GET[id]'");
// Now I am getting our results and making them an array
while($r = mysql_fetch_array($sql)) {
// Everything within the two curly brackets can read from the database using $r[]
// I need to convert the UNIX Timestamp entered into the database for when a thread...
// ... is posted into a readable date, using date().
$posted = date("jS M Y h:i",$r[posted]);
// Now this shows the thread with a horizontal rule after it.
echo "$r[message]<h4>Posted by $r[author] on $posted</h4><hr>";

// End of Array
}


Any thoughts?

Hello, i have a private message system nearly done , the only thing that i cant get to work is the Trash messages that a user has... so the user can delete messages either from the inbox/sent/friends box ... then each message row gets update with pm_sender_is_deleted='1' or pm_reciever_is_deleted='1' , depends if the message was deleted in the inbox or sent box respectively.

Here is my db structure on the first table:

        pm_id 

int(11)

pm_msg_id 

int(11)

pm_sender_id 

varchar(30)

pm_reciever_id 

varchar(30

pm_sender_isSpam 

tinyint(1)

pm_sender_isRead 

tinyint(1)

pm_sender_is_deleted 

tinyint(1)

pm_sender_is_removed 

tinyint(1)

pm_reciever_isSpam 

tinyint(1)

pm_reciever_isRead 

tinyint(1)

pm_reciever_is_deleted 

tinyint(1)

pm_reciever_is_removed 

tinyint(1)

here is the second:

usermessages_id 

int(11)

usermessages_msg_id 

int(11) 

usermessages_sender_id 

varchar(30)

usermessages_reciever_id 

varchar(30)

usermessages_subject 

varchar(300)

usermessages_content 

usermessages_created_at 

datetime

usermessages_canReply 

tinyint(1)

When a user decides to delete a message i update the _is_deleted as i said above successfully.
It seems that i cant get the a correct SQL code to display the mesages that i have deleted...

These 3 queries tells how many msgs are in the trash for each user:

//get messages that i have sent to  myself
                $get_same = mysql_query("SELECT * FROM glr_pm_data WHERE pm_sender_id='$email' && pm_reciever_id='$email' && pm_sender_is_deleted='1' && pm_reciever_is_deleted='1' && pm_sender_is_removed='0' && pm_reciever_is_removed='0'");

$same = mysql_num_rows($get_same);

//get messages that i have recieved

$get_rec = mysql_query("SELECT * FROM glr_pm_data WHERE pm_reciever_id='$email' && pm_reciever_is_deleted='1' && pm_sender_id!='$email' && pm_reciever_is_removed='0'");

$new = mysql_num_rows($get_rec);

//get messages that i have sent to others and NOT to myself

$get_snd = mysql_query("SELECT * FROM glr_pm_data WHERE pm_sender_id='$email' && pm_sender_is_deleted='1' && pm_sender_is_removed='0' && pm_reciever_id!='$email'");

a query i have tried to display the trash messages is:

$query = "SELECT *

  FROM glr_pm_data INNER JOIN glr_usermessages ON glr_pm_data.pm_msg_id=glr_usermessages.usermessages_msg_id &&

  (pm_sender_id='$email' && pm_reciever_id='$email'

  && pm_sender_is_deleted='1' && pm_sender_is_removed='0'

  && pm_reciever_is_deleted='1' && pm_reciever_is_removed='0')

  ||

  (pm_reciever_id='$email' && pm_sender_id!='$email'

  && pm_reciever_is_deleted='1' && pm_reciever_is_removed='0')

  ||

  (pm_sender_id='$email' && pm_reciever_id!='$email'

  && pm_sender_is_deleted='1' && pm_sender_is_removed='0')

  ORDER BY glr_pm_data.pm_id DESC $limit";
So if anyone can help me out create a correct query to display the trash messages i would appreciate..