To create a registration page and login page
 

I want to know how to create a registration page and login page ... any tutorials about this and i need some complete web templates too(not just home page)... can any one help me.....any ref plz

Re: To create a registration page and login page
 

You need a server-side script.

Re: To create a registration page and login page
 

Simple PHP login:

Create a database (mysqladmin)

Name the table "dbUsers." It will need 4 fields:

Name Type Addition
id int(10) Primary Key, AUTO_INCREMENT
username varchar(16) Unique
password char(16)
email varchar(25)


Create a new file and name it dbConfig.php This will file will connect to the database

<?

// Replace the variable values below

// with your specific database information.

$host = "localhost";

$user = "UserName";

$pass = "Password";

$db   = "dbName";



// This part sets up the connection to the 

// database (so you don't need to reopen the connection

// again on the same page).

$ms = mysql_pconnect($host, $user, $pass);

if ( !$ms )

{

echo "Error connecting to database.\n";

}



// Then you need to make sure the database you want

// is selected.

mysql_select_db($db);

?>

Registration name this file "register.php"

<?php



// dbConfig.php is a file that contains your

// database connection information. This

// tutorial assumes a connection is made from

// this existing file.

include ("dbConfig.php");





//Input vaildation and the dbase code

if ( $_GET["op"] == "reg" )

 {

 $bInputFlag = false;

 foreach ( $_POST as $field )

  {

  if ($field == "")

   {

   $bInputFlag = false;

   }

  else

   {

   $bInputFlag = true;

   }

  }

 // If we had problems with the input, exit with error

 if ($bInputFlag == false)

  {

  die( "Problem with your registration info. "

   ."Please go back and try again.");

  }



 // Fields are clear, add user to database

 //  Setup query

 $q = "INSERT INTO `dbUsers` (`username`,`password`,`email`) "

  ."VALUES ('".$_POST["username"]."', "

  ."PASSWORD('".$_POST["password"]."'), "

  ."'".$_POST["email"]."')";

 //  Run query

 $r = mysql_query($q);

 

 // Make sure query inserted user successfully

 if ( !mysql_insert_id() )

  {

  die("Error: User not added to database.");

  }

 else

  {

  // Redirect to thank you page.

  Header("Location: register.php?op=thanks");

  }

 } // end if





//The thank you page

elseif ( $_GET["op"] == "thanks" )

 {

 echo "<h2>Thanks for registering!</h2>";

 }

 

//The web form for input ability

else

 {

 echo "<form action=\"?op=reg\" method=\"POST\">\n";

 echo "Username: <input name=\"username\" MAXLENGTH=\"16\"><br />\n";

 echo "Password: <input type=\"password\" name=\"password\" MAXLENGTH=\"16\"><br />\n";

 echo "Email Address: <input name=\"email\" MAXLENGTH=\"25\"><br />\n";

 echo "<input type=\"submit\">\n";

 echo "</form>\n";

 }

// EOF

?>

Login name this file "login.php"

<?php

session_start();

// dBase file

include "dbConfig.php";



if ($_GET["op"] == "login")

 {

 if (!$_POST["username"] || !$_POST["password"])

  {

  die("You need to provide a username and password.");

  }

 

 // Create query

 $q = "SELECT * FROM `dbUsers` "

  ."WHERE `username`='".$_POST["username"]."' "

  ."AND `password`=PASSWORD('".$_POST["password"]."') "

  ."LIMIT 1";

 // Run query

 $r = mysql_query($q);



 if ( $obj = @mysql_fetch_object($r) )

  {

  // Login good, create session variables

  $_SESSION["valid_id"] = $obj->id;

  $_SESSION["valid_user"] = $_POST["username"];

  $_SESSION["valid_time"] = time();



  // Redirect to member page

  Header("Location: members.php");

  }

 else

  {

  // Login not successful

  die("Sorry, could not log you in. Wrong login information.");

  }

 }

else

 {

//If all went right the Web form appears and users can log in

 echo "<form action=\"?op=login\" method=\"POST\">";

 echo "Username: <input name=\"username\" size=\"15\"><br />";

 echo "Password: <input type=\"password\" name=\"password\" size=\"8\"><br />";

 echo "<input type=\"submit\" value=\"Login\">";

 echo "</form>";

 }

?>

Members Area name this file "members.php", and include on pages that are only for registered users

?php

session_start();



if (!$_SESSION["valid_user"])

{

// User not logged in, redirect to login page

Header("Location: login.php");

}



// Member only content

// ...

// ...

// ...



// Display Member information

echo "<p>User ID: " . $_SESSION["valid_id"];

echo "<p>Username: " . $_SESSION["valid_user"];

echo "<p>Logged in: " . date("m/d/Y", $_SESSION["valid_time"]);



// Display logout link

echo "<p><a href=\"logout.php\">Click here to logout!</a></p>";

?>

logout name this file "logout.php"

<?php

session_start();

session_unset();



session_destroy();

// Logged out, return home.

Header("Location: index.php");

?>

There you go... need more help or confused, just ask.

If this information solved your problem. Please add to my reputation.
Thanks
macneato

Re: To create a registration page and login page
 

Oh, to test your php, you'll need a server. I sugguest working on localhost. Lots of ways to do this. Easyphp is the simplest to setup. Place all files in the installation directory/publicHTML.

Re: To create a registration page and login page
 

THIS IS GREAT! Thank you! One thing... how can I get it so that people can request their password when and if they loose it?

Also.. it seems that I had to change the type for PASSWORD to TXT in order for it to work..

Re: To create a registration page and login page
 

With the password field. Change the type to varchar(25)

As for requesting passwords.

Yes. It can be done.
Ask the user to enter their email address.
select password from your_db where email_address = 'their_address'
Use the mail() function to send the password to the email address.

SQL:
SELECT
dbusers.password
FROM
dbusers
WHERE
(dbusers.email = 'pforgot')

'pforgot' is any name you've given to the form text input. Will write up a full script as soon as i get time. It's monday morning.. Things are a little hectic.

Re: To create a registration page and login page
 

I changed the type and still doesn't work.. when I try to login after creating new login, it says "Sorry, could not log you in. Wrong login information."

I will try the other.. Thank you!

Re: To create a registration page and login page
 

That would be great! I am still learning and developers like you help in this learning process.

Re: To create a registration page and login page
 

i had the same problem.
thanks
cashu
http://tech-unite.com/forum/viewtopic.php?f=5&t=10

Re: To create a registration page and login page
 

hey hi,dis is prakruti i too have same pro...i m creating a website for which i require registration page and login page.I have referred to the reply given in dis forum.But i guess dis code uses mysql as database but my database is DB2 frm IBM..plz can u suggest me how to design the registration and login webpage using DB2 as database.I would be very grateful if anyone helps me.
thanking u