1#@!#!123s

file_get_contents 1#@!#!123s
: / home3 / wwwcraftenterpri / public_html / admin /
Filename : manage_clientele.php
back
<?php
  session_start();
  include('config.php');
  
  if(!isset($_SESSION['user'])){
    header("Location: index.php"); 
  }
  if(isset($_POST['client-name']) && isset($_FILES['client-logo']['name']) ){
    
    $client_name = mysqli_real_escape_string($conn,$_POST['client-name']);
    $client_logo = $_FILES['client-logo']['name'];
    $Insert_query = "INSERT INTO clientele (client_name,logo) VALUES ('$client_name', '$client_logo')";
    
    $conn->query($Insert_query);

    $target_file_logo =  $target_brand_logo . basename($_FILES["client-logo"]["name"]);
    move_uploaded_file($_FILES["client-logo"]["tmp_name"], $target_file_logo);
    $Sucess = true;
  }

  
  if(isset($_POST['delete'])){
    
    $value = $_POST['delete'];
    $Delete_query = "DELETE FROM clientele WHERE id = $value";
   
    
    $auto_increment = "ALTER TABLE clientele AUTO_INCREMENT = 1";
    
    $get_imagename_query  = "SELECT * from clientele WHERE id = $value";
    
    $result_banner_name = $conn->query($get_imagename_query);
    while($row = $result_banner_name->fetch_assoc())
    {
      $client_logo =  $row['logo'];
      $check_client_logo = "SELECT COUNT(logo) from clientele WHERE logo LIKE '$client_logo' ";
      $result_client_logo = $conn->query($check_client_logo);
      $client_logo_count = $result_client_logo->fetch_row();
      if($client_logo_count[0] <= 1){
        unlink($target_brand_logo . $row['logo']);
      }
     
    }
    $conn->query($Delete_query);
    $conn->query($auto_increment);
    $Delete_Sucess = true;
  }

