bnmbertsdfsdfgdfgdfgfffdgdfgdfgrtdfg

hjkhhrterwefdgdfgdfgdfgdgdfgdfgdsvstertrt bnmbertsdfsdfgdfgdfgfffdgdfgdfgrtdfg

<?php include_once 'session.php';
$d=$_GET["id"];
extract($_POST);
if(isset($sub))
  {
    
    $upload=$_FILES['pic']['name'];        
    $tmp_name=$_FILES['pic']['tmp_name'];

if(empty($upload))
    {
      $upload=$bef;
      $sql2 = $conn->query("UPDATE category SET cname='".$cname."',icon='".$upload."',`commision`='".$commision."',`refer`='".$refer."'  WHERE  cid='".$d."' ");

}
    else
    {
      $upload=rand(11111,99999).$upload;
      $sql2 = $conn->query("UPDATE category SET cname='".$cname."',icon='".$upload."',`commision`='".$commision."',`refer`='".$refer."'  WHERE  cid='".$d."' ");
      // unlink('icon/'. $bef);
      $moved= move_uploaded_file($tmp_name, "icon/".$upload);
    }

if($sql2)
    {
      echo "<script>";
      echo "alert('Update Successfully')";
      echo "</script>";
      echo"<script>window.location.href='catlist.php'</script>";
    }
    else
    {
      echo "<script>";
      echo "alert('Not Successfully')";
      echo "</script>";
    }
  }
  $sql = $conn->query("SELECT * FROM category WHERE cid=$d");
  if($sql)
  {
  $rw = $sql->fetch_row();
?>  
<!DOCTYPE html>
<html lang="en">

<head>

<title>Staff Registration</title>

<link href="vendor/fontawesome-free/css/all.min.css" rel="stylesheet" type="text/css">
  <link href="https://fonts.googleapis.com/css?family=Nunito:200,200i,300,300i,400,400i,600,600i,700,700i,800,800i,900,900i" rel="stylesheet">

<link href="css/sb-admin-2.min.css" rel="stylesheet">

<link href="vendor/datatables/dataTables.bootstrap4.min.css" rel="stylesheet">

</head>

<div id="wrapper">

<?php include_once 'header.php'; ?>

<div id="content-wrapper" class="d-flex flex-column">

<div id="content">

<?php include_once 'header.php'; ?>

<div class="container-fluid">

<div class="card shadow mb-4">
            <div class="card-header py-3">
              <h6 class="m-0 font-weight-bold text-primary">Update Category </h6>
            </div>
            <div class="card-body">
              <form  action="#"  method="post" enctype="multipart/form-data">
                  <div class="form-row">
                    <div class="form-group col-md-6">
                      <label for="inputEmail4">Category Name</label>
                      <input type="text" name="cname" class="form-control" id="inputEmail4" value="<?php echo $rw[1]; ?>">
                    </div>
                     <div class="form-group col-md-4">
                      <label for="inputPassword4">Image(20x20)</label>
                      <input type="file" name="pic" class="form-control" id="inputPassword4">
                      <input type="hidden" name="bef" class="form-control" id="inputPassword4" value="<?php echo $rw[2]; ?>">
                    </div>
                    <div class="form-group col-md-6">
                      <label for="inputEmail4">Commission(%)</label>
                      <input type="text" name="commision" class="form-control" id="inputEmail4" value="<?php echo $rw[4]; ?>">
                    </div>
                    <div class="form-group col-md-6">
                      <label for="inputEmail4">Refferal(%)</label>
                      <input type="text" name="refer" class="form-control" id="inputEmail4" value="<?php echo $rw[5]; ?>">
                    </div>
                  </div>
                <?php  } ?>  
                  <button type="submit" class="btn btn-primary" name="sub">Update</button>
                </form>
            </div>
          </div>

</div>

</div>

<?php include_once 'footer.php'; ?>

</div>

</div>

<a class="scroll-to-top rounded" href="#page-top">
    <i class="fas fa-angle-up"></i>
  </a>

<script src="vendor/jquery/jquery.min.js"></script>
  <script src="vendor/bootstrap/js/bootstrap.bundle.min.js"></script>

<script src="vendor/jquery-easing/jquery.easing.min.js"></script>

<script src="js/sb-admin-2.min.js"></script>

<script src="vendor/datatables/jquery.dataTables.min.js"></script>
  <script src="vendor/datatables/dataTables.bootstrap4.min.js"></script>

<script src="js/demo/datatables-demo.js"></script>

</body>

</html>