forget password can't function...

[bb nicole]

Below is my forget password, why cannot function?? When i click on the submit button, it still remain on the same page and just like i didn't click anything...

[PHP]<?php
if($go == "1")
{
mysql_connect("localhost","root","");
mysql_select_db("ums e-job portal");

$sql = @mysql_query("SELECT * FROM company WHERE username='$username' && emailAdd='$email' ");
if(!$sql)
{
echo "The username and email address do not match.";
exit;
}
$query = mysql_query($sql);
$fPass = mysql_fetch_array($query);

$to = "SELECT * FROM company WHERE emailAdd='$email' ";
$subject = "Your Password";
$body = "SELECT * FROM company WHERE username='$username' && password='$password' ";
$headers = "From: [e-mail]\n";

mail($to, $subject, $body, $headers);
echo "Your Password has been sent to $to";
}
?>[/PHP]

[HTML]<form action="<?= $PHP_SELF ?>" method="post">
Username: <input type="text" name="username" size="24" border="0"><br>
E-mail: <input type="text" name="email" size="24" border="0"><br>
<input type="hidden" name="go" value="1" border="0"><input type="submit" name="submitButtonName" border="0">
</form[/HTML]>

[Motoma]

Are these both the same page?

[bb nicole]

Are these both the same page?

Ya... :)
I have seperate it after this, but it still cannot function, just link to the page got the php code but is blank...

Thanks...

[steven]

Firstly, PHP_SELF should be changed to $_SERVER['PHP_SELF'] and perhaps you could try adding echo statements into your PHP to debug. For example, one just after your if statement, to see if you even reach the condition.

[Atli]

Hi.

MySQL databases can not have spaces.
So if this is really the database you try to connect to it will give you an error.

[PHP]mysql_select_db("ums e-job portal");[/PHP]

Try this to see if it is the error

[PHP]mysql_select_db("ums e-job portal") or die(mysql_error);[/PHP]

[Atli]

Also just noticed this.

[PHP]<form action="<?= $PHP_SELF ?>"[/PHP]

Dont know if the <?= is usable in older versions but it wont work in php 5.2
It should be <?php
Note. that in PHP 5.2.0 <? is also wrong uless you have the 'short_open_tag' set to 'on' in your php.ini (default is off)

And as Steven said it is probbly better to write
$_SERVER['PHP_SELF'] rather than $PHP_SELF,
tho both will work on PHP 5

An you will have to acctually print it so you need to do echo or print

[PHP]<form action="<?php echo $_SERVER['PHP_SELF']; ?>"[/PHP]

[bb nicole]

THANKS Alti and Steven...
I modify the code ledy but still can't work...
And i try 2 detect the error by put
[PHP]<? error_reporting(E_ALL);[/PHP] as Alti told me before, the error message appear as below:
Notice: Undefined variable: go in C:\Apache2\Apache2\htdocs\forgetPassword.php on line 3
which line 3 is [PHP]<? if($go == "1") ?>[/PHP]

And i have put the code:
[HTML]<input type="hidden" name="go" value="1" border="0"><input type="submit" name="submit" value="Submit" border="0">
</form>[/HTML]
at the bottom of the page...

Is it need to code something as below to define it??
[PHP]<?
$go=..........;
?>[/PHP]
BUt i don't know how to code it, can somebody give me some guildeline??? Thanks..

[Atli]

Try replacing it with

[PHP]$_REQUEST['go'][/PHP]

Also, its always best to close all HTML tags, like so.

[HTML]<input ...></input>
or
<input ... />[/HTML]

[bb nicole]

Try replacing it with

[PHP]$_REQUEST['go'][/PHP]

Also, its always best to close all HTML tags, like so.

[HTML]<input ...></input>
or
<input ... />[/HTML]

Thanks... I try already, but the error still same as below:
Notice: Undefined variable: go in C:\Apache2\Apache2\htdocs\forgetPassword.php on line 3


What should i do??? I have no idea how to define the variable... Thanks..

[Motoma]

Thanks... I try already, but the error still same as below:
Notice: Undefined variable: go in C:\Apache2\Apache2\htdocs\forgetPassword.php on line 3


What should i do??? I have no idea how to define the variable... Thanks..

Post the latest version of your code.

[bb nicole]

Post the latest version of your code.

Thanks.. Below is my latest code... All the code is in same page...
[PHP]<?php
error_reporting(E_ALL);

if($_REQUEST['go'] == "1")

