Database Answers Header A very happy Community in Fiji !!!
Specifications for Portal Preferences
Home Ask a Question Data Models FAQs SQL Scripts Search Site Map  
Back to the Conceptual Data Model.


  • Step 1 : Register as a new User.
  • Code to display stored Tutorials in 'tutorials' table MySQL.
  • Personalization Options.
  • Example of Page to be generated from Database.

    'users' Table in mySQL :-
    mysql> describe users
        -> ;
    +-----------------+--------------+------+-----+---------+----------------+
    | Field           | Type         | Null | Key | Default | Extra          |
    +-----------------+--------------+------+-----+---------+----------------+
    | UserID          | int(11)      |      | PRI | NULL    | auto_increment |
    | UserName        | varchar(50)  | YES  |     | NULL    |                |
    | Password        | varchar(50)  | YES  |     | NULL    |                |
    | Email           | varchar(100) | YES  |     | NULL    |                |
    | Page_Careers    | varchar(25)  | YES  |     | NULL    |                |
    | Page_DataModels | varchar(25)  | YES  |     | NULL    |                |
    | Page_Search     | varchar(25)  | YES  |     | NULL    |                |
    | Page_SiteMap    | varchar(25)  | YES  |     | NULL    |                |
    | Photo           | int(11)      | YES  |     | 0       |                |
    +-----------------+--------------+------+-----+---------+----------------+
    9 rows in set (0.01 sec)    
    
    mysql> select username,password,email from users;
    +----------+----------+-----------------------------+
    | username | password | email                       |
    +----------+----------+-----------------------------+
    | barryw   | miami3   | barryw@gmisystems.com       |
    | bdimple  | miami3   | bdimple@databaseanswers.com |
    +----------+----------+-----------------------------+
    2 rows in set (0.00 sec)                                   
    
    ********************************************
    MySQL :-
    tutorials TABLE :-
    mysql> describe tutorials;
    +----------------------+--------------+------+-----+---------+-------+
    | Field                | Type         | Null | Key | Default | Extra |
    +----------------------+--------------+------+-----+---------+-------+
    | tutorial_code        | varchar(10)  |      | PRI |         |       |
    | tutorial_name        | varchar(50)  | YES  |     | NULL    |       |
    | tutorial_description | varchar(255) | YES  |     | NULL    |       |
    +----------------------+--------------+------+-----+---------+-------+
    3 rows in set (0.01 sec) 
    
    DATA IN THE tutorials TABLE :-
    mysql> select tutorial_code,tutorial_name from tutorials;
    +---------------+------------------+
    | tutorial_code | tutorial_name    |
    +---------------+------------------+
    | INSTAL_9I     | Instal Oracle 9i |
    +---------------+------------------+
    1 row in set (0.00 sec)
    
    mysql>                          
    
    
    
    
    
    

  • [ Home Page | Ask Us a Question | Email Us | FAQs | Search & Site Map ]

    © IceBreaker WebDesigns 2002