Send email when new entry is made to database?

[lvictor]

I've setup a homespun (not a 3rd party software package) PHP site that displays results from mysql, and has an issue submission form. The issue is now that the client now wants to be emailed whenever someone submits a new issue.

I've been looking around this site and other site's forums, and haven't yet found a solution to this issue, any recommendations? Thanks!

[devinemke]

[man]mail[/man]

[lvictor]

I've been trying with the mail function already with no luck.

What I'm trying to do is find the ACTUAL EXACT CODE to integrate into my form submission script that won't screw up the form submission/writing to database functions.

[devinemke]

lvictor wrote:

I've been trying with the mail function already with no luck

what is the problem? be specific.

[lvictor]

devinemke wrote:

what is the problem? be specific.

Well, I'm wondering where exactly in this code to place the mail function, and how to phrase it (this IS the newbies forum!):

---

<?
include("conn.php");
$mode=$_GET["mode"];
if($mode=="add") {
$region=$_POST["region"];
$status=$_POST["status"];
$location = $_POST['location'];
$office = $_POST['office'];
$title = $_POST['title'];
$domain = $_POST['domain'];
$devices = $_POST['devices'];
$risk = $_POST['risk'];
$line = $_POST['line'];
$originator = $_POST['originator'];
$owner = $_POST['owner'];
$segment = $_POST['segment'];
$origtarget = $_POST['origtarget'];
$currtarget = $_POST['currtarget'];
$milestone = $_POST['milestone'];
$lastupdate = $_POST['lastupdate'];
$details = $_POST['details'];
$date = $_POST['date'];
$date = $_POST['description'];
$sql="insert into $branch(region,status,location,office,title,domain,devices,risk,line,originato r,owner,segment,origtarget,currtarget,milestone,lastupdate,details,date,descri ption) values('$region','$status', '$location', '$office', '$title', '$domain', '$devices', '$risk', '$line', '$originator', '$owner','$segment', '$origtarget', '$currtarget', '$milestone', '$lastupdate','$details', '$date','$description')";
$result=mysql_query($sql,$connection) or die(mysql_error());
header("location: index.php");

} elseif($mode=="update") {
$region=$_POST["region"];
$status=$_POST["status"];
$location = $_POST['location'];
$office = $_POST['office'];
$title = $_POST['title'];
$domain = $_POST['domain'];
$devices = $_POST['devices'];
$risk = $_POST['risk'];
$line = $_POST['line'];
$originator = $_POST['originator'];
$owner = $_POST['owner'];
$segment = $_POST['segment'];
$origtarget = $_POST['origtarget'];
$currtarget = $_POST['currtarget'];
$milestone = $_POST['milestone'];
$lastupdate = $_POST['lastupdate'];
$details = $_POST['details'];
$date = $_POST['date'];
$description = $_POST['description'];
$id=$_POST["id"];
$sql="update $branch set region='$region',status='$status',location='$location',office='$office',title= '$title',domain='$domain',devices='$devices',risk='$risk',line='$line',origina tor='$originator',owner='$owner',segment='$segment',origtarget='$origtarget',c urrtarget='$currtarget',milestone='$milestone',lastupdate='$lastupdate',detail s='$details',date='$date',description='$description' where id='$id'";
//echo $sql;
$result=mysql_query($sql,$connection) or die(mysql_error());
header("location: index.php");
}
?>

[devinemke]

your code could be shortened significantly:

<?php
include('conn.php');

$fields = array('region','status','location','office','title','domain','devices','risk','line','originator','owner','segment','origtarget','currtarget','milestone','lastupdate','details','date','description');

foreach ($fields as $key => $value)
{
	$post_value = $_POST[$value];
	$post_value = trim($post_value);
	$post_value = stripslashes($post_value);
	$post_value = addslashes($post_value);

$fields[$key] = $value . ' = ' . $post_value;
}

if ($_GET['mode'] == 'add') {$sql = 'INSERT INTO';}
if ($_GET['mode'] == 'update') {$sql = 'UPDATE';}
$sql .= $branch . ' SET ' . implode(',', $fields);
if ($_GET['mode'] == 'update') {$sql .= ' WHERE id = ' . $_POST['id'];}
$result = mysql_query($sql, $connection) or exit(mysql_error());

$fields = array_map('stripslashes', $fields);

$from = 'from: [e-mail]';
$to = '[e-mail]';
$subject = 'database update';
$body = implode("\n", $fields);

mail($to, $subject, $body, $from) or exit('mail failed');

header('location: index.php');
?>

[lvictor]

Thanks, I tried using this code, but unfortunately, it is not functioning at all.

[cgraz]

Are you getting an error, blank screen, is the SQL working but the email isn't sending? Is the email sending but the SQL isn't working?

Could you be a little more specific...?

[lvictor]

cgraz wrote:

Are you getting an error, blank screen, is the SQL working but the email isn't sending? Is the email sending but the SQL isn't working?

Could you be a little more specific...?

Very sorry... the SQL works, and the data is entered into the database. But the email doesn't go through.

[cgraz]

Did you change the email address to use your email? The script has [e-mail] - is this the right address?

If sending mail just isn't working, you may have sendmail disabled (or misconfigured), in which case you'll need to check with your host to verify.

[lvictor]

Yes, I changed the email address, here's the error I'm getting:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'office = ,title = ,domain = ,devices = ,risk = 3,line = ,originator = ,owner = ,' at line 1