1#@!#!123s

32759 1#@!#!123s
: / home / alliance / public_html / admin /
Filename : dashboard.php
back
<?php
include('config.php');
session_start();

if(!isset($_SESSION['login'])){
    
    header('Location:index.php');
}

if(isset($_POST['add_slider']))
{
    
    
  $bantxt_big=$_POST['bantxt_big'];
  
  $bantxt_small=$_POST['bantxt_small'];
  
  $ban_img = $_FILES['ban_img']['name'];  
    
  $imagepath="../img/alliance/".$ban_img;
  
  if($ban_img!='')
  {
   move_uploaded_file($_FILES["ban_img"]["tmp_name"],$imagepath);  
  }
 
 $banner_slider=mysqli_query($con,"INSERT INTO `banner_slider` (`ban_img`, `bantxt_big`, `bantxt_small`, `create_date`) VALUES ('$ban_img', '$bantxt_big', '$bantxt_small', CURDATE())");
    
 if($banner_slider==true)
 {
     echo "<script>alert('Banner Slider Inserted Successfully..');</script>";
     
 } else {
     
     echo "<script>alert('Something went wrong..');</script>";
 }
    
}


if(isset($_POST['upd_slider']))
{
    
  $rec_id=$_POST['rec_id'];    
    
  $bantxt_big=$_POST['bantxt_big'];
  
  $bantxt_small=$_POST['bantxt_small'];
  
  $ban_img = $_FILES['ban_img']['name'];  
    
  $imagepath="../img/alliance/".$ban_img;
  
  if($ban_img!='')
  {
      
   move_uploaded_file($_FILES["ban_img"]["tmp_name"],$imagepath);  
   
   $banner_img=mysqli_query($con,"update banner_slider set `ban_img`='".$ban_img."' where id='".$rec_id."' and is_active=1"); 
   
  }
 
  $banner_text=mysqli_query($con,"update banner_slider set `bantxt_big`='".$bantxt_big."', `bantxt_small`='".$bantxt_small."' where id='".$rec_id."' and is_active=1");
    
 if($banner_text==true)
 {
     echo "<script>alert('Banner Slider Updated Successfully..');location.href='dashboard.php';</script>";
     
 } else {
     
     echo "<script>alert('Something went wrong..');</script>";
 }
    
}


if(isset($_GET['del']))
{
 
 $del_id=$_GET['del'];
 
 $delete_banner=mysqli_query($con,"update banner_slider set is_active='0' where id='".$del_id."' and is_active=1");
   
  if($delete_banner==true)
 {
     echo "<script>alert('Banner Slider Deleted Successfully..');location.href='dashboard.php';</script>";
     
 } else {
     
     echo "<script>alert('Something went wrong..');</script>";
 }   
    
}




?>
<!DOCTYPE html>
<html>
<head><meta http-equiv="Content-Type" content="text/html; charset=utf-8">
  
  <meta http-equiv="X-UA-Compatible" content="IE=edge">
  <title>Alliance | Banner Slider</title>
  <!-- Tell the browser to be responsive to screen width -->
  <meta name="viewport" content="width=device-width, initial-scale=1">
  <!-- Font Awesome -->
  <link rel="stylesheet" href="plugins/font-awesome/css/font-awesome.min.css">
  <!-- Ionicons -->
  <link rel="stylesheet" href="https://code.ionicframework.com/ionicons/2.0.1/css/ionicons.min.css">
  <!-- DataTables -->
  <link rel="stylesheet" href="plugins/datatables/dataTables.bootstrap4.css">
  <!-- Theme style -->
  <link rel="stylesheet" href="dist/css/adminlte.min.css">
  <!-- iCheck -->
  <link rel="stylesheet" href="plugins/iCheck/flat/blue.css">
  <!-- Morris chart -->
  <link rel="stylesheet" href="plugins/morris/morris.css">
  <!-- jvectormap -->
  <link rel="stylesheet" href="plugins/jvectormap/jquery-jvectormap-1.2.2.css">
  <!-- Date Picker -->
  <link rel="stylesheet" href="plugins/datepicker/datepicker3.css">
  <!-- Daterange picker -->
  <link rel="stylesheet" href="plugins/daterangepicker/daterangepicker-bs3.css">
  <!-- bootstrap wysihtml5 - text editor -->
  <link rel="stylesheet" href="plugins/bootstrap-wysihtml5/bootstrap3-wysihtml5.min.css">
  <!-- Google Font: Source Sans Pro -->
  <link href="https://fonts.googleapis.com/css?family=Source+Sans+Pro:300,400,400i,700" rel="stylesheet">
