|
Server IP : 162.214.80.37 / Your IP : 216.73.216.83 Web Server : Apache System : Linux sh013.webhostingservices.com 4.19.286-203.ELK.el7.x86_64 #1 SMP Wed Jun 14 04:33:55 CDT 2023 x86_64 User : imyrqtmy ( 2189) PHP Version : 8.2.18 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON Directory (0755) : /home2/imyrqtmy/public_html/inventory/Ajax/ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
<?php
include("../include/db.php");
extract($_POST);
if (!empty($_POST["city"])) {
$query = "select * from tbl_item where wname ='$city'";
$res = mysqli_query($con, $query) or die(mysqli_error($con));
if (mysqli_num_rows($res) > 0) {
echo '<option value="">Select item</option>';
while ($row = mysqli_fetch_assoc($res)) {
echo '<option value="' . $row['id'] . '">' . $row['name'] . '</option>';
}
} else {
echo '<option value="">item not available</option>';
}
}
?>