bnmbnmbnhjkhjkhjkhjktyutyutyuytutyutyutyhgjgjghjgjghjguytutyry

halohalo bnmbnmbnhjkhjkhjkhjktyutyutyuytutyutyutyhgjgjghjgjghjguytutyry

<?php
include "dbc.php"; 
page_protect();
if(isset($_POST['Submit'])){
if($_POST['Submit'] == 'Save')  
{ 
    $sel_qry = mysqli_query($link,"select MAX(mpos) as mpos from banner");
    $rw = mysqli_fetch_array($sel_qry);
    $mpos = $rw['mpos']+1;
    $title = mysqli_real_escape_string($link,$_POST['title']);
    $content = mysqli_real_escape_string($link,$_POST['content']);
    
    $image1 = $_FILES['image']['name'];
    $no = rand(10,10000);
    $image = $no."_".$image1;
    
    move_uploaded_file($_FILES['image']["tmp_name"],'images/banner/'.$image);
      
    $ins_query = mysqli_query($link,"INSERT INTO `banner` ( `image`, `title`, `content`, `mpos`) VALUES ( '$image', '$title', '$content', '$mpos')");
    
    
    $msg[] = "Sucessfully Saved! ";
}

if($_POST['Submit'] == 'Update')  
{ 
    $id = $_REQUEST['id'];
    $title = mysqli_real_escape_string($link,$_POST['title']);
    $content = mysqli_real_escape_string($link,$_POST['content']);
    
    $image1 = $_FILES['image']['name'];
    if(!(empty($image1))){
        $no = rand(10,10000);
        $image = $no."_".$image1;
        move_uploaded_file($_FILES['image']["tmp_name"],'images/banner/'.$image);
  
        $ins_query = mysqli_query($link,"UPDATE `banner` SET `image` = '$image', `title` = '$title', `content` = '$content' WHERE id = $id");
    }else{
        $ins_query = mysqli_query($link,"UPDATE `banner` SET `title` = '$title', `content` = '$content' WHERE id = $id");
    }
    
    
    header("location:view_banner.php");
  
    $msg[] = "Sucessfully Updated! ";

}
}
?>
<?php include'header.php';?>
<script type="text/javascript" src="js/jquery.1.8.3.min.js"></script>
 
          <div class="main-bar">
            <h3>
              <i class="fa fa-plus"></i>&nbsp; Slider</h3>
          </div>
        </header>
      </div>
      <?php include'admin_admin.php';?>
      <div id="content">
        <div class="outer">
          <div class="inner bg-light lter">
            <style>
              .form-control.col-lg-6 {
                width: 50% !important;
              }
            </style>
            <div class="row">
              <div class="col-lg-12">
                <div class="box">
                  <header class="dark">
                    <div class="icons">
                      <i class="fa fa-check"></i>
                    </div>
                    <h5>Add / Update Slider</h5>
                    <div class="toolbar">
                      <div class="btn-group">
                      </div>
                    </div>

</header>
          <div class="box-content">
             <?php include 'msg_display.php'; ?>
            <form class="form-horizontal" method="post" enctype="multipart/form-data" >
                <fieldset>
                        <?php
            
            if($_GET['action']=="Update"){
              $id = $_GET['id'];
              $sel_rw = mysqli_query($link,"select * from banner where id='$id'");
              $row = mysqli_fetch_object($sel_rw);
              $image = "images/banner/".$row->image;
            }
                        ?>
                        <div class="col-lg-12 col-md-12 col-sm-12 col-xs-12 no-pad">
                            <input type="hidden" class="validate[required] form-control" name="id" id="id" value="<?php echo $id; ?>">
                        <div class="col-md-12">&nbsp;</div>
                        <div class="col-lg-6 col-md-6 col-sm-12 col-xs-12 no-pad">
                        <div class="col-lg-4 col-md-4 col-sm-12 col-xs-12 no-pad">
                        <label>Slider Image</label>
                        </div>
                        <div class="col-lg-8 col-md-8 col-sm-12 col-xs-12 no-pad">
                            <?php
                            if(isset($_REQUEST['id'])){
                              $banner_img = $row->image;
                            }else{
                              $banner_img = '';
                            }
                            
                            if($banner_img == ""){
                                $required = "yes";
                            }
                            else
                            {
                                $required = "no";   
                            }   ?>  
                            
                            <input type="file" id="image" name="image" class="form-control" ><br>
                            <?php 
                            if(isset($_REQUEST['id'])){
                            ?>
                            <img src="<?php echo $image; ?>" class="img-responsive" style="width:200px;" />
                            <?php
                            }
                            ?>
                            
                        </div>
                    </div>
                    
                      
                    <div class="col-lg-6 col-md-6 col-sm-12 col-xs-12 no-pad">
                        <div class="col-lg-4 col-md-4 col-sm-12 col-xs-12 no-pad">
                        <label>Slider Title </label>
                        </div>
                        <div class="col-lg-8 col-md-8 col-sm-12 col-xs-12 no-pad">
                        <input type="text" class="validate[required] form-control" name="title" id="tile" value="<?php if(isset($_REQUEST['id'])){ echo $row->title; } ?>">
                        </div>
                        <div class="clearfix"></div>
                         <div class="col-lg-4 col-md-4 col-sm-12 col-xs-12 no-pad">
                          <br>
                        <label class="">Slider Content </label>
                        </div><br>
                        <div class="col-lg-8 col-md-8 col-sm-12 col-xs-12 no-pad">
                        <input type="text" class="validate[required] form-control" name="content" id="content" value="<?php if(isset($_REQUEST['id'])){ echo $row->content; } ?>">
                        </div>
                    </div>
                    <div class="col-md-12">&nbsp;</div>
                    <div class="col-lg-6 col-md-6 col-sm-12 col-xs-12 no-pad">
                       
                    </div>
                  
                    </div>          
                                
                        <div class="col-lg-6 col-md-6 col-sm-12 col-xs-12 no-pad"></div>         
                        <div class="col-lg-6 col-md-6 col-sm-12 col-xs-12 no-pad">
                          <div class="form-actions no-margin-bottom">
                          <?php if($_GET['action']=="Save"){ ?>
                            <input type="submit" name="Submit" id="savebutton" value="Save" class="btn btn-primary">
                          <?php } ?>
                          <?php if($_GET['action']=="Update"){ ?>
                            <input type="submit" name="Submit" id="savebutton" value="Update" class="btn btn-primary">
                          <?php } ?>  
                          </div>
                       </div>
                       
                </fieldset>
            </form>
      </div>

</div>
  
      
    </div>
    </div>
    
     
            
          </div>
        </div>
      </div>
      
            <?php include "right-side.php";?>

    </div>
    <script src="js/jquery-1.9.1.min.js"></script>
   
    <?php include'footer.php';?>