PHP - How To Strip Email Addresses From A Website...

Hi Everyone,

Very new to PHP and databases, so please go easy on me!

I have a series on web pages each containing a link that says 'apply here'. What I am trying to achieve is when any of these links are clicked on the user is taken to a php form page where they are asked for a series of further information such as name, telephone number etc. When they click submit this information then gets sent off to a speciifc email address.

My problem is that depending on which page the user has originally come from (the page where they clicked on the apply here link) needs to determine what email address the form information gets sent to.

I thought that the best way to achieve this would be to create a database that contains all of the email addresses (as eventually there will be alot of them) and the form page could call in the relevant email somehow... although I am totally confused on how to go about doing this.

Any help would be great! Thankyou.

Hey guys

Whats the best way to take all the email addresses from a MySQL database of contact information and turn it into an array which i can use in the To: Section of sending an email in php?

Thanks.

Hi

Apologies as this may seem like a trival matter, but im new to coding and just need a bit of help....

I have a form which includes a drop down menu of various departments. Depending on which department is chosen, the form is then sent to different people.

This is the html code for the drop down:

<select name="department" size="1" id="department">
<option value="" selected>Please select</option>
<option value="Health & Safety">Health &amp; Safety</option>
<option value="Property">Property</option>
</select>

So for example the first option mails out to mrjones@email.com mrsmith@email.com and the second would go to mrbloggs@emai.com mr@black@email.com and mrwhite@email.com etc...

I have a separate php file which gathers the variables so i was thinking an if statement would need to be put into this page?

Out of interest i tried something myself and sort of got a result im after:

<select name='department' id='department'>
<option value='man1@website.com'>Department 1</option>
<option value='man2@website.com'>Department 1</option>
</select>

Then i used $email_to = $_POST['department']; in the php file.

But i would like to be able to send to 2 or 3 people so tried:

<select name='department' id='department'>
<option value='man1@website.com, man2@website.com '>Department 1</option>
</select>

This didnt work


Any help very much appreciated

Thanks
Jools

I have no idea what im doing wrong but this just isnt working, theres no error messages but im not getting any of the emails. Here is all the code that i had anything to do with editing, i have removed any personal info from it.

Code: [Select]
<?php
$dbhost = 'localhost';
$dbuser = ' ';
$dbpass = ' ';

$conn = mysql_connect($dbhost, $dbuser, $dbpass) or die                      ('Error connecting to mysql');

mysql_select_db(" ", $conn);

$result = mysql_query("SELECT ****, ********** FROM **** WHERE name='*****'");

while($row = mysql_fetch_array($result))
{
$message =
"<p><u><b><font size=\"5\" color=\"#800080\">********************</font></b></u></p>
<p><b><font color=\"#800080\" size=\"4\">**************************************************</font></b></p>
<p><b><font color=\"#800080\">*********</font></b> <b><font color=\"#333333\">**********</font></b></p>
<p><b><font color=\"#800080\">********</font></b> <font color=\"#333333\"><b>***********</b></font></p>
<p><font color=\"#800080\"><b>*******</b></font> <font color=\"#333333\"><a href=\"***********************************************</a></font></p>
<p>&nbsp;</p>";
}

$query=mysql_query('SELECT `email`,`name` FROM `users`'); //grab emails and names from database
while($row = mysql_fetch_array($query)) //start a loop to send an email to each individual
{
    //mail function with $row['email'] as the email address
    //I'm using phpmailer as an example here - - >
    include_once('phpMailer/class.phpmailer.php');
    
    $mail             = new PHPMailer(); // defaults to using php "mail()"
    
    $body             = $message; //message inside the email
    
    $mail->From       = "**************"; //email address that the email is being sent from
    $mail->FromName   = "*************"; //more in depth for who the mail is from.
    
    $mail->Subject    = "***********************************"; //The subject for the message
    
    //$mail->AltBody    = "To view the message, please use an HTML compatible email viewer!"; // optional, comment out and test
    
    
    $mail->AddAddress($row[email], $row['name']);
} 

mysql_close($conn);
?>

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

Code: [Select]
<?php
$firstname = $_POST['firstname'];
$lastname = $_POST['lastname'];
$email = $_POST['email'];
$dropdown = $_POST['dropdown'];
$formcontent=" From: $firstname \n Surname: $lastname \n Email: $email \n Dropdown: $dropdown";
$recipient = "martin@sittingspiritually.co.uk, siobhan@sittingspiritually.co.uk";
$subject = "Newsletter Sign Up";
$mailheader = "From: $email \r\n";
mail($recipient, $subject, $formcontent, $mailheader) or die("Error!");
if ( mail($recipient, $subject, $formcontent, $mailheader) ){
header('Location: http://www.sittingspiritually.co.uk/thankyou.php');
} else {
die ("error");
}
?>

I have recently created a small snippet of php code for posting mail and it's sweet apart from 1 thing.

I have two email addresses in the recipient section. It only sends to the last name in the list.

Is this because i have written recipient? Should it be recipients?

I need this mail to be delivered to both of the email addresses.

I'm sure it's simple for someone with expert knowledge.

Thanks in advance for any help.

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!

 

Hello, any help would be greatly appreciated. I have two dropdowns with 2 options in each. Customer picks one option from each dropdown and the form gets emailed to addresses from the two selections. The code below gives and error.

