We have to make Facebook wall system,Face book like system and Facebook time management system for each and every post
-In my previous post Facebook wall system will be implemented
-In this Post contains facebook like system and facebook time management system along with wall post system will be implemented
-in this section i have created separate login system for every users
-users can login and post their words in their wall
-others users will like or unlike the post using their user-id
-face book time management means, users posts display the time when they posted and how many hours,minutes or seconds ago they posted their words or quotes and all
- this are the task we have to done
-there are several steps to complete our task
-Create database and following tables
-there are 3 Table contains in database
1.Login
2.Messages
3.message_like
1.Login table :
CREATE TABLE IF NOT EXISTS `login` (
`uid` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(250) NOT NULL,
`password` varchar(250) NOT NULL,
PRIMARY KEY (`uid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=13 ;
2.Message table:
CREATE TABLE IF NOT EXISTS `messages` (
`msg_id` int(11) NOT NULL AUTO_INCREMENT,
`message` varchar(200) NOT NULL,
`uid_fk` int(11) NOT NULL,
`like_count` int(11) DEFAULT NULL,
`created` varchar(250) DEFAULT NULL,
PRIMARY KEY (`msg_id`),
KEY `uid_fk` (`uid_fk`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=17 ;
3.message_like table :
CREATE TABLE IF NOT EXISTS `message_like` (
`like_id` int(11) NOT NULL AUTO_INCREMENT,
`msg_id_fk` int(11) DEFAULT NULL,
`uid_fk` int(11) NOT NULL,
`created` varchar(250) NOT NULL,
PRIMARY KEY (`like_id`),
KEY `uid_fk` (`uid_fk`),
KEY `msg_id_fk` (`msg_id_fk`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=59 ;
-Download the file and configure your hostname,username and password
-Live demo is available,check it
- if any queries regarding, post your commands
Screen Shots:
No comments:
Post a Comment