if ($cat2 != "") { $sql .= " AND rad_category2 = '{$cat2}'"; } if ($cat3 != "") { $sql .= " AND rad_category3 = '{$cat3}'"; } if ($cat4 != "") { $sql .= " AND rad_category4 = '{$cat4}'"; } $res = mysqli_query($con, $sql); if ($res) { $dataArray = array(); if (mysqli_num_rows($res) > 0) { $tempArr = array(); while ($resRow = mysqli_fetch_array($res)) { $rad_kod = $resRow['rad_kod']; $rad_category1 = trim($resRow['rad_category1']); $rad_category2 = trim($resRow['rad_category2']); $rad_category3 = trim($resRow['rad_category3']); $rad_category4 = trim($resRow['rad_category4']); $rad_desc = trim($resRow['rad_desc']); $rad_no = trim($resRow['rad_no']); $atcCode = $rad_category1 . $rad_category2 . $rad_category3 . $rad_category4 . $rad_no; $level4 = getATCLevel4($rad_category1, $rad_category2, $rad_category3, $rad_category4); $tempArr = array("rad_kod" => $rad_kod, "ATCCode" => $atcCode, "level4" => $level4, "rad_desc" => $rad_desc); array_push($dataArray, $tempArr); } } } echo json_encode($dataArray); }
<?php if (isset($_POST['atcCode'])) { include 'connection_pure.php'; include 'function.php'; $atcCode = $_POST['atcCode']; if (!empty($atcCode) || $atcCode != null || $atcCode != "") { // 0 12 3 4 56 // V 01 A A 10 $part1 = substr($atcCode, 0, 1); $part2 = substr($atcCode, 1, 2); $part3 = substr($atcCode, 3, 1); $part4 = substr($atcCode, 4, 1); $part5 = substr($atcCode, 5, 2); // rad_no // echo "part1: $part1, part2: $part2, part3: $part3, part4: $part4, part5: $part5"; $sql = "SELECT rad_desc\n\t\t\t\tFROM ref_atc_detail\n\t\t\t\tWHERE rad_category1 = '{$part1}'\n\t\t\t\tAND rad_category2 = '{$part2}'\n\t\t\t\tAND rad_category3 = '{$part3}'\n\t\t\t\tAND rad_category4 = '{$part4}'\n\t\t\t\tAND rad_no = '{$part5}'"; $res = mysqli_query($con, $sql); $addrs = array(); if ($res) { if (mysqli_num_rows($res) > 0) { $row = mysqli_fetch_array($res); $rad_desc = $row['rad_desc']; $level4 = getATCLevel4($part1, $part2, $part3, $part4); echo $level4 . ":\n" . $rad_desc; } } } }