bnmbnmbnmnbmbio;io;irererereeo;o;oi;;oi;oioi;oi;oio;;oovn

hjkhhjhjol;io;ioio;ioiio;ioreererereio;;iooi;i;o;oii;o;ioo;iio;oi; bnmbnmbnmnbmbio;io;irererereeo;o;oi;;oi;oioi;oi;oio;;oovn

<?php
require_once "include/config.php";
if (isset($_POST['term'])) {
     $city=$_POST['term'];
     $type=$_POST['type'];
     $query = "SELECT packages.* FROM packages LEFT JOIN package_types ON package_types.id=packages.package_type_id WHERE city1 LIKE '{$city}%' AND type='$type'";
   // $query = "SELECT DISTINCT city1 FROM packages WHERE city1 LIKE '{$city}%' AND type=''";
    $result = mysqli_query($db, $query);
 
    if (mysqli_num_rows($result) > 0) {
     while ($user = mysqli_fetch_array($result)) { ?>
    <li><?php echo $user['city1']; ?></li>
    
<?php } } } ?>

<?php if (isset($_POST['from'])) {
     $from=$_POST['from'];
     $to=$_POST['to'];
     $type=$_POST['type'];
     $query = "SELECT packages.* FROM packages LEFT JOIN package_types ON package_types.id=packages.package_type_id WHERE city1 LIKE '{$from}%' AND city2 LIKE '{$to}%' AND type='$type'";
    $result = mysqli_query($db, $query);
 
    if (mysqli_num_rows($result) > 0) {
     while ($user = mysqli_fetch_array($result)) { ?>
    <li><?php echo $user['city2']; ?></li>
    
<?php } } } ?>

<?php
if (isset($_POST['city'])) {
  $city=$_POST['city'];
  $type=$_POST['type'];
  $query = "SELECT packages.* FROM packages LEFT JOIN package_types ON package_types.id=packages.package_type_id WHERE city1='$city' AND type='$type'";
    $result = mysqli_query($db, $query);
 
    if (mysqli_num_rows($result) > 0) {
     while ($city = mysqli_fetch_array($result)) { ?>
      <option value="<?php echo $city['city2']; ?>"><?php echo $city['city2']; ?></option>
   <?php } } } ?>