bnmbnmbnmnbbtyutyutyutyutyutyu,nm,nmmnmm,bbbbbn

]nbmbmbnmbnmbytutytyutyutyutyumbnmjhkhjkhjkhjkhjkhjknnnnnnnn bnmbnmbnmnbbtyutyutyutyutyutyu,nm,nmmnmm,bbbbbn

<?php include("config.php"); ?>
<!DOCTYPE html>
<html>
    <head>
        <meta charset="utf-8">
        <meta name="viewport" content="width=device-width, initial-scale=1.0">
        <meta name="description" content="">
        <meta name="author" content="">

<title>Admin | Blog</title>

<link href="css/bootstrap.min.css" rel="stylesheet" />

<link href="assets/font-awesome/css/font-awesome.min.css" rel="stylesheet" />
        <link href="assets/ionicon/css/ionicons.min.css" rel="stylesheet" />
        <link href="css/material-design-iconic-font.min.css" rel="stylesheet">

<link href="css/animate.css" rel="stylesheet" />

<link href="css/waves-effect.css" rel="stylesheet">

<link href="css/helper.css" rel="stylesheet" type="text/css" />
        <link href="css/style.css" rel="stylesheet" type="text/css" />

<div class="row">
                            <div class="col-sm-12">
                                <h4 class="pull-left page-title">Blog</h4>
                                <ol class="breadcrumb pull-right">
                                    <li><a href="dashboard.php">Dashboard</a></li>
                                    <li class="active">Blog</li>
                                </ol>
                            </div>
                        </div>
                         <?php 
                            if(isset($_GET['delete']))
                            {
                              $delete=$_GET['delete'];
                            }
                            else
                            {
                              $delete=0;
                              $slug="";
                            }
                              $sql="delete from blog where id='$delete'";
                              $res=mysqli_query($db,$sql);
                            ?>

<?php 
                            if(isset($_GET['slug']))
                            {
                              $slug=$_GET['slug'];
                            }
                            else
                            {
                              $slug=0;
                            }
                             $sql1="select * from `blog` where id='$slug' ";
                            $res1=mysqli_query($db,$sql1);
                            $row6=mysqli_fetch_array($res1);
                            $title=$row6['title'];
                            //$title_slug=$row6['title_slug'];
                            $post_date=$row6['post_date'];
                            $post_by=$row6['post_by'];
                            $post_desc=$row6['post_desc'];
                            $img=$row6['image'];
                            ?>
                        <div class="row">
                            <div class="col-sm-12">
                                <div class="panel panel-default">
                                    <div class="panel-heading"><h3 class="panel-title">Services </h3></div>
                                    <div class="panel-body">
                                        <form class="form-horizontal" role="form" method="post" enctype="multipart/form-data">                      
                                            <div class="form-group">
                                                <label class="col-md-2 control-label">Blog Title</label>
                                                <div class="col-md-6"> 
                                                   <input type="text" class="form-control" name="title" value="<?php echo $title; ?>" placeholder="Blog Title"> 
                                                </div>
                                            </div>  
                                              <div class="form-group">
                                                <label class="col-md-2 control-label">Blog Date</label>
                                                <div class="col-md-3"> 
                                                   <input type="text" class="form-control" name="post_date" value="<?php echo $post_date; ?>" placeholder=""> 
                                                </div>
                                                  <label class="col-md-2 control-label">Post By.</label>

<div class="col-md-3"> 
                                                   <input type="text" class="form-control" name="post_by" value="<?php echo $post_by; ?>" placeholder="Post By.."> 
                                                </div>
                                            </div>

<div class="form-group">
                                                <label class="col-md-2 control-label">Desc</label>
                                                <div class="col-md-10"> 
                                                    <textarea class="ckeditor m input sm" id="editor" rows="5" name="editor1"><?php echo $post_desc ?></textarea> 
                                                </div>
                                            </div>
                                           
                                              <div class="form-group">
                                                    <label class="col-md-2 control-label">Services Image</label>
                                                    <div class="col-md-3">
                                                        <div class="fileUpload btn btn-primary waves-effect waves-light">
                                                            <span>upload image here...</span>
                                                            <input type="file" name="image" class="upload">
                                                        </div>
                                                    </div>
                                                    <div class="col-md-4">
                                                        <img src="upload/<?php echo $img; ?>" style="width: 100px;">
                                                    </div>
 
                                                </div>

