1#@!#!123s

32759 1#@!#!123s
: / home / alliance / www / admin /
Filename : annual_services.php
back
<?php
include('config.php');
header('Content-Type: text/html; charset=ISO-8859-1');
session_start();

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



if(isset($_POST['upd_slider']))

{
    
  $rec_id=$_POST['rec_id'];    
    
  $Titile=$_POST['Titile'];
  
  $textarea=$_POST['textarea'];
  
  $sub_titile=$_POST['sub_titile'];
  
  $sub_image=$_POST['sub_image']['name'];
  
  $pro_img = $_FILES['pro_img']['name'];  
  
  
  $imagepath="../img/alliance/".$pro_img;
  
  if($pro_img!='')
  {
      
   move_uploaded_file($_FILES["pro_img"]["tmp_name"],$imagepath);  
   
   $banner_img=mysqli_query($con,"update  annual_services set `pro_img`='".$pro_img."' where Id='".$rec_id."' and is_active=1"); 
   
   
  }
  
  
    $imagepath="../img/alliance/".$sub_image;
  
  if($sub_image!='')
  {
      
   move_uploaded_file($_FILES["sub_image"]["tmp_name"],$imagepath);  
   
   $banner_img=mysqli_query($con,"update  annual_services set `sub_image`='".$sub_image."' where Id='".$rec_id."' and is_active=1"); 
   
   
  }
  


 
   $banner_text=mysqli_query($con,"update annual_services set `Titile`='".$Titile."', `Content`='".$textarea."', `sub_titile`='".$sub_titile."' where Id='".$rec_id."' and is_active=1");
  

  
    
//  if($banner_text==true)
//  {
//      echo "<script>alert('Content Updated Successfully..');location.href='home.php';</script>";
     
//  } else {
     
//      echo "<script>alert('Something went wrong..');</script>";
//  }
    
}





?>
<!DOCTYPE html>
<html>
<head>
  <meta 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 -->
  <!-- Font Awesome -->
  <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/font-awesome/4.4.0/css/font-awesome.min.css">
  <!-- Ionicons -->
  <link rel="stylesheet" href="https://code.ionicframework.com/ionicons/2.0.1/css/ionicons.min.css">
  <!-- Theme style -->
  <link rel="stylesheet" href="dist/css/adminlte.min.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 -->

  <?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"> Annual Services</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 Content</h3>
              </div>
             
              <form role="form" method="post" enctype="multipart/form-data">
                <div class="card-body">
                    
                <div class="row">
                    
                <?php 
                $id=$_GET['edit'];
                $upd_banner=mysqli_query($con,"select * from annual_services where Id='".$id."' and is_active=1");
                $upd_value=mysqli_fetch_array($upd_banner);
                ?>    
                <input type="hidden" name="rec_id" value="<?php echo $upd_value['Id']; ?>">
      
                              <div class="col-md-4">  
          <div class="custom-file">
                       <label for="exampleInputEmail1">Image:</label>
                        <input type="file" class="custom-file-input" name="pro_img" id="pro_img" >
                        <label class="custom-file-label" for="exampleInputFile" style="top: 31px;">Choose file</label>
                      </div>
          
          </div>
                
                  <div class="col-md-4">    
                  <div class="form-group">
                    <label for="exampleInputEmail1">Title:</label>
                    <input type="text" class="form-control" name="Titile" id="Titile" value="<?php echo $upd_value['Titile']; ?>">
                  </div>
                  </div>
                  
                     
       
      
                   <div class="col-md-4">
                <div class="card-body pad">
              <div class="mb-3">
                <textarea class="textarea" name="textarea" style="width: 100%; height: 200px; font-size: 14px; line-height: 18px; border: 1px solid #dddddd; padding: 10px;"><?php echo $upd_value['Content']; ?></textarea>
              </div>
            </div>
           
            </div>
       
       
                                                              <div class="col-md-4">  
          <div class="custom-file">
                       <label for="exampleInputEmail1">Image:</label>
                        <input type="file" class="custom-file-input" name="sub_image" id="sub_image" >
                        <label class="custom-file-label" for="exampleInputFile" style="top: 31px;">Choose file</label>
                      </div>
          
          </div>  
                  
              <div class="col-md-6">
                <div class="card-body pad">
              <div class="mb-3">
                <textarea class="textarea" name="sub_titile" style="width: 100%; height: 200px; font-size: 14px; line-height: 18px; border: 1px solid #dddddd; padding: 10px;"><?php echo $upd_value['sub_titile']; ?></textarea>
              </div>
            </div>
           
            </div>
       
         
                </div>
                </div>

                <div class="card-footer">
                  <button type="submit" name="upd_slider" class="btn btn-primary">Update</button>
                  <a href="annual_services.php" class="btn btn-default" type="button">Cancel</a>
                </div>
              </form>
            </div>
            
            <?php } ?>
            
              <div class="card">
            <div class="card-header">
              <h3 class="card-title">View Content</h3>
            </div>
            <!-- /.card-header -->
            <div class="card-body">
              <table id="example1" class="table table-bordered table-striped">
                <thead>
                <tr>
                  <th>S.No</th>
                  <th>Image</th>
                  <th>Title</th>
                  <th>Content</th>
                  <th>Image</th>
                  <th>Content</th>
                  <th>Action</th>
                </tr>
                </thead>
                <tbody>
                <?php 
                $banner_slider=mysqli_query($con,"select * from annual_services 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['pro_img']; ?>" style="width:200px;height:80px;"></td>
                     <td><?php echo $banner_row['Titile']; ?></td>
                  <td><?php echo $banner_row['Content']; ?></td>
                  <td><?php echo $banner_row['sub_titile']; ?></td>
                  <td><img src="../img/alliance/<?php echo $banner_row['sub_image']; ?>" style="width:200px;height:80px;"></td>
                  <td><a href="annual_services.php?edit=<?php echo $banner_row['Id']; ?>" class="btn btn-app"><i class="fa fa-edit"></i> Edit</a>&nbsp;
                  </td>
                </tr>
                <?php $i=$i+1; } ?>
                </tbody>
                <tfoot>
                <tr>
                  <th>S.No</th>
                  <th>Image</th>
                  <th>Title</th>
                  <th>Content</th>
                  <th>Image</th>
                  <th>Content</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>
<!-- Bootstrap 4 -->
<script src="plugins/bootstrap/js/bootstrap.bundle.min.js"></script>
<!-- FastClick -->
<script src="plugins/fastclick/fastclick.js"></script>
<!-- AdminLTE App -->
<script src="dist/js/adminlte.min.js"></script>
<!-- AdminLTE for demo purposes -->
<script src="dist/js/demo.js"></script>
<!-- CK Editor -->
<script src="plugins/ckeditor/ckeditor.js"></script>
<!-- Bootstrap WYSIHTML5 -->
<script src="plugins/bootstrap-wysihtml5/bootstrap3-wysihtml5.all.min.js"></script>

<script>
  $(function () {
    $("#example1").DataTable();
  });
</script>

<script>
  $(function () {
    // Replace the <textarea id="editor1"> with a CKEditor
    // instance, using default configuration.
    ClassicEditor
      .create(document.querySelector('#editor1'))
      .then(function (editor) {
        // The editor instance
      })
      .catch(function (error) {
        console.error(error)
      })

    // bootstrap WYSIHTML5 - text editor

    $('.textarea').wysihtml5({
      toolbar: { fa: true }
    })
  })
</script>

</body>
</html>