View file iblog/themes/stock/pages/single_topic.php

File size: 12.01Kb
<?php
	
	$page_id = getpostid($conn,$para2);
	$conn->query("UPDATE ".BLOG_POST." SET num_views = num_views + 1 WHERE id = '{$page_id}'");
	
	$sql = "select * from blog_post where id='$page_id'";
	$data = $conn->query($sql);
	
	$a = $data->fetch_array();	
	$date = $a['date'];
	$title = $a['title'];
	$page_content = $a['page_content'];
	$feature_img = $a['feature_img'];
	$meta_title = $a['meta_title'];
	$meta_desc = $a['meta_desc'];
	$meta_keywords = $a['meta_keywords'];
	$side_bar = $a['side_bar'];
	$num_views = $a['num_views'];
	$tot_comments = totalcomments($conn,$page_id);
	$sidebar = sidebar($side_bar);
	
?>
<!DOCTYPE html>
<html lang="en">

<?php include $theme_dir."/include/head.php";?>

<body>

    <!-- START SITE -->

    <div id="wrapper">
	
		<div class="row">
		
			<div class="shadow">
	

        <?php include $theme_dir."/include/header.php";?>

        <div class="container sitecontainer bgw">

			   
			   <div class="<?php echo $sidebar;?> col-xs-12 m22 single-post">
                    <div class="widget">
                        <div class="large-widget m30">
                            <div class="post clearfix">

                                <div class="title-area">
                                    <div class="bread">
                                        <ol class="breadcrumb">
                                            <li><a href="javascript:;"><i class="fa fa-home"></i> Home</a></li>
                                            <li><a href="javascript:;"> <?php echo ucfirst($blog_page);?></a></li>
                                            <li class="active"><?php echo $title;?></li>
                                        </ol>
                                    </div><!-- end bread -->
                                    <h3><?php echo $title;?></h3>

                                    <div class="large-post-meta">
                                        <span class="avatar"><a href="javascript:;">
										<img src="<?php echo $theme_dir;?>/images/admin.png" alt="" class="img-circle"> Admin</a></span>
                                        <small>|</small>
                                        <span><a href="javascript:;"><i class="fa fa-clock-o"></i> 
												<?php echo date("d M Y",strtotime($date));?></a>
										</span>
                                        <small class="hidden-xs">|</small>
                                        <span class="hidden-xs"><a href="javascript:;"><i class="fa fa-comments-o"></i> 
										<?php echo $tot_comments;?></a></span>
                                        <small class="hidden-xs">|</small>
                                        <span class="hidden-xs"><a href="javascript:;"><i class="fa fa-eye"></i> <?php echo $num_views;?></a></span>
                                    </div><!-- end meta -->

                                </div><!-- /.pull-right -->

                                <!--<div class="post-media">
                                    <a href="single.html">
                                        <img alt="" src="upload/single.jpg" class="img-responsive">
                                    </a>
                                </div>-->

                            </div><!-- end post -->

                            <div class="post-desc">
                                
								<?php echo $page_content;?>

                                <div class="post-sharing">
                                    <ul class="list-inline">
                                        <li>
											<a href="javascript:;" onclick="facebook();" class="fb-button btn btn-primary">
												<i class="fa fa-facebook"></i> <span class="hidden-xs">Share on Facebook</span>
											</a>
										</li>
                                        <li>
											<a href="javascript:;" onclick="twitter();" class="tw-button btn btn-primary">
												<i class="fa fa-twitter"></i> <span class="hidden-xs">Tweet on Twitter</span>
											</a>
										</li>
                                        <li>
											<a href="javascript:;" onclick="googleplus();" class="gp-button btn btn-primary">
												<i class="fa fa-google-plus"></i>
											</a>
										</li>
										<li>
											<a href="javascript:;" onclick="linkedin();" class="linkedin-button btn btn-primary">
												<i class="fa fa-linkedin"></i> <span class="hidden-xs">Share on Linkedin</span>
											</a>
										</li>
                                    </ul>
                                </div><!-- end post-sharing -->
                            </div><!-- end post-desc -->
                            
							<br>


                            <div id="comments" class="row">
                                <div class="col-md-12">
                                    <div class="widget">
                                        <div class="widget-title">
                                            <h4>What other's say about : About This Topic</h4>
                                            <hr>
                                        </div><!-- end widget-title -->

										
							<?php 
								$sql = "select * from comments where blog_id='$page_id' and status = 1 ORDER BY id DESC";
								$data = $conn->query($sql);
								$countcomm = $data->num_rows;
								if($countcomm != 0){
								while($a = $data->fetch_array()){ ?>
                                        <div class="comments">
                                            <div class="well">
                                                <div class="media">
                                                    <div class="media-left">
                                                        <a href="javascript:;">
                                                          <img class="media-object img-circle" 
														  src="<?php echo $theme_dir;?>/images/user.png" alt="Generic placeholder image">
                                                        </a>
                                                    </div>
                                                    <div class="media-body">
                                                        <h4 class="media-heading"><?php echo $a['name'];?></h4>
                                                        <div class="time-comment clearfix">
                                                            <small class="pull-left">
																<li class="fa fa-calendar"></li>
																<?php echo date("d M Y",strtotime($a['date']));?>
															</small>
                                                        </div><!-- end time-comment -->
                                                        <p><?php echo $a['comments'];?></p>
                                                    </div>
                                                </div><!-- end media -->
                                            </div><!-- end well -->
                                        </div><!-- end collapse -->
								<?php } } else{ ?>	
									
									<div class="comments">
										<div class="well">
											<div class="media">
												<h2>No Comments</h2>
											</div><!-- end media -->
										</div><!-- end well -->
									</div><!-- end collapse -->
								<?php } ?>
										
										
										
                                    </div><!-- end widget -->   
                                </div><!-- end col -->
                            </div><!-- end row -->

                            <div class="row">
                                <div class="col-md-12">
                                    <div class="widget">
                                        <div class="widget-title">
                                            <h4>Leave a Comment</h4>
                                            <hr>
                                        </div><!-- end widget-title -->

                                       <div class="commentform">
                                            <form id="postcomments" class="row">
                                                <div class="col-md-12 col-sm-12">
                                                    <label>Comment <span class="required">*</span></label>
                                                    <textarea class="form-control" name="comments" placeholder="Comments"></textarea>
                                                </div>
                                                <div class="col-md-4 col-sm-12">
                                                    <label>Name <span class="required">*</span></label>
                                                    <input type="text" class="form-control" name="name" placeholder="Full Name">
                                                </div>
                                                <div class="col-md-4 col-sm-12">
                                                    <label>Email <span class="required">*</span></label>
                                                    <input type="email" name="email" class="form-control" placeholder="Email">
                                                </div>

                                                <div class="col-md-4 col-sm-12">
                                                    <label>Mobile No</label>
                                                    <input type="text" class="form-control" name="mobile" placeholder="Mobile Number">
                                                </div>

                                                <div class="col-md-3 col-sm-12">
                                                    <input type="submit" value="Send Comment" class="btn btn-primary">
                                                </div>
												
												<div class="col-md-12 col-sm-12">
													<div id="notify"></div>
                                                </div>
												<input type="hidden" name="blogid" value="<?php echo $page_id;?>">
                                            </form>
                                        </div><!-- end newsletter -->
                                    </div><!-- end widget -->   
                                </div><!-- end col -->
                            </div><!-- end row -->

                        </div><!-- end large-widget -->
                    </div><!-- end widget -->
                </div>
				

                    
				<?php if($side_bar != 0){include $theme_dir."/include/sidebar.php";}?>

                   

        

            </div>
            <!-- end row -->
        </div>
        <!-- end container -->

		
		<?php include $theme_dir."/include/footer.php";?>
		
			</div>
			
		</div>
                <!-- end col -->
    </div>
    <!-- end wrapper -->
    <!-- END SITE -->
	<input type="hidden" id="dir" value="<?php echo $theme_dir;?>">
	
    <script src="<?php echo $theme_dir;?>/js/jquery.min.js"></script>
    <script src="<?php echo $theme_dir;?>/js/bootstrap.js"></script>
    <script src="<?php echo $theme_dir;?>/js/plugins.js"></script>
    <!-- FlexSlider JavaScript
    ================================================== -->
    <script>		
		//
		$("#postcomments").submit(function (event){
		event.preventDefault();
			var dir = $("#dir").val();
			var dir_url = dir + "/validation/comments_ajax.php";
			
			$.ajax({
                url:dir_url,
                type:'POST',
                data:$(this).serialize(),
                success: function(data){
						if(data == 1){
							 $('#postcomments')[0].reset();
							$("#notify").html('<div class="alert alert-success"><b>Success: </b> Thank you For your comment, Your Comment will be appear within 24 hours after Moderation.</div>').fadeIn(400).delay(3000).fadeOut(1000);
						}else{
							$("#notify").html('<div class="alert alert-error"><b>Error: </b> ' + data + '</div>').fadeIn(400).delay(3000).fadeOut(400);
						}
					}

			});
				
		});
    </script>

</body>
</html>