[RESOLVED] PHP to Email

Billett

Hi All,

It's been a long time since I have posted on here.

I have a PHP form that inserts into my database. What I would like to do it also have it email either anitification to say it's been inserted to the admin of the site or to email the data to the admin.

<?PHP

 //form data
$bd_pcode = $_POST['bd_pcode'];
$bd_golive = $_POST['bd_golive'];
$bd_project = $_POST['bd_project'];
$bd_pm = $_POST['bd_pm'];
$bd_itqa = $_POST['bd_itqa'];
$bd_testm = $_POST['bd_testm'];
$bd_solution = $_POST['bd_solution'];

//Connect to db
  require('connect.php');

// query

  $query="INSERT INTO Booking_details (EMS_Ref, Project_Code, Go_Live, Project_Name, Project_Manager, ITQA_Lead, Test_Lead, Solution_Designer)VALUES ('NULL', '" .$bd_pcode. "', '" .$bd_golive. "', '" .$bd_project. "', '" .$bd_pm. "', '" .$bd_itqa. "', '" .$bd_testm. "', '" .$bd_solution. "')";

  mysql_query($query) or die ('Error Inserting Data'. mysql_error());

  // return message
  echo "Thank You for submitting the EMS Form please make a note of your reference number
?>

Any pointers would be good, im not necessary looking for someone to give me the answer, but help with resources on how I can learn would be good.

Chris

Weedpacket

At about the point where you have

// return message

, build up a string with the contents of the email you want to send, and use [man]mail[/man] to send it to the admin.

Billett

Thank you I managed to get it working 🙂

<?PHP

 //form data
$bd_pcode = $_POST['bd_pcode'];
$bd_golive = $_POST['bd_golive'];
$bd_project = $_POST['bd_project'];
$bd_pm = $_POST['bd_pm'];
$bd_itqa = $_POST['bd_itqa'];
$bd_testm = $_POST['bd_testm'];
$bd_solution = $_POST['bd_solution'];

//Connect to db
  require('connect.php');

// query

  $query="INSERT INTO Booking_details (EMS_Ref, Project_Code, Go_Live, Project_Name, Project_Manager, ITQA_Lead, Test_Lead, Solution_Designer)VALUES ('NULL', '" .$bd_pcode. "', '" .$bd_golive. "', '" .$bd_project. "', '" .$bd_pm. "', '" .$bd_itqa. "', '" .$bd_testm. "', '" .$bd_solution. "')";

  mysql_query($query) or die ('Error Inserting Data'. mysql_error());

  //mail string
  $admin_mail = 'This is a Test email';

// Mail command

// The message
$message = "$admin_mail";

// In case any of our lines are larger than 70 characters, we should use wordwrap()
$message = wordwrap($message, 70);

// Send
mail('xxxxxx', 'Test Email', $message);

  // return message
  echo "Thank You for submitting the EMS Form please make a note of your reference number";
?>