This is an attempt to reply what was posted in the requested tutorials at Here

First of all, this tutorial is by no means COMPLETE, and will only include the parts needed to Login / Register a user successfully on a website using PHP and MySQL.

First of all, we need to open up a Database connection. I may note too, that this can be and i'm sure IS done in many differen't ways. However, this is how I do it.

db_info.php

<?php $dbhost = ""; # Generally localhost $dbuser = ""; # Your MySQL username $dbpass = ""; # Your MySQL password $dbid = ""; # The database you wish to use. mysql_connect($dbhost, $dbuser, $dbpass) or die("Could not connect to Server: " . mysql_error()); # Connect to the server or die! mysql_select_db($dbid); # Select database ?>

This is generally the VERY first thing included on an index.php, and we do this with the include statement.

include("include/db_info.php"); # Include the page's code :)

Next, we setup a basic table with PHPMyAdmin, or some other way. Or even SQL..

CREATE TABLE site_users `user_id` int(10) unsigned NOT NULL auto_increment, `user_name` varchar(32) NOT NULL default '', `user_pass` varchar(32) NOT NULL default '', `user_email` varchar(128) NOT NULL default '', PRIMARY KEY (`user_id`), KEY `user_name` (`user_name`) ) TYPE=MyISAM

Now, create that table in the database with a mysql_query.

mysql_query("string above");

Great! We now have a table (Provided it all worked). Now, lets make a register page :)

I will skip the HTML part of the registration, I expect you know how to use $_POST superglobals.

register_user.php

<?php include("include/db_info.php"); #include our info again. //Now we need some variables! $username = addslashes($_POST["username"]); $password = md5($_POST["password"])); # MD5 is an awesome checksummer! $password2 = md5($_POST["password2"])); # make sure it was correct twice. $email = $_POST["email"]; #NOTE: ADDSLASHES() FUNCTION # Very important, helps to prevent user's using MySQL injections into your mysql queries. #Note, there are several ways of doing this. But i'll show you just one. list($ename, $domain) = split("@", $email); if(checkdnsrr($domain, "MX")) { #This will check for a MX record for the domain. if($password == $password2) { #Do both passwords match? $ckInfoQ = mysql_query("SELECT user_name from site_users where user_name = '$username'"); # now we're grabbing any records with that username. if(@mysql_num_rows($chInfoQ) == 0) { # Is there any rows with that username? mysql_free_result($chInfoQ); # Free the result, your host will love you for this one :) $email = addslashes($email); mysql_query("INSERT INTO site_users (user_id, user_name, user_password, user_email) VALUES ('0', '$username', '$password', '$email')"); print "You've now been registered!<br />"; # Let the user know the good news } else { print "There is another user with that name!<br />"; # OOPS! } } else { print "Both passwords do not match!<br />"; # Another oops } } else { print "The email address is not valid!<br />"; # Oopsy!! } ?> 

Now, we've checked them out, registered them.. whats left? Oh, lets let them login!!

Again presuming you know how to make the HTML for the login form.

login_user.php

<?php include("include/db_info.php"); # Do i need to tell you by now? $username = addslashes($_POST["username"]); $password = md5($_POST["password"]); #Sweet, we have all the info, lets check if they exist! $myInfoQ = mysql_query("SELECT user_name from site_users WHERE user_name = '$username' AND user_pass = '$password'"); #okay, so we're selecting where the username is true AND the password is matched to that username :) if(@mysql_num_rows($myInfoQ) == 1) { # Does the row exist? $myInfo = mysql_fetch_array($myInfoQ); #Success!! The username and password information match. session_start(); $_SESSION["user_name"] = $myInfo["user_name"]; print "You have now logged in " . $_SESSION["user_name"] . "!<br />"; } else { print "Your username or password was incorrect!<br />"; } ?>

Of course, this is just the VERY BASIC type of user system, but this is a fully working example.

If you have any questions please leave a comment, or if you have any idea's on improving parts of the script, please also leave them in the comments :-) thanks.