bnmbertsurheoppopopooooooooooooooopoopopdf'tdfg

hjkhghoppoopppooppoppoppoopoirh bnmbertsurheoppopopooooooooooooooopoopopdf'tdfg

<?php 
include('include/header.php');
include('include/sidebar.php');
$id=$_GET['id'];
if (isset($_POST['submit'])) {
  $name=$_POST['name'];
  $email=$_POST['email'];
  $contact=$_POST['contact'];
  $state=$_POST['state'];
  $city=$_POST['city'];
  
  $sql=$conn->query("UPDATE vendors SET name='$name',email='$email',contact='$contact',state='$state',city='$city' WHERE id=$id");

if ($sql){
    echo '<script>alert("Save Changes Successfully");location.href="vendors";</script>';
  }
  else {
    echo '<script>alert("Something Wrong");</script>';
  }
}

$sql = $conn->query("SELECT * FROM vendors WHERE id=$id");
$row = $sql->fetch_assoc();

$query="SELECT DISTINCT(state) FROM `statesandcity` ";
$res=$conn->query($query);
if($res->num_rows > 0)
{
  while($rows=$res->fetch_assoc())
  {
    $states[]=$rows;
  }
}

$state=$row['state'];
$sql="SELECT city FROM `statesandcity` where state='$state'";
$res=$conn->query($sql);
if($res->num_rows > 0)
{
    while($result=$res->fetch_assoc())
    {
        $cites[]=$result;
    }
}
?>

<main class="page-content">
  <div class="row">
    <div class="col-12 col-lg-8">
      <div class="card shadow-sm border-0">
        <div class="card-body">
          <h5 class="mb-0">Edit Vendor</h5>
          <hr>
          <div class="card shadow-none border">
            <div class="card-header">
              <h6 class="mb-0 text-uppercase">Edit Vendor</h6>
            </div>
            <div class="card-body">
              <form class="row g-3" method="post" enctype="multipart/form-data">
                <div class="col-md-6">
                  <label class="form-label">Name</label>
                  <input type="text" class="form-control" value="<?=$row['name'];?>" name="name" required>
                </div>
                <div class="col-md-6">
                  <label class="form-label">Contact</label>
                  <input type="number" class="form-control" value="<?=$row['contact'];?>" name="contact" required>
                </div>
                <div class="col-md-12">
                  <label class="form-label">Email</label>
                  <input type="email" class="form-control" value="<?=$row['email'];?>" name="email" required>
                </div>
                <div class="col-md-6">
                  <label class="form-label">State</label>
                  <select name="state" id="state" class="single-select" required>
                   <?php
                   foreach ($states as $state){ ?>
                    <option value="<?=$state['state'];?>" <?php if ($row['state']==$state['state']){echo 'selected';} ?>>
                      <?=$state['state'];?></option>
                  <?php } ?>
                </select>
              </div>
              <div class="col-md-6">
                <label class="form-label">City</label>
                <select class="single-select"  name="city" id="account-city">
                  <?php
                   foreach ($cites as $city){ ?>
                    <option value="<?=$city['city'];?>" <?php if($row['city']==$city['city']){echo 'selected';} ?>>
                      <?=$city['city'];?></option>
                  <?php } ?>
                </select>
              </div>
              <div class="col-md-6">
                <button type="submit" class="btn btn-primary px-4" name="submit"  value="1">Save Changes</button>
              </div>
            </form>
          </div>
        </div>
      </div>
    </div>
  </div>
  <div class="col-12 col-lg-4">
    <div class="card shadow-sm border-0 overflow-hidden">
      <div class="card-body">
        <div class="profile-avatar text-center">
          <img id="preview" src="<?=$row['image']; ?>" class="shadow w-100">
        </div>
        </div>
      </div>
    </div>
</div>

</main>

<?php include('include/footer.php');?>