Solved

insert into db and send email

Posted on 2006-06-28
10
209 Views
Last Modified: 2013-12-12
Hi,

I am new to php, please bear with me.... I have created a simple form that askes customers for their details and it emails those details to someone.. what i want to do is to have these details submitted to a DB at the same time - I have no idea how to incorporate this in my code... can someone please help?

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

<?php
// Receiving variables
@$title = addslashes($_POST['title']);
@$surname = addslashes($_POST['surname']);
@$address = addslashes($_POST['address']);
@$town = addslashes($_POST['town']);
@$county = addslashes($_POST['county']);
@$postcode = addslashes($_POST['postcode']);
@$telephone = addslashes($_POST['telephone']);
@$besttime = addslashes($_POST['besttime']);
@$email = addslashes($_POST['email']);

// Validation
if (strlen($title) == 0 )
{
die("<p align='center'><font face='Arial' size='3' color='#FF0000'>Please enter a valid title</font></p>");
}

if (strlen($surname) == 0 )
{
die("<p align='center'><font face='Arial' size='3' color='#FF0000'>Please enter a valid surname</font></p>");
}

if (strlen($address) == 0 )
{
die("<p align='center'><font face='Arial' size='3' color='#FF0000'>Please enter a valid address</font></p>");
}

if (strlen($town) == 0 )
{
die("<p align='center'><font face='Arial' size='3' color='#FF0000'>Please enter a valid town</font></p>");
}

if (strlen($county) == 0 )
{
die("<p align='center'><font face='Arial' size='3' color='#FF0000'>Please enter a valid county</font></p>");
}

if (strlen($postcode) == 0 )
{
die("<p align='center'><font face='Arial' size='3' color='#FF0000'>Please enter a valid postcode</font></p>");
}

if (strlen($telephone) == 0 )
{
die("<p align='center'><font face='Arial' size='3' color='#FF0000'>Please enter a valid telephone</font></p>");
}

if (strlen($besttime) == 0 )
{
die("<p align='center'><font face='Arial' size='3' color='#FF0000'>Please enter a valid besttime</font></p>");
}

if (! ereg('[A-Za-z0-9_-]+\@[A-Za-z0-9_-]+\.[A-Za-z0-9_-]+', $email))
{
die("<p align='center'><font face='Arial' size='3' color='#FF0000'>Please enter a valid email</font></p>");
}

if (strlen($email) == 0 )
{
die("<p align='center'><font face='Arial' size='3' color='#FF0000'>Please enter a valid email</font></p>");
}

//Sending Email to form owner
$pfw_header = "From: $email\n"
  . "Reply-To: $email\n";
$pfw_subject = "Info";
$pfw_email_to = "someone@somewhere.co.uk";
$pfw_message = "title: $title\n"
. "surname: $surname\n"
. "address: $address\n"
. "town: $town\n"
. "county: $county\n"
. "postcode: $postcode\n"
. "telephone: $telephone\n"
. "besttime: $besttime\n"
. "email: $email\n";
@mail($pfw_email_to, $pfw_subject ,$pfw_message ,$pfw_header ) ;


 echo("<p align='center'><font face='Arial' size='3' color='#FF0000'>Thankyou for your enquiry, we will contact you shortly regarding your query</font></p>");
?>
0
Comment
Question by:karma12
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 5
10 Comments
 
LVL 40

Expert Comment

by:Richard Quadling
ID: 17000103
Send the email as you have done and then add appropriate code to update the DB.

So, after your @mail(...);

$r_conn = mysql_pconnect($s_server, $s_username, $s_password);
$s_SQL = <<< END_SQL
INSERT INTO
 tablename(title, surname, address, town, country, postcode, telephone, besttime, email)
 VALUE('$title', '$surname', '$address', '$town', '$country', '$postcode', '$telephone', '$besttime', '$email')
END_SQL;
$r_results = mysql_query($s_SQL);
mysql_free_results($r_results);

0
 
LVL 40

Expert Comment

by:Richard Quadling
ID: 17000112
That is COMPLETELY untested, and you would need to make sure you are using MySQL and not some other DB. You will need to know the server name and your DB credentials ($s_server, $s_username, $s_password).

In terms of error handling, the mysql_xxx functions return False if they go wrong.

Commonly ...

