1#@!#!123s

22527 1#@!#!123s
: / home / realforcepumps / public_html / admin /
Filename : blog.php
back
<?php 
include("main.php");
/* insert blog */
if(isset($_POST['blog_insert']) and $_POST['name']!=''  and $_POST['comment']!=''){
	$name =  mysqli_real_escape_string($con,$_POST['name']);
	//$date  =  mysqli_real_escape_string($con,$_POST['date']);
	$des  =  mysqli_real_escape_string($con,$_POST['comment']);
	$pic  =  $_FILES['picture']['name'];
	$date = date("Y-m-d");
	if($pic != ''){
		$extension		= end(explode(".", $pic));
			$targate_file	= time().rand(10,100).".".$extension;
			if (move_uploaded_file($_FILES['picture']['tmp_name'], "blog/".$targate_file)){
				$query = "INSERT INTO `blog`( `varTitle`, `txtDescription`, `varImage`, `dtDate`) VALUES ('$name','$des','$targate_file','$date')";
					if($insert = mysqli_query($con,$query)){
						echo '<script>window.location.replace("blog.php");</script>';
					}else{
						echo '<script>alert("Something went wrong");</script>';
					}
			}else{
						echo '<script>alert("Something went wrong");</script>';
					}
	}else{
		echo '<script>alert("Select Image First");</script>';
	}
		
}
/* insert blog */

/* update blog */
if(isset($_POST['blog_update'])){
	$id = mysqli_real_escape_string($con,$_POST['blog_update']);
	$name =  mysqli_real_escape_string($con,$_POST['name']);
	//$date  =  mysqli_real_escape_string($con,$_POST['date']);
	$des  =  mysqli_real_escape_string($con,$_POST['comment']);
	$pic  =  $_FILES['picture']['name'];
	$date = date("Y-m-d");
	$update .= "UPDATE `blog` SET `varTitle`= '$name',`txtDescription`='$des',`dtDate`='$date' ";
	if($pic !=''){
		$extension		= end(explode(".", $pic));
			$targate_file	= time().rand(10,100).".".$extension;
			if (move_uploaded_file($_FILES['picture']['tmp_name'], "blog/".$targate_file)){
				$update  .= ", `varImage`='$targate_file'";
			}
	}
	$update .= "WHERE intId=$id";
	
	   if(mysqli_query($con,$update))
		{
			echo "<script>alert('Updated Successfully');</script>";
			echo "<script>window.location.replace('blog.php');</script>";
		}else{
			echo "Something went wrong";
		}
} 
/* update blog */


/* Delete  blog */
if(isset($_POST['blog_delete']) ){
	$id = mysqli_real_escape_string($con,$_POST['blog_delete']);
	$del_select = mysqli_query($con,"SELECT  `varImage` FROM `blog` WHERE `intId`=$id");
	$del_row    = mysqli_fetch_object($del_select);
	unlink("blog/$del_row->varImage");
	$delete = mysqli_query($con,"DELETE FROM `blog` WHERE `intId`=$id");
	if($delete){
		
		echo "<script>alert('Deleted Successfully');</script>";
		echo "<script>window.location.replace('blog.php');</script>";
	}else{
		echo '<script>alert("Something went wrong");</script>';
	}
}
/* Delete blog */

