<?php
include("config.php");
session_start();
$error='';
if($_SERVER["REQUEST_METHOD"] == "POST") {
// username and password sent from form textbox
$email = mysqli_real_escape_string($db,$_POST['email']);
$pass = mysqli_real_escape_string($db,$_POST['pass']);
$sql = "SELECT * FROM users WHERE email = '$email' and pass = '$pass'";
$result = mysqli_query($db,$sql);
$row = mysqli_num_rows($result);
$count = mysqli_num_rows($result);
//read user from database record
$sql = "SELECT name, gender, age, user, email, pass FROM users where email='$email'";
$result = mysqli_query($db,$sql);
$row = mysqli_num_rows($result);
$count = mysqli_num_rows($result);
$name= $row['name'];
$gender= $row['gender'];
$age= $row['age'];
$user= $row['user'];
$email= $row['email'];
$pass= $row['pass'];
if($count == 1) {
// session variables of user for chatroom
$_SESSION['name'] = $name;
$_SESSION["gender"] = $gender;
$_SESSION["age"] = $age;
$_SESSION['user'] = $user;
$_SESSION['email'] = $email;
header("location: chatroom.php");
} else {
$error = "Your Email or Passwsord is invalid";
}
}
?>
//display code
<div class="welcome-container">
<div class="users" id="users">
<!-- //welcome message to logged in user -->
Welcome:
<?php
echo $_SESSION['user'];
?>
</div>
</div>