Day 17 - Include: Easy cut and paste for Programmers - Become PHP Expert in 30 days

[annie]

http://php.flashwebhost.com/annie/

The password has been sent to the e-mail address specified

 <?php

include "includes/database.php"; 

if (isset($_POST['email'])) {
    $email = $_POST['email'];
} else {
    die('Please enter your email address');
}

$email = trim($email);

$sql = "select * from users where email='$email'";

$result = $mysqli->query($sql);

if ($result->num_rows == 0) {
    die("User with email address <b>$email</b> not found");
}

$userInfo = mysqli_fetch_assoc($result);

$name = $userInfo['name'];
$password = $userInfo['password'];
mail($email,"Your password", "Hello $name, your password is $password");

echo 'The password has been sent to the e-mail address specified';

[sherlyk]

http://php.flashwebhost.com/sherly/lost_password.html

The password has been sent to the e-mail address specified

<?php

include "includes/database.php"; 

if (isset($_POST['email'])) {    
   $email = $_POST['email'];
} else {    
   die('Please enter your email address');
}

$email = trim($email);

$sql = "select * from users where email='$email'";

$result = $mysqli->query($sql);

if ($result->num_rows == 0) {    
die("User with email address <b>$email</b> not found");

}
$userInfo = mysqli_fetch_assoc($result);

$name = $userInfo['name'];
$password = $userInfo['password'];
mail($email,"Your password", "Hello $name, your password is $password");
echo 'The password has been sent to the e-mail address specified';

[stefin]

http://php.flashwebhost.com/stefin/lost_password.php
New Password send to your email

This one was pretty good and interesting, i like copy pasting

<?php
include "includes/database.php";  

if (isset($_POST['email'])) {    $email = $_POST['email'];} else {    die('Please enter your email address');}
$email = trim($email);


$sql = "select * from users where email='$email'";
$result = $mysqli->query($sql);

if ($result->num_rows == 0) {    die("User with email address <b>$email</b> not found");}
$userInfo = mysqli_fetch_assoc($result);
$name = $userInfo['name'];$password = $userInfo['password'];mail($email,"Your password", "Hello $name, your password is $password");
echo 'New Password send to your email';

[admin]

Nice. We can keep frequently used code in another file and include them as needed.

[Vahaa11]

http://php.flashwebhost.com/sibichan..._password.html

Yes, I got the mail with password

I used 'require' in lost_password.php

<?php
require "includes/database.php";  
if (isset($_POST['email'])) {

    $email = $_POST['email'];

} else {

    die('Please enter your email address');}
// now we have $email variable.

// $email can contain space if user enter white space..

// So lets remove any white space char using trim() function.
$email = trim($email);
// lets write an SQL statement to search our users table

// to find the user having email address == $email
$sql = "select * from users where email='$email'";
// In above line, we used single quotes between email, because it is a string.
// Now time to execute the SQL statement.

$result = $mysqli->query($sql);
// lets see how many records found in database

// If num_rows is 0, no user found
if ($result->num_rows == 0) {

    die("User with email address <b>$email</b> not found");

}
// lets get the user record from MySQLi result
$userInfo = mysqli_fetch_assoc($result);
// $userInfo is an associate array.

// Lets print it.

// Now you can see all information about the user, including password.
$name = $userInfo['name'];

$password = $userInfo['password'];

mail($email,"Your password", "Hello $name, your password is $password");

echo 'The password has been sent to the e-mail address specified';

[admin]

Good, require is better, but used include as everyone understand the meaning of the word and is easy to relate to what it do - include code from other file.