help!!!

jac38

This is what I'm trying to do:

Step1 - user selects multiple names from a select field on a form.

Step2 - take those names and issue a - select EMAIL from PersonTable where person ="Smith, John" or person="Doe, John" or person="Blow, Joe"; - to retrieve the e-mail addresses.

Step3 - email all those persons selected.

I hope I'm not making this confusing. How do I go about doing this? Your help will be greatly appreciated. Thanks.😕

stolzyboy

something like this should get you in the right direction

put the select box into an array like

then
$check = @implode(", ", $check);
$query = "select * from table where email like '%$check%';";
$result = mysql_query($query);

while ($row = mysql_fetch_array($result))
{
echo $row['fieldnamefromtable'] . "<br>";
}

siwis

assuming you have a long list selector from which multiple options can be selected OR if even if you have a series of checkboxes next to the names.... the construct you are looking for (there may be a better one) is foreach()

The list of names should be passed back as an array, so therefore you use foreach() to loop through the array

foreach($namelistarray[]) {
// Do this
};

jac38

Hello,

Thanks for your help but now I'm getting this error can anyone tell me what

"Warning: Server Error in c:\inetpub\wwwroot\ErrAdd_step2.php on line 142" means?

Thanks.

<?php
foreach($formVars["ENG2"]as $value){
$query2="select email from engineers where eng='".$value."'";

$result2 = mysql_query($query2);

//(3)while there are still rows in the result set fetch the current row into the array $row

while($row = mysql_fetch_array($result2)){

//(4)Display the text of each symm

for ($i=0; $i<mysql_num_fields($result2); $i++)
		echo $row[$i];
//Print carriage return to neaten the output

$to="<". $row[$i].">";

$subject="RDT Error notification";

$headers = "From: R&D Test Group <corapi_joe@emc.com>";
$headers .="X-Sender: <corapi_joe@emc.com>\r\n";
$headers .="X-Mailer: PHP\r\n";
$headers .="X-Priority: 1\r\n";
$headers .="Return-Path: <corapi_joe@emc.com>\r\n";

$out="Dear ".$value.",\n\n";

$out.="This ".$formVars["TYPE"]." error has been submitted by ".$formVars["TESTR"]." and sent out to be reviewed by ".$formVars["ENG"].".\n\n";
$out.="The RDT number is: ". $RDT."\n\n";
$out.="Status: ".$STAT."\n\n";
$out.="The Error submitted: ".$formVars["ERR"]."\n\n";
$out.="Severity of error: ".$formVars["SEV"]."\n\n";
$out.="Code Level: ".$formVars["CODE"]."\n\n";
$out.="Error occurred on box: ".$formVars["MCC"]."\n\n";
$out.="The OS Host is: ".$formVars["OSH"]."\n\n";
$out.="Listing: ".$formVars["LIST"]."\n\n";
mail($to, $subject, $out);
}}

stolzyboy

where exactly is the error occuring according to the post, since we can't see the line numbers

siwis

Likewise.... what is the line of code at line 142. List a few lines prior to 142 in addition as it is quite common for the actual error to be on a previous line.

I may be wrong but I reckon you are missing a pair of braces tou bound your for($i=0; $i<mysql_num_fields($result2); $i++) AND should it not be for($i=0; $i<=mysql_num_rows($result2); $i++)

Also, a typical mail() command takes 4 arguments:
mail($recipient, $subject, $message, $mailheaders);

jac38

Sorry about that. I orginally had the headers argument but I took it out for debugging reasons. Thanks for all your help guys.

