[Resolved] URL in Message of email

deolsabh

Hi Guru's
I am trying to insert a url in email message which follows to a information related to that email address
my link works but some how i am not able to insert this link into message i.e in body
i can see this link when i exceute this file and i can follow the link also but i am not able to include in the body
Please help
Here is my code

<html>
<head>
<title>IT Phone List</title>
</head>
<BODY>
<?php

require_once("site_sc_fns.php");

if(empty($SEND)){$SEND="";}

switch($SEND){
case "Send":
if(!empty($MESSAGE)){
if(empty($SUBJECT)){$SUBJECT= " ";}
$HEADERS = "MIME-Version: 1.0\r\n";
$HEADERS .= "Content-type: text/html; charset=iso-8859-1\r\n";
$HEADERS .= "From: Info <[ REPLY EMAIL ADDRESS ]>\r\n";
/ [ REPLY EMAIL ADDRESS] should be replaced with the appropriate email address /
/ This script is based on pulling email addresses from a MySQL user database The code below should be changed to the appropriate information /

		$SUBJECT = "IT Phone List Update.\r\n"; 

		$MESSAGE = "$url" ;

		$linkID = mysql_connect("localhost", "", "");
		mysql_select_db(virus, $linkID);

		$obRS = mysql_query("SELECT email_g FROM phlistnew", $linkID);

		while($row = mysql_fetch_row($obRS)){
			foreach ($row as $field){

	mail($field, $SUBJECT, $MESSAGE, $HEADERS);
				print "Message sent to: $field";

			}
		}

		mysql_close($linkID);
		echo "<hr><b>MESSAGE DETAILS</b><hr>";
		echo "<b>Subject:</b> $SUBJECT<br>";
		echo "<b>Message:</b> $MESSAGE <br>"; 

		$email_g = $field ;

		$url = "show_cat.php?email_g=" .$field;
   		$ktsite =  $field; 
   			 $url = "show_cat.php?email_g=" .$email_g;
  	 	$ktsite =  $email_g; 
   		   do_html_url($url, $ktsite); 
   		   echo "<b>Message:</b><p>$MESSAGE";
			echo do_html_url($url, $ktsite);

	}
	break;
default:
	echo "<FORM ACTION=itmail.php  METHOD=GET NAME=FORM1 >";
	echo "Please type in html code below.<BR>";
	echo "<TEXTAREA NAME=MESSAGE STYLE='width:500;height:300' WRAP=off  > </TEXTAREA><BR>";
	echo "<INPUT TYPE=BUTTON ONCLICK=\"document.FORM1.MESSAGE.value=''\" VALUE=Reset >&nbsp;<INPUT TYPE=SUBMIT VALUE=Send NAME=SEND > ";
	echo "</FORM>";

}
?>
</BODY></HTML>

marian

from what i am seeing you are sending the email before you declare the url? maybe that is what is not working.

Roger_Ramjet

I use rawurlencode to pass URLs etc in message bodies. Don't know how it will work with a URL in the subject instead. Be interesting to find out.

deolsabh

$MESSAGE = $url ;

i Have actually commented out it is not there
i just wanted to try that

Please help

deolsabh

Ramjet
i am looking to put that in body
if you can help

marian

i don't think adding the url to the body is a problem; i have done it several times:

here is what you want right?

$subject = "Testing";
$body = "<BR><BR>";
$body .="click <A CLASS=TBLACK HREF=\"http://www.phpbuilder.com\">here</A> to update us your information.<br>";

/ additional header pieces for errors, From cc's, bcc's, etc /
$headers = "From: \n";
$headers .= "Return-Path:\n"; // Return path for errors
$headers .= "Reply-To:\n";
/ If you want to send html mail, uncomment the following line /
$headers .= "Content-Type: text/html; charset=iso-8859-1\n"; // Mime type
$headers .= "cc:\n"; // CC to
$headers .= "bcc:\n"; // BCCs to
/ and now mail it /

mail($sEmail,$subject,$body,$headers);

copy this and test it out with an email address and you will see it works;

it is how you are declaring your url.

deolsabh

actually i am adding a link to database which is releated to his email address and when he click on this link it takes to a form which he can update

Roger_Ramjet

$msg = 'Please click this link to edit your details ' . $url ;

$body = rawurlencode($msg);

deolsabh

now i get this in body of email
somehow i am not a getting emaill address as url in body

show_cat.php%3Femail_g%3D

deolsabh

ANY UPDATE i a struck