My form:
<form method="POST" action="quote.php" onsubmit="return checkform(this)">
<input type="hidden" name="agent" value="recipient_1,recipient_2">
<input type="hidden" name="office" value="recipient_3,recipient_4">
<select name="agent" id="agent">
<option value="recipient_1">Agent1 </option>
<option value="recipient_2">Agent2 </option>
</select>
<select name="office" id="office">
<option value="recipient_3">Location1  </option>
<option value="recipient_4">Location2 </option>
</select>
<input type="submit" name="submit" value="Submit">
</form>

quote.php is below:
$recipients = array(

'recipient_1' => 'email_1@yahoo.com',
'recipient_2' => 'email_2@yahoo.com',
'recipient_3' => 'email_3@yahoo.com',
'recipient_4' => 'email_4@yahoo.com',
);
$exploded_recipients = explode(",",$_REQUEST['agent']);
foreach($exploded_recipients as $value)
{
$my_email = $recipients[$value];
$success = mail($my_email, $Subject, $Body, "From: <$EmailFrom>");
}


Thanks in advance

 :'(I've already had two strikes on my efforts at questions, so I'm planning on at least fouling this one away....
     The attached, running(!) PHP email generating program allows me to input info, but then generates the following error message after filling out the form:
 from Yahoo website:  "Sorry, the page you requested was not found.
       "Additionally, a 410 Gone error was encountered while trying to handle the request."

        Here is the questionable code:

<html>
<body>

<?php
if (isset($_REQUEST['email']))
//if "email" is filled out, send email
  {
  //send email
  $email = $_REQUEST['email'] ;
  $subject = $_REQUEST['subject'] ;
  $message = $_REQUEST['message'] ;
  mail( "debbiekn777@yahoo.com", "Subject: $subject",
  $message, "From: $email" );
  echo "Thank you for using our mail form";
  }
else
//if "email" is not filled out, display the form
  {
  echo "<form method='post' action='mailform.php'>
  Email: <input name='email' type='text' /><br />
  Subject: <input name='subject' type='text' /><br />
  Message:<br />
  <textarea name='message' rows='15' cols='40'>
  </textarea><br />
  <input type='submit' />
  </form>";
  }
?>

</body>
</html>

        Please, where do I go from here?

Trying to be different from the last kid,
Yshua

The PHP code sends me an email from the server, but the user input is empty or "blank". I only receive: "From: \ Email: \ Subject: \ Message: " and that's it.

How do I fix my PHP and/or HTML code to receive user input from the form? Attached is my existing HTML and PHP code that doesn't send me any "user input" from the form.

Thanks to anyone who can help!!

I have a paragrpah which has tags that needs to be stripped off.

so the paragraph looks like

Quote

<div id="ctl00_placeholderMain_pnlInTheBox" class="tabitem">                       <p>                      HP LaserJet 9050 printer<br/> Power cord<br/> Parallel cable<br/> HP LaserJet Q8543X Smart print cartridge<br/> Printer documentation<br/> Printer software CD<br/> Control panel overlay<br/> Face-up output bin<br/> Two 500-sheet input tray<br/> 100 Sheet Multipurpose Tray<br/> HP JetDirect Fast</p>                </div>


I want it to look like

Quote

HP LaserJet 9050 printer
Power cord
Parallel cable
HP LaserJet Q8543X Smart print cartridge
Printer documentation
Printer software CD
Control panel overlay
Face-up output bin
Two 500-sheet input tray
100 Sheet Multipurpose Tray
HP JetDirect Fast


How would I go on about doing this..

currently i use

Code: [Select]
$inbox = $html->find( "#ctl00_placeholderMain_pnlInTheBox" );

if ( isset( $inbox[ 0 ] ) )
{



$box =( $inbox[0] );

$box = strpos($box, ';') !== FALSE ? substr( $box, strpos( $box, ";" ) + 1 ) : $box; 


}
else
{
$box = "0";
}

$name = "D'Angelo" 

ok I'm running a mysql query as

$query = " INSERT INTO TEST (ID, NAME) VALUES ('NULL','$NAME')";


If the name = "D'Angelo" the apostrophe would cause it to fail. Is there a way to do this without striping the characters? 

I am building a component where users enter a Youtube URL and press save. I need to run some code on the form field where the URL was entered to strip all but the unique identifier. i.e. something like this:
$url = 'http://www.youtube.com/watch?v=_VaAlaIJ384&feature=rec-LGOUT-real_rev-rn-4r-10-HM';
strip all befor (including) 'v='
strip all after (including) '&'

Can anyone suggest how I would do this?

Hi everyone!
I'm trying to get the variables out of a string like this:
Code: [Select]
$string='this is a sentence with a load of [great, clever, textual] variables ';
What I want to do is output a list of strings that have used the variables to create unique strings like this:
Code: [Select]
this is a sentence with a load of great variables
this is a sentence with a load of clever variables
this is a sentence with a load of textual variables
I tried exploding the string into arrays, but what I really need to do is explode on '[' then output the words to an array (until I get to the closing ']') and then move on...

The eventual string will have potentially loads of variables, but let's do one thing at a time.

What's the best way of starting a project like this?

Neil

Hi All I Am confused

I would like to put info into a database but need it to be secure. I have some code shown below. The problem is I would like to put in ' but keep the data secure.
When it comes back I do not want to show \' I think you might know what I am trying to do.
Here is the code but would like to know how to stop the \' showing.
Code: [Select]
$password = mysql_real_escape_string(stripslashes(trim($_POST['password'])));
Any help would be great thank you.