PHP - One Form, Two Dropdowns With Selected Values Going To Separate Email Addresses

I want to send confirmation email to 2 different email boxes.
this is the code sending to one box:

{
$this->load->library('email');
//$config['mailtype'] = 'html';
//$this->email->initialize($config);

$this->email->from('no-reply@mymail.com 'Site team');
$this->email->to($em);

$this->email->subject('Welcome');
$msg = 'You have registered';

$this->email->message($msg);

$this->email->send();
}
thanks
and what should be the code sending same email to one more email box (example: mymail@gmail. com)

Hi there,

I have a newsletter sign up form which just puts the data (id and email) into a mysql table.

To stop people hacking the site, is there a way to make sure the only thing being submitted in the input is an email address?

Here's my current form and submit php:

Code: [Select]
<?php

$mailer = $_GET['mailer'];

if ($mailer == 'added') {

$email=$_POST['email'];

if($email == '') {
echo '<div class="daily_not_submitted"><span style="padding-right:6px;"><img src="https://store.huhmagazine.co.uk/images/cross.jpg"></span>Please fill in all the fields.</div>';
}else {

$sql="INSERT INTO `dailymailer` (`email`) VALUES ('$email');";
$result=mysql_query($sql) or die(mysql_error());

if($result){
echo "<div class='daily_submitted'><span style='padding-right:6px;'><img src='http://www.huhmagazine.co.uk/images/uploaded/checkboxtick.jpg'></span>Thank you.</div>";
}
else {
echo "Error\n";
}
}
}
?>

<div id="sidebarnewsletter">
<form name="mailinglist" method="post" action="?mailer=added">
<input type="text" name="email" class="sidebarnewsletter" placeholder="Enter Your Email Address" />
<input type="submit" class="sidebarnewsletter_button" value="Sign Up">
</form>
<div class="clear"></div>
</div>

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.

I'm trying to make a script that will search the source code of a given url and strip every email address that pops up.

I already have a script that will crawl around, jumping from webpage to webpage... i just need to figure out how to strip the contents... any suggestions?

goodguybadguy.net

they can tell when you enter an email address that hasnt been registered yet. how the hell are they doing this? does gmail or  yahoo have some sort of database they allow access to for this?

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

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, 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

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 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!

 

I am currently trying to make a line graph out of data using php and javascript. How do I add up the values of a column and separate them by month. For example the database has 74 amount of rows. Then the values from the "views" column get added up and then displayed by month.

Code: [Select]
   <table width="70%" class="linechart">
     <thead>
       <tr>
         <td></td>
         <th scope="col">Jan</th>
         <th scope="col">Feb</th>
         <th scope="col">Mar</th>
         <th scope="col">Apr</th>
         <th scope="col">May</th>
         <th scope="col">Jun</th>
         </tr>
       </thead>
     
     <tbody>
       <tr>
         <th scope="row">Post Views</th>
         <td>24324</td>
         <td>29634</td>
         <td>15435</td>
         <td>56545</td>
         <td>23543</td>
         <td>2123</td>
         </tr>
         
       </tbody>
   </table>

Hey guys,

I need your help on this please.

I am working on a php web application. I have a form that gets information for Supplier and his traveling details.

The values are stored in arrays. I would like to store supplier details in Supplier table and the travelling details in the Travel table.

Here is the code with the comments.

<?php
    if (isset($_VARS['submitSuppliers']))
    {
        //error checking starts here
        $isError = false;
        if (empty($_VARS['supplierName']))
        {
            $isError = true;
            $_VARS['supplierRequest']['supplierName']['errorMessage'] = 'You need to provide a Supplier Name.';
        }

        if (empty($_VARS['address']))
        {
            $isError = true;
            $_VARS['supplierRequest']['address']['errorMessage'] = 'You need to provide an Address.';
        }
        if (empty($_VARS['travel']))
        {
            $isError = true;
            $_VARS['supplierRequest']['city']['errorMessage'] = 'You need to provide travelling details.';
        }

        #this checks if there is no error and then proceeds to save form values
        if (!$isError)
        {
            #This function adds the details and Returns the autoincremented Supplier ID
            $SupId = add_suppliers($_VARS); 
            if ($SupId)
            {
                #=== Now here I would like to save the travelling details in the Travel table  using the generated supplier id
                # $travId = add_Travel($_VARS); //==== how do I segregate only travel details from the $_VARS array to store in travel table?
                REDIRECT('/supplier/index.html', array('confirmationMessage' => 'Your details have been saved.'));
            }else
            {
                notify_admin('supplierjoin.php');
            }
        }else
        {
            $_VARS['supplierRequest']['errorMessage'] = "There was a problem with the information you provided. Please check the form and try again.";
        }
    }

?>


Kindly help.

Any comment or feedback is always welcome.

Thank you

I have created a query to show the subject name as a drop down box now I would like to you use value to compare what module available in the database.

For now I can disaplyed all the module that is avilable for all the subject. But i would like to use the drop down box to gather which subject they have chosend then use this information to gather the module

$query=("SELECT Tes_Name FROM User u, Subject s, Test t WHERE u.Use_ID = '{$_SESSION['ID']}'
    
    AND s.Sub_ID=t.Sub_ID

");
<Html>

<?php

session_start();

$Value1 = mysql_real_escape_string(trim($_POST['myselect'])); 

$_SESSION['myselect'] = $Value1;

//echo $Value1;

include '../Database/connection.php';



?>

<body>
<form action="Previousq_Module2.php" method="post">
<?PHP


include '../Database/Module_Exsit.php';


$result=mysql_query($query) or die ("Unable to Make the Query:" . mysql_error() );
echo "<select name=select>";

while($row=mysql_fetch_array($result)){

echo "<OPTION VALUE=".$row['Tes_ID'].">".$row['Tes_Name']."</OPTION>";
}

echo "</select>";

?>

<input type="submit" value="submit"/>
</form>
</body>
</html>

I have several drop down boxes. When submit is clicked it execute query on another page. Problem is when submit is clicked selected values are return to defaults. Is it possible for the values to be remembered after submitting them? Part of the drop down code:
Code: [Select]
  <?php
            $result = mysql_query("SELECT *
 FROM product
GROUP BY Rim");
            ?>
           
  <select id="Rim" name="Rim"  selected="selected" style="width:158px;position:static;z-index:-1;">
  <option value="rim" selected="selected"><?php echo "Rim"; ?></option>

 <?php
 
 while ($row = mysql_fetch_array($result)) {
  echo "<option>" . $row['Rim']  . "</option>";
  echo "<br />";
  } ?>
 
       </select>  

Hi, I have a form for news articles.  It has a title and a body which is fine.  I also have a search box that allows the user to search for a memeber and click their name when it appears.  This moves a div with a data-id into another div.  The purpose of this is to tag them in the article.

I am able to post all of the simple stuff but how would i post these value.  I am assuming that i would need to create an array of said values but i am struggling to get them showing in post at all.

Here is the code i have so far

<?php

function searchForPeople($searchVal, $exclude = '0'){

	$sv1 = $searchVal;
	$sv2 = $searchVal;

	include 'includes/dbconn.php';
	$out ="";

	$stmt = $conn -> prepare("
	                         SELECT fname, lname, id
	                         FROM person 
	                         WHERE id NOT IN (".implode(',', array_map('intval', $exclude)).") 
	                         AND (fname LIKE CONCAT('%',?,'%') OR lname LIKE CONCAT('%',?,'%'))
	                         ");
	$stmt -> bind_param('ss', $sv1, $sv2);
	$stmt -> execute();
	$stmt -> bind_result($fn, $ln, $pid);

	while($stmt -> fetch()){
		$out .= "<div class='btn btn-primary m-1 tagInArticle' name='taggedPerson[]' data-id='$pid'>$fn $ln</div>";
	}

	return $out;
}

?>

		......
							<div id="searchResultsHere">
								<!-- ajax content here -->
							</div>
							<hr>
							<div id="taggedInArticleContainer">
								<!-- ajax content here -->
							</div>
		.......


						<div class="col-lg-2">
							<button type="submit" name="PublishNewNews" class="btn btn-primary w-100 mb-3">Publish</button>
							<button class="btn btn-primary w-100">Save</button>
							<hr>
							<div class="btn btn-warning w-100 mb-3">Private</div>
							<input type="hidden" name="howVisible" value="Private">
							<hr>
							<p class="text-justify">Private news articles will only be avilable to logged in users</p>
						</div>

		.......



<script>

	$('#searchResultsHere').on('click', '.tagInArticle', function tagInArticle(){
		var tagButton = $(this);
		tagButton.appendTo('#taggedInArticleContainer')
	});

	$('#searchForPeopleBox').keyup(function(){
		var searchVal = $(this).val()
		var tagged = '0'
		var tagged = $('#taggedInArticleContainer').find('.tagInArticle').map(function(){
		 return $(this).data('id');
  		}).get();
		$.ajax({
			type: 'post',
			data: {"ajax" : 'one', "val" : searchVal, "exclude" : tagged},
			success: function(resp){
				$('#searchResultsHere').html(resp)
			}
		})
	});

	


</script>

I hope this is enough to go on.

I am sure it is simple but i just cant get it.

Thanks all in advance.