send form data to mysql AND email

[etoast]

Wonder whether anyone can help. I can create a form that sends it’s data in an email and I can create a form that sends it’s data to mysql. But I would like to know how to send the form’s textarea contents in an email, but send an input file to mysql. Can you split form data like this so that part goes to email and part goes to mysql? And if so how would you do it?

Any pointers would be fantastic.

Thank you in advance for your time.

Regards

[etully]

If you examine your PHP code that sends the email you will see how it works. Likewise for the PHP script that writes to the database.

Highlight the email sending code, copy it to the clipboard, and paste it into the script that writes to the database. Or vice versa, highlight the code that writes to the database and paste it into the script that sends the email.

Then you will have two things: A FORM that inputs data and a PHP script that processes the data. The form's ACTION tag will point to the PHP script. That script will:

1. Send an email
2. Write to the database.

Give it a shot. If it doesn't work, paste the code here and we'll take a look.

[etoast]

thanks for the advice. this works in case anyone is interested:

<?php
require_once ('mysql_connect.php');
  if ($HTTP_POST_VARS['submit']) {
     $pic_name=$HTTP_POST_VARS['pic_name'];
     $pic_person=$HTTP_POST_VARS['pic_person'];
     $query ="INSERT INTO table (pic_name,pic_person)";
     $query.=" VALUES ('{$_FILES['imagefile']['name']}','$pic_person')";
     $result=mysql_query($query);
     if ($result) echo "new image added!";
     else echo "ERROR: unable to post.";

if (($_FILES['imagefile']['type'] == "image/gif") OR ($_FILES['imagefile']['type'] == "image/jpeg") OR ($_FILES['imagefile']['type'] == "image/pjpeg"))
{ 
copy ($_FILES['imagefile']['tmp_name'], "images/".$_FILES['imagefile']['name']) or die ("Could not copy"); 
} 
else 
{ 
echo "Could Not Copy, Wrong Filetype (".$_FILES['imagefile']['name'].")n"; 
} 
if ($pic_person == 0) {
$to = "[e-mail]";
   $subject = "persona has added a new image";
   $message = "$realmessage";
   mail($to,$subject,$message);
} else {
$to = "[e-mail]";
   $subject = "personb has added a new image";
   $message = "$realmessage";
   mail($to,$subject,$message);
  }
}
 ?>

and the form...

<form method="POST" action="upload_image.php" enctype="multipart/form-data">
<input type="file" name="imagefile" />
<br />
message for the email<br />
<textarea name="realmessage" cols="21" rows="10">
</textarea>
<br />
<input type="radio" name="pic_person" value="0">persona tick here<br />
<input type="radio" name="pic_person" value="1">personb tick here<br /><br />
<input type="submit" name="submit" value="upload image" />
</form>