{
mysql_connect("localhost","root","");
mysql_select_db("ums e-job portal") or die(mysql_error);


$sql = @mysql_query("SELECT * FROM company WHERE username='$username' && emailAdd='$email'");
if(!$sql)
{
echo "The username and email address do not match.";
exit;
}


if(!empty($username)&&!empty($email)){
$query = mysql_query($sql)
or die("Cannot execute query");
}

$fPass = mysql_fetch_array($query);

$to = "SELECT * FROM company WHERE emailAdd='$email' ";
$subject = "Your Password";
$body = "SELECT * FROM company WHERE username='$username' && password='$password' ";
$headers = "From: [e-mail]\n";

mail($to, $subject, $body, $headers);
echo "Your Password has been sent to $to";
}

?>[/PHP]

[HTML]
<form action="<?php echo $_SERVER['PHP_SELF']; ?>" method="post">
Username: <input type="text" name="username" size="24" border="0"><br>
E-mail: <input type="text" name="email" size="24" border="0"><br>
<input type="hidden" name="go" value="1" border="0"><input type="submit" name="submit" value="Submit" border="0">
</form>[/HTML]

[Motoma]

Try changing

[PHP]<?php

error_reporting(E_ALL);



if($_REQUEST['go'] == "1") [/PHP]

to

[PHP]
<?php

error_reporting(E_ALL);



if($_POST['go'] == "1") [/PHP]

[Atli]

I tried your code, put it all in one .php file, and once I submitted the form, the unidentified index error dissapears.
I see no reason why this code should give you the error after you submit the form.

I did however notice this.
[PHP]// First query, ok
$sql = @mysql_query("SELECT * FROM company WHERE username='$username' && emailAdd='$email'");
if(!$sql)
{
echo "The username and email address do not match.";
exit;
}

// Second query, not ok
if(!empty($username)&&!empty($email)){
$query = mysql_query($sql) // <-- running the first query
or die("Cannot execute query");
}

$fPass = mysql_fetch_array($query); // <-- Fetching the second, incorrect query
[/PHP]

You are trying to run the same query twice, and the second time you'r running the ID number of the first one.

You should remove the second one and edit the mysql_fetch_array to use the first one.

[bb nicole]

Try changing

[PHP]<?php

error_reporting(E_ALL);



if($_REQUEST['go'] == "1") [/PHP]

to

[PHP]
<?php

error_reporting(E_ALL);



if($_POST['go'] == "1") [/PHP]

Emm.. I use as what you said, but din't work...
The error shown as below:
Notice: Undefined index: go in C:\Apache2\Apache2\htdocs\forgetPassword.php on line 4

Thanks... :)

[bb nicole]

I tried your code, put it all in one .php file, and once I submitted the form, the unidentified index error dissapears.
I see no reason why this code should give you the error after you submit the form.

I did however notice this.
[PHP]// First query, ok
$sql = @mysql_query("SELECT * FROM company WHERE username='$username' && emailAdd='$email'");
if(!$sql)
{
echo "The username and email address do not match.";
exit;
}

// Second query, not ok
if(!empty($username)&&!empty($email)){
$query = mysql_query($sql) // <-- running the first query
or die("Cannot execute query");
}

$fPass = mysql_fetch_array($query); // <-- Fetching the second, incorrect query
[/PHP]

You are trying to run the same query twice, and the second time you'r running the ID number of the first one.

You should remove the second one and edit the mysql_fetch_array to use the first one.

Thanks, Alti..I delete the second query and the
[PHP]$fPass = mysql_fetch_array($query);[/PHP]
to
[PHP]$fPass = mysql_fetch_array($sql);[/PHP]
but it still go error, same error as below:
Notice: Undefined index: go in C:\Apache2\Apache2\htdocs\forgetPassword.php on line 4

And after submit the username and email, the error as below...

Notice: Undefined variable: email in C:\Apache2\Apache2\htdocs\forgetPassword.php on line 21

Notice: Undefined variable: username in C:\Apache2\Apache2\htdocs\forgetPassword.php on line 23

Notice: Undefined variable: password in C:\Apache2\Apache2\htdocs\forgetPassword.php on line 23

Warning: mail(): "sendmail_from" not set in php.ini or custom "From:" header missing in C:\Apache2\Apache2\htdocs\forgetPassword.php on line 26
Your Password has been sent to SELECT * FROM company WHERE emailAdd=''



And i think it cannot defined the variable go, but i don't how 2 define it...