<?php
foreach($formVars["ENG2"]as $value){
$query2="select email from engineers where eng='".$value."'";

$result2 = mysql_query($query2);

//(3)while there are still rows in the result set fetch the current row into the array $row

while($row = mysql_fetch_array($result2)){

//(4)Display the text of each symm

for ($i=0; $i<mysql_num_fields($result2); $i++)
		echo $row[$i];
//Print carriage return to neaten the output

$to="<". $row[$i].">";

$subject="RDT Error notification";

$out="Dear ".$value.",\n\n";

siwis

I'm still certain you are missing a brace after "for ($i=0; $i<mysql_num_fields($result2); $i++)" and a closing brace at the end.

<?php 
foreach($formVars['ENG2']as $value)	{
	$query2="select email from engineers where eng='".$value."'"; 

$result2 = mysql_query($query2); 

//(3)while there are still rows in the result set fetch the current row into the array $row 

while($row = mysql_fetch_array($result2)){ 

//(4)Display the text of each symm 

	for ($i=0; $i<mysql_num_fields($result2); $i++)	{
		echo $row[$i]; 
//Print carriage return to neaten the output 

		$to="<". $row[$i].">"; 

		$subject="RDT Error notification"; 

		$headers = "From: R&D Test Group <corapi_joe@emc.com>"; 
		$headers .="X-Sender: <corapi_joe@emc.com>\r\n"; 
		$headers .="X-Mailer: PHP\r\n"; 
		$headers .="X-Priority: 1\r\n"; 
		$headers .="Return-Path: <corapi_joe@emc.com>\r\n"; 

		$out="Dear ".$value.",\n\n"; 

		$out.="This ".$formVars['TYPE']." error has been submitted by ".$formVars['TESTR']." and sent out to be reviewed by ".$formVars['ENG'].".\n\n"; 
		$out.="The RDT number is: ". $RDT."\n\n"; 
		$out.="Status: ".$STAT."\n\n"; 
		$out.="The Error submitted: ".$formVars['ERR']."\n\n"; 
		$out.="Severity of error: ".$formVars['SEV']."\n\n"; 
		$out.="Code Level: ".$formVars['CODE']."\n\n"; 
		$out.="Error occurred on box: ".$formVars['MCC']."\n\n"; 
		$out.="The OS Host is: ".$formVars['OSH']."\n\n"; 
		$out.="Listing: ".$formVars['LIST']."\n\n"; 
		mail($to, $subject, $out, $headers); //This is line 142 
	};
};
};
?>

although to be entirely honest I can't really see what you are trying to do here.

jac38

It still fails, do you think it's possible that I have my web server setup wrong? I can't think of what else it could be.

siwis

Anything is "possible".

I'm just still struggling to see exactly what the code you posted is meant to achieve. As I can't see what it does, its pretty hard to diagnose what might be wrong with it.

Obviously, I can see that it is attempting to send one (or more) emails.

Firstly, have you ascertained whether your php config will connect to your smtp server?

Try a simple one liner with a mail() command with the 4 arguments hard coded.

jac38

The good news - I changed a couple of things in my php.ini file and I don't see anymore warnings.

The Bad news - I don't see the e-mails either.

My job is to find errors(ironic isn't it?) and send them off to 1 or more engineers to fix them. So I'm creating a intranet site that my fellow peers and I can log the error, have the error saved to a database, then send an e-mail to notify the engineer. I've created the form which saves the info but I can't send an e-mail. The web server was just an extra computer laying around our lab that is connected to the network.

I've tried the simple script with the new php.ini configurations and I'm still not seeing an e-mail but the warning is gone.

This is the script:

<?php

mail("corapi_joe@emc.com", "My Subject", "Line 1\nLine 2\nLine 3");

And these are the configurations:

sendmail_from = me@localhost.com
sendmail_path =Default_sendmail_path
SMTP = localhost

Is there a command that I can put in that will tell me if the e-mail went through?

Thanks for all your help.

siwis

It sounds to me like you're on a Windblows box????

If so, Do you have SENDMAIL configured on it?

the simplest test would be along the lines of

if (!mail($to, $subject, $message, $headers)) { echo "Failed" } else { echo "SUCCESS!" };

jac38

I tried the code and it comes back as success, but still no e-mail.

I don't think winblows uses sendmail like unix does, but everything looks right as far as I can tell - but that doesn't mean much. Any suggestions on where to go from here?

siwis

Sorry, but as this seems to be a local configuration issue, I can't really offer you any more assistance.🙁

jac38

That's Ok you've been a big help, thanks for all your time. I hope someday I can repay you back.