Translate

Wednesday 19 June 2013

Notification concept using PHP&AJAX

Screenshot:
                         
 index.php:

<body>
<div id="menu">
    <ul>
        <li>
            <a href="#" style="padding:10px 0;">
            <img src="images.png" style="width: 25px;" />
            <?php
            include("db.php");
                $sql=mysql_query("select * from comments");
                $comment_count=mysql_num_rows($sql);
                if($comment_count!=0)
                {
                echo '<span id="mes">'.$comment_count.'</span>';
                }
            ?>
            </a>
        <ul class="sub-menu">
        
            <?php
            
            $msql=mysql_query("select * from messages order by msg_id desc");
            while($messagecount=mysql_fetch_array($msql))
            $id=$messagecount['msg_id'];
            $msgcontent=$messagecount['message'];
            ?>
            <li class="egg">
            <div class="toppointer"><img src="top.png" /></div>
                <?php 

                $sql=mysql_query("select * from comments where msg_id_fk='$id' order by com_id");
                $comment_count=mysql_num_rows($sql);

                if($comment_count>2)
                {
                $second_count=$comment_count-2;
                } 
                else 
                {
                $second_count=0;
                }
                ?>

                <div id="view_comments<?php echo $id; ?>"></div>

                <div id="two_comments<?php echo $id; ?>">
                <?php
                $listsql=mysql_query("select * from comments where msg_id_fk='$id' order by com_id limit $second_count,2 ");
                while($rowsmall=mysql_fetch_array($listsql))
                { 
                $c_id=$rowsmall['com_id'];
                $comment=$rowsmall['comments'];
                ?>

                <div class="comment_ui">

                <div class="comment_text">
                <div  class="comment_actual_text"><?php echo $comment; ?></div>
                </div>

                </div>
                
                <?php }?>
                <div class="bbbbbbb" id="view<?php echo $id; ?>">
                    <div style="background-color: #F7F7F7; border-bottom-left-radius: 3px; border-bottom-right-radius: 3px; position: relative; z-index: 100; padding:8px; cursor:pointer;">
                    <a href="#" class="view_comments" id="<?php echo $id; ?>">View all <?php echo $comment_count; ?> comments</a>
                    </div>
                </div>
            </li>
        </ul>
        </li>
    </ul>
</div>
</body>

Scripts:
<script type="text/javascript" src="jquery.min.js"></script>
<script type="text/javascript">
$(function() 
{
$(".view_comments").click(function() 
{

var ID = $(this).attr("id");

$.ajax({
type: "POST",
url: "comments.php",
data: "msg_id="+ ID, 
cache: false,
success: function(html){
$("#view_comments"+ID).prepend(html);
$("#view"+ID).remove();
$("#two_comments"+ID).remove();
}
});

return false;
});
});
</script>

comments.php:
 <?php
 include("db.php");

if(isSet($_POST['msg_id']))
{
$id=$_POST['msg_id'];
$com=mysql_query("select * from comments where msg_id_fk='$id' order by com_id");
while($r=mysql_fetch_array($com))
{
$c_id=$r['com_id'];
$comment=$r['comments'];
?>
<div class="comment_ui" >
<div class="comment_text">
<div  class="comment_actual_text"><?php echo $comment; ?></div>
</div>
</div>
<?php } }?>


               
                      

1 comment:

  1. What excactly it is supposed to happen in these codes? Why you mix up messages with comments?

    ReplyDelete