Free Student Projects

Follow

Cool Login Form With PHP, MySQL and jQuery

by Shiva Prasad

Share

Login and user authentication is the most common feature in any dynamic website. We are going to create a simple login system using PHP code on our pages, and a MySQL database to store our users information. The rar file contains the complete PHP MySQL Login source code of our authentication script and a MySQL file to create and populate the required tables.

Cool Login Form With PHP, MySQL and jQuery

Connection.php

<?php
// connect to database
$con = mysql_connect(“localhost”,”root”,”technology”);
if (!$con)
{
die(‘Could not connect: ‘ . mysql_error());
}
//Select Database
mysql_select_db(“logindb”, $con);
?>

Login.php

<?php
// Database connection
include(“connection.php”);

// AJAX JQuery Validation
include(“validation/validation.php”);

// Condition checks Submit button is set or not
if(isset($_POST[“btnlogin”]))
{

// Select username and password from admin table
$result = mysql_query(“SELECT * FROM admin WHERE username=’$_POST[adminid]’ AND password=’$_POST[password]'”);

// Query checks Entered user id is valid or not…
if(mysql_num_rows($result) == 1)
{

//     redirects to admindashboard.php
header(“Location: admindashboard.php”);
}
else
{

// “Login Failed.. Please try again” message stores in variable $abc
$abc=”Login Failed.. Please try again”;
}
}
?>

<form name=”formID” id=”formID” method=”post” action=””>
<p align=”center”><b> <u><h2>Login Page </h2></u><br>Enter User ID and Password to Login website <br>
<font color=”#FF0000″>
<?php
// prints if its invalid password
echo $abc;
?>
</font></b>
</p>
<p> <strong>User Name :
<input type=”text” name=”adminid” id=”adminid” />
</strong></p>
<p><strong>Password :
<input type=”password” name=”password” id=”password” />
</strong></p>
<p>
<strong>
<input  type=”submit” name=”btnlogin” id=”btnlogin” value=”Login” />
<input  type=”reset” name=”button2″ id=”button2″ value=”Reset” />
<br />
</strong></p><p>&nbsp;</p><p>&nbsp;</p>
<p>
</form>

Table Design :

Download Source Code :

For more project Ideas visit http://www.bestprojectsidea.com/

For Source code of all projects visit http://www.studentprojectcode.com/

POPULAR PROJECTS

Share

Related

Latest