Before the stage, see the Mdjwq@yeah.net and the red dragonfly of the small version of the chat program, carefully read their code, feel this is a rare code, especially for the novice, the program used a number of techniques, very valuable reference. I according to their code, combined with their own experience, added some features (online personnel management, etc.), the implementation of the method from txt to MySQL (and PHP collocation of the best combination), all programs in the local debugging through, hope to have their own chat program can be directly used by netizens. When my personal homepage is complete, will be used in conjunction with the Forum (the Forum has been fully installed, other content will be completed from Chinaren to Oso migration), open up a Oracle (large site database platform) and MySQL (and PHP collocation of the best combination) Information discussion bar for the database administrator.
Forum Information table:
CREATE TABLE lt_t_online/* Record online personnel information */
(/* Name, last spoke time, IP address, status (0 online 1 offline) */
Lt_username varchar () NOT NULL,
Lt_lasttime datetime NOT NULL,
Lt_addrip varchar () NULL,
Lt_state char (1) NOT NULL
);
CREATE TABLE lt_t_content/* Chat Information table */
(/* Speaker, object, classification, expression, color, content, time */
Lt_speaker varchar () NOT NULL,
lt_speaked varchar () NOT NULL,
Lt_secrecy char (1) NOT NULL,
Lt_face smallint NULL,
Lt_color varchar (6) NULL,
Lt_content varchar (+) NOT NULL,
Lt_time datetime NOT NULL
);
.
The program consists of five parts:
http://www.bkjia.com/PHPjc/509053.html www.bkjia.com true http://www.bkjia.com/PHPjc/509053.html techarticle before the stage, see Mdjwq@yeah.net and the Red Dragonfly's mini-version of the chat program, carefully read their code, feel this is a rare code, especially for just getting started ...