[bb nicole]

could someone give me a guildeline what is the problem of my forget password code??
Thanks... :)

[ronverdonk]

could someone give me a guildeline what is the problem of my forget password code??
Thanks... :)

Except for the warning you don't have a problem in your code. All you get are notices and that is because you have set the

error_reporting(E_ALL);
 

.

That error level setting is used only for debugging purposes and should be set off during production!

To get rid of these notices just comment that line out and only the real errors are left.

Ronald :cool:

[bb nicole]

Except for the warning you don't have a problem in your code. All you get are notices and that is because you have set the

error_reporting(E_ALL);
 

.

That error level setting is used only for debugging purposes and should be set off during production!

To get rid of these notices just comment that line out and only the real errors are left.

Ronald :cool:

I have set off the

error_reporting(E_ALL);
 

and test it, the output is:
Warning: mail(): "sendmail_from" not set in php.ini or custom "From:" header missing in C:\Apache2\Apache2\htdocs\forgetPassword.php on line 25
Your Password has been sent to SELECT * FROM company WHERE emailAdd=''

Then i change the code after 25,
where the original is
[PHP]
$to = "SELECT * FROM company WHERE emailAdd='$email' ";
$subject = "Your Password";
$body = "SELECT * FROM company WHERE username='$username' && password='$password' ";
$headers = "From: [e-mail]\n";
[/PHP]
to
[PHP]$sql1 = @mysql_query("SELECT * FROM company WHERE emailAdd='$email' ");
$to = mysql_fetch_array($sql1);

$subject = "Your Password";

$sql2 = @mysql_query("SELECT * FROM company WHERE username='$username' && password='$password' ");
$body = mysql_fetch_array($sql2);

$headers = "From: localhost/admin.php\n";
[/PHP]
The ouput is same like original...

Emm...How to repair it?? Thanks..

[ronverdonk]

(a) for the mail command you must either have specified the "FROM in php.ini mor set in in the header of your email. It must be an email address!!!

(b) you cannot, just like that, include the result of the query in your mail body because it is an array.

Anyway, why do you do the select when you already know the result, i.e. in variables $email, $username and $password????

If that is so, the mail setup can be like (example):

[php]
$to = $email;
$subject = "Your Password";
$body = "Username: $username\nPassword: $password\n";
$headers = "From: [e-mail]";
if (mail($to, $subject, $body, $headers))
echo
echo "Mail successfully sent!";
else
echo "Error sending email";
[/php]

Ronald :cool:

[bb nicole]

(a) for the mail command you must either have specified the "FROM in php.ini mor set in in the header of your email. It must be an email address!!!

(b) you cannot, just like that, include the result of the query in your mail body because it is an array.

Anyway, why do you do the select when you already know the result, i.e. in variables $email, $username and $password????

If that is so, the mail setup can be like (example):

[php]
$to = $email;
$subject = "Your Password";
$body = "Username: $username\nPassword: $password\n";
$headers = "From: [e-mail]";
if (mail($to, $subject, $body, $headers))
echo
echo "Mail successfully sent!";
else
echo "Error sending email";
[/php]

Ronald :cool:

Emm.. is it edit hte code as what i edit below?? I edit my code, but the output still remain the same as below:
Warning: mail(): "sendmail_from" not set in php.ini or custom "From:" header missing in C:\Apache2\Apache2\htdocs\forgetPassword.php on line 25
Error sending email


Below is my php code:
[PHP]$to = $email;
$subject = "Your Password";
$body = "Username: $username\nPassword: $password\n";
$headers = "From: [e-mail]";

if(mail($to, $subject, $body, $headers)){
echo "Your Password has been sent to $to";
}
else{
echo "Error sending email";} [/PHP]

Thanks...

[ronverdonk]

You have a problem with the 'sendmail_from' option in your php.ini file. If you cannot change your php.ini file, try it from the outside by inserting this statement just before you issue the mail(...) command

[php]ini_set(sendmail_from, "[e-mail]"); // the INI lines are to force the From Address to be used !
[/php]
Ronald :cool:

[bb nicole]

You have a problem with the 'sendmail_from' option in your php.ini file. If you cannot change your php.ini file, try it from the outside by inserting this statement just before you issue the mail(...) command

[php]ini_set(sendmail_from, "[e-mail]"); // the INI lines are to force the From Address to be used !
[/php]
Ronald :cool:

