Developing a Login System with PHP and MySQL

| Main | Template Blog | Webmaster Resources | Video Tutorials |

Template Offers
7,500 + Templates
osCommerce Templates
Template Membership
100's of Templates
Dreamweaver Templates
Free Web Templates
CategoryeCommerce Templates(2)
CategoryFree Business Templates(4)
CategoryFree Portal Templates(1)
Main Menu
Free Templates Home
Blog Templates
Dreamweaver Templates
Flash Templates
Logo Templates
Mambo Templates
Swish Templates
Buy Web Templates
View All Templates
Video Tutorials
Webmaster Articles
Write for Us
Advertise
Download Our Toolbar
Contact Us
Search
Link to Us
Webmaster Resources
Webmaster Feeds

Free Templates Home arrow Webmaster Articles arrow Programming arrow Developing a Login System with PHP and MySQL

Template Blog


Developing a Login System with PHP and MySQL Print E-mail
Written by daBoss   
Article Index
Developing a Login System with PHP and MySQL
Page 2
Page 3

Most interactive websites nowadays would require a user to log in into the website’s system in order to provide a customized experience for the user. Once the user has logged in, the website will be able to provide a presentation that is tailored to the user’s preferences.

A basic login system typically contains 3 components:

  • The component that allows a user to register his preferred login id and password
  • The component that allows the system to verify and authenticate the user when he subsequently logs in
  • The component that sends the user’s password to his registered email address if the user forgets his password

Such a system can be easily created using PHP and MySQL.

Component 1 – Registration

Component 1 is typically implemented using a simple HTML form that contains 3 fields and 2 buttons:

  • A preferred login id field
  • A preferred password field
  • A valid email address field
  • A Submit button
  • A Reset button

Assume that such a form is coded into a file named register.html. The following HTML code excerpt is a typical example. When the user has filled in all the fields, the register.php page is called when the user clicks on the Submit button.

[form name="register" method="post" action="register.php"]
[input name="login id" type="text" value="loginid" size="20"/][br]
[input name="password" type="text" value="password" size="20"/][br]
[input name="email" type="text" value="email" size="50"/][br]
[input type="submit" name="submit" value="submit"/]
[input type="reset" name="reset" value="reset"/]
[/form]

The following code excerpt can be used as part of register.php to process the registration. It connects to the MySQL database and inserts a line of data into the table used to store the registration information.

@mysql_connect("localhost", "mysql_login", "mysql_pwd") or die("Cannot connect to DB!");
@mysql_select_db("tbl_login") or die("Cannot select DB!");
$sql="INSERT INTO login_tbl (loginid, password and email) VALUES (".$loginid.”,”.$password.”,”.$email.”)”;
$r = mysql_query($sql);
if(!$r) {
$err=mysql_error();
print $err;
exit();
}

The code excerpt assumes that the MySQL table that is used to store the registration data is named tbl_login and contains 3 fields – the loginid, password and email fields. The values of the $loginid, $password and $email variables are passed in from the form in register.html using the post method.



 

Related Items


Advertisement

Webmaster Tip
Use a linked CSS (cascading style sheet) for formating to make site wide changes easy.
 
Advertise on Template Hunter
Login Form





Lost Password?
Who's Online
We have 1 guest online

Template Tuning
© 2002-2012 Template Hunter