</head>
<body class="hold-transition sidebar-mini">
<div class="wrapper">

  <!-- Navbar -->
  <?php include('include/header.php'); ?>
  <!-- /.navbar -->

  <!-- Main Sidebar Container -->
  <?php include('include/sidebar.php'); ?>

  <!-- Content Wrapper. Contains page content -->
  <div class="content-wrapper">
    <!-- Content Header (Page header) -->
    <div class="content-header">
      <div class="container-fluid">
        <div class="row mb-2">
          <div class="col-sm-6">
            <h1 class="m-0 text-dark">Banner Slider</h1>
          </div><!-- /.col -->
        </div><!-- /.row -->
      </div><!-- /.container-fluid -->
    </div>
    <!-- /.content-header -->

    <!-- Main content -->
    <section class="content">
      <div class="container-fluid">
        <div class="row">
          <!-- left column -->
          <div class="col-md-12">
            <!-- general form elements -->
            
         <?php
         
         if(isset($_GET['edit']))
         {
         ?>    
            <div class="card card-primary">
              <div class="card-header">
                <h3 class="card-title">Update Banner Silder</h3>
              </div>
             
              <form role="form" method="post" enctype="multipart/form-data">
                <div class="card-body">
                    
                <div class="row">
                    
                <?php 
                $upd_id=$_GET['edit'];
                $upd_banner=mysqli_query($con,"select * from banner_slider where id='".$upd_id."' and is_active=1");
                $upd_value=mysqli_fetch_array($upd_banner);
                ?>    
                    
                 <div class="col-md-4">
                  <div class="form-group">
                    <label for="exampleInputFile">File input</label>
                    <div class="input-group">
                      <div class="custom-file">
                          <input type="hidden" name="rec_id" value="<?php echo $upd_value['id']; ?>">
                        <input type="file" class="custom-file-input" name="ban_img" id="ban_img" >
                        <label class="custom-file-label" for="exampleInputFile">Choose file</label>
                      </div>
                    </div>
                  </div>
                  </div>
                  <div class="col-md-4">    
                  <div class="form-group">
                    <label for="exampleInputEmail1">Banner (Big Text)</label>
                    <input type="text" class="form-control" name="bantxt_big" id="bantxt_big" value="<?php echo $upd_value['bantxt_big']; ?>">
                  </div>
                  </div>
                  
                  <div class="col-md-4">
                  <div class="form-group">
                    <label for="exampleInputPassword1">Banner (Small Text)</label>
                    <input type="text" class="form-control" name="bantxt_small" id="bantxt_small" value="<?php echo $upd_value['bantxt_small']; ?>">
                  </div>
                  </div>
                  
                  </div>
                </div>

                <div class="card-footer">
                  <button type="submit" name="upd_slider" class="btn btn-primary">Update</button>
                  <a href="dashboard.php" class="btn btn-default" type="button">Cancel</a>
                </div>
              </form>
            </div>
            
            <?php } else { ?>
            <div class="card card-primary">
              <div class="card-header">
                <h3 class="card-title">Add Banner Silder</h3>
              </div>
             
              <form role="form" method="post" enctype="multipart/form-data">
                <div class="card-body">
                <div class="row">
                    
                 <div class="col-md-4">
                  <div class="form-group">
                    <label for="exampleInputFile">File input</label>
                    <div class="input-group">
                      <div class="custom-file">
                        <input type="file" class="custom-file-input" name="ban_img" id="ban_img" required>
                        <label class="custom-file-label" for="exampleInputFile">Choose file</label>
                      </div>
                    </div>
                  </div>
                  </div>
                  
                  <div class="col-md-4">    
                  <div class="form-group">
                    <label for="exampleInputEmail1">Banner (Big Text)</label>
                    <input type="text" class="form-control" name="bantxt_big" id="bantxt_big" placeholder="Banner text">
                  </div>
                  </div>
                  
                  <div class="col-md-4">
                  <div class="form-group">
                    <label for="exampleInputPassword1">Banner (Small Text)</label>
                    <input type="text" class="form-control" name="bantxt_small" id="bantxt_small" placeholder="Banner text">
                  </div>
                  </div>
                  
                  </div>
                </div>

                <div class="card-footer">
                  <button type="submit" name="add_slider" class="btn btn-primary">Submit</button>
                </div>
              </form>
            </div>
            
            <?php } ?>
            
              <div class="card">
            <div class="card-header">
              <h3 class="card-title">View Banner Slider</h3>
            </div>
            <!-- /.card-header -->
            <div class="card-body">
              <table id="example1" class="table table-bordered table-striped">
                <thead>
                <tr>
                  <th>S.No</th>
                  <th>Banner Image</th>
                  <th>Banner(Big Text)</th>
                  <th>Banner(Small Text)</th>
                  <th>Action</th>
                </tr>
                </thead>
                <tbody>
                <?php 
                $banner_slider=mysqli_query($con,"select * from banner_slider where is_active=1");
                $i=$i+1;
                while($banner_row=mysqli_fetch_array($banner_slider))
                {
                ?>    
                <tr>
                  <td><?php echo $i; ?></td>
                  <td><img src="../img/alliance/<?php echo $banner_row['ban_img']; ?>" style="width:200px;height:80px;"></td>
                  <td><?php echo $banner_row['bantxt_big']; ?></td>
                  <td><?php echo $banner_row['bantxt_small']; ?></td>
                  <td><a href="dashboard.php?edit=<?php echo $banner_row['id']; ?>" class="btn btn-app"><i class="fa fa-edit"></i> Edit</a>&nbsp;
                  <a href="dashboard.php?del=<?php echo $banner_row['id']; ?>" onclick="return confirm('Are you sure you want to delete this item?');" class="btn btn-app"><i class="fa fa-trash"></i> Delete</a>
                  </td>
                </tr>
                <?php $i=$i+1; } ?>
                </tbody>
                <tfoot>
                <tr>
                  <th>S.No</th>
                  <th>Banner Image</th>
                  <th>Banner(Big Text)</th>
                  <th>Banner(Small Text)</th>
                  <th>Action</th>
                </tr>
                </tfoot>
              </table>
            </div>
            <!-- /.card-body -->
          </div>
            
            <!-- /.card -->
          </div>
          <!--/.col (right) -->
        </div>
        <!-- /.row -->
      </div><!-- /.container-fluid -->
    </section>
    <!-- /.content -->
  </div>
  <!-- /.content-wrapper -->
 
 <?php include('include/footer.php'); ?>

  