?>
<!--  page-wrapper -->
        <div id="page-wrapper">

            <div class="row">
                <!-- Page Header -->
                <div class="col-lg-12">
                    <h1 class="page-header">Blog</h1>
                </div>
                <!--End Page Header -->
            </div>
                        <div class="row">
                            <div class="col-sm-12">
                                <div class="panel panel-default">
                                    <div class="panel-heading"><h3 class="panel-title">Add Blog</h3></div>
                                    <div class="panel-body">
                                        <div class=" form">
                                            <form class="cmxform form-horizontal tasi-form" id="commentForm" method="post" action="" novalidate="novalidate" enctype="multipart/form-data">
                                                <div class="form-group ">
                                                    <label for="cname" class="control-label col-lg-2">Name (required)</label>
                                                    <div class="col-lg-10">
                                                        <input class=" form-control" id="cname" name="name" type="text" required="required" aria-required="true">
                                                    </div>
                                                </div> 
												<!--<div class="form-group ">
                                                    <label for="cname" class="control-label col-lg-2">Date </label>
                                                    <div class="col-lg-10">
                                                        <input class=" form-control"  name="date" type="date" required="required" aria-required="true">
                                                    </div>
                                                </div>-->
												<div class="form-group ">
                                                    <label for="cemail" class="control-label col-lg-2">Upload Picture </label>
                                                    <div class="col-lg-10">
                                                        <input class="form-control " id="cemail" type="file" name="picture" required="" aria-required="true">
                                                    </div>
                                                </div>
                                                <div class="form-group ">
                                                    <label for="ccomment" class="control-label col-lg-2">Description (required)</label>
                                                    <div class="col-lg-10">
                                                        <textarea class="form-control ckeditor" id="js-my-textarea1" name="comment" required="required" aria-required="true" placeholder="Enter The Description"></textarea>
                                                    </div>
                                                </div>
                                                <div class="form-group">
                                                    <div class="col-lg-offset-2 col-lg-10">
                                                        <button class="btn btn-success waves-effect waves-light"  name="blog_insert" type="submit">Submit</button>
                                                    </div>
                                                </div>
                                            </form>
                                        </div> <!-- .form -->
                                    </div> <!-- panel-body -->
                                </div> <!-- panel -->
                            </div> <!-- col -->

                        </div> <!-- End row -->

						<div class="panel">
                            
                            <div class="panel-body">
                                <div class="row">
                                    <div class="col-sm-6">
                                        <div class="m-b-30">
                                            
                                        </div>
                                    </div>
                                </div>
                                <table class="table table-bordered table-striped" id="datatable-editable">
                                    <thead>
                                        <tr>
                                            <th>S.no.</th>
											<th>Picture</th>
                                            <th>Name</th>
                                            <th>Description</th>
                                            <th>Date</th>
                                            <th>Actions</th>
                                        </tr>
                                    </thead>
                                    <tbody>
										<?php  
											$q = "SELECT `intId`, `varTitle`, `txtDescription`, `varImage`, `dtDate` FROM `blog`";
											$query  = mysqli_query($con,$q);
											$sno=1;
											while($row = mysqli_fetch_object($query)){
												echo '<tr class="gradeX">
															<td>'.$sno.'</td>
															<td><img src="blog/'.$row->varImage.'" height="75" widht="75"></td>
															<td>'.$row->varTitle.'</td>
															<td>'.$row->txtDescription.'</td>
															<td>'.date("d M Y", strtotime($row->dtDate)).'</td>
															<td class="actions">
																<a href="#" class="on-default edit-row"><i class="fa fa-pencil" data-toggle="modal" data-target="#edit_'.$row->intId.'"></i></a>
																<a href="#" class="on-default remove-row"><i class="fa fa-trash-o" data-toggle="modal" data-target="#del_'.$row->intId.'"></i></a>
															</td>
															 <!--Update Blog Modal -->
  <div class="modal fade" id="edit_'.$row->intId.'" role="dialog">
    <div class="modal-dialog modal-lg">
    
      <!-- Modal content-->
      <div class="modal-content">
        <div class="modal-header">
          <button type="button" class="close" data-dismiss="modal">&times;</button>
          <h4 class="modal-title">Update Blog</h4>
        </div>
        <div class="modal-body">
			<form class="cmxform form-horizontal tasi-form" id="commentForm" method="post" action="" novalidate="novalidate" enctype="multipart/form-data">
				<div class="row">
					<div class="form-group ">
						<label for="cname" class="control-label col-lg-2">Name (required)</label>
						<div class="col-lg-10">
							<input class=" form-control" id="cname" name="name" type="text" required="required" aria-required="true" value="'.$row->varTitle.'">
						</div>
					</div> 
				</div> 
				<div class="row">								
					<div class="form-group ">
						<label for="cemail" class="control-label col-lg-2">Upload Picture </label>
						<div class="col-lg-5">
							<input class="form-control " id="cemail" type="file" name="picture" required="" aria-required="true">
						</div>
						<div class="col-lg-5">
							<img src="blog/'.$row->varImage.'" height="150" width="150">
						</div>
					</div>
				</div>
				<div class="row">
					<div class="form-group ">
						<label for="ccomment" class="control-label col-lg-2">Description (required)</label>
						<div class="col-lg-10">
							<textarea class="form-control ckeditor" id="js-my-textarea1" name="comment" required="required" aria-required="true" placeholder="Enter The Description">'.$row->txtDescription.'</textarea>
						</div>
					</div>
				</div>
				<div class="row">
					<div class="form-group">
						<div class="col-lg-offset-2 col-lg-10">
							<button class="btn btn-success waves-effect waves-light"  name="blog_update" type="submit" value="'.$row->intId.'">Update</button>
						</div>
					</div>
				</div>
			</form>
        </div>
        <div class="modal-footer">
          <button type="button" class="btn btn-default" data-dismiss="modal">Close</button>
        </div>
      </div>
      
    </div>
  </div>
	
 <!-- Delete Modal -->
  <div class="modal fade" id="del_'.$row->intId.'" role="dialog">
    <div class="modal-dialog modal-lg">
    
      <!-- Modal content-->
      <div class="modal-content">
        <div class="modal-header">
          <button type="button" class="close" data-dismiss="modal">&times;</button>
          <h4 class="modal-title">Delete Blog</h4>
        </div>
        <div class="modal-body">
			<form class="cmxform form-horizontal tasi-form" id="commentForm" method="post" action="" novalidate="novalidate" enctype="multipart/form-data">
				<div class="row">
					<div class="form-group ">
						<label for="cname" class="control-label col-lg-2">Name (required)</label>
						<div class="col-lg-10">
							<input class=" form-control" id="cname" name="name" type="text" required="required" aria-required="true" value="'.$row->varTitle.'">
						</div>
					</div>
				</div>	
				<div class="row">				
					<div class="form-group ">
						<label for="cemail" class="control-label col-lg-2">Picture </label>
						<div class="col-lg-10">
							<img src="blog/'.$row->varImage.'" height="150" width="150">
						</div>
					</div>
				</div>
				<div class="row">
					<div class="form-group ">
						<label for="ccomment" class="control-label col-lg-2">Description (required)</label>
						<div class="col-lg-10">
							<textarea class="form-control ckeditor" id="js-my-textarea1" name="comment" required="required" aria-required="true" placeholder="Enter The Description">'.$row->txtDescription.'</textarea>
						</div>
					</div>
				</div>
				<div class="row">
					<div class="form-group">
						<div class="col-lg-offset-2 col-lg-10">
							<button class="btn btn-success waves-effect waves-light"  name="blog_delete" type="submit" value="'.$row->intId.'">Delete</button>
						</div>
					</div>
				</div>
			</form>
        </div>
        <div class="modal-footer">
          <button type="button" class="btn btn-default" data-dismiss="modal">Close</button>
        </div>
      </div>
      
    </div>
  </div>	
															
														</tr>';
														$sno++;
											}
										?>
                                        
                                    </tbody>
                                </table>
                            </div>
                            <!-- end: page -->

                        </div> <!-- end Panel -->

<?php 
include("footer.php");
?>