Jump to content

[SOLVED] mail function

rugzo

By rugzo
in PHP Coding Help

Recommended Posts

rugzo Member

rugzo

Posted
Posted

Hi all,

i am a newbie and have a question about the php mail function. Everytime i call the page it sends the email which i actually want that it will be send after submitting the page. The other problem is that it sends a blank email instead of the values i define. The code looks like -->

 

</td>
  </tr>
  <tr>
    <td>Training Document</td>
    <td><?php $sql = mysql_query ("SELECT * FROM subjects ORDER BY Id DESC LIMIT 1") ;
     while ($liste = mysql_fetch_array($sql)) {
      echo $liste[10];

}
mysql_free_result($sql);

?>

</td>
  </tr>
  </table>
  

<?php
$message = $_REQUEST['Subject'] ;
$message = $_REQUEST['Troubleshoot'] ;
$message = $_REQUEST['Knox'] ;
$message = $_REQUEST['Summary'] ;
$message = $_REQUEST['CTI'] ;
$message = $_REQUEST['GR'] ;
$message = $_REQUEST['Info'] ;
$message = $_REQUEST['Description'] ;
$message = $_REQUEST['Script'] ;
$message = $_REQUEST['TrainingDocuments'] ;
$headers = 'From: [email protected]' ;

mail( "[email protected] , [email protected] , [email protected] , [email protected]" , "Project SAFI", $messasge, $headers ) ;

?>

 

how can i prevent that it sends email every time the page is loaded and why is it sending a blank email istead of the variables i've choosen.

 

thanks for your help

 

best regards,

 

(edited to add 



 tags)



			
		


		

		
	


	

	





	
Link to comment

	
		
	
	
    
         https://forums.phpfreaks.com/topic/138784-solved-mail-function/
    

	
	
Share on other sites

	

	


	

	

	




	



					
					
					
				

					

					
					







	

	

	

		

			

				


	
		kenrbnsn
	

				
				
					
						
Regular Member
					
				
			

		

		

			

				


kenrbnsn
			

			

			    Posted 
				
			

		

	

	
	

		




	

		

			

				
    
					
					
					
					
					
				

			

			
		


		

			Posted 
			
			
				
				
			
		

	


	

    

	

		
		

			

You're clobbering the values in the $message variable each time. You need to concatenate them:






<?php
$msg = array('Subject','Troubleshoot','Knox','Summary','CTI','GR','Info','Description','Script','TrainingDocuments');
$message = '';
foreach ($msg as $itm)
    $message .= $itm . ': ' . $_REQUEST[$itm] . "\n";
?>






 



BTW, you shouldn't be using the $_REQUEST array. Always use either $_GET or $_POST depending on where the values are coming from.


 



Ken



			
		


		

		
	


	

	





	
Link to comment

	
		
	
	
    
         https://forums.phpfreaks.com/topic/138784-solved-mail-function/#findComment-725661
    

	
	
Share on other sites

	

	


	

	

	




	



					
					
					
				

					

					
					







	

	

	

		

			

				


	
		chronister
	

				
				
					
						
Regular Member
					
				
			

		

		

			

				


chronister
			

			

			    Posted 
				
			

		

	

	
	

		




	

		

			

				
    
					
					
					
					
					
				

			

			
		


		

			Posted 
			
			
				
				
			
		

	


	

    

	

		
		

			

Well, first off check your spelling. You mis-spelled the $message variable in the mail function.


 



Also, your $message vars need to be concatenated.


 






<?php
$message = $_REQUEST['Subject'] ;
$message .= $_REQUEST['Troubleshoot'] ;
$message .= $_REQUEST['Knox'] ;
$message .= $_REQUEST['Summary'] ;
$message .= $_REQUEST['CTI'] ;
$message .= $_REQUEST['GR'] ;
$message .= $_REQUEST['Info'] ;
$message .= $_REQUEST['Description'] ;
$message .= $_REQUEST['Script'] ;
$message .= $_REQUEST['TrainingDocuments'] ;

?>






 



You should always check your spelling first when errors occur. 


 



Nate



			
		


		

		
			

		
	


	

	





	
Link to comment

	
		
	
	
    
         https://forums.phpfreaks.com/topic/138784-solved-mail-function/#findComment-725662
    

	
	
Share on other sites

	

	


	

	

	




	



					
					
					
				

					

					
					






					
					
					
				

					

					
					






					
					
					
				

					

					
					







	

	

	

		

			

				


	
		rugzo
	

				
				
					
						
Member
					
				
			

		

		

			

				


rugzo
			

			

			    Posted 
				
			

		

	

	
	

		




	

		

			

				
    
					
						
  • Author
    • 
					
					
					
					
					
				

			

			
		


		

			Posted 
			
			
				
				
			
		

	


	

    

	

		
		

			

<html>


 



<body bgcolor="#C0C0C0">



