Email Form - Please Help Me. - PHPBuilder Forums

Email Form - Please Help Me.

kpowning

Hello All. I have been trying to make this form work, but nothing is happening. Since, I'm new to this scripting stuff, I imagine that I probably have part of this script wrong. I would appreciate it if anyone could help me on this and maybe point me in the right direction.

Here is the copy of the script:

<?php require_once('Connections/GspotMembers.php'); ?>
<?php if(isset($_POST['Remind_Me'])) { // if form has been submitted
$sql = "SELECT Password,email FROM users WHERE UserName='$UserName'";
mysql_select_db($database_GspotMembers, $GspotMembers);
$result = mysql_query($query, $GspotMembers) or die(mysql_error());
if ($result = mysql_fetch_array($query)) {
$Password = $result[Password];
$thisEmail = $result;
$message = "Your password is $Password";
mail("$thisEmail", "G-Spot Racing Login Information.", "$message", "From: [email]support@gspotracing.com\n");
}
} else {
?>

    <form action="<?=$HTTP_SERVER_VARS['PHP_SELF']?>" method="post">

<table width="590" border="0" cellspacing="0" cellpadding="0">
<tr> </tr>
<tr>
<td><div align="center"><font color="#00FF00">Complete this form and your
password will be sent to the Email address you used when you signed
up.</font></div></td>
</tr>
<tr>
<td bgcolor="#FFFF00"><div align="center"></div></td>
</tr>
<tr>
<td bgcolor="#FFFF00"><div align="center">UserName:
<input type="text" name="UserName" maxlength="20" size="30">
</div></td>
</tr>
<tr> </tr>
<tr> </tr>
<tr>
<td bgcolor="#FFFF00"> <div align="center">
<input type="hidden" name="remind_me" value="1">
<input type="submit" name="Submit" value="Submit">
</div></td>
</tr>
</table>
<br>
</form>

<?php
}

?>Here is the copy of the script:

PHPdev

What errors if any are you receiving? Does the email just not send?

Also another tip is that you can use the '{php} {/php}' (replace {} with []) tags on this board to color code you script... may make easier to read.

PHPdev

kpowning

Ya, the email doesn't send out and basically nothing happens at all. This might help you help me...In my database, I have the column titles: User ID (Key), UserName, Password, VerifyPassword, EmailAddress.

I'm just not sure how to do this or if my coding is correct. Please let me know any suggestions that you might have...

Also, you responded to my other question on showing the username of the person that is logged in, is there an actual script that I need to use or do I just need to implement that variable that you gave me into the webpage on a .php?

Thanks,
Kyle

Bunkermaster

hmmmm G-Spot racing 😃 nice name

wilsonodk

Use this instead

<?php 
require_once('Connections/GspotMembers.php');

