Belajar Tidak Identik dengan Buku

PHP Login Page Example

This post for PHP beginners Login Page Example. I want to explain creating database, posting form values, storing the session value and destroy the session. It’s is very useful and simple.

1. Database
MySQL admin table columns id, username, passcode.

CREATE TABLE admin
(
id INT PRIMARY KEY AUTO_INCREMENT,
username VARCHAR(30) UNIQUE,
passcode VARCHAR(30)
);


2. Config.php
Database configuration file.

<?php

$mysql_hostname = “localhost“;
$mysql_user = “user“;
$mysql_password = “password“;
$mysql_database = “db“;
$bd = mysql_connect($mysql_hostname, $mysql_user, $mysql_password)
or die(“Opps some thing went wrong“);
mysql_select_db($mysql_database, $bd) or die(“Opps some thing went wrong“);

?>

3. Login.php
Contains PHP and HTML code.

>?php

include(“config.php“);
session_start();
if($_SERVER[“REQUEST_METHOD“] == “POST“)
{

// username and password sent from Form 

$myusername=addslashes($_POST[‘username‘]);
$mypassword=addslashes($_POST[‘password‘]);

$sql=”SELECT id FROM admin WHERE username=’$myusername’ and passcode=’$mypassword’“;
$result=mysql_query($sql);
$row=mysql_fetch_array($result);
$active=$row[‘active’];
$count=mysql_num_rows($result);


// If result matched $myusername and $mypassword, table row must be 1 row

if($count==1)
{
session_register(“myusername”);
$_SESSION[‘login_user‘]=$myusername;

header(“location: welcome.php”);
}
else
{
$error=”Your Login Name or Password is invalid“;
}
}

?>
<form action=”” method=”post“>
<label>UserName :</label>
<input type=”text” name=”username“/><br />
<label>Password :</label>
<input type=”password” name=”password“/><br/>
<input type=”submit” value=” Submit “/><br />
</form>

4. lock.php
Session verification. If no session value page redirect to login.php

<?php

include(‘config.php‘);
session_start();
$user_check=$_SESSION[‘login_user‘];

$ses_sql=mysql_query(“select username from admin where username=’$user_check’“);

$row=mysql_fetch_array($ses_sql);

$login_session=$row[‘username‘];

if(!isset($login_session))
{
header(“Location: login.php“);
}

?>

5. welcome.php

<?php

include(‘lock.php‘);

?>
<body>

<h1>Welcome <?php echo $login_session; ?></h1>

</body>


6. logout.php
SignOut Destroy the session value.

<?php

session_start();
if(session_destroy())
{
header(“Location: login.php“);
}

?>

Related Posts

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Happy Paperless located at Banjarnegara , Jawa Tengah, Indonesia . Reviewed by 28 customers rated: 1 / 5



Rumus-Excel.Com
Kunjungi rumus-excel.com untuk belajar excel. Anda juga dapat menyumbangkan artikelnya ke kami untuk kita publish