5SLhQgtc

1$product = strtolower($_POST["product"]);
2
3
4require_once ('db.php');
5$sql = "SELECT * FROM tbproduct WHERE product LIKE '$product'";
6
7$result = $conn->query($sql);
8if ($result->num_rows > 0) {
9    while ($row = $result->fetch_assoc()) {        {
10
11            $array = array(
12                'price' => $row["price"],
13                'sellprice' => $row["sellprice"],
14                );
15
16
17            echo json_encode($array);
18
19        }
20
21    }
22} else {
23    echo 'Data Not Found';
24}
25
26?>
27	
28CREATE TABLE IF NOT EXISTS `tbproduct` (
29  `id` INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
30  `product` varchar(30) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
31  `price` varchar(30) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
32  `sellprice` varchar(30) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL
33);