Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- how to send an email when someone logs into mysql
- <?php
- session_start();
- require_once('connect.php');
- // Retrieve username and password from database according to user's input
- $input_username = mysql_real_escape_string($_POST['username']);
- $login = mysql_query("SELECT * FROM user WHERE username = '".$input_username."'" );
- // Check username and password match
- $row = mysql_fetch_array($login);
- if (mysql_num_rows($login)) {
- if($row['password'] === md5($_POST['password'])){
- $_SESSION['username'] = $_POST['username']; // store in session
- $sql = "UPDATE user SET logindate = NOW() WHERE username = '" . mysql_real_escape_string($_SESSION['username']) . "'";
- mysql_query($sql) or die("Error in SQL: " . mysql_error());
- }
- else{
- // Invalid login
- echo header('Location: loginerror.php');
- exit;
- }
- ?>
- if ($rowcount == 1) {
- $_SESSION['username'] = $_POST['username'];
- $headers = "From:Me <no-reply@example.com>rn";
- $headers .= "Reply-To: no-reply@example.comrn";
- $email_to = "your@emailadress.tld";
- $subject = "Someone logged in!";
- $message = "User ".$_POST['username']." logged in!";
- mail($email_to, $subject, $message, $headers);
- header("Location: securedpage.php");
- }
- if(mail($email_to, $subject, $message, $headers)) {
- // mail function was successful
- } else {
- // error; mail function was NOT successful
- }
- $input_password = mysql_real_escape_string($_POST['password']);
- $login = mysql_query("SELECT * FROM tbuser WHERE (username = '" . $input_username . "') AND (password = '" . md5($input_password) . "')",$db);
Add Comment
Please, Sign In to add comment