[PHP] Simple login system by DevNet

Download: http://www.2shared.com/file/3404198/...b7/login.html?

:poster_ss
index.php

Quote:

---

<?
session_start();
if(!isset($_SESSION['SESS_MEMBER']) || (trim($_SESSION['SESS_MEMBER'])=='')) {
?>
<form action="logincheck.php" method="post">
Username: <input type="text" name="username">
<br>
Password: <input type="password" name="password">
<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<input type="submit" value="Submit">
</form>
<?
}else{
?>
Welcome <?echo $_SESSION['SESS_MEMBER'];?>
<br>
<a href="index.php?page=logout">Logout</a>
<br>
<?
}
?>
<?
$page = $_GET['page'];
if ($page == logout){
?>
<?unset($_SESSION['SESS_MEMBER']);?>
Successful Logout!
<meta http-equiv="REFRESH" content="0;url=index.php">
<?
}
?>

---

logincheck.php

Quote:

---

<?php
session_start();
$username = $_POST['username'];
$password = $_POST['password'];
$sql_host = "localhost";
$sql_user = "USERNAME";
$sql_pass = "PASSWORD";
$sql_db = "DB";
$table = "TABLE";

mysql_connect ("$sql_$host", "$sql_user", "$sql_pass") or die (mysql_error());
mysql_select_db ("$sql_db") or die (mysql_error());

$query = "SELECT username FROM $table WHERE username = '$username' AND password = '$password'";
$result = mysql_query($query);
if ($result){
if(mysql_num_rows($result)>0) {
session_regenerate_id();
$member=mysql_fetch_assoc($result);
$_SESSION['SESS_MEMBER']=$member['username'];
session_write_close();
header("location: index.php");
exit();
}else{
header ("location: loginfailed.php");
exit();
}
}
?>

---

loginfailed.php

Quote:

---

Wrong username or password.

---

db.sql

Quote:

---

-- phpMyAdmin SQL Dump
-- version 2.11.4
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: May 25, 2008 at 06:26 AM
-- Server version: 5.0.51
-- PHP Version: 5.2.5

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- Database: `login`
--

-- --------------------------------------------------------

--
-- Table structure for table `login`
--

CREATE TABLE IF NOT EXISTS `login` (
`id` int(4) NOT NULL auto_increment,
`username` varchar(65) NOT NULL,
`password` varchar(65) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `login`
--

INSERT INTO `login` (`id`, `username`, `password`) VALUES
(1, 'demo', 'demo');

---

readme.txt

Quote:

---

Login system oleh DevNet!
Edit file logincheck.php and edit like this

$sql_host = "localhost"; // sql host
$sql_user = "USERNAME"; // sql username
$sql_pass = "PASSWORD"; // sql password
$sql_db = "DB"; // sql database
$table = "TABLE"; // sql table

Import db.sql at phpmyadmin and use demo for username and password.

---

Post this in the Showcase!

Quote:

---

Originally Posted by EliteGM

Post this in the Showcase!

---

I second that, moved.

Nice work on releasing this.

oh..thx for move this topic :P

I hope you don't mind: I've changed some stuff, added some stuff, fixed the 'looks' =p
Added config.php for connecting and some vars settled.

http://www.techzine.nl/uploaded/41734_a551072a.gifD/L Me!

thx for edit it :juggle: i no have time to make special script :poster_ss

Didnt do much, just some CSS for the boxes, and just cleaned up =p