Okay, Hello I've been trolling for years. This the first time I've ever asked for php help. Normally my questions seem so amateur when I finally find theanswer on my own. But this is making me pull my hair out. Hopefully someone can help me.
I currently have a php script that will look for a referral id in the url. If one is found..it displays the contact information of the referrer.
I have modified the script so in addition to it showing the contact information. It will also show a contact form on the "contact us page"
What I can't figure out is how to get the email address from the database into this form. Could someone take a look? When I use mail($row['email']...ect. The script will complete but the mail will not come to the email address in the database.
Here is the code:
This is config.php which looks for the id and displays the contact block and the email for on the contact page.
Code: <?php
session_start();
error_reporting(E_ALL);
ini_set('display_errors',"on");
/*set debug to TRUE to delete cookies and test changes to the script.
set debug to FALSE to run in production environment.*/
$debug = FALSE;
// reset everything if debug is true
if ($debug) {
$_SESSION['contact_block'] = '';
setcookie('affid','',1);
$id='';
echo "Debug is ON";
die;
}
// we no longer use this cookie. Replaced by $_COOKIE['affid']
if (isset($_COOKIE['id'])) {unset($_COOKIE['id']); }
/*Logic:
If an affiliate ID was passed to the URL as a GET, grab it and do a lookup.
Otherwise, no affiliate, so display the default contact information.*/
//echo "Site is in debug mode and under test by developer but still usable. Please ignore.<br />";
if (isset($_GET['id'])) {
//echo 'Right now $_GET[ID] is '.$_GET['id']."<br />";
} else {//echo 'Right now $_GET[ID] is undefined'."<br />";
}
if (isset($_GET['id']))
{$id = $_GET['id'];}
elseif (isset($_COOKIE['affid'])) {$id = $_COOKIE['affid'];}
else {$id = 0;}
//echo "Now ID in config.php = ".$id."<br />";
$contact_block = lookup($id);
if (empty($contact_block)) {
$contact_block = '<p>United States Office: 410-727-6444</p>
<p>Costa Rica Office US Line: 410-800-4773</p>
<p>Costa Rica Office: 011-506-2778-7080</p>
<p>Toll Free: 866-466-5623 </p>';
$id = 0;}
// set a cookie
setcookie('affid', $id, time()+(3600*24*30),'/','.delpacifico.net');
$_SESSION['contact_block'] = $contact_block;
//echo 'Cookie in config.php = '.$_COOKIE['affid']."<br />";
//echo 'Final ID = '.$id."<br />";
?>
<?PHP
function lookup($id=0) {
// set default contact block in case affiliate no longer exists
$contact_block='';
if ($id > 0) {
// Establish database connection
include("project/ewcfg6.php");
$db = mysql_connect(EW_CONN_HOST,EW_CONN_USER,EW_CONN_PASS);
mysql_select_db(EW_CONN_DB);
// get the contact information
$sql = mysql_query("select * from affiliates where id = $id");
$num_rows = mysql_num_rows($sql);
if ($num_rows > 0){
while($row = mysql_fetch_array( $sql )) {
$contact_block = '<P>Name: '.$row['Name'].'<br />'.'Firm: '.$row['Firm'].'<br />'.'Phone: '.$row['Telephone'].'<br />'. '<a href="mailto:'.$row['email'].'?bcc=info@delpacifico.net">Send Email</a> </P>';
}
while($row2 = mysql_fetch_array( $sql )) { $contact_email = $row2['email'];
}
}
}
return($contact_block);
}
?>
<?PHP
$contact_form = '<form method="post" action="sendeail.php">
<!-- DO NOT change ANY of the php sections -->
<?php
$ipi = getenv("REMOTE_ADDR");
$httprefi = getenv ("HTTP_REFERER");
$httpagenti = getenv ("HTTP_USER_AGENT");
?>
<input type="hidden" name="ip" value="<?php echo $ipi;?>" />
<input type="hidden" name="httpref" value="<?php echo $httprefi; ?>" />
<input type="hidden" name="httpagent" value="<?php echo $httpagenti; ?>" />
Your Name: <br />
<input type="text" name="visitor" size="35" />
<br />
Your Email:<br />
<input type="text" name="visitormail" size="35" />
<br /> <br />
<br />
Attention:<br />
<select name="attn" size="1">
<option value=" Sales n Billing ">Sales n Billing </option>
<option value=" General Support ">General Support </option>
<option value=" Technical Support ">Technical Support </option>
<option value=" Webmaster ">Webmaster </option>
</select>
<br /><br />
Mail Message:
<br />
<textarea name="notes" rows="4" cols="40"></textarea>
<br />
<input type="submit" value="Send Mail" />
<br />
</form>'
?>
This is the email script that's called when the user submits the form
Code: <html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Sendemail Script</title>
</head>
<body>
<!-- Reminder: Add the link for the 'next page' (at the bottom) -->
<!-- Reminder: Change 'YourEmail' to Your real email -->
<?php
$ip = $_POST['ip'];
$httpref = $_POST['httpref'];
$httpagent = $_POST['httpagent'];
$visitor = $_POST['visitor'];
$visitormail = $_POST['visitormail'];
$notes = $_POST['notes'];
$attn = $_POST['attn'];
if (eregi('http:', $notes)) {
die ("Do NOT try that! ! ");
}
if(!$visitormail == "" && (!strstr($visitormail,"@") || !strstr($visitormail,".")))
{
echo "<h2>Use Back - Enter valid e-mail</h2>n";
$badinput = "<h2>Feedback was NOT submitted</h2>n";
echo $badinput;
die ("Go back! ! ");
}
if(empty($visitor) || empty($visitormail) || empty($notes )) {
echo "<h2>Use Back - fill in all fields</h2>n";
die ("Use back! ! ");
}
$todayis = date("l, F j, Y, g:i a") ;
$attn = $attn ;
$subject = $attn;
$notes = stripcslashes($notes);
$message = " $todayis [EST] n
Attention: $attn n
Message: $notes n
From: $visitor ($visitormail)n
Additional Info : IP = $ip n
Browser Info: $httpagent n
Referral : $httpref n
";
$from = "From: $visitormailrn";
mail("kelbizzle@mailinator.com", $subject, $message, $from);
header( "Location: http://www.delpacifico.com/thanks.php" );
?>
<p align="center">
Date: <?php echo $todayis ?>
<br />
Thank You : <?php echo $visitor; ?> ( <?php echo $visitormail; ?> )
<br />
Attention: <?php echo $attn; ?>
<br />
From:<?php echo $from; ?>
<br />
Message:<br />
<?php $notesout = str_replace("r", "<br/>", $notes);
echo $notesout; ?>
<br />
<?php echo $ip ;?>
<br /><br />
<a href="contact.php"> Next Page </a>
</p>
</body>
</html>
Hit counter updating once per IP - IP HIT COUNTER
I have a hit counter, for the amount of views on a tutorial.It'll do the query and then do..$views = $row['views'] + 1;Then insert $views into the database.This updates the view for each refresh of
SOAP Issue
Hi,I am facing some understanding problem with SOAP basic.kindly recommend some SOAP expert.Thanks
Could Someone Please Debug This?
I was wondering if someone could debug this script for me. I realize it's not the tidest script (and probably not the most efficiant in the world) but it was quite late when I wrote it and I can't be
PHP onsubmit in the form not going to the fuction.
I have a form through ‘onsubmit’ calling a function validation(). But not going to the function at all. Why?<form action="member.php" method="post"
PHP & MS Access - Line Break
Hey Guys!I'm pulling records from an MS Access database and listing them using PHP and I'm running into an error that I can't seem to figure out.Please see the code below:Code: if
insert Multiple rows into the table from that table data
Hi All,
subtract 1 from value entered in text field
HiHow do I subtract 1 from the vaue entered into a text field?Thanks
Slow data retrieval which requires improvement..please help
I am working on a Help Desk Ticketing system and have a page called MY TICKETS which shows all tickets in grids. the problem is that the number of records are around 30 to 40 but there is a lag
Using Microsoft Exchange Server with PHP
Hi,I wanted to know if its possible to fetch email attachments from the exchange server using php.I know its possible to read message using the source I found in an article here
private constructor
Hello,Can we create a constructor as private? If yes, what is the use of it? If no, why can't we make it?Please suggest...Thanks