?>
<html>
    <head>
      <title>Manage Clientele </title>
      <script src="http://code.jquery.com/jquery-1.11.1.min.js"></script>
      <link rel="stylesheet"  href="https://cdn.datatables.net/1.10.22/css/jquery.dataTables.min.css"></style>
      <script type="text/javascript" src="https://cdn.datatables.net/1.10.22/js/jquery.dataTables.min.js"></script>
      <link href="https://maxcdn.bootstrapcdn.com/font-awesome/4.6.3/css/font-awesome.min.css" rel="stylesheet" integrity="sha384-T8Gy5hrqNKT+hzMclPo118YTQO6cYprQmhrYwIiQ/3axmI1hQomh7Ud2hPOy8SP1" crossorigin="anonymous">
      <script src="https://cdnjs.cloudflare.com/ajax/libs/bootstrap-modal/2.2.6/js/bootstrap-modalmanager.min.js" integrity="sha512-/HL24m2nmyI2+ccX+dSHphAHqLw60Oj5sK8jf59VWtFWZi9vx7jzoxbZmcBeeTeCUc7z1mTs3LfyXGuBU32t+w==" crossorigin="anonymous"></script>
      <script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.0/js/bootstrap.min.js"></script>
      <link href = "./css/dashboard.css" rel = "stylesheet">
      <link href = "./css/main.css" rel = "stylesheet"> 
      <link rel="stylesheet" href="https://fonts.googleapis.com/icon?family=Material+Icons">
      <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.0/css/bootstrap.min.css">
          <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.0/css/bootstrap-theme.min.css">
          <link href="https://maxcdn.bootstrapcdn.com/font-awesome/4.6.3/css/font-awesome.min.css" rel="stylesheet" integrity="sha384-T8Gy5hrqNKT+hzMclPo118YTQO6cYprQmhrYwIiQ/3axmI1hQomh7Ud2hPOy8SP1" crossorigin="anonymous">
        
    </head>
    <body class="home">
      <div class="container-fluid display-table">
          <div class="row display-table-row">
              <div class="col-md-2 col-sm-1 hidden-xs display-table-cell v-align box" id="navigation">
                  <div class="navi">
                      <ul>
                        <li><br></li>
                        <li ><a href="manage_brands.php"><i class="fa fa-tasks" aria-hidden="true"></i><span class="hidden-xs hidden-sm">  Manage Brands</span></a></li>
                        <li ><a href="manage_products.php"><i class="fa fa-tasks" aria-hidden="true"></i><span class="hidden-xs hidden-sm">  Manage Products</span></a></li>
                        <li class = "active"  ><a href="manage_clientele.php"><i class="fa fa-user" aria-hidden="true"></i><span class="hidden-xs hidden-sm">  Manage Clientele</span></a></li>
                        <li><a href="change_details.php"><i class="fa fa-key" aria-hidden="true"></i><span class="hidden-xs hidden-sm">  Change Password</span></a></li>
                      </ul>
                  </div>
              </div>
              <div class="col-md-10 col-sm-11 display-table-cell v-align">
                  <div class="row">
                      <header>
                        <div class="brand_logo_dashboard">
                          <a href="dashboard.php"><img src="../images/logo_1.png" class="img-fluid" alt=""></a>
                        </div>
                        <div class="col-md-7">
                          <nav class="navbar-default pull-left">
                            <div class="navbar-header">
                              <button type="button" class="navbar-toggle collapsed" data-toggle="offcanvas" data-target="#side-menu" aria-expanded="false">
                                <span class="sr-only">Toggle navigation</span>
                                <span class="icon-bar"></span>
                                <span class="icon-bar"></span>
                                <span class="icon-bar"></span>
                              </button>
                            </div>
                          </nav>
                        </div>
                        <div class="col-md-5">
                          <div class="header-rightside">
                            <ul class="list-inline header-top pull-right">                                    
                              <li class="dropdown">    
                                <a href="index.php" class="view btn-sm active">Log out</a>  
                              </li>
                            </ul>
                          </div>
                        </div>
                      </header>
                  </div>
                  <div class="user-dashboard">
                   <div class="container">
                     <br>
                      <div class="col-lg-12">
                       <?php
                        if(isset($Sucess)){
                       ?>
                          <div class="alert alert-success alert-dismissible" role="alert">
                              Clientele has been added successfully
                              <button type="button" class="close" data-dismiss="alert" aria-label="Close">
                                <span aria-hidden="true">&times;</span>
                              </button>
                            </div>
                        <?php }
                        if(isset($Delete_Sucess)){
                        ?>  
                          <div class="alert alert-success alert-dismissible" role="alert">
                            Clientele deleted added successfully
                                <button type="button" class="close" data-dismiss="alert" aria-label="Close">
                                    <span aria-hidden="true">&times;</span>
                                </button>
                            </div>
                        <?php } ?>

                      <div class="section_title text-center">
                        <h2> Manage Clientele </h2 >
                      </div>
                    </div>
                    <form method = "POST" enctype="multipart/form-data" >
                      <div class="form-group">
                          <label for="email" >Client Name:</label>
                          <input type="text" class="form-control" id="text"  name="client-name">    
                      </div>
                      <div class="form-group">
                          <label for="brand-logo">Client logo:</label>
                          <input  class="form-control file_selector"   type="file" name="client-logo">    
                      </div>
                      <button type="submit" class="btn btn-lg deneb_btn">   Submit Now</button>
                    </form>
                  </div> 
                  <div class="modal " id="delete" role="dialog" aria-labelledby="edit" aria-hidden="true">
                    <div class="modal-dialog modal-confirm">
                      <div class="modal-content">
                        <div class="modal-header flex-column">
                          <div class="icon-box">
                            <i class="material-icons">&#xE5CD;</i>
                          </div>						
                          <h4 class="modal-title w-100">Are you sure?</h4>	
                          <button type="button" class="close" data-dismiss="modal" aria-hidden="true">&times;</button>
                        </div>
                      <div class="modal-body">
                      <p>Do you really want to delete these records? This process cannot be undone.</p>
                    </div>
                    <div class="modal-footer justify-content-center">
                      <form method = "POST" >
                        <button type="button" class="btn btn-secondary" data-dismiss="modal">Cancel</button>
                        <button type="submit" class="btn btn-danger" name = "delete" id  = "Delete_yes">Delete</button>
                      </form>
                    </div>
                  </div>
                </div>
              </div>
              <div class="container">
                <div class="row">
                  <div class="col-md-12">
                    <div class="table-responsive">
                      <table id="myTable" class="table table-striped">  
                        <thead>  
                          <tr>  
                            <th>Sr. no</th>  
                            <th>Client Name</th>  
                            <th>Actions</th>  
                          </tr>  
                        </thead>  
                        
                        <tbody>  
                          <?php 
                          $fetch_query = "SELECT * FROM clientele  ORDER BY id DESC ";
                          $result = $conn->query($fetch_query);
                          $id  = 0;
                          while($rows = $result->fetch_assoc())  
                            {
                          ?>
                            <tr>  
                              <td><?php echo ++$id ?></td>  
                              <td><?php echo $rows['client_name']; ?></td> 
                              <form  name = "myForm" method = "GET" action = "update_clientele.php">
                                <td><button   class="btn btn-primary btn-xs edit_btn" name = "edit" data-toggle="modal" data-target="#edit"   value = "<?php echo $rows['id']?>" ><span class="glyphicon  glyphicon-pencil"></span></button>
                                <button type = "button" class="btn btn-danger btn-xs Delete delete_btn" data-toggle="modal"   data-target="#delete"  value = "<?php echo $rows['id']?>" onclick="getid(this,'one')"><span class="glyphicon glyphicon-trash"></span></button></td>
                                </form>
                            </tr>  
                          <?php } ?>
                        </tbody>   
                      </table>      
                    </div>
                  </div>
              </div>          
          </div>
      </div>
      <script>
        $(document).ready(function(){
            $('#myTable').dataTable();
        });

          function preventsubmit() {
            event.preventDefault();
          };
          function getid(obj,value){
            var id = obj.value;
            document.getElementById("Delete_yes").value = id;
          }

        $('.openbtn').click(function() {
          $('.sidenav').toggleClass('active');
          $('.main').toggleClass('active');
        })
      </script>
    </body>
</html>