<br>



<br>



<form action="safientry.php" method="post" name="em">


 



<table align="center" cellspacing="0" cellpadding="0" border="1" bordercolor="#000000">



<tr>



 <td>Subject</td>



 <td>



 <textarea  rows="3" cols="100" name="Subject">



 </textarea>



 </td>



</tr>



<tr>



 <td>Troubleshoot</td>



  <td>



   <textarea  rows="30" cols="100" name="Troubleshoot">



   </textarea>



 </td>



</tr>



<tr>



 <td>Knox</td>



  <td>



   <textarea  rows="3" cols="100" name="Knox">



   </textarea>



 </td>



</tr>



<tr>



 <td>Summary</td>



  <td>



   <textarea  rows="3" cols="100" name="Summary">



   </textarea>



 </td>



</tr>



<tr>



 <td>CTI</td>



  <td>



   <textarea  rows="3" cols="100" name="CTI">



   </textarea>



 </td>



</tr>



<tr>



 <td>Group</td>



  <td>



    <textarea  rows="3" cols="100" name="GR">



    </textarea>



 </td>



</tr>



<tr>



 <td>Additional Information</td>



  <td>



    <textarea  rows="3" cols="100" name="Info">



    </textarea>



 </td>



</tr>



<tr>



 <td>Description</td>



  <td>



    <textarea  rows="10" cols="100" name="Description">



    </textarea>



 </td>



</tr>



<tr>



 <td>Script</td>



  <td>



    <textarea  rows="3" cols="100" name="Script">



    </textarea>



 </td>



</tr>



<tr>



 <td>Training Documents</td>



  <td>



    <textarea  rows="3" cols="100" name="TrainingDocuments">



    </textarea>



 </td>



</tr>



<tr>



<td width="30"><input type="button" name="Gonderen" value="submit" size="20" onclick="if(em.Subject.value.length==0) alert('fill in completely'); else em.submit();"> </td>



</tr>



</table>



</form>


 


 



<?php


 


 



@mysql_connect ("localhost", "root", "123*qwe123") or die (mysql_error()) ;



@mysql_select_db ("kb") or die (mysql_error()) ;


 


 



$Subject = $_POST["Subject"] ;



$Troubleshoot = $_POST["Troubleshoot"] ;



$Knox = $_POST["Knox"] ;



$Summary = $_POST["Summary"] ;



$CTI = $_POST["CTI"] ;



$GR = $_POST["GR"] ;



$Info = $_POST["Info"] ;



$Description = $_POST["Description"] ;



$Script = $_POST["Script"] ;



$TrainingDocuments = $_POST["TrainingDocuments"] ;


 


 


 



if ($Subject <>"") {



$sql = "INSERT INTO subjects (Subject, Troubleshoot, Knox, Summary, CTI, GR, Info, Description, Script, TrainingDocuments) values ('$Subject', '$Troubleshoot', '$Knox', '$Summary', '$CTI', '$GR', '$Info', '$Description', '$Script', '$TrainingDocuments') " ;



$kayit = mysql_query($sql)   ;


 



echo mysql_error() ;



                  }


 


 



?>


 


 



<table border="1" cellpadding="0" cellspacing="0">



  <tr>



    <td>Id</td>



    <td><?php $sql = mysql_query ("SELECT * FROM subjects ORDER BY Id DESC LIMIT 1") ;



     while ($liste = mysql_fetch_array($sql)) {



      echo $liste[0];


 



}



mysql_free_result($sql);



?></td>



  </tr>



  <tr>



    <td>Subject</td>



    <td><?php $sql = mysql_query ("SELECT * FROM subjects ORDER BY Id DESC LIMIT 1") ;



     while ($liste = mysql_fetch_array($sql)) {



      echo $liste[1];


 



}



mysql_free_result($sql);



?></td>



  </tr>



  <tr>



    <td>Troubleshoot</td>



<td><?php $sql = mysql_query ("SELECT * FROM subjects ORDER BY Id DESC LIMIT 1") ;



     while ($liste = mysql_fetch_array($sql)) {



      echo $liste[2];


 



}



mysql_free_result($sql);



?></td>



  </tr>



  <tr>



    <td>Knox</td>



    <td><?php $sql = mysql_query ("SELECT * FROM subjects ORDER BY Id DESC LIMIT 1") ;



     while ($liste = mysql_fetch_array($sql)) {



      echo $liste[3];


 



}



mysql_free_result($sql);



?></td>



  </tr>



  <tr>



    <td>Summary</td>



    <td><?php $sql = mysql_query ("SELECT * FROM subjects ORDER BY Id DESC LIMIT 1") ;



     while ($liste = mysql_fetch_array($sql)) {



      echo $liste[4];


 



}



mysql_free_result($sql);