// if form has been submitted
if (isset($_POST['Remind_Me'])) { 

// My SQL statement
$sql = "SELECT Password,EmailAddress FROM users WHERE userName='$UserName'";

// Pick my DB
// Are you sure that Connections/GSpotMembers.php 
// doesn't select your DB?
mysql_select_db($database_GspotMembers, $GspotMembers);

// Query the DB
$query = mysql_query($query) or die(mysql_error());

// Use the the query in an array called result
$result = mysql_fetch_array($query);
$Password = $result['Password']; 
$thisEmail = $result['EmailAddress']; 
$message = "Your password is $Password"; 

// Build the email
mail("$thisEmail", "G-Spot Racing Login Information.", "$message", "From: [email]support@gspotracing.com\n"); 

} else {
// The form has NOT been submitted
?>

It seems that you are having a similar problem as Ham - Still Having Problems... HELP!
Where did you find this code?

kpowning

Actually, I was trying to use almost the same code that he was. I just changed a couple of things to try to get it to work on my site. Basically, I needed the same thing. I hope it is ok to do that....

Anyways,

I tried that script you just gave me and still it doesn't work. Do I need to change anything in that script? Please help...

Thanks,
Kyle

wilsonodk

Originally posted by kpowning
Actually, I was trying to use almost the same code that he was. I just changed a couple of things to try to get it to work on my site. Basically, I needed the same thing. I hope it is ok to do that....

That's a great way to learn, I only mentioned it because I thought that thread might help. But, you'd already seen it. 🙂

Originally posted by kpowning
I tried that script you just gave me and still it doesn't work. Do I need to change anything in that script?

Are you getting an error messages?
I'd also like to know what version of PHP are you using?
And could you post the PHP code from 'Connections/GspotMembers.php'?
My guess would be that the line with mysql_select_db() is the culprit,
but I say that b/c I don't know where the variables are being defined.
Try commenting it, see what happens.
Also,
try sticking the mail() call into a variable and seeing what it returns

$sendmail = mail("$thisEmail","G-Spot Racing Login Information.","$message","From: [email]support@gspotracing.com\n");

if ($sendmail == 1) {
echo "An email was sent to $thisEmail";
}else{
echo 'No email sent';
}

HTH

kpowning

When I tried that new script, I received the following error... Any Ideas??

Parse error: parse error, unexpected T_CONSTANT_ENCAPSED_STRING in /webapp/vhosts/gspot@gspotracing.com/TMPk6hb3532c2.php on line 31

kpowning

Actually I'm building these .php pages in Dreamweaver MX. Hope this helps.. I appreciate your help on this...

wilsonodk

Dreamweaver MX? Love it! Use it all the time at work.

However, it looks as though you are testing the pages locally,
can you put them on a web server with PHP and test them there?

kpowning

Ok, Here is the script that I'm using now on the page. I'm still getting an error:

Parse error: parse error, unexpected T_CONSTANT_ENCAPSED_STRING in /webapp/vhosts/gspot@gspotracing.com/EmailUserinfo.php on line 30

*I have also tried everyother way using all the scripts that have been supplied on this thread. Changin anything in this script below only refreshed the page and nothing would happen.

<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>

<body bgcolor="#000000">
<?php
require_once('Connections/GspotMembers.php');

// if form has been submitted
if (isset($_POST['Remind_Me'])) {

// My SQL statement
$sql = "SELECT Password,EmailAddress FROM users WHERE userName='$UserName'";

// Pick my DB
// Are you sure that Connections/GSpotMembers.php
// doesn't select your DB?
mysql_select_db($database_gspot_gspotracing_com, $Members);

// Query the DB
$query = mysql_query($query) or die(mysql_error());

// Use the the query in an array called result
$result = mysql_fetch_array($query);
$Password = $result['Password'];
$thisEmail = $result['EmailAddress'];
$message = "Your password is $Password";
$sendmail = mail("$thisEmail","G-Spot Racing Login Information.","$message",_"From: [email]support@gspotracing.com\n");

if ($sendmail == 1) {
echo "An email was sent to $thisEmail";
}else{
echo 'No email sent';
}
?>

    <form action="<?=$HTTP_SERVER_VARS['PHP_SELF']?>" method="post">

</body>
</html>
<?php
}
?>

*Do I have to use the "Remind_Me" scripting in this script? Like I stated earlier, I'm brand new to all of this scripting...I hope you can help. Thanks for everything so far. Also, if it helps, I posted earlier in this thread, how my database was set-up.

Thanks,
Kyle

wilsonodk

the line

if (isset($_POST['Remind_Me'])) {

doesn't match the hidden variable

<input type="hidden" name="remind_me" value="1">

You need to change one or the other.

also
just before your <form> tag you need to put this line

<?php } else { ?>

kpowning

What do I need to change it to? I'm lost right here. Do I have to change it to a certain name or what is that attribute for: "remind_me". Also you said to enter in that one script above the </form> attribute. which one? The attribute before the form post information of at the end where there is just </form>?

Thanks,
Kyle

wilsonodk

Originally posted by kpowning
What do I need to change it to? I'm lost right here. Do I have to change it to a certain name or what is that attribute for: "remind_me". Also you said to enter in that one script above the </form> attribute. which one? The attribute before the form post information of at the end where there is just </form>?

Kyle,
The hidden input is there so that when the user clicks the submit button it will past the variable named "remind_me" to the processing script. However, your processing script won't run because it is looking for a variable named "Remind_Me".

It is generally best to stay consistant with your naming strategy, so if I were you I'd change the hidden input to:

<input type="hidden" name="Remind_Me" value="1">

As for the placement of that little PHP code, place it like this:

<?php
} else { 
?>
<form action="<?=$HTTP_SERVER_VARS['PHP_SELF']?>" method="post">

In your earlier script you had it in there but it is missing now, and without it you will never see the form.

It might help to think about it this way,
At the begining of your script you are asking a question,

// Has someone pressed the submit button before?
if (isset($_POST['Remind_Me'])) {

If they have, you ask your database for their email and password and send them an email reminding them of their password.

Else,
They have not (pressed the submit button), and therefore need to see the form to be able to.

HTH

barand

$query = mysql_query($sql)

might give better results;

kpowning

Ok, I changed those scripts to what you told me too, and now the following script is listed below. I'm still getting this error on line 30:

Parse error: parse error, unexpected T_CONSTANT_ENCAPSED_STRING in /webapp/vhosts/gspot@gspotracing.com/EmailUserinfo.php on line 30

This is what is in line 30:
$sendmail = mail("$thisEmail","G-Spot Racing Login Information.","$message",_"From: [email]support@gspotracing.com\n");

<html> 
<head> 
<title>Gspot Racing</title> 
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> 
</head> 

<body bgcolor="#000000"> 
<?php 
require_once('Connections/GspotMembers.php'); 

// if form has been submitted 
if (isset($_POST['Remind_Me'])) { 

// My SQL statement 
$sql = "SELECT Password,EmailAddress FROM users WHERE userName='$UserName'"; 

// Pick my DB 
// Are you sure that Connections/GSpotMembers.php 
// doesn't select your DB? 
mysql_select_db($database_gspot_gspotracing_com, $Members); 

// Query the DB 
$query = mysql_query($query) or die(mysql_error()); 

// Use the the query in an array called result 
$result = mysql_fetch_array($query); 
$Password = $result['Password']; 
$thisEmail = $result['EmailAddress']; 
$message = "Your password is $Password"; 
$sendmail = mail("$thisEmail",_"G-Spot Racing Login Information.",_"$message",_"From: [email]support@gspotracing.com\n"); 

if ($sendmail == 1) { 
echo "An email was sent to $thisEmail"; 
}else{ 
echo 'No email sent'; 
} 
?> 
<?php
} else { 
?>
<form action="<?=$HTTP_SERVER_VARS['PHP_SELF']?>" method="post"> 

<table width="590" border="0" cellspacing="0" cellpadding="0"> 
<tr> </tr> 
<tr> 
<td><div align="center"><font color="#00FF00">Complete this form and your 
password will be sent to the Email address you used when you signed 
up.</font></div></td> 
</tr> 
<tr> 
<td bgcolor="#FFFF00"><div align="center"></div></td> 
</tr> 
<tr> 
<td bgcolor="#FFFF00"><div align="center">UserName: 
<input type="text" name="UserName" maxlength="20" size="30"> 
</div></td> 
</tr> 
<tr> </tr> 
<tr> </tr> 
<tr> 
<td bgcolor="#FFFF00"> <div align="center"> 
<input type="hidden" name="Remind_Me" value="1">
<input type="submit" name="Submit" value="Submit"> 
</div></td> 
</tr> 
</table> 
<br> 
</form> 

</body> 
</html> 
<?php 
} 
?>

barand

$sendmail = mail("$thisEmail","G-Spot Racing Login Information.","$message",_"From: [email]support@gspotracing.com\n");

$thisEmail and $message are string variables and not literals so remove the surrounding quotes.

wilsonodk

Originally posted by barand
$thisEmail and $message are string variables and not literals so remove the surrounding quotes.

I don't think that's the problem,
You need to remove the underscores

$sendmail = mail("$thisEmail","G-Spot Racing Login Information.","$message","From: [email]support@gspotracing.com\n");

Sometimes, for reasons I don't know, when copying text from a web site, text editors replace spaces with characters other than what you intended.

kpowning

🙂 Ok, I didn't get any errors, but now I'm receiving:

Query was empty

Why is this, I'm starting to catch on here, but I don't understand why it isn't getting any results, or emailing any info..

Thanks,
Kyle

[deleted]

Didn't you already select the db in the include file?

// Pick my DB
// Are you sure that Connections/GSpotMembers.php
// doesn't select your DB?
mysql_select_db($database_gspot_gspotracing_com, $Members);

Anyway, here is the patched up code to complete the process

// execute the query 
$query = mysql_query($sql) or die(mysql_error()); 

// Use the the query in an array called result 
$result = mysql_fetch_array($query);