Need some email help.

Jazzy_Girl

Hi, when someone enters a web site name into a form field, I need other items in the form sent to the email address for the web site. I have a mysql database and know how to use it if this helps. I also know the usual process for sending items to email using php. Just not sure how to tie this all together. Any suggestions on how I can do this? I need to learn how so I can avoid listing others email addresses on my site but still get them their desired information. Thank you very much.

stolzyboy

i'm not sure i follow your dilemna, this sounds like a simple email via PHP, not sure how the "someone enters a web site name into a form field" works in this situation

Jazzy_Girl

Its not a normal email situation because of what I listed above. The php will need to check a database or something to see which email address belongs to the web site name entered in a form field. Then it will send the rest of the form fields to the email adddress when it finds the match. Anyone know how to do this? Its done all the time with link exchange sites and many others when they need to send information to their listed web sites. Thank you!

stolzyboy

well... that's pretty simple, now that i understand it

the following code is AFTER you submit the form with the url, i'm not going to do any stripping of the url or anthing for http:// or www., etc... since this is a mere example, but you'll want to do that with regex

this is untested for parse errors and actual functionality... you'll have to do that part on your own, but this is a general concept

<?
if ($_POST['submitbutton'] == "Submit Email")
{
	$conn = mysql_connect("host", "user", "pass");
	$db = mysql_select_db("database");

$url = $_POST['urltext']; //sanitize your code rather than just setting variable

$query = "select url from tablename where url_field = '" . $url . "';";  //this may have to be a LIKE clause depending on how you want to match
$result = mysql_query($query) or die(mysql_error());

if (mysql_num_rows($result) != 0)  //this area may need to change also since a LIKE clause could produce more than 1 result, forcing a while loop thru the result set
{
	$row = mysql_fetch_array($result);
	$email_address = $row['email_address_field'];
	//do your mail sending
}
else
{
	//handle however you like if there are no such urls in the db
}
}
?>

Jazzy_Girl

Thanks a lot! I don't expect you to walk me all the way through it but it would help to know what some of your suggestions mean. On the top one, that would be the field for the "name" of that particular form field... Or are you trying to say, "if the form is submitted than "the following" is supposed to happen....." On the "url text," is that the form field where the web name would go? On the query, is it trying to say "find the entry listed under the matching "url text" name. (Which would be its email address I put into the database under the particular web name). Then do this with it? This is where I'm getting especially lost, the email codeing after $row=.

stolzyboy

you are correct on your assumptions... that is AFTER it's submitted, it's just there for example 🙂 and you are correct on your other questions, urltext is just what was typed in text field for the web name, yes, query is saying look for an email address field in the db that has the url of "whatever you typed in"

as far as emailing after than, you'll just get the OTHER values from the form and send the email, for help with mail, visit www.php.net/mail you can use simple ones with no html or use html ones, there are examples there of both

hth,
stolzyboy

Jazzy_Girl

OK OK, I get excited when I actually understand where someone is taking me. Usually their explanations take a lot more work. Now I get it, I have the email pulled out and then I can do something with it from there. This is where I would have to post my other form fields. So if I do this,
$email = $row['email_address_field'];
$name="name";
$subject = "subject" ;
$emailbody = "emailbody" ; etc. and so on.

Can I just send it all on including a regular php form with the mail command in the rest of the php?
mail($mailto, $subject, $messageproper, "From: \"$name\" <$email>" . $headersep . "Reply-To: \"$name\" <$email>" . $headersep);//
If so that is just great, thanks for tying this together for me, it seemed like there should be a way. Now I understand the whole concept. I had no idea where to start with it. If I have this wrong tell me. On your else statement. That is only for if it can't find the names email address, correct? Appreciated.

stolzyboy

yes, again, you are correct... you are on the right track, just keep trucking...

Jazzy_Girl

Very good, some gifts are on their way!