Problem with small emailing form.

[unistake]

Hi all,

 

I have a simple script that does not work! I think it may be to do with $num = mysqli_num_rows($result) and $row = mysqli_assoc_result($result).

 

I have tried echoing the value which works if I put it above the include("cxn.php");.

 

The code is:

<?php
include("cxn.php");
$sql = "SELECT * FROM table WHERE email='$_POST[email]'";
$result = mysqli_query($cxn,$sql)
or die("Cant execute query!");

$num = mysqli_num_rows($result);

$row = mysqli_fetch_assoc($result);

if ($num > 0) {
	$to = "$_POST[email]";
	$subj = "from the website";
	$mess = "Your value is".$row['value'];
	$mailsend = mail($to,$subj,$mess,$headers);

	echo "email sent to $_POST['email']";
}

else { echo "email not found!";}
?>

[revraz]

Any errors?

What doesn't work?

You have a $headers variable, but nothing is in it.

[unistake]

That is all the php page, it does not show any errors.

 

 

[revraz]

Maybe it is working but it's being filtered as Junk Mail.

Did you check the server log to see if it's getting sent?

[unistake]

I am not getting the email and the echo after the email is not showing.

[revraz]

Check your server log, do you have a SMTP server setup?

[unistake]

Yes the email from the site works fine and I have checked the SMTP, I have another script from which I copied and pasted the email part of this script above.

 

if I put echo $_POST['email'] after the $result = mysqli_query($cxn,$sql) or die("Cant execute query!"); it does not work.

 

Any ideas?

[unistake]

anyone?

[mentalist]

I have tried echoing the value which works if I put it above the include("cxn.php");.

 

Sounds like there's an error in cxn.php...

 

Also if 'die' is reached and executed, then there is no more execution, so if it works before but not after then it must be between. Logicalsss

[unistake]

ofcourse! but there is not a problem with it. I use the same include("cxn.php") for the rest of the site. The webpages are in the same directory.

[unistake]

This works..

 

<?php
include("cxn.php");
$sql = "SELECT * FROM Members WHERE email='$_POST[email]'";
$result = mysqli_query($cxn,$sql)
or die("Cant execute query!");

$row = mysqli_fetch_assoc($result);

echo $row['field'];
?>

 

the script does not work when I include the $num = mysqli_num_rows($result) and also the email part of the script.

[mentalist]

When you say "does not work", please give the actual details otherwise were guessing...

[unistake]

got it to work somehow! I started to write it again and it works?!