passwordRequest.php

 <?php

require_once("connection.php");

$username=addslashes($_GET['email']);

$table="v_username_validado";

$sql="SELECT * FROM $table WHERE username = '$username'";

$query=mysqli_query($con, $sql) or die($sql);

$total=mysqli_num_rows($query);

if($total==1) {

    $fetch=mysqli_fetch_assoc($query);

    $idUsername=$fetch['idUsername'];

    require_once("token.php"); # cria um token na variável $token

    $path="mail/passwordEmail.php?username=$username&idUsername=$idUsername&token=$token";

    $sql="INSERT INTO token (idUsername, token)

    VALUES ($idUsername, '$token')";

    mysqli_query($con,$sql) or die($sql);

} else {

    $path="password.html?msg=semRecuperacao";

}

header("Location:$path");

?>