Jul
3

Reloaded: Facebook Style Wall Posting and Comments System using jQuery PHP and Ajax.

Author ZeeShaN    Category AJAX, Facebook, JQuery, PHP, Web Development     Tags , , ,

Facebook style wall posting and commenting system. Try a new reloaded version of demo which is almost similar to facebook style.
My previous facebook style posting system was not so much like original facebook posting style and also there is no commenting system So I created this tutorial again to complete the commenting system and I tried my best to give my dear users a complete posting script with comments system. Facebook is now a days top social networking site. So I have created some tutorials similar to facebook. Youtube style rating is also very popular tutorial on this blog. Hope you like it.

Waiting for your feed back to make it more good.

Database Structure

CREATE TABLE `facebook_posts` (
  `p_id` int(11) NOT NULL auto_increment,
  `f_name` varchar(50) NOT NULL,
  `post` varchar(255) NOT NULL,
  `f_image` varchar(50) NOT NULL,
  `date_created` int(11) NOT NULL,
  `userip` varchar(200) NOT NULL,
  PRIMARY KEY  (`p_id`)
)
CREATE TABLE `facebook_posts_comments` (
  `c_id` int(11) NOT NULL auto_increment,
  `userip` varchar(200) NOT NULL,
  `comments` text NOT NULL,
  `date_created` int(11) NOT NULL,
  `post_id` int(11) NOT NULL,
   PRIMARY KEY  (`c_id`)
)

I have used ip check to make user restricted to there posts or comments. They can only there postings.
Two new function missed in source files. One for making links clickable and other for removing tags etc.

function clickable_link($text = '')
{
	$text = preg_replace('#(script|about|applet|activex|chrome):#is', "\\1:", $text);
	$ret = ' ' . $text;
	$ret = preg_replace("#(^|[\n ])([\w]+?://[\w\#$%&amp;~/.\-;:=,?@\[\]+]*)#is", "\\1<a href="\" target="\&quot;_blank\&quot;">\\2</a>", $ret);
 
	$ret = preg_replace("#(^|[\n ])((www|ftp)\.[\w\#$%&amp;~/.\-;:=,?@\[\]+]*)#is", "\\1<a href="\" target="\&quot;_blank\&quot;">\\2</a>", $ret);
	$ret = preg_replace("#(^|[\n ])([a-z0-9&amp;\-_.]+?)@([\w\-]+\.([\w\-\.]+\.)*[\w]+)#i", "\\1<a href="\">\\2@\\3</a>", $ret);
	$ret = substr($ret, 1);
	return $ret;
}
 
function checkValues($value = '')
{
	$value = trim($value);
	if (get_magic_quotes_gpc())
	{
		$value = stripslashes($value);
	}
 
	$value = strtr($value,array_flip(get_html_translation_table(HTML_ENTITIES)));
	$value = strip_tags($value);
	$value = mysql_real_escape_string($value);
	$value = htmlspecialchars($value);
 
	return $value;
}

Here is the comment box focus code below. When we click on a comment box text area.

//onfocus
$('.commentMark').livequery("focus", function(e){
 
	var parent  = $(this).parent();
	$(".commentBox").children(".commentMark").css('width','337px');
	$(".commentBox").children("a#SubmitComment").hide();
	$(".commentBox").children(".CommentImg").hide();			
 
	var getID =  parent.attr('id').replace('record-','');
	$("#commentBox-"+getID).children("a#SubmitComment").show();
	$('.commentMark').css('width','300px');
	$("#commentBox-"+getID).children(".CommentImg").show();
});

Submit comment code.

// I used livejquery plugin to work my code effective for dynamic elements.
$('a.comment').livequery("click", function(e){
 
	var getpID =  $(this).parent().attr('id').replace('commentBox-','');
	var comment_text = $("#commentMark-"+getpID).val();
 
	if(comment_text != "Write a comment...")
	{
		$.post("add_comment.php?comment_text="+comment_text+"&amp;post_id="+getpID, {
 
		}, function(response){
 
			$('#CommentPosted'+getpID).append($(response).fadeIn('slow'));
 
 
 
			$("#commentMark-"+getpID).val();
		});
	}
 
});

Get more records code

