[RESOLVED] dbase additions to send to friend email form

[mrjoeblack]

Ok so we have this send to a friend form which is now working fine (only I dont have the validation done, cos I'm waiting for one of you wizards to get that done for me hahaha) BUT next question on this is as follows:

Question: As the email is sent off to the friend, is it possible to have the form also send the 3 field's data into a sql database for me???

here's the code:

 <?php 

if (!$_POST["email"]) { echo "oops! you have not completed friends email correctly .. please close this window and try again"; exit; }    


if (!$_POST["yourname"]) { echo "oops! you have not completed your name correctly .. please close this window and try again"; exit; } 


if (!$_POST["youremail"]) { echo "oops! you have not completed your email correctly .. please close this window and try again"; exit; }     

// Validate / Parse 
// ** You need to valid the submitted data here ** 

// Send Email 
$headers  = "MIME-Version: 1.0\r\n"; 
$headers .= "Content-type: text/html; charset=iso-8859-1\r\n"; 
$headers .="From: ".$_POST["yourname"]." <".$_POST["youremail"].">\r\n"; 

if(!mail($_POST["email"],"subject","message body", $headers)) { echo ""; exit; }         
else { echo "Well done, thanks!"; } 
?>  

[bradgrafelman]

mrjoeblack;10996838 wrote:

is it possible to have the form also send the 3 field's data into a sql database for me???

Well no, because the form itself isn't doing anything. It's your code that uses that data in whatever way you please.

So if your question is whether or not you can insert data into a SQL database using PHP, then the answer is yes.

[mrjoeblack]

ooookkkk brad, well maybe what I meant to ask is, can I add php to the form and the php which send the email, so that it will also send the info to a database at the same time or simultaneously I guess.

[bradgrafelman]

mrjoeblack;10996853 wrote:

can I add php to the form

No, because that doesn't make any sense; the "form" just just a bunch of text (a.k.a. HTML). How do you "add php" to that?

My point above is that your script simply sends an e-mail and that's it, but no one says your script has to end there. What's stopping you from simply adding more code (such as code that executes a SQL query)?

[mrjoeblack]

well yes, I understand I may have my terminolgy wrong, but basically that's what I'm trying to ask you how to do?? what code do I add to the php for dbase insertion??

[bradgrafelman]

Whatever code you want. If you want to connect to a database and execute a query, then you'd probably want to look for PHP functions that... connect to a database and execute a query. Not sure what else it is you're asking about.

[mrjoeblack]

can you tell me where I'd put the code in the existing form and I was hoping you might write up some for me so i get the gist, so to speak.

[bradgrafelman]

mrjoeblack;10996860 wrote:

can you tell me where I'd put the code in the existing form

Again, there is nothing to add to the "form" (which, again, is nothing more than plain text being rendered somewhere by a web browser as HTML).

As for the PHP code you've posted above, it obviously doesn't matter where you add the code that executes the SQL query, since the order doesn't matter at all.

mrjoeblack;10996860 wrote:

and I was hoping you might write up some for me so i get the gist, so to speak.

You can get the "gist" by reading the appropriate manual pages (which already include coding examples anyway).

[Weedpacket]

There are a number of chapters in the PHP manual that give examples of how to write code for communicating with databases. Pick the one that matches the database system you're using, and remember that it will also have its own manual that you will eventually need to become familiar with.

[mrjoeblack]

ok this is what I've got so far... It's giving me an error in the code ... now I'm stuck!! Any suggestions???

    $headers  = "MIME-Version: 1.0\r\n"; 
    $headers .= "Content-type: text/html; charset=iso-8859-1\r\n"; 
    $headers .="From: ".$_POST["yourname"]." <".$_POST["youremail"].">\r\n"; 

if(!mail($_POST["email"],"email subject","email message", $headers)) { echo ""; exit; }         
else { echo "Well done, thanks!"; } 


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

	include('connect-mysql.php' ) ;

	$email = $_POST['email'] ;
	$yourname = $_POST['yourname'] ;
	$youremail = $_POST['youremail'] ;

	$sqlinsert = "INSERT INTO friends (email, yourname, youremail)  VALUES ( '$email' , '$yourname' , '$youremail' )" ;

	if(!$email == "" && (!strstr($email,"@") || !strstr($email,"."))) 
{
echo "<p>Please Go Back and enter a valid e-mail address</p>\n"; 
$badinput = "<p>we need your valid email </p>\n";
echo $badinput;
die ("Use new form ! ");
}

if(empty($email) || (empty($yourname) ||empty($youremail)))
 {
echo "<p>You have not completed all fields, please Go Back and fill out all the fields</p>\n";
die ("Use anew form ! "); 
}

	mysql_query($sqlinsert = "INSERT INTO friends (email, yourname, youremail)  VALUES ( '$email' , '$yourname' , '$youremail' )"); 


?> 

[Weedpacket]

Error: Error message not given in post #10996919.

[mrjoeblack]

ok I got this now .... it shows no errors but doesn't want to find dbase. Dam I have no clue about this stuff!!

  <?php 



if (!$_POST["email"]) { echo "oops! you have not completed friends email correctly .. please close this window and try again"; exit; }    


if (!$_POST["yourname"]) { echo "oops! you have not completed your name correctly .. please close this window and try again"; exit; } 


if (!$_POST["youremail"]) { echo "oops! you have not completed your email correctly .. please close this window and try again"; exit; }     


$headers  = "MIME-Version: 1.0\r\n"; 
$headers .= "Content-type: text/html; charset=iso-8859-1\r\n"; 
$headers .="From: ".$_POST["yourname"]." <".$_POST["youremail"].">\r\n"; 

if(!mail($_POST["email"],"email subject","email message", $headers)) { echo ""; exit; }         
else { echo "Well done, thanks!"; } 


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

	include('connect-mysql.php' ) ;

	$email = $_POST['email'] ;
	$yourname = $_POST['yourname'] ;
	$youremail = $_POST['youremail'] ;

	$sqlinsert = "INSERT INTO friends (email, yourname, youremail)  VALUES ( '$email' , '$yourname' , '$youremail' )" ;


	mysql_query($sqlinsert = "INSERT INTO friends (email, yourname, youremail)  VALUES ( '$email' , '$yourname' , '$youremail' )"); 

}
?>

[mrjoeblack]

I dont understand your reply, sorry!!:queasy:

[mrjoeblack]

Incredible!!! hahahaha I actually got it working. Turned out I was trying to insert into a db on another server using localhost, now at least i understand what localhost means lol.

phewww!!! take the rest of the night off guys.🙂