PHP - How Do I Pass Variables To A Php Email Script?

I have a search page that then submits to a php page that queries the database. I've been struggling to figure out how to paginate it, but I think I've narrowed down the problem. I didn't realize $_POST results didn't pass through when people clicked the pagination links at the bottom. I verified this by replacing  the LIKE variable with a specific word and it worked.

I'm trying to learn how to set up sessions, thinking this might solve my problem. Doesn't seem to be working. Can I get some suggestions on how to do this? What's happening now is that it's pulling a random 8 pages that have nothing to do with the original query.

I start my entire page with:
Code: [Select]
<?php

session_start();

$_SESSION['leafshape'] = $_post['select1'];
$_SESSION['leafcolor'] = $_post['select2'];
$_SESSION['leafvein'] = $_post['select3'];
$_SESSION['leafmargin'] = $_post['select4'];

$leafshape = $_SESSION['leafshape']; 
$leafcolor = $_SESSION['leafcolor'];
$leafvein = $_SESSION['leafvein']; 
$leafmargin = $_SESSION['leafmargin']; 

and I'm setting up the queries like this:
Code: [Select]
$query = "SELECT COUNT(*) as num
                    FROM
                        descriptors
                    JOIN
                        plantae ON (descriptors.plant_id = plantae.plant_name)
                    WHERE
                        descriptors.leaf_shape LIKE '{$_SESSION['leafshape']}'
                        AND descriptors.leaf_venation LIKE '{$_SESSION['leafvein']}'
                        AND descriptors.leaf_margin LIKE '{$_SESSION['leafmargin']}'";

I also tried replacing the '{$_SESSION['leafshape']}' in the query with the assigned variable $leafshape

I have a form, where I'm collecting registration info - like name, address, email, password. I'm calling another php file at server side code, where it will check whether the email exists or not. Pretty simple, just receiving those post variables and check with the database.

The issue, if I find a match, I want to go back to the registration.php page, using the following code:

if ($email_already_use == "y") {
      $_SESSION['ERROR'] = "Error";
      $_SESSION['MESSAGE'] = "This email address already used. Please try another";
      header("location: ".$settings['site_url']."registration.php");
      exit;
}

Now, I would like to place the user input at the registration.php file, but I do not want to use pass variable at URL like this:

