Hey I need help, I am having trouble with going through the if statements in my
ID: 3589500 • Letter: H
Question
Hey I need help, I am having trouble with going through the if statements in my login.php file. I'm not sure if it knows what the username and password values are? What am I doing wrong? I didn't include my CSS but here it is? It is a typical log in page. How do I connect database too?? I am using Jquery AJAX and phpMyAdmin for database.
Please help.
///index.php
<!DOCTYPE html>
<html>
<head>
<title>Project</title>
<meta charset = "UTF-8">
<link rel="stylesheet" href="styles.css"/>
<script src="jQuery.js"></script>
</head>
<header>
<h1>Project</h1>
</header>
<body>
<div id = "contain">
<div id="login_error"> </div>
<form action = "login.php" id="#searchform">
<ul id = "login" >
<li>
Username: <br>
<input type="text" name="username" align="middle" id="username">
</li>
<li>
Password:<br>
<input type="password" name="password" align="middle" id="password">
</li>
<li>
<input type = "submit" value="Sign In" id="signIn">
</li>
<li>
<input type = "submit" value="Register" id="reg" >
</li>
</ul>
</form>
</div>
</div>
</body>
<script>
$("#searchForm").submit(function( event ) {
event.preventDefault();
var $form = $( this );
user = $form.find("#username").val();
pass = $form.find("#password").val();
var data = "user=" + user + "&pass=" + pass;
url = $form.attr( "action" );
$.ajax({
method: "post",
url: url,
data: data,
success: function(data)
{
$("#login_error").html(data);
}
})
})
});
</script>
<footer>
<h3> Follow US </h3>
</footer>
</html>
///// login.php
<!DOCTYPE html>
<html>
<head>
<title>Project</title>
<meta charset = "UTF-8">
<link rel="stylesheet" href="styles.css"/>
<script src="jQuery.js"></script>
</head>
<header>
<h1>Project</h1>
</header>
<body>
<div id = "contain">
</div>
</body>
<?php
$user = $_POST['user'];
$pass = $_POST['pass'];
if(empty($user & $pass))
{
echo "All fields are required!";
}
else
if(empty($user))
{
echo "Username required";
}
else if(empty($pass))
{
echo "Password required!";
}
else{
echo "Welcome $user :) ";
}
?>
Explanation / Answer
Hi
I have modified your code slightly.you can clarify your doubts any time regarding this question.
To connect with database.first create the database in phpmyadmin and run the follwoing query in sql in your database
CREATE TABLE `user` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`username` varchar(255) NOT NULL,
`email` varchar(255) NOT NULL,
`password` varchar(255) NOT NULL,
`active` tinyint(1) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `username` (`username`)
)
Next your index page
<!DOCTYPE html>
<html>
<head>
<title>Project</title>
<meta charset = "UTF-8">
<link rel="stylesheet" href="styles.css"/>
<script>
function validateForm() {
var x = document.forms["myForm"]["username"].value;
if (x == "") {
alert("Please Enter Username");
return false;
}
var y = document.forms["myForm"]["password"].value;
if (y == "") {
alert("Please Enter Password");
return false;
}
}
</script>
</head>
<header>
<h1>Project</h1>
</header>
<body>
<div id = "contain">
<div id="login_error"> </div>
<form action = "login.php" method="POST" name="myForm">
<ul id = "login" >
<li>
Username: <br>
<input type="text" name="username" align="middle" id="username">
</li>
<li>
Password:<br>
<input type="password" name="password" align="middle" id="password">
</li>
<li>
<input type = "submit" value="Login" id="signIn">
</li>
<li>
<input type = "submit" value="Register" id="signUp">
</li>
<li>
</li>
</ul>
</form>
</div>
</div>
</body>
<footer>
<h3> Follow US </h3>
</footer>
</html>
Database connection->connect.php
<?php
$connection = mysqli_connect('localhost', 'root', '');
if (!$connection){
die("Database Connection Failed" . mysqli_error($connection));
}
$select_db = mysqli_select_db($connection, 'sam');
if (!$select_db){
die("Database Selection Failed" . mysqli_error($connection));
}
?>
login.php
<!DOCTYPE html>
<html>
<head>
<title>Project</title>
<meta charset = "UTF-8">
</head>
<header>
<h1>Project</h1>
</header>
<body>
<div id = "contain"></div>
</body>
<?php
require('connect.php');
if (isset($_POST['username']) and isset($_POST['password'])){
$username = $_POST['username'];
$password = $_POST['password'];
$query = "SELECT * FROM `user` WHERE username='$username' and password='$password'";
$result = mysqli_query($connection, $query) or die(mysqli_error($connection));
$count = mysqli_num_rows($result);
if ($count == 1){
$_SESSION['username'] = $username;
}else{
echo "Invalid Login Credentials.<br>Please check ur username and password correctly";
}
} else {
echo "All fields are required!";
}
if (isset($_SESSION['username'])){
$username = $_SESSION['username'];
echo "Hi " . $username . " <br>";
echo "Welcome to user area";
echo "<a href="logout.php"> Logout</a>";
}else{
}
?>
logout.php
<?php
session_start();
session_destroy();
header('Location: login.php');
?>