How to make a auto mail configuration...

Chrysanthus

Hi i do not know where to start with this but i have started with this sow far...

1.

I wanna make a form that's gives the user the ability to get there password sent by e-mail to them by typing in there username in this form.

<html>

<head>
<title></title>
</head>

<form action="" method="post" name="login">
Username:
<input class="inputSidebar" type="text" name="username"<br>
<input class="button" type="submit" name="submit" value="Get password">
</form>

<body>

<?php

?>

</body>

</html>

2.

then after it will searce the db after the username and check the e-mail and send the password to the registerd e-mail in the db.

How do i start?

i have a form
i have a db.
i have registerd info to test the funktion if it works1
i have no idé to where to start[/COLOR]

snoopy13

you make a query to find the user's email adress and password
$query="SELECT email, password FROM table WHERE username='$username'";

you read out this information with fetch_array and safe it in a variable ($email) and ($pass)

then you send the email:
$to = "$email";

$headers .="From: ADMIN \r\n";
$subject = "your Password";
$text = "Hello user, your password is $pass";

mail($to, $subject $text, $headers);

hope that helps

Chris-the_dude

First, you want to send your form data to a php script, so for ex., on your form you will want

then on your php script you will want to accept the username, and then query the database for that person's password, and then finally email it to them. It might look something like this:

<?php

$username = $_POST['username'];

$sql = "SELECT password, email
            FROM TABLE
            WHERE USERNAME = '$username'";
// connect to database and run query.  This code will differ depending on what kind of database you have
$db = db_connect();
$results = runSQL($db, $sql);
$row = $results->fetchRow();

//now email the results to the user.  This code assumes you have columns named 'email' and 'password' in your table.

if (mail($row['email'], "Your Password", "Your password is ".$row['password']))
    echo "Email Sent Successfully";

?>

Chris-the_dude

damn, all that code and I got beat to it :-p

Chrysanthus

To Chris-the dude

hi i manage to come so far but i wonder how i get everything on the same page..

is it selp echo i am supposed
to use?

if i wanna fint in the last mail code where do i put it?

<form action="selp echo" method="post" name="getpass">
Username:<br>
<input class="inputSidebar" type="text" name="username"<br>
<input class="button" type="submit" name="submit" value="Get password">
</form>

<?

$username=$_POST["username"];

include('mysqlcon.php');

$mysqlcon = "select * from reg_info where username = '$username';";
$result = mysql_query($mysqlcon) or die("Query failed");

if (mysql_num_rows($result) == '1') {

print "<p><center><big>Welcome $username Please click <a href=\"index.php\">here to continue to flameline.com in some seconds you will recive a email with your password in it.</big></center></p>";

}
else
{
print "<p><center><big>Sorry, incorrect $username.</big></big></center></p>";
print "<p><center><big>if not a member <a href=\"register.php\">click here to register</big></center></p>";
}

?>

ups i forgott i run mysql

Chris-the_dude

I don't understand what you mean by 'selp echo'

If you want everything on the same page - lets call it 'emailPass.php', the structure might look like this:

<?

include ('mysqlcon.php');
$username = $_POST['username'];

if (!$username)  // they haven't filled out the form yet.
{
?>
<html>
<body>
<form action="selp echo" method="post" name="getpass"> 
Username:<br> 
<input class="inputSidebar" type="text" name="username"<br> 
<input class="button" type="submit" name="submit" value="Get password"> 
</form> 
</body>
</html>
<?
}

else // form has been filled out
{
$mysqlcon = "select * from reg_info where username = '$username';"; 
$result = mysql_query($mysqlcon) or die("Query failed"); 

  if (mysql_num_rows($result) == '1') { 
  /********Dont forget this**********/
  $row = mysql_fetch_row($result);

  print "<p><center><big>Welcome $username Please click <a href=\"index.php\">
here to continue to flameline.com in some seconds you will recive a email with your password in it.</big></center></p>"; 

  /**********put mail function here!**************/
  if (mail($row['email'], "Your Password", "Your password is ".$row['password'])) 
    echo "Email Sent Successfully"; 


  } 
  else 
  { 
  print "<p><center><big>Sorry, incorrect $username.</big></big></center></p>"; 

  print "<p><center><big>if not a member <a href=\"register.php\">
click here to register</big></center></p>"; 
  } 
}
?>

That should do it for you

Chrysanthus

Sorry for not giveing the right info..

i mean that when i execute the the form the php code will do all the stuff and the same page will come back up again with the prints and all.....

when i talk about selp echo a ment echo the same page...
:rolleyes:

Chris-the_dude

From what I understand, my code should work for you

good luck

Chrysanthus

hi yeah it works but it stops at line 24 and there are enterys in the db but i get "Query failed" anyway any idés.

$result = mysql_query($mysqlcon) or die("Query failed");

my db looks like this

CREATE TABLE reg_info

(regid int(11) NOT NULL auto_increment,
username varchar(32) default NULL UNIQUE,
password varchar(32) default NULL,
firstname varchar(32) default NULL,
lastname varchar(32) default NULL,
birthdate varchar(8) default NULL,
gender ENUM('M','F') default NULL,
email varchar(32) default NULL UNIQUE,
country varchar(32) default NULL,
city varchar(32) default NULL,
gotmember ENUM('Yes','No') default NULL,
regdate TIMESTAMP(14) default NULL,

PRIMARY KEY (regid));

// thanks for the help

Chris-the_dude

It doesn't look like you actually have any code that actually connects to your database and selects which table to use for your query. Look into the msql_connect and mysql_select_db functions for help.

Chrysanthus

i connect to the db in the include file

include ('mysqlcon.php');

That i have inserted this info

<?

mysql_connect ("localhost","root","*****");
mysql_select_db ("flameline");
?>

Chris-the_dude

I reccomend doing some error checking in your include file to make sure that you are actually connected to your database.

ex:
if (!mysql_connect(....))
echo "error: could not connect to database";
if (!mysql_select_db(...))
echo "error: could not select database";

otherwise, if that doesn't work, just check your tables and double check that your sql syntax is correct.

Chrysanthus

i give up thanks any way