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;
}
}
}
}
