Recommend this page to a friend!
  Classes of Moazam  >  PHP Online Users  >  README  >  Download  
Role: Configuration script
Content type: text/plain
Description: Setup Instructions
Class: PHP Online Users
Keep track of site visitors
Author: By
Last change:
Date: 12 years ago
Size: 809 bytes


Class file image Download
Create following two tables to your database

Create table `users` (
    `user_id` Int NOT NULL AUTO_INCREMENT,
    `user_name` Varchar(20) NOT NULL,
    `password` Varchar(34) NOT NULL,
    `name` Varchar(100) NOT NULL,
    Primary Key (`user_id`)
) ENGINE = InnoDB;

Create table `online` (
    `online_id` Int NOT NULL AUTO_INCREMENT,
    `user_id` Int NOT NULL,
    `user_name` Varchar(15),
    `log_time` Int,
 Primary Key (`online_id`),
 Index `online_user_id_INX` (`user_id`),
 Foreign Key (`user_id`) references `users` (`user_id`) on delete restrict on update restrict

Note: You should add your user/member table and correct the foreign key in online table. If you have different user id field name then replace all user_id occurence in online.class.php with your user id field name.

For more information send a message to info at phpclasses dot org.