<div class="form-group">
                                                <label class="col-md-2 control-label"></label>
                                                <div class="col-md-10">
                                                  <button type="submit" name="<?php if(isset($_GET['slug'])){ echo "Update"; }else { echo "Submit";} ?>" class="btn btn-purple waves-effect waves-light"><?php if(isset($_GET['slug'])){ echo "Update"; }else { echo "Submit";} ?></button>
                                                </div>
                                            </div>
                                        </form>
                                         <?php
                                            if(isset($_POST['Submit']))
                                            {
                                              
                                                $post_date=$_POST['post_date'];
                                                $editor1=$_POST['editor1'];
                                                $post_by=$_POST['post_by'];
                                                $title=$_POST['title'];

$title_slug = strtolower(trim(preg_replace('/[^A-Za-z0-9-]+/', '-', $title)));

$image = $_FILES['image']['name'];
                                                if(!$image)
                                                {
                                                    $image=$img;
                                                }
                                                else
                                                {
                                                    $file_path = 'upload/';
                                                    $file_path = $file_path . basename( $_FILES['image']['name']);    
                                                    if(move_uploaded_file($_FILES['image']['tmp_name'], $file_path)) 
                                                    { 
                                                    }
                                                }

$sql="INSERT INTO `blog` (`id`, `post_date`, `post_by`, `title`, `post_desc`, `image`, `status`) VALUES (NULL, '$post_date', '$post_by', '$title', '$editor1','$image', '1');";
                                                $res=mysqli_query($db,$sql);
                                                if($res==1)
                                                {
                                                    echo ("<script LANGUAGE='JavaScript'>window.alert('Succesfully added.!!');window.location.href='blog.php';</script>");
                                                    /*echo "data save";*/
                                                }
                                                else
                                                {
                                                    echo ("<script LANGUAGE='JavaScript'>window.alert('Product Not Added.!!');window.location.href='blog.php';</script>");
                                                    /*echo "data Not save";*/
                                                }
                                            }
                                        ?>
                                        <?php
                                            if(isset($_POST['Update']))
                                            {
                                                $slug=$_GET['slug'];
                                                $post_date=$_POST['post_date'];
                                                $editor1=$_POST['editor1'];
                                                $post_by=$_POST['post_by'];
                                                $title=$_POST['title'];
                                               
                                                $image = $_FILES['image']['name'];
                                                if(!$image)
                                                {
                                                    $image=$img;
                                                }
                                                else
                                                {
                                                    $file_path = 'upload/';
                                                    $file_path = $file_path . basename( $_FILES['image']['name']);    
                                                    if(move_uploaded_file($_FILES['image']['tmp_name'], $file_path)) 
                                                    { 
                                                    }
                                                }
                                                $sql="update `blog` set `post_date`='$post_date',`post_by`='$post_by',`title`='$title',`post_desc`='$post_desc',`image`='$image' where id='$slug'";
                                                $res=mysqli_query($db,$sql);
                                                if($res==1)
                                                {
                                                    echo ("<script LANGUAGE='JavaScript'>window.alert('Succesfully Updated');
                                                        window.location.href='blog.php';</script>");
                                                        /*echo "data update";*/
                                                }
                                                else
                                                {
                                                   echo ("<script LANGUAGE='JavaScript'>window.alert('Not Updated Data.!');
                                                        window.location.href='blog.php';</script>");
                                                        /*echo "data not save";*/
                                                }
                                              }
                                            ?>
                                    </div> 
                                </div> 
                            </div> 
                        </div>

<div class="row">
                            <div class="col-md-12">
                                <div class="panel panel-default">
                                    <div class="panel-heading">
                                        <h3 class="panel-title">View Blog</h3>
                                    </div>
                                    <div class="panel-body">
                                        <div class="row">
                                            <div class="col-md-12 col-sm-12 col-xs-12">
                                                <div class="table-responsive">
                                                <table id="datatable" class="table table-striped table-bordered">
                                                    <thead>
                                                        <tr>
                                                            <th>ID</th>
                                                            
                                                            <th>Title</th>
                                                            <th>date</th>
                                                            <th>Post by</th>
                                                            <th>image</th>
                                                            <th>Post Desc</th>
                                                            <th>Setting</th>
                                                        </tr>
                                                    </thead>
                                                    <tbody>
                                                        <?php
                                                          $sql="SELECT * FROM `blog`";
                                                            $res=mysqli_query($db,$sql);
                                                            while($row=mysqli_fetch_array($res))
                                                            {
                                                        ?>
                                                        <tr>
                                                            <td><?php echo $row['id']; ?></td>
                                                            <td><?php echo $row['title']; ?></td>
                                                            <td><?php echo $row['post_date']; ?></td>
                                                            <td><?php echo $row['post_by']; ?></td>
                                                            <td><img style="width: 80px;" src="upload/<?php echo$row['image']; ?>"></td>
                                                           
                                                            <td><?php echo $row['post_desc']; ?></td>
                                                            
                                                            <td>
                                                                <a href="blog.php?slug=<?php echo $row['id']; ?>">
                                                                    <button class="btn btn-icon waves-effect waves-light btn-primary m-b-5"> <i class="fa fa-pencil"></i> </button>
                                                                </a>
                                                                <a href="blog.php?delete=<?php echo $row['id']; ?>">
                                                                    <button class="btn btn-icon waves-effect waves-light btn-danger m-b-5" onclick="return confirm('Are you sure you want to delete this item?');"> <i class="fa fa-remove"></i> </button>
                                                                </a>
                                                            </td>
                                                        </tr>
                                                    <?php } ?>
                                                       
                                                    </tbody>
                                                </table>
                                            </div>
                                            </div>
                                        </div>
                                    </div>
                                </div>
                            </div>
                            
                        </div> 
                    </div> 
                               
                </div>

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

</div>

</div>
        
    
        <script>
            var resizefunc = [];
        </script>

<script src="js/jquery.min.js"></script>
        <script src="js/bootstrap.min.js"></script>
        <script src="js/waves.js"></script>
        <script src="js/wow.min.js"></script>
        <script src="js/jquery.nicescroll.js" type="text/javascript"></script>
        <script src="js/jquery.scrollTo.min.js"></script>
        <script src="assets/jquery-detectmobile/detect.js"></script>
        <script src="assets/fastclick/fastclick.js"></script>
        <script src="assets/jquery-slimscroll/jquery.slimscroll.js"></script>
        <script src="assets/jquery-blockui/jquery.blockUI.js"></script>

<script src="js/jquery.app.js"></script>
        <script src="assets/datatables/jquery.dataTables.min.js"></script>
        <script src="assets/datatables/dataTables.bootstrap.js"></script>
        <script type="text/javascript">
            $(document).ready(function() {
                $('#datatable').dataTable();
            } );
        </script>
         <script type="text/javascript">
            jQuery(document).ready(function() {
            jQuery(".select2").select2({
                    width: '100%'
                });
             });
        </script>
        <script src="assets/select2/select2.min.js" type="text/javascript"></script>
        <script>
            CKEDITOR.replace( 'editor1' );
        </script>
        <script>
            CKEDITOR.replace( 'editor2' );
        </script>
        
        <script src="assets/select2/select2.min.js" type="text/javascript"></script>
        <script type="text/javascript" src="assets/bootstrap-wysihtml5/wysihtml5-0.3.0.js"></script>
        <script type="text/javascript" src="assets/bootstrap-wysihtml5/bootstrap-wysihtml5.js"></script>
        
        
       
        
                           
        <script>
            $(document).on("change keyup blur", "#chDiscount", function() {
            var main = $('#cBalance').val();
            var disc = $('#chDiscount').val();
            var dec = (disc / 100).toFixed(2); //its convert 10 into 0.10
            var mult = main * dec; // gives the value for subtract from main value
            var discont = main - mult;
            $('#result').val(discont);
            });
        </script>
    </body>
</html>