?></td>



  </tr>



  <tr>



    <td>CTI</td>



    <td><?php $sql = mysql_query ("SELECT * FROM subjects ORDER BY Id DESC LIMIT 1") ;



     while ($liste = mysql_fetch_array($sql)) {



      echo $liste[5];


 



}



mysql_free_result($sql);



?></td>



  </tr>



  <tr>



    <td>Group</td>



    <td><?php $sql = mysql_query ("SELECT * FROM subjects ORDER BY Id DESC LIMIT 1") ;



     while ($liste = mysql_fetch_array($sql)) {



      echo $liste[6];


 



}



mysql_free_result($sql);



?></td>



  </tr>



  <tr>



    <td>Additional Information</td>



    <td><?php $sql = mysql_query ("SELECT * FROM subjects ORDER BY Id DESC LIMIT 1") ;



     while ($liste = mysql_fetch_array($sql)) {



      echo $liste[7];


 



}



mysql_free_result($sql);



?></td>



  </tr>



  <tr>



    <td>Description</td>



    <td><?php $sql = mysql_query ("SELECT * FROM subjects ORDER BY Id DESC LIMIT 1") ;



     while ($liste = mysql_fetch_array($sql)) {



      echo $liste[8];


 



}



mysql_free_result($sql);



?></td>



  </tr>



  <tr>



    <td>Script</td>



    <td><?php $sql = mysql_query ("SELECT * FROM subjects ORDER BY Id DESC LIMIT 1") ;



     while ($liste = mysql_fetch_array($sql)) {



      echo $liste[9];


 



}



mysql_free_result($sql);



?></td>



  </tr>



  <tr>



    <td>Training Document</td>



    <td><?php $sql = mysql_query ("SELECT * FROM subjects ORDER BY Id DESC LIMIT 1") ;



     while ($liste = mysql_fetch_array($sql)) {



      echo $liste[10];


 



}



mysql_free_result($sql);


 



?>


 



</td>



  </tr>



  </table>



  


 



<?php



$message = $_REQUEST['Subject'] ;



$message .= $_REQUEST['Troubleshoot'] ;



$message .= $_REQUEST['Knox'] ;



$message .= $_REQUEST['Summary'] ;



$message .= $_REQUEST['CTI'] ;



$message .= $_REQUEST['GR'] ;



$message .= $_REQUEST['Info'] ;



$message .= $_REQUEST['Description'] ;



$message .= $_REQUEST['Script'] ;



$message .= $_REQUEST['TrainingDocuments'] ;



$headers .= 'From: [email protected]' ;


 



mail( "[email protected]", "Project SAFI", $message, $headers ) ;


 



?>


 



<br>



<br>



<br>



<br>



<br>



<br>



<br>



<br>



<i><font face="verdana" size="1" >



copyright Özgürd</font></i>


 



</body>



</html>


 



			
		


		

		
	


	

	





	
Link to comment

	
		
	
	
    
         https://forums.phpfreaks.com/topic/138784-solved-mail-function/#findComment-725681
    

	
	
Share on other sites

	

	


	

	

	




	



					
					
					
				

					

					
					







	

	

	

		

			

				


	
		chronister
	

				
				
					
						
Regular Member
					
				
			

		

		

			

				


chronister
			

			

			    Posted 
				
			

		

	

	
	

		




	

		

			

				
    
					
					
					
					
					
				

			

			
		


		

			Posted 
			
			
				
				
			
		

	


	

    

	

		
		

			

<?php

if(isset($_POST['Gonderen']))
{
   $message = $_REQUEST['Subject'] ;
$message .= $_REQUEST['Troubleshoot'] ;
$message .= $_REQUEST['Knox'] ;
$message .= $_REQUEST['Summary'] ;
$message .= $_REQUEST['CTI'] ;
$message .= $_REQUEST['GR'] ;
$message .= $_REQUEST['Info'] ;
$message .= $_REQUEST['Description'] ;
$message .= $_REQUEST['Script'] ;
$message .= $_REQUEST['TrainingDocuments'] ;
$headers .= 'From: [email protected]' ;

mail( "[email protected]", "Project SAFI", $message, $headers ) ;
}

?>









			
		


		

		
			

		
	


	

	





	
Link to comment

	
		
	
	
    
         https://forums.phpfreaks.com/topic/138784-solved-mail-function/#findComment-725696
    

	
	
Share on other sites

	

	


	

	

	




	



					
					
					
				

					

					
					






					
					
					
				
			
			



		

	


	
	
	
		

			
Archived

			

				This topic is now archived and is closed to further replies.
			

		

	
	
	

	







	

		
			
				Go to topic listing
			
		
	

	




						


					

					


					

				

			

			
		

		
		


	

		×
		

			
				

					
				

			

			

			

			
		

	






	

		×
		

			
    
				
  • Create New...
    • 
				
			

		

	



		






















	

		

			
Important Information

			
We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.