Sorry, my computer broken this few day, i have change my code to:
[PHP]$to = $email;
$subject = "Your Password";
$body = "Username: $username\nPassword: $password\n";
ini_set(sendmail_from, "[e-mail]"); // the INI lines are to force the From Address to be used !
[/PHP]
But the ouput is:
Warning: mail(): Failed to connect to mailserver at "localhost" port 25, verify your "SMTP" and "smtp_port" setting in php.ini or use ini_set() in C:\Apache2\Apache2\htdocs\forgetPassword.php on line 25
Error sending email

What should i do now??
Thanks..

[Motoma]

Verify that you have SMTP running on your server.

[bb nicole]

Verify that you have SMTP running on your server.

Sorry, may i know how to verify it??

[Motoma]

Sorry, may i know how to verify it??

Depends...what operating system are you using?

[bb nicole]

Depends...what operating system are you using?

Microsoft Windows XP... So, what should i do?? Thanks, Motoma..

[Atli]

If you have access to an online server it would be much simpler to test this kind of script on that, it will probbly have this set up already.

I'm assuming ofc that you are only using your localhost to test scripts you are developing, and the shipping them off somwhere else where it is used.

[Motoma]

Microsoft Windows XP... So, what should i do?? Thanks, Motoma..

Install an SMTP server :P

Google will give you as good of a result for this as I can.

[bb nicole]

Install an SMTP server :P

Google will give you as good of a result for this as I can.

I have install an SMTP server.. What should i do to verify that i have SMTP running on my server??
No matter i have key in the username or email or not, the output is same...
Output:
Warning: mail(): Failed to connect to mailserver at "localhost" port 25, verify your "SMTP" and "smtp_port" setting in php.ini or use ini_set() in C:\Apache2\Apache2\htdocs\forgetPassword.php on line 25
Error sending email

[Motoma]

Is you firewall enabled? Is it blocking your smtp port?

[bb nicole]

Is you firewall enabled? Is it blocking your smtp port?

Thanks...
I have checking my firewall, it don't blocking my smtp port... So, what is the problem of it... Do you or someone have other scripts of forget password to let me try is whether it is work??

[ronverdonk]

Just only one thing left:
Show us your PHP.INI (in the Windows subdirectory!) settings for the following entries:

[mail function]
; For Win32 only.
SMTP = xxxxxxxxxxxxx
smtp_port = yy
 
; For Win32 only.
sendmail_from = zzzzzzzzzzzzzz

Ronald :cool:

[Atli]

I recommend you try this. It's a free SMTP server. Just install it, open it and you should be able to use the mail() function on your localhost.

Free SMTP server

I would turn of any other SMTP server you might have before you use this.

[bb nicole]

Just only one thing left:
Show us your PHP.INI (in the Windows subdirectory!) settings for the following entries:

[mail function]
; For Win32 only.
SMTP = xxxxxxxxxxxxx
smtp_port = yy
 
; For Win32 only.
sendmail_from = zzzzzzzzzzzzzz

Ronald :cool:

This is my php.ini setting...
[mail function]
; For Win32 only.
SMTP = localhost

; For Win32 only.
sendmail_from = [e-mail]


I don't know what i'm doing correct or not, but i'm trying to change it as below:
; For Win32 only.
SMTP = localhost
smtp_port = 25

; For Win32 only.
sendmail_from = [e-mail]

And the code as below:

$to = $email;
$subject = "Your Password";
$body = "Username: $username\nPassword: $password\n";
ini_set(sendmail_from, "[e-mail]");  // the INI lines are to force the From Address to be used !

but the output still is the same message:
Warning: mail(): Failed to connect to mailserver at "localhost" port 25, verify your "SMTP" and "smtp_port" setting in php.ini or use ini_set() in C:\Apache2\Apache2\htdocs\forgetPassword.php on line 25
Error sending email


Thanks..

[bb nicole]

I recommend you try this. It's a free SMTP server. Just install it, open it and you should be able to use the mail() function on your localhost.

Free SMTP server

I would turn of any other SMTP server you might have before you use this.

Emm.. I already install it, but i'm unable to use the mail() function on localhost.
Thanks..

[Atli]

Then, as was pointed out earlier, either the mail settings in your php.ini have been changed or there is a firewall blocking your SMTP server.

Your php.ini mail settings should be:
SMTP = localhost
smtp_port = 25

And there is really no way to tell you how to check the firewall because there are like million types of firewalls each with their own configurations.
You will just have to find out which one you have and find a way to unblock port 25

[bb nicole]

