Saturday, 8 September 2012

BUILDING A WEBSITE: 1 Creating a login form

Creating a login form

Creating a login form

  1. We can either create the form using the html input tags
    •    
      <form method="post" action="verification.php"> 
         Username <input type= "text" name= "username" size= " 15 " title= "Your username" />
         Password <input type= "password" name= "password" size= " 15 " title= "Your password"/>
         <input type= "submit" name= "login" value= "Login" title= "Click to login" />
      </form>
      
      
      This will generate a form looking like this :
      Username : Password :

  2. Or we can do so using tables


    • 
      <table border= " 0 ">
         <form method="POST" action="verification.php">
           <tr><td>Username<input type= "text" name= "username" size= " 15 " title= "Your username" /></td></tr>
           <tr><td>Password<input type= "password" name= "password" size= " 15 " title= "Your password"></td></tr>
           <tr><td> </td><td> </td><td><input type= "submit" name= "login" value= "Login" title= "Click to login" /></td></tr>
         </form>
      </table>
       
      

      This will generate a form looking like this :


      Username:
      Password:
        

BUILDING A WEBSITE: 3 Creating Registration form

Creating a registration form

Creating a registration form

      The sample code below :
      <form method="GET" action="registration.php"> <table> <tr><td>Username:</td> <td> <input type= "text" name= "username" size= " 15 " title= "Your username" /> </td></tr> <tr><td>Password:</td> <td> <input type= "password" name= "password" size= " 15 " title= "Your password"> </td></tr> <tr><td>Confirm Password:</td> <td> <input type= "password" name= "password" size= " 15 " title= "Confirm Your password"> </td></tr> <tr> <td colspan='2'> <input type= "submit" name= "login" value= "Login" title= "Click to login" /></td> </tr> </table> </form>
      Generates a form like this :

    Username:
    Password:
    Confirm Password:

Friday, 7 September 2012

BUILDING A WEBSITE: 2 Creating the database and the table users

The database called 'webpage' is created with a table 'users'

     
     CREATE DATABASE webpage;
     USE webpage;
    
     CREATE TABLE USERS
      (
      USER_NAME VARCHAR(128) NOT NULL  ,
      USER_ID INTEGER NOT NULL AUTO_INCREMENT ,
      ENCRYPTED_PASSWORD VARCHAR(128) NOT NULL  ,
      SALT VARCHAR(128) NOT NULL , 
         PRIMARY KEY (USER_ID) 
      ) ;
     

Wednesday, 5 September 2012

BUILDING A WEB SITE

Registering users into a database via a login form and authenticating them at login using php,sql and html.

  1. A database is created with a table for users
  2. A login form is then created
  3. Next a registration form is then created
  4. Then users are authenticated