</div>
<!-- ./wrapper -->

<!-- jQuery -->
<script src="plugins/jquery/jquery.min.js"></script>
<!-- jQuery UI 1.11.4 -->
<script src="https://code.jquery.com/ui/1.12.1/jquery-ui.min.js"></script>
<!-- Resolve conflict in jQuery UI tooltip with Bootstrap tooltip -->
<script>
  $.widget.bridge('uibutton', $.ui.button)
</script>
<!-- Bootstrap 4 -->
<script src="plugins/bootstrap/js/bootstrap.bundle.min.js"></script>
<!-- Morris.js charts -->
<script src="https://cdnjs.cloudflare.com/ajax/libs/raphael/2.1.0/raphael-min.js"></script>
<script src="plugins/morris/morris.min.js"></script>
<!-- Sparkline -->
<script src="plugins/sparkline/jquery.sparkline.min.js"></script>
<!-- daterangepicker -->
<script src="https://cdnjs.cloudflare.com/ajax/libs/moment.js/2.10.2/moment.min.js"></script>
<script src="plugins/daterangepicker/daterangepicker.js"></script>
<!-- datepicker -->
<script src="plugins/datepicker/bootstrap-datepicker.js"></script>
<!-- Bootstrap WYSIHTML5 -->
<script src="plugins/bootstrap-wysihtml5/bootstrap3-wysihtml5.all.min.js"></script>
<!-- Slimscroll -->
<script src="plugins/slimScroll/jquery.slimscroll.min.js"></script>
<!-- DataTables -->
<script src="plugins/datatables/jquery.dataTables.js"></script>
<script src="plugins/datatables/dataTables.bootstrap4.js"></script>
<!-- FastClick -->
<script src="plugins/fastclick/fastclick.js"></script>
<!-- AdminLTE App -->
<script src="dist/js/adminlte.js"></script>
<!-- AdminLTE dashboard demo (This is only for demo purposes) -->
<script src="dist/js/pages/dashboard.js"></script>
<!-- AdminLTE for demo purposes -->
<script src="dist/js/demo.js"></script>
<script>
  $(function () {
    $("#example1").DataTable();
  });
</script>
</body>
</html>