Web Developer's Blog: php

user registration and authentication example

here is a code for authentication system( user registratoin and login functionality).

First of all set your database configuration in Db.php file, and then create table in database and Add all content in specified file name.

First you need to do the registration then after you can login in to the system. After login you redirect on the page Welcome.php here you can find Logout link for logout from the system.

In this I havn’t create index file so you need to go through direct link.

Create Table

CREATE TABLE IF NOT EXISTS `login` (

`id` int(11) NOT NULL AUTO_INCREMENT,

`firstname` varchar(20) NOT NULL,

`lastname` varchar(20) NOT NULL,

`gender` varchar(5) NOT NULL,

`mobileno` varchar(20) NOT NULL,

`email` varchar(50) NOT NULL,

`password` varchar(50) NOT NULL,

PRIMARY KEY (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

Create files specified file name Db.php, Registraton.php, Login.php, Welcome.php.
Copy and Past the code in the files and then run the example.

DB.php

<?php

$conn = mysql_connect("localhost","root","");

mysql_select_db("practice",$conn);

Registration.php

<?php include('Db.php'); ?>

<html><head><title>Registration</title></head>

.title { font-family: Arial, Helvetica, sans-serif; text-align:center;width:350px; }

.tableDesign { font-size:16px;font-family:Arial, Helvetica, sans-serif; width:350px; height:400px; }

table { background-color:#CCC; }

table input { height:25px;font-size:16px; }

table tr { height:15px; }

.errorMessage { color:red;text-align:center; }

</style>

<body>

<label><div class="title"><u>Registration Form</u></div></label>

<tr><td colspan="2"><?php if(isset($_GET['err_message'])){ echo "<div class='errorMessage'>".$_GET['err_message'].'</div>'; } ?></td></tr>

<tr><td>First Name: </td><td><input type="text" name="txtFirstName" /></td></tr>

<tr><td>Gender:</td><td><input type="radio" name="txtGender" value="Male" />

Male <input type="radio" name="txtGender" value="Female" />Female</td></tr>

<tr><td>Mobile No.: </td><td><input type="text" name="txtMobileNo" /></td></tr>

<tr><td>Password: </td><td><input type="password" name="txtPassword" /></td></tr>

<tr><td> </td><td><a href="Login.php">Back To Login</a></td></tr>

</table>

</form>

<?php if(isset($_POST['submit']))

{

$resultExists = mysql_query("select count(*) userExists from login where email = '".$_POST['txtEmail']."'")or die(mysql_error());

$rowExists = mysql_fetch_array($resultExists);

if($rowExists["userExists"] > 0){ header("Location:Registration.php?err_message=Email Already Exists.!!!"); }

else {

$result = mysql_query("insert into login(firstname, lastname, gender, mobileno,email, password) values('".$_POST['txtFirstName']."','".$_POST['txtLastName']."','".$_POST['txtGender']."','".$_POST['txtMobileNo']."','".$_POST['txtEmail']."','".md5($_POST['txtPassword'])."')")or die(mysql_error());

$row_count = mysql_affected_rows();

if($row_count == 1){ header("Location:Login.php?message=Registration Successfull.!!!"); }

else { echo "Not Insert...!!!"; }

}

}?>

</body>

</html>

Login.php

<?php include('Db.php'); session_start(); ?>

<html><head><title>Login</title></head>

function validation() {

var f =document.loginForm;

var error = "Please Check Errors";

var flag = true;

if(f.txtUserName.value == "") {

error += "\nEnter User Name";

flag = false;

}

if(f.txtPassword.value == "") {

error += "\nEnter Password";

flag = false;

}

if(flag == false)

{ alert(error); }

return flag;

}

</script>

.title { font-family: Arial, Helvetica, sans-serif; text-align:center;width:350px; }

.tableDesign { font-size:16px;font-family:Arial, Helvetica, sans-serif; width:350px; height:150px; }

table { background-color:#CCC; }

table input { height:25px;font-size:16px; }

table tr { height:15px; }

.errorMessage { color:red;text-align:center; }

.message { color:green; }

</style>

<body>

<?php if(isset($_GET['action'])&& isset($_SESSION['userAuthenticated'])){ unset($_SESSION['userAuthenticated']); } ?>

<label><div class="title"><u>Login</u>  </div></label>

<tr><td colspan="2"><?php if(isset($_GET['err_message'])){ echo "<div class='errorMessage'>".$_GET['err_message'].'</div>'; }

else if(isset($_GET['message'])){ echo "<div class='message'>".$_GET['message'].'</div>'; } ?></td></tr>

<tr><td>UserName</td><td><input type="text" name="txtUserName"></td></tr>

<tr><td>Password</td><td><input type="password" name="txtPassword"></td></tr>

<tr><td> </td><td><a href="Registration.php">Registration</a></td></tr>

</table>

</form><?php

if(isset($_POST['submit']))

{

$username = $_POST['txtUserName'];

$password = $_POST['txtPassword'];

$result = mysql_query("select count(*) as authenticated from login where email = '{$username}' and password = '".md5($password)."'")or die(mysql_error());

$row = mysql_fetch_array($result);

if( $row["authenticated"] == 1){ $_SESSION['userAuthenticated'] = $username; header("Location:Welcome.php?name='".$username."'"); }

else { header("Location:Login.php?err_message=username or password is wrong.!!!"); }

}?>

</body>

</html>

Welcome.php

<?php session_start();

if(!isset($_SESSION['userAuthenticated']) &&$_SESSION['userAuthenticated'] = true)

{ echo header("Location:Login.php?err_message=First Do The Login.!!!"); ; }

echo "Welcome : ";

if(isset($_GET['name'])){ echo $_GET['name']; } ?>  

<a href="Login.php?action=logout">Logout</a>

Thank you for the visiting my blog

Insert, Update, Delete CRUD example

Find the below code for developing CRUD(create, retrive, update, delete) application in php .

here is added the code for creating crud applcation . i used user table for this operations.

Code for creating table in database

CREATE TABLE IF NOT EXISTS `user` (

`id` int(11) NOT NULL AUTO_INCREMENT,

`name` varchar(20) NOT NULL,

`address` varchar(20) NOT NULL,

`mobileno` varchar(20) NOT NULL,

`city` varchar(20) NOT NULL,

PRIMARY KEY (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=10 ;

Create Config.php file for connecting database

<?php $cn = mysql_connect("localhost","root","");

mysql_select_db("practice",$cn); ?>

replace your database name in place of practice. Add your host name, username password for the database connection.

Adding Record: Create file Add.php put the below content for adding record in the table.

<tr>

</tr>

<tr>

<td>Address:</td>

</tr>

<tr>

<td>Mobile No.:</td>

</tr>

<tr>

<option value="">Select </option>

<option value="ahmedabad">Ahmedabad</option>

<option value="jamnagar">Jamnagar</option>

</select></td>

</tr>

<tr>

</tr>

</table>

</form>

<?php

include("Config.php");

if(isset($_POST["submit"]))

{

$name = $_POST["txtName"];

$address = $_POST["txtAddress"];

$mobileNo = $_POST["txtMobileNo"];

$city = $_POST["city"];

echo $query = "insert into user(name, address, mobileno, city) values('$name','$address','$mobileNo','$city')";

$result = mysql_query($query)or die(mysql_query());

if($result)

{

header("Location:View.php");

}

See below image about insert record

Display all record : Create file name View.php and add below content for listing records from the table.

<?php

include("Config.php");

if(isset($_GET["action"]))

{

$id = $_GET['id'];

if($_GET["action"] == "delete")

{

$result = mysql_query("delete from user where id = $id")or die(mysql_error());

header("Location:View.php");

}

else if($_GET["action"] == "edit")

{

header("Location:Edit.php?id=$id");

}

else

{

header("Location:View.php");

}

?><html>

<head>

<title>CRUD Operation Example</title>

</head>

<body>

<a href="Add.php">Add Record</a>

<thead>

<th>Address</th>

<th>Mobile No.</th>

<th colspan="2">Action</th>

</thead>

<tbody>

<?php

$query = "select * from user";

$result = mysql_query($query);

while($row = mysql_fetch_row($result)or die(mysql_error()))

{

echo "<tr>";

echo "<td>".$row[1]."</td>";

echo "<td>".$row[2]."</td>";

echo "<td>".$row[3]."</td>";

echo "<td>".$row[4]."</td>";

$id = $row[0];

echo "<td><a href='?action=edit&id=$id'>EDIT</a></td>";

echo "<td><a href='?action=delete&id=$id'>DELETE</a></td>";

echo "</tr>";

}

</tbody>

</table>

</body>

</html>

Update Record: Create file name Edit.php put the below content for update existing record in the table.

<?php

include("Config.php");

$id = $_GET['id'];

$result = mysql_query("SELECT * FROM user WHERE id = $id") or die(mysql_error());

$row = mysql_fetch_array($result);

if($row)

{ ?>

<tr>

</tr>

<tr>

<td>Address:</td>

</tr>

<tr>

<td>Mobile No.:</td>

</tr>

<tr>

<option value="">Select </option>

<option value="ahmedabad" <?php if($row[4] == 'ahmedabad'){ ?> selected="selected" <?php } ?> >Ahmedabad</option>

<option value="jamnagar" <?php if($row[4] == 'jamnagar'){ ?> selected="selected" <?php } ?> >Jamnagar</option>

</select></td>

</tr>

<tr>

</tr>

</table>

</form> <?php

}

if(isset($_POST["submit"]))

{

$id = $_POST["txtId"];

$name = $_POST["txtName"];

$address = $_POST["txtAddress"];

$mobileNo = $_POST["txtMobileNo"];

$city = $_POST["city"];

echo $query = "update user set name = '$name', address = '$address', mobileno = '$mobileNo', city = '$city' where id = '$id'";

$result = mysql_query($query)or die(mysql_query());

if($result)

{

header("Location:View.php");

}

swaping two numeric value

Here listed five method of swaping two numeric(integer) value.

method 1: Assign the value of the second variable to the first variable. Third temporary variable $temp is used to hold the value of the first variable so it’s value can't be lost.

$x = 1;
$y = 2;
$temp = '';
$temp = $x;
$x = $y;
$y = $temp;
echo 'Value of X: '.$x;
echo 'Value of Y: '.$y;

method 2: Using php function array and list.

$x = 3;
$y = 4;
list($x, $y) = array($y, $x);
echo 'Value of X: '.$x;
echo 'Value of Y: '.$y;

method 3: Using addition and subtraction

$x = 5;
$y = 6;

$x = $x + $y;
$y = $x - $y;
$x = $x - $y;

echo 'Value of X: '.$x;
echo 'Value of Y: '.$y;

method 4: Using Division and multiplication

$x = 7;
$y = 8;

$x = $x * $y;
$y = $x / $y;
$x = $x / $y;

echo 'Value of X: '.$x;
echo 'Value of Y: '.$y;

method 5: using XOR method

$x = 9;
$y = 10;

$x = $x ^ $y;
$y = $x ^ $y;
$x = $x ^ $y;

echo 'Value of X: '.$x;
echo 'Value of Y: '.$y;

Disadvantage of this method is difficult to understand the process.

Web Developer's Blog

Pages

Saturday, February 28, 2015

user registration and authentication example

Insert, Update, Delete CRUD example

swaping two numeric value