// I used livejquery plugin to work my code effective for dynamic elements.
$(‘a.more_records’).livequery(“click”, function(e){
 
var next = $(this).attr(‘id’).replace(‘more_’,”);
 
$.post(“posts.php?show_more_post=”+next, {
 
}, function(response){
$(‘#bottomMoreButton’).remove();
$(‘#posting’).append($(response).fadeIn(’slow’));

});
 
});

Delete comment code:

//deleteComment
$('a.c_delete').livequery("click", function(e){
 
	if(confirm('Are you sure you want to delete this comment?')==false)
	return false;
	e.preventDefault();
	var parent  = $(this).parent();
	var c_id =  $(this).attr('id').replace('CID-','');
	$.ajax({
		type: 'get',
		url: 'delete_comment.php?c_id='+ c_id,
		data: '',
		beforeSend: function(){
		},
		success: function(){
			parent.fadeOut(200,function(){
				parent.remove();
			});
		}
	});
});


add_comments.php File:

<div id="record-<?php  echo $rows['c_id'];?>" class="commentPanel">
		<img class="CommentImg" style="float: left;" src="small.png" alt="" width="40" />
		<label class="postedComments">
 
		</label>
 
		<span style="margin-left: 43px; color: #666666; font-size: 11px;">
		 0)
		echo date('F d Y', $rows['date_created']);
		elseif($days2 == 0 && $hours == 0 && $minutes == 0)
		echo "few seconds ago";
		elseif($days2 == 0 && $hours == 0)
		echo $minutes.' minutes ago';
		else
		echo "few seconds ago";	
 
		?>
		</span>
 
		  <a id="CID-<?php  echo $rows['c_id'];?>" class="c_delete" href="#">Delete</a></div>

post.php File:

<?php
include('dbcon.php');
 
function checkValues($value)
{
	 // Use this function on all those values where you want to check for both sql injection and cross site scripting
	 //Trim the value
	 $value = trim($value);
 
	// Stripslashes
	if (get_magic_quotes_gpc()) {
		$value = stripslashes($value);
	}
 
	 // Convert all &lt;, &gt; etc. to normal html and then strip these
	 $value = strtr($value,array_flip(get_html_translation_table(HTML_ENTITIES)));
 
	 // Strip HTML Tags
	 $value = strip_tags($value);
 
	// Quote the value
	$value = mysql_real_escape_string($value);
	$value = htmlspecialchars ($value);
	return $value;
 
}	
 
function clickable_link($text = '')
{
	$text = preg_replace('#(script|about|applet|activex|chrome):#is', "\\1:", $text);
	$ret = ' ' . $text;
	$ret = preg_replace("#(^|[\n ])([\w]+?://[\w\#$%&~/.\-;:=,?@\[\]+]*)#is", "\\1<a href=\"\\2\" target=\"_blank\">\\2</a>", $ret);
 
	$ret = preg_replace("#(^|[\n ])((www|ftp)\.[\w\#$%&~/.\-;:=,?@\[\]+]*)#is", "\\1<a href=\"http://\\2\" target=\"_blank\">\\2</a>", $ret);
	$ret = preg_replace("#(^|[\n ])([a-z0-9&\-_.]+?)@([\w\-]+\.([\w\-\.]+\.)*[\w]+)#i", "\\1<a href=\"mailto:\\2@\\3\">\\2@\\3</a>", $ret);
	$ret = substr($ret, 1);
	return $ret;
}
 
$next_records = 10;
$show_more_button = 0;
if(checkValues($_REQUEST['value']))
{
	$userip = $_SERVER['REMOTE_ADDR'];
	echo "INSERT INTO facebook_posts (post,f_name,userip,date_created) VALUES('".checkValues($_REQUEST['value'])."','99Points','".$userip."','".strtotime(date("Y-m-d H:i:s"))."')";
 
	mysql_query("INSERT INTO facebook_posts (post,f_name,userip,date_created) VALUES('".checkValues($_REQUEST['value'])."','99Points','".$userip."','".strtotime(date("Y-m-d H:i:s"))."')");
 
	$result = mysql_query("SELECT *,
	UNIX_TIMESTAMP() - date_created AS TimeSpent FROM facebook_posts order by p_id desc limit 1");
 
}
elseif($_REQUEST['show_more_post']) // more posting paging
{
	$next_records = $_REQUEST['show_more_post'] + 10;
 
	$result = mysql_query("SELECT *,
	UNIX_TIMESTAMP() - date_created AS TimeSpent FROM facebook_posts order by p_id desc limit ".$_REQUEST['show_more_post'].", 10");
 
	$check_res = mysql_query("SELECT * FROM facebook_posts order by p_id desc limit ".$next_records.", 10");
 
	$show_more_button = 0; // button in the end
 
	$check_result = mysql_num_rows(@$check_res);
	if($check_result > 0)
	{
		$show_more_button = 1;
	}
}
else
{	
	$show_more_button = 1;
	$result = mysql_query("SELECT *,
	UNIX_TIMESTAMP() - date_created AS TimeSpent FROM facebook_posts order by p_id desc limit 0,10");
 
}
 
while ($row = mysql_fetch_array($result))
{
	$comments = mysql_query("SELECT *,
	UNIX_TIMESTAMP() - date_created AS CommentTimeSpent FROM facebook_posts_comments where post_id = ".$row['p_id']." order by c_id asc");		?>
   <div class="friends_area" id="record-<?php  echo $row['p_id']?>">
 
   <img src="99.jpeg" style="float:left;" alt="" />
 
	   <label style="float:left" class="name">
 
	   <b><?php echo $row['f_name'];?></b>
 
	   <em><?php  echo clickable_link($row['post']);?></em>
	   <br clear="all" />
 
	   <span>
	   <?php  
 
		// echo strtotime($row['date_created'],"Y-m-d H:i:s");
 
		$days = floor($row['TimeSpent'] / (60 * 60 * 24));
		$remainder = $row['TimeSpent'] % (60 * 60 * 24);
		$hours = floor($remainder / (60 * 60));
		$remainder = $remainder % (60 * 60);
		$minutes = floor($remainder / 60);
		$seconds = $remainder % 60;
 
		if($days > 0)
		echo date('F d Y', $row['date_created']);
		elseif($days == 0 && $hours == 0 && $minutes == 0)
		echo "few seconds ago";		
		elseif($days == 0 && $hours == 0)
		echo $minutes.' minutes ago';
		else
		echo "few seconds ago";	
 
	   ?>
 
	   </span>
	   <a href="javascript: void(0)" id="post_id<?php  echo $row['p_id']?>" class="showCommentBox">Comments</a>
 
	   </label>
	   <?php
		$userip = $_SERVER['REMOTE_ADDR'];
		if($row['userip'] == $userip){?>
		<a href="#" class="delete"> Remove</a>
	   <?php
		}?>
		<br clear="all" />
		<div id="CommentPosted<?php  echo $row['p_id']?>">
			<?php
			$comment_num_row = mysql_num_rows(@$comments);
			if($comment_num_row > 0)
			{
				while ($rows = mysql_fetch_array($comments))
				{
					$days2 = floor($rows['CommentTimeSpent'] / (60 * 60 * 24));
					$remainder = $rows['CommentTimeSpent'] % (60 * 60 * 24);
					$hours = floor($remainder / (60 * 60));
					$remainder = $remainder % (60 * 60);
					$minutes = floor($remainder / 60);
					$seconds = $remainder % 60;						
					?>
				<div class="commentPanel" id="record-<?php  echo $rows['c_id'];?>" align="left">
					<img src="small.png" width="40" class="CommentImg" style="float:left;" alt="" />
					<label class="postedComments">
						<?php  echo clickable_link($rows['comments']);?>
					</label>
					<br clear="all" />
					<span style="margin-left:43px; color:#666666; font-size:11px">
					<?php
 
					if($days2 > 0)
					echo date('F d Y', $rows['date_created']);
					elseif($days2 == 0 && $hours == 0 && $minutes == 0)
					echo "few seconds ago";		
					elseif($days2 == 0 && $hours == 0)
					echo $minutes.' minutes ago';
					else
		echo "few seconds ago";	
					?>
					</span>
					<?php
					$userip = $_SERVER['REMOTE_ADDR'];
					if($rows['userip'] == $userip){?>
					&nbsp;&nbsp;<a href="#" id="CID-<?php  echo $rows['c_id'];?>" class="c_delete">Delete</a>
					<?php
					}?>
				</div>
				<?php
				}?>				
				<?php
			}?>
		</div>
		<div class="commentBox" align="right" id="commentBox-<?php  echo $row['p_id'];?>" <?php echo (($comment_num_row) ? '' :'style="display:none"')?>>
			<img src="small.png" width="40" class="CommentImg" style="float:left;" alt="" />
			<label id="record-<?php  echo $row['p_id'];?>">
				<textarea class="commentMark" id="commentMark-<?php  echo $row['p_id'];?>" name="commentMark" cols="60"></textarea>
			</label>
			<br clear="all" />
			<a id="SubmitComment" class="small button comment"> Comment</a>
		</div>
   </div>
<?php
}
if($show_more_button == 1){?>
<div id="bottomMoreButton">
<a id="more_<?php echo @$next_records?>" class="more_records" href="javascript: void(0)">Older Posts</a>
</div>
<?php
}?>

delete_comments.php File:

The above code is just to show you different functionless. However you can get complete working script by downloading source above.

Add To Facebook Stumble This Digg This Add To Del.icio.us Add To Reddit Add To Yahoo Add To Twitter


Written by ZeeShaN

ZeeShaN RasooL is a web developer who loves to work in latest technologies to create more interactive dynamic and beautiful web pages.

  • dhenys

    hi there, it’s nice post…
    but i have some question
    why i get error “Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/pointsin/public_html/demos/facebook_wallpost_system/add_comment.php on line 49″
    when i input some special characters like as #,&,+

    need help…

    May 07 2012
    CommentsLike
    • omar Albadre

      hi
      iam happy
      ilove you
      in allh

      May 06 2012
      CommentsLike
      • Voldemaras

        it has a bug if youu hit remove post or comments it does removes all comments and posts untill you refresh the website to fetch not removed again

        May 03 2012
        CommentsLike
        • ottou

          Notice: Undefined index: value
          Notice: Undefined index: show_more_post
          please help me!!

          May 02 2012
          CommentsLike
          • Balaji

            Hi all
            please give in comment box like this or or etc like HTML tag, it’s ll display
            Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/pointsin/public_html/demos/facebook_wallpost_system/add_comment.php on line 49

            April 19 2012
            CommentsLike
            • Gastón

              Replace the code in the file you downloaded post.php published here. and now throws the error:

              Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in D:\AppServ\www\www.fasgoo.com\Demo 1\facebook\posts.php on line 78

              the error occurs in the (while)

              April 09 2012
              CommentsLike
              • Gastón

                hello excuse my ignorance, I get this error and do not know how to fix it!

                Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in D:\AppServ\www\www.fasgoo.com\Demo 1\facebook\posts.php on line 71

                I will be able to help make it work?

                April 09 2012
                CommentsLike
                • Genuineapps

                  Thank you It works ..

                  April 07 2012
                  CommentsLike
                  • Fahad

                    Can you help me with a same project but done in asp.net ..I am really in need ..Thanks !

                    March 30 2012
                    CommentsLike
                    • Fahad

                      Can you help me with a similar script and project for asp.net ..i am really in need !!Thx! :)

                      March 30 2012
                      CommentsLike











                      Enter your Email:

                      Click Here for Popular

                      Who I Am

                      Zeeshan Rasool

                      Software Engineer - PHP
                      Lahore - Pakistan

                      zeeshan(@)99points.info
                      Skype: zeeshan-rasool
                      gTalk: zishan.rasool85

                      Categories

                      Tags

                      99points adobe AJAX ajax pagination ajax rating ajax tutorial ajax voting system captcha Codeigniter codeigniter 2.0 codeigniter recaptcha CSS css tutorials dreamweaver cs5 Facebook facebox farmville ffmpeg flv google api hacking Joomla JQuery JQuery Gallery JQuery menus jquery plugins Jquery tutorial mafia war Mootools MySQL pagination PHP php curl recaptcha RSS Feed SEO simplepie socail networking ssl Tutorials Twitter wall script Web XSS youtube

                      Comments