header("location: ".$settings['site_url']."registration.php?".name=$name&address=$address&email=$email;

Is there anyway, I can retrieve those variables at registration.php, without specifying .name=$name&address=$address&email=$email ?

Thanks for your help. I see some sites has similar implementation, but did not find anything like how to do it.

Hello everyone,

Can someone show me a way how to pass $_post variable from a form to a function?

So, input username and input password to a function login($username, $password).

Before, if I wanted to send a welcome letter when a user registers i'd do this.

$body = "<inserted html code>";
mail('email@email.com', 'Subject', $body, $headers);


Now that I am advancing in PHP, I was trying a different method, because when I did the above method, I would have to take all the HTML out of the variable to change something, like an image link, etc...

I have tried doing another method, where I can actually leave all the HTML code in a separate file, so that I can easily edit it, and tried 3 things...

This one works, but it doesn't pass variables:

$body = file_get_contents("emailTemplate.inc.php");
mail('email@email.com', 'Subject', $body, $headers);

When I do this one, the page actually just shows on the current page (naturally):

$body = include("emailTemplate.inc.php");
mail('email@email.com', 'Subject', $body, $headers);

Of course, this has the same effect as the include function:

$body = require("emailTemplate.inc.php");
mail('email@email.com', 'Subject', $body, $headers);

So my question is, how do I send a formatted HTML email, and pass variables to it, so I can personalize it by the persons name, etc, without adding the HTML to a variable, and so that I can easily update the page whenever I want, and without taking it out of the variable, and sticking back in the edited code?

Any help would be appreciated! I would also like to say that I am using this code for the $headers variable too:


$headers  = 'MIME-Version: 1.0' . "\r\n";
$headers .= 'Content-type: text/html; charset=iso-8859-1' . "\r\n";
$headers .= 'From: from@email.com <email@email.com>' . "\r\n";

Thank you in advanced!

I have the array defined and print_r (outside the function is show what I need...)
However, I need to somewhay pass those three arguments - name, price, shipping (keys & values) into the "all_products" function and assign (inside the function) each element to a variable {name, price, shipping}.

Code: [Select]
function all_products($key,$value) {

# This is where I'm lost - I know the values are passed to the function but how to I assign them to below variable?
echo "$name";
echo "$price";
echo "$shipping";


// Products array defined to send values into "all_products" function & loop to display item name & individual pricing (using WHILE LOOP)
$products = array('Product1' =>
                                    array   (   'name'  =>  'item one',
                                                'price' => '30.00',
                            'shipping' => '0.00'),
             'Product2' =>                       
                        array (   'item two',
                                                'price' => '19.50',
                            'shipping' => '0.10'),
             'Product3' =>
                        array (   'item three',
                                                'price' => '21.99',
                            'shipping' => '0.10')
                                                );


while (list($keys, $values) = each($products)) {
             while (list($k, $v) = each($values))
   echo "Checking Looped Data Outside Function: <strong>$k: </strong> $v<br/>";

#   echo "<pre>";
#   print_r($value);
#   echo "</pre>";

# Trying to send array elements into "all_products" function & echo (name, price, shipping) keys and values inside that function
all_products($k,$v);

}

I want to query a database (search) and pass the desired columns from the search results to another page like so: Code: [Select]
<?php

//address error handling

ini_set ('display_errors', 1);
error_reporting (E_ALL & ~E_NOTICE);


//authenticate user
require('auth.php');


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

// Connect to the database.

        require_once ('config.php');


//Query the database.
$sql = "SELECT* FROM members INNER JOIN images ON members.member_id = images_member_id WHERE members.ethnicity = '{$_POST['ethnicity']}'";

$query = mysql_query($sql);

if(mysql_num_rows($query) > 0){ while(($row = mysql_fetch_assoc($query)) !== false)
         
{

//Redirect to search results page.

header("Location: search_results.php?friend='.$row['member_id'].'&me='.$_SESSION['id'].' &pic='.$row['image'].'&name='.$row['username'].'");

}

} else { //If no results found.

echo 'No results match this search query.' ;

}

}



?>
 

I get the following error when i try to run the page (by submitting a form from another page which executes this page):

Parse error: syntax error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING in /home/a4993450/public_html/profile_search.php on line 31

The culprit line is this one:
header("Location: search_results.php?friend='.$row['member_id'].'&me='.$_SESSION['id'].' &pic='.$row['image'].'&name='.$row['username'].'");

As you can see, I eliminated all white space between the variables and concatenations, thinking that that was the problem but I keep getting the error message.  I'm at a loss about what to do next.  Any help?

Currently I have a PHP file that is pulling information from a table in the Database and inserting it into an HTML table. It consists of the fields: Last_Name, First_Name, Party, District, Address, CIty, State, Zip, and Email. And the Email field is being converted to a Hyperlink.  (All working fine so far)

I also have a form that has a prewritten letter to be sent to the email address. I need to have the HyperLink from the Email pass the address to the form to allow me to send it. I am not sure how to get this to happen. Here is the code I have so far:

The pull from the database:
<?php




$dbhost = 'localhost';
$dbuser = 'removed';
$dbpass = 'removed';
$db = 'removed';

$link = mysql_connect($dbhost, $dbuser, $dbpass)or die(mysql_error());
mysql_select_db($db)or die(mysql_error());

$result = mysql_query("SELECT * FROM 2011members") 
or die(mysql_error());  


echo "<table border='1'>";
echo "<tr> <th>Last Name</th> <th>First Name</th> <th>Party</th> <th>District</th> <th>Address</th> <th>City</th> <th>State</th> <th>Zip</th> <th>Email</th> </tr>";
// keeps getting the next row until there are no more to get
while($row = mysql_fetch_array( $result )) {
// Print out the contents of each row into a table
echo "<tr><td>"; 
echo $row['Last_Name'];
echo "</td><td>"; 
echo $row['First_Name'];
echo "</td><td>"; 
echo $row['Party'];
echo "</td><td>"; 
echo $row['District'];
echo "</td><td>"; 
echo $row['Address'];
echo "</td><td>"; 
echo $row['City'];
echo "</td><td>"; 
echo $row['State'];
echo "</td><td>"; 
echo $row['Zip'];
echo "</td><td>"; 
//Normal Pull
//echo $row['Email'];
//echo "</td><td>"; 
//Just Hyperlink
//echo '<a href="http://',Email,'">',Email,'</a>';
//echo "</td></tr>"; 
echo '<a href="http://'.$row['Email'].'">'.$row['Email'].'</a>';
echo "</td></tr>"; 
} 

echo "</table>";
?>

The Form:
Code: [Select]
<?php 
if($_POST){
$to = 'becca@windfallstudio.com';
$subject = "WHAT SHOULD THIS BE";
$message  =  "Date: $date\n\r".
 "Dear $legislator,\n\r".
 "As a constituent of yours, I urge you to closely review $bill as it pertains to the distribution and allotment of the 4 percent bed tax collected at lodging properties in Montana.\n\r".
"Tourism is very important to Montana. Not only it is the second largest industry in Montana, it is also a key economic engine for businesses and the thousands of Montanans that have jobs because of tourism.\n\r".
"Nearly 10 million visitors travel to our state each year, contributing between $2.4 billion and $3 billion annually into our economy. In addition to bringing new money into our state, these visitors also help support more than 42,000 Montana jobs and $897 million in worker salaries. (Source: Montana Office of Tourism Annual Report - 2010)\n\r".
"Please rest assured that these millions of visitors don't come on their own. They are enticed to come here through marketing and outreach done by various organizations that include the Montana Office of Tourism, Glacier Country Regional Tourism Commission and Missoula Convention and Visitor Bureau.\n\r".
"While there is a 7 percent bed tax collected at all lodging entities in the state, 3 percent supports the General Fund and 4 percent supports travel-related partners. The 4 percent is vital to marketing our stage and it is imperative for that money to remain solely dedicated to travel and tourism promotion. I would urge you to vote no on any bill that would direct any portion of that 4 percent elsewhere.\n\r".
"Thank you for your consideration in this request and for doing all you can to represent us, your constituents, to the best of your ability. I look forward to hearing from you soon.\n\r".
"Sincerely,\n".u
"$name \n".
"$street \n".
"$city, $zip \n".
"$email \\n".
$headers = "From: $email";
mail($to, $subject, $message, $headers);
// SUCCESS!
echo '<p class="notice">'.
'Thank you for your submission.  '.
   '</p>';
// clear out the variables for good-housekeeping
unset($date,$legislator,$bill,$name,$street,$city,$zip,$email);
$_POST = array();
}
?>

<div id="content" class="section">
<?php arras_above_content() ?>

<?php if (have_posts()) : while (have_posts()) : the_post(); ?>
<?php arras_above_post() ?>
<div id="post-<?php the_ID() ?>" <?php arras_single_post_class() ?>>
        <?php arras_postheader() ?>
       
        <div class="entry-content clearfix">
<form method="post" action="" id="letter">
<p><label for="name">Date</label>
<input type="text" name="date" id="date" value="<?php echo $_POST['date'];?>"/></p>
<p>Dear Senator/Representative
<select name="legislator">
<option>Choose a Legislator</option>
<option>Senator John Q. Public</option>
<option>Rep. Jane Q. Public</option>
<option>Some Third Person</option>
</select>,</p>
<p>As a constituent of yours, I urge you to closely review Bill
<select name="bill">
<option>Choose a Bill</option>
<option>SB 13 / LC0448</option>
<option>LC0505</option>
<option>LC0532</option>
</select>
 as it pertains to the distribution and allotment of the 4 percent bed tax collected at lodging properties in Montana.</p>
<p>Tourism is very important to Montana. Not only it is the second largest industry in Montana, it is also a key economic engine for businesses and the thousands of Montanans that have jobs because of tourism.</p>
<p>Nearly 10 million visitors travel to our state each year, contributing between $2.4 billion and $3 billion annually into our economy. In addition to bringing new money into our state, these visitors also help support more than 42,000 Montana jobs and $897 million in worker salaries. (Source: Montana Office of Tourism Annual Report - 2010)</p>
<p>Please rest assured that these millions of visitors don't come on their own. They are enticed to come here through marketing and outreach done by various organizations that include the Montana Office of Tourism, Glacier Country Regional Tourism Commission and Missoula Convention and Visitor Bureau.</p>
<p>While there is a 7 percent bed tax collected at all lodging entities in the state, 3 percent supports the General Fund and 4 percent supports travel-related partners. The 4 percent is vital to marketing our stage and it is imperative for that money to remain solely dedicated to travel and tourism promotion. I would urge you to vote no on any bill that would direct any portion of that 4 percent elsewhere.</p>
<p>Thank you for your consideration in this request and for doing all you can to represent us, your constituents, to the best of your ability. I look forward to hearing from you soon.</p>
<p>Sincerely,<br />
<label for="name">Name:</label>
<input type="text" name="name" id="name" value="<?php echo $_POST['name'];?>"/><br />
<label for="email">Street:</label>
<input type="text" name="street" id="street" value="<?php echo $_POST['street'];?>"/><br />
<label for="email">City:</label>
<input type="text" name="city" id="city" value="<?php echo $_POST['city'];?>"/><br />
<label for="email">Zip:</label>
<input type="address" name="zip" id="zip" value="<?php echo $_POST['zip'];?>"/><br />
<label for="email">E-mail:</label>
<input type="text" name="email" id="email" value="<?php echo $_POST['email'];?>"/></p>
<input type="submit" class="button" value="Submit" />
</form>
<?php the_content( __('<p>Read the rest of this entry &raquo;</p>', 'arras') ); ?> 
        <?php wp_link_pages(array('before' => __('<p><strong>Pages:</strong> ', 'arras'), 
'after' => '</p>', 'next_or_number' => 'number')); ?>
</div>
What do I need to do to get the Email link from the HTML table to pass to the Email variable in the Form?

Hello.

I have series of pages which connect form data and insert it into my database.  When someone completes the form, they get an autoresponder with some variables of their signup included ($park & $firstname below).  I would like to include some more detailed information regarding the event that is found in a different table called 'event'. 

I am not sure if it would take a join, or how to pass the variables.  Can I just create a new SELECT statement and then pass the variables along?

Any guidance would be great.


Code: [Select]
<?php include('dbconfig.php'); 

$event_id   = $_POST['event_id'];
$park                    = $_POST['park'];
$firstname               = $_POST['firstname'];
$lastname                = $_POST['lastname'];
$email                   = $_POST['email'];
$phone                   = $_POST['phone'];
$email_list              = $_POST['email_list'];

// Make a MySQL Connection
mysql_connect("localhost", "$user", "$password") or die(mysql_error());
mysql_select_db("$database") or die(mysql_error());

mysql_query("INSERT INTO volunteer
(id, event_id, park, firstname, lastname, email, phone, email_list) VALUES('', '$event_id', '$park', '$firstname', '$lastname', '$email', '$phone', '$email_list') ")
or die(mysql_error());
?>

<?php

$to = "$email";
$subject = "Trailworker Event Signup Confirmation";
$message = "Hello [b]$firstname[/b]! Thank you for signing up to work the [b]$park [/b] trailworker event.  A crew leader will contact you shortly.";
$from = "info@xxxxxxxxxx.com";
$headers = "From: $from";
mail($to,$subject,$message,$headers);

 
echo "Thank you for signing up. You will receive an email shortly letting you know event details and who your crew leader is.";


?>

Hi, n0obie here.  I'm trying to identify where my customers are coming from via emails I've sent/received. However, many email providers (namely Gmail) have circumvented this by disallowing IP address geolocation/image caching.

Hi, I have this script, it all works fine apart from when I pass the variable on, it only passes the first word and not the whole variable

The form that actions to the samples page passes the $siteName as My Test Site, if I type echo $siteName in the sameples page, it will print My Test Site, however when I use this

Code: [Select]
createSample&siteName=$siteName
to pass the variable to the next page, it just echos 'My' instead of My Test Site. Even when I scroll over the link above it just shows My in the url.

Code: [Select]
case "samples":

// Get submitted data and assign to variables

$siteName = $_POST['siteName'];
$adminEmail = $_POST['adminEmail'];
$sendmailLoc = $_POST['sendmailLoc'];
$imgdir = $_POST['imgdir'];
$imgdirbase = $_POST['imgdirbase'];

// Write variable data to text file

$FileName = "data/server.txt";
$FileHandle = fopen($FileName, 'w') or die("can't open file");
$data = "<?php\n\$siteName = '$siteName';\n?>";
fwrite($FileHandle, $data);
$data = "<?php\n\$adminEmail = '$adminEmail';\n?>";
fwrite($FileHandle, $data);
$data = "<?php\n\$sendmailLoc = '$sendmailLoc';\n?>";
fwrite($FileHandle, $data);
$data = "<?php\n\$imgdir = '$imgdir';\n?>";
fwrite($FileHandle, $data);
$data = "<?php\n\$imgdirbase = '$imgdirbase';\n?>";
fwrite($FileHandle, $data);
fclose($FileHandle);

// Displays the create sample pages page

ECHO <<<SAMPLES

<table border=0 align=center bgcolor=#00CCFF>
  <tr>
    <td><span class=style1><b><center>Create Sample Pages</center></b></span></td>
  </tr>
  <tr>
    <td>Would you like Member Site Maker to create sample pages for:
<ul>
<li>index.html</li>
<li>login.html</li>
<li>search.html</li>
<li>register.html</li>
</ul>
</td>
</tr>
<tr>
<td><a href=installation.php?cmd=createSample&siteName=$siteName>Yes</a>
</td>
<td><a href=installation.php?cmd=mysql>No</a>

</td>
</tr>

</table>

SAMPLES;

break;
Can anybody tell me where I am going wrong please?

Thanks

Hi Everyone!  Thanks in advance for taking the time to review my post.  I am pretty new to PHP so please excuse my ignorance.

I am working a project for myself.  I want to be able to send out newsletters to my customers and sponsors.    I have written the code and here it is:

<?php
$subject = $_POST['subject'];
$message = $_POST['message'];
$email = "bubba@bubba.com";
$headers = "From: $email";
$email_list = file("elist.txt");
$total_emails = count($email_list);
for ($counter=0; $counter<$total_emails; $counter++) {
   $email_list[$counter] = trim($email_list[$counter]);
   }
$to = implode(",",$email_list);


if ( mail($to,$subject,$message,$headers) ) {
   echo "The email has been sent!";
   } else {
   echo "The email has failed!";
   }
?>

-----------------------------------------------------------------------------

In my elist.txt file - I have two fields.   Name and email.

Bubba|bubba@bubba.com
Oohay|oohay@yahoo.com

If i leave the names out of this file, the email script works great!

I want to leave the names in there and reference them in my email that I am sending out to be more personal. 

Can this be done and can you help?

Thanks!
Mike

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.

Good afternoon everyone, probably just a quick one this one!

I have a reg form, and once the user has been added to the database then it is meant to send them an email with their username and password.

The email works fine, received as it should, however the place where I am trying to echo variables is blank.

For instance
Code: [Select]
<style type='text/css'>
h3 {
font-family: Tahoma, Geneva, sans-serif;
font-size: 24px;
font-style: oblique;
color: #00F;
}
</style>
<body>
<img src='https://www.buy2earn.co.uk/images/logo.png' width='240' height='100'>
<hr>
<h3>Welcome to buy2earn.co.uk!</h3>
<p>
Welcome <?php echo $username:?>
just shows Welcome ...................

How do I send the variables in the email?

Cheers

Hi guys,

this is my first post, and im needing some help with email and variables in php.

when i save this out it works:


<?php

$test = "hi there";
mail('myemail@mythingy.com.au','test subject', 'This is a test');
?>




but as soon as i add variable into the mix it doesnt work...




<?php

$email = "myemail@mythingy.com.au";

mail($email,'test subject', 'This is a test');
?>





any clues?