Login System

PHP Code

+ 0 likes

Please Register to submit score.

Average Score	5.0
Scores Submitted	1
Date Added	Dec 30, 2006
Last Updated	Dec 30, 2006
Tags	login mysql register system

Introduction

�Description�

This is a login System, it has 3 files
login.php
register.php
lastmember.php

once a user has been logged in it will return him/her to the home page. to see if they are logged in use the code at the bottom of my script

When a user registers, it will update the lastmember.php page, so you can include it in your home page by using <? include('lastmember.php'); ?> and it shows the last member that signed up. you can add/change the stuff in the last member.php page but i suggest not changing anything, because i hate people saying they changed so and so and it doesn't work. so just leave it alone :P

Enjoy

Grab the Code

�Login.php Start�

<?php
//session_start();
// set your infomation.
$dbhost='localhost';
$dbusername='root';
$dbuserpass='root';
$dbname='root';

if (isset($_COOKIE['user'])) {
echo "Welcome $_COOKIE[user]";
}else{

//connect to the mysql database server.
mysql_connect ($dbhost, $dbusername, $dbuserpass);
mysql_select_db($dbname) or die('Cannot select database');

if ($_POST['username']) {
//did they supply a password and username
$username=$_POST['username'];
$password=$_POST['password'];
if ($password==NULL) {
echo "A password was not supplied";
}else{
$query = mysql_query("SELECT username,password FROM users WHERE username = '$username'") or die(mysql_error());
$data = mysql_fetch_array($query);
if($data['password'] != $password) {
echo "The supplied login is incorrect";
}else{
$query = mysql_query("SELECT username,password FROM users WHERE username = '$username'") or die(mysql_error());
$row = mysql_fetch_array($query);
setcookie("user", "$username", time()+3600);
echo "<META HTTP-EQUIV=\"Refresh\" CONTENT=\"1; URL=membersarea.php\">";
}
}
}
?>
<form action='login.php' method='POST'>
<table style='border:1px solid #000000;'>
<tr>
<td align='right'>
Username: <input type='text' size='15' maxlength='25' name='username'>
</td>
</tr>
<tr>
<td align='right'>
Password: <input type='password' size='15' maxlength='25' name='password'>
</td>
</tr>
<tr>
<td align='center'>
<input type="submit" value="Login">
</td>
</tr>
<tr>
<td align='center'>
<a href='register.php'>Register Here</a>
</td>
</tr>
</table>
</form>
<?
};
?>

�End Of Login.php�

�Register.php start.�

<center>
<?php
// set your infomation.
$dbhost='localhost';
$dbusername='root';
$dbuserpass='root';
$dbname='root';
// connect to the mysql database server.
mysql_connect ($dbhost, $dbusername, $dbuserpass);
mysql_select_db($dbname) or die("Cannot select database");

//Are they just getting here or submitting their info?
if (isset($_POST["username"])) {
$username = $_POST["username"];
$password = $_POST["password"];
$cpassword = $_POST["cpassword"];
$email = $_POST["email"];
//Was a field left blank?
if($username==NULL|$password==NULL|$cpassword==NULL|$email==NULL) {
echo "A field was left blank.";
}else{
//Do the passwords match?
if($password!=$cpassword) {
echo "Passwords do not match";
}else{
//Has the username or email been used?
$checkuser = mysql_query("SELECT username FROM users WHERE username='$username'");
$username_exist = mysql_num_rows($checkuser);

$checkemail = mysql_query("SELECT email FROM users WHERE email='$email'");
$email_exist = mysql_num_rows($checkemail);

if ($email_exist&#620;|$username_exist&#620;) {
echo "The username or email is already in use";
}else{
//Everything seems good, lets insert.
$query = "INSERT INTO users (username, password, email) VALUES('$username','$password','$email')";
mysql_query($query) or die(mysql_error());
echo "The user $username has been successfully registered.";
}
}
}
}
?>
<h1>Register</h1>
<form action="register.php" method="POST">
<table style="border:1px solid #000000;">
<tr>
<td align="right">
Username: <input type="text" size="15" maxlength="25" name="username">
</td>
</tr>
<tr>
<td align="right">
Password: <input type="password" size="15" maxlength="25" name="password">
</td>
</tr>
<tr>
<td align="right">
Confirm Password: <input type="password" size="15" maxlength="25" name="cpassword">
</td>
</tr>
<tr>
<td align="right">
Email: <input type="text" size="15" maxlength="25" name="email">
</td>
</tr>
<tr>
<td align="center">
<input type="submit" value="Register">
</td>
</tr>
<tr>
<td align="center">
<a href="login.php">Login Here</a>
</td>
</tr>
</table>
</form>
</center>

�End Of Register.php�

�Lastmember.php start�
// set your infomation.
$dbhost='localhost';
$dbusername='root';
$dbuserpass='root';
$dbname='root';

//connect to the mysql database server.
mysql_connect ($dbhost, $dbusername, $dbuserpass);
mysql_select_db($dbname) or die('Cannot select database');

$row1 = mysql_query("SELECT * FROM users ORDER BY uid DESC LIMIT 1") or die(mysql_error());
echo "$row1";
while($row=mysql_fetch_array($row1))
{
echo "<h2>$row[username]</h2>";
}
?>
�End of lastmember.php�

