Developer Forums | About Us | Site Map
Search  
HOME > TUTORIALS > SERVER SIDE CODING > PHP TUTORIALS > DEVELOPING A LOGIN SYSTEM WITH PHP AND MYSQL


Sponsors





Useful Lists

Web Host
site hosted by netplex

Online Manuals

Developing A Login System With PHP And MySQL
By John L - 2007-09-11 Page:  1 2 3

Registration

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

1. A preferred login id field
2. A preferred password field
3. A valid email address field
4. A Submit button
5. 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" />

<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.



View Developing A Login System With PHP And MySQL Discussion

Page:  1 2 3 Next Page: Verification and Authentication


Copyright 2004-2017 GrindingGears.com. All rights reserved.
Article copyright and all rights retained by the author.