Wednesday 10 July 2013

Facebook like and unlike system using [php-mysql-ajax] and facebook wall post system with time calculation system for each post and display it in users wall



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