To check to see if someone is logged in use.

<?
if (isset($_COOKIE['user'])) {
echo "You are logged in: $_COOKIE['user'] Enjoy.";
} else{ 
echo "You are not logged in. <a href='register.php'>Register here</a>";
?>

Comments

(20) RSS

Go to Bottom

F*U*R*B*Y*

Comments: 585

PHP Snippet: Login System
Posted on Dec 30, 2006 10:41 pm

wo0t go my complex login system :P

Hawkee

Comments: 566

PHP Snippet: Login System
Posted on Dec 31, 2006 1:58 am

You should include the SQL create statement for your table. Check my review system snippet to see what I mean. Also, why not put the dbhost, dbusername, etc. connection parameters in one place. You can do this entire thing in a single document with a switch statement or some if-statements.

F*U*R*B*Y*

Comments: 585

PHP Snippet: Login System
Posted on Dec 31, 2006 3:26 am

i thought i uploaded it :P i'll find it and update this script

Noutrious

Comments: 355

PHP Snippet: Login System
Posted on Dec 31, 2006 5:45 am

It would be perfect, if it included PM system, Personal info setter etc.

F*U*R*B*Y*

Comments: 585

PHP Snippet: Login System
Posted on Dec 31, 2006 6:16 am

yeah i'm writing a PM system now :P

Noutrious

Comments: 355

PHP Snippet: Login System
Posted on Dec 31, 2006 7:20 am

Nice :)

sean

Comments: 108

PHP Snippet: Login System
Posted on Dec 31, 2006 9:41 pm

Hawkee, when are you making a system to allow multiple *.php file uploads? not being pushy, just curious.

Hawkee

Comments: 566

PHP Snippet: Login System
Posted on Dec 31, 2006 11:09 pm

sean, that idea has been on the backburner for some time. Still need to flesh it out and find the time to work on it.

F*U*R*B*Y*

Comments: 585

PHP Snippet: Login System
Posted on Jan 17, 2007 6:12 pm

PM System is completed, if Hawkee does do the multiple *.php file uploads i'll upload it with my login system... if you want it before hand i'll post it as a snippet

cooolstar

Comments: 12

PHP Snippet: Login System
Posted on Jan 25, 2007 4:07 pm

salamz,
Furby gave users a very good script.
but it was good if he would paste here without any <table tags>.

but it is good, any one having any problems with other login systems can get idea of logins by his snippet very quickly.

nice one :)

Bandit

Comments: 7

PHP Snippet: Login System
Posted on Feb 17, 2007 6:22 pm

Nice code, I'd just like to point out one thing though. Your code is vulnerable to SQL injection, and these kind of attacks are becoming more and more popular. Try using the mysql_real_escape_string function. It helps protect against such attacks.

--Bandit

F*U*R*B*Y*

Comments: 585

PHP Snippet: Login System
Posted on Feb 18, 2007 5:48 am

Can you please explain more, i really don't get in to the SQL Injections, i stay clear of that, so can you explain it and tell me what i have to change, so i can add it :)

Hawkee

Comments: 566

PHP Snippet: Login System
Posted on Feb 19, 2007 1:26 pm

Here is a perfect example:

http://en.wikipedia.org/wiki/SQL_injection

log2

Comments: 52

PHP Snippet: Login System
Posted on Feb 9, 2008 5:28 pm

You shouldn't recall your database at the top of the page, it should be hidden, and in an htaccess directory so people can't see your information (There are ways of downloading PHP files)

AdrianF

Comments: 37

PHP Snippet: Login System
Posted on Jun 6, 2008 8:40 am

How I Upload THis? And Configure and shoot?

F*U*R*B*Y*

Comments: 585

PHP Snippet: Login System
Posted on Jun 6, 2008 9:02 am

You place the files in seperate files, then save them as what i said to. and then upload to your webhost

AdrianF

Comments: 37

PHP Snippet: Login System
Posted on Jun 6, 2008 10:38 am

how?

AdrianF

Comments: 37

PHP Snippet: Login System
Posted on Jun 6, 2008 10:38 am

fark i'm can be not smart at some shoot

jonesy44

Comments: 1,085

PHP Snippet: Login System
Posted on Jun 6, 2008 2:16 pm

make new files on your host;

login.php
register.php

and copy the relevent parts of the files into the files.

This then uses cookies/sessions, (i haven't read it fully) to tell whether a user is logged in/not

Nalemin

Comments: 2

PHP Snippet: Login System
Posted on Aug 24, 2008 2:37 pm

Umm, so what's the query I would use to make the table for it? :(

Also, I'm getting this error:

Parse error: parse error, unexpected T_ECHO in /home/www/aurora-online.org/register.php on line 34

Login System

Introduction

Grab the Code

Comments

FUR*BY

My Snippet Tags

Contact

Friends (29)

Sponsors

		Student Adelaide
Last seen: Oct 12, 2008 Profile \| Website Likes (28) Friends (29) Snippets (47) Images (30) Comments Received (600) Comments Submitted (585) Forum Posts (681)