Then, as was pointed out earlier, either the mail settings in your php.ini have been changed or there is a firewall blocking your SMTP server.

Your php.ini mail settings should be:
SMTP = localhost
smtp_port = 25

And there is really no way to tell you how to check the firewall because there are like million types of firewalls each with their own configurations.
You will just have to find out which one you have and find a way to unblock port 25

I have go to control panel -> windows firewall -> expection -> add port
I aad the port as below:
Name: localhost
Port Number: 25
but the result is still same, i want to give up ledy..

[Atli]

Do you have any Anti-virus programs?
Is it possible a router is blocking the port?
Are you sure your connected to the internet!?

[ronverdonk]

If you have a email account with a provider, they usually have an SMTP server box that you can address.

Suppose your email account is [e-mail], their smtp server will be something like smtp.provider.com. You can check that from your own email client setup.

That is what you then specify in the SMTP = statement i.e.

SMTP = smtp.provider.com

For the sendmail_from you can then specify your own email address:

sendmail_from = [e-mail]

That works for me, I just use my provider's smtp server and don't have to install my own.

Ronald :cool:

[Motoma]

Try this:

From the start menu, click Run.
Type in 'cmd'.
From the command prompt, type 'telnet localhost 25'.
What do you see?

[bb nicole]

Try this:

From the start menu, click Run.
Type in 'cmd'.
From the command prompt, type 'telnet localhost 25'.
What do you see?

After i type, it show me:
Connecting to localhost... Could not open connection to the host, on port 25: Connect Fail
Thanks..

[bb nicole]

If you have a email account with a provider, they usually have an SMTP server box that you can address.

Suppose your email account is [e-mail], their smtp server will be something like smtp.provider.com. You can check that from your own email client setup.

That is what you then specify in the SMTP = statement i.e.

SMTP = smtp.provider.com

For the sendmail_from you can then specify your own email address:

sendmail_from = [e-mail]

That works for me, I just use my provider's smtp server and don't have to install my own.

Ronald :cool:

Sorry, how can i check whether i have a email account with a provider and how to check that from my own email client setup. Thanks..

[bb nicole]

Do you have any Anti-virus programs?
Is it possible a router is blocking the port?
Are you sure your connected to the internet!?

Yes, i used Karpersky Anti-Virus 6.0, but i don't know whether it is block the port.. Thanks..

[Motoma]

After i type, it show me:
Connecting to localhost... Could not open connection to the host, on port 25: Connect Fail
Thanks..

This means you do not have an SMTP server running.
This is also the source of your error.

[bb nicole]

This means you do not have an SMTP server running.
This is also the source of your error.

What should i do?? I already install Free SMTP Server..Thanks..

[Motoma]

What should i do?? I already install Free SMTP Server..Thanks..

Are you running it?
Do you have the SMTP server up on your screen?

[bb nicole]

Are you running it?
Do you have the SMTP server up on your screen?

It oledy have the shotcut in my screen.. and it can open, but it is need to used it? It's just a server, right??
I'm trying to click on it, it has a button call option,
DNS Server is autodetect
SMTP Port is standard #25

Thanks..

[Motoma]

It oledy have the shotcut in my screen.. and it can open, but it is need to used it? It's just a server, right??
I'm trying to click on it, it has a button call option,
DNS Server is autodetect
SMTP Port is standard #25

Thanks..

You will need to keep it running in order to use mail.

[bb nicole]

You will need to keep it running in order to use mail.

How to keep it running??
ANd my outlook express cant send the mail and got error message come out, is it related??
The error message is:
The service is currently unavailable. Try again later. Account: 'Hotmail', Server: 'http://services.msn.com/svcs/hotmail/httpmail.asp', Protocol: HTTPMail, Server Response: 'Service Unavailable', Port: 0, Secure(SSL): No, Socket Error: 87, Error Number: 0x800CCCF0
Unable to poll for new messages on your HTTP server. Account: 'Hotmail', Server: 'http://services.msn.com/svcs/hotmail/httpmail.asp', Protocol: HTTPMail, Server Response: 'Service Unavailable', Port: 0, Secure(SSL): No, Socket Error: 87, Error Number: 0x800CCCF0

Thanks...

[9911782]

Hi All

I've been reading this thread, bcoz I had the same problem. I have followed all these instruction until Installation of Free SMTP Server. Now I have a problem when I clicked on the icon, it gives me an error.
'Internet or DNS Server Inaccessible'.

What must I do?

thanks :)