$r_conn = mysql_pconnect($s_server, $s_username, $s_password) or die('Sorry. It has all gone horribly wrong : ' . mysql_errno() . ':' . mysql_error());
$s_SQL = <<< END_SQL
INSERT INTO
 tablename(title, surname, address, town, country, postcode, telephone, besttime, email)
 VALUE('$title', '$surname', '$address', '$town', '$country', '$postcode', '$telephone', '$besttime', '$email')
END_SQL;
$r_results = mysql_query($s_SQL) or die('Sorry. It has all gone horribly wrong : ' . mysql_errno() . ':' . mysql_error());
mysql_free_results($r_results);

sort of thing.
0
 

Author Comment

by:karma12
ID: 17000295
where would i stick this in my code? or does that not matter?
0
Why Off-Site Backups Are The Only Way To Go

You are probably backing up your data—but how and where? Ransomware is on the rise and there are variants that specifically target backups. Read on to discover why off-site is the way to go.

 

Author Comment

by:karma12
ID: 17000307
i know my DB credentials...... do you not mean i need my hostname not server???
0
 
LVL 40

Expert Comment

by:Richard Quadling
ID: 17000329
Your database server name or IP.

It may be localhost if you have a your DB server in your Web server.

It may not.

That code should be put in just after the mail() call.
0
 

Author Comment

by:karma12
ID: 17000423
I get the followin error: although the email is sent...

Warning: mysql_pconnect(): Unknown MySQL server host '0net' (1) in insert_db.php on line 33


which is

$r_conn = mysql_pconnect($s_bbbbb.dns-systems.net, $s_username, $s_password) or die('Sorry. It has all gone horribly wrong : ' . mysql_errno() . ':' . mysql_error());

im wondering if the hiphan in the Hostname is failin it? or is their no chance that can happen....
0
 
LVL 40

Accepted Solution

by:
Richard Quadling earned 500 total points
ID: 17000482
What's the name of the DB server?

I think you completely misread my variables!!!!

$r_conn = mysql_pconnect('servername', $s_username, $s_password) or die('Sorry. It has all gone horribly wrong : ' . mysql_errno() . ':' . mysql_error());

or

$s_server = 'localhost'; // Or some other name
$r_conn = mysql_pconnect($s_server, $s_username, $s_password) or die('Sorry. It has all gone horribly wrong : ' . mysql_errno() . ':' . mysql_error());

0
 

Author Comment

by:karma12
ID: 17000504
Hi,

I managed to get it working using the below:::

<?php


//Sending Email to form owner
$pfw_header = "From: $email\n"
  . "Reply-To: $email\n";
$pfw_subject = " Info";
$pfw_email_to = "someone@somewhere.co.uk";
$pfw_message = "firstname: $firstname\n"
. "firstname: $firstname\n"
. "surname: $surname\n"
. "initial: $initial\n"
. "address1: $address1\n"
. "address2: $address2\n"
. "city: $city\n"
. "postcode: $postcode\n"
. "contactno: $contactno\n"
. "email: $email\n"
. "appliances: $appliances\n";
@mail($pfw_email_to, $pfw_subject ,$pfw_message ,$pfw_header ) ;

$con = mysql_connect("bbbbb.dns-systems.net","bbbbb_test","bbbbb");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }mysql_select_db("bbbbb_test", $con);$sql="INSERT INTO person
(firstname,surname,initial,address1,address2,city,postcode,contactno,email,appliances)
VALUES
('$_POST[firstname]','$_POST[surname]','$_POST[initial]','$_POST[address1]','$_POST[address2]','$_POST[city]','$_POST[postcode]','$_POST[contactno]','$_POST[email]','$_POST[appliances]')";if (!mysql_query($sql,$con))
  {
  die('Error: ' . mysql_error());
  }echo "Success!";

?>
0
 

Author Comment

by:karma12
ID: 17000512
ill award you the points becasue you pointed me in the right direction, which i greatly appreciate........
0
 
LVL 40

Expert Comment

by:Richard Quadling
ID: 17000600
Ta!
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Things That Drive Us Nuts Have you noticed the use of the reCaptcha feature at EE and other web sites?  It wants you to read and retype something that looks like this. Insanity!  It's not EE's fault - that's just the way reCaptcha works.  But it i…
This article discusses how to implement server side field validation and display customized error messages to the client.
Learn how to match and substitute tagged data using PHP regular expressions. Demonstrated on Windows 7, but also applies to other operating systems. Demonstrated technique applies to PHP (all versions) and Firefox, but very similar techniques will w…
This tutorial will teach you the core code needed to finalize the addition of a watermark to your image. The viewer will use a small PHP class to learn and create a watermark.

695 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question