include('conn.php'); if($_GET['url']==""){ }else{ //$table_name_path = $_GET['url']; $table_name_path = htmlentities($_GET['url'],ENT_QUOTES,"UTF-8"); #$table_name_path2 = current(explode('/',$table_name_path)); $sqlQry = "(SELECT* FROM menu WHERE fldTitlePath='".$table_name_path."' AND fldStatus='0' AND fldDel='0')"; //UNION //(SELECT* FROM tourist_places WHERE fldTitlePath='".$table_name_path."' AND fldStatus='0' AND fldDel='0') $result = mysqli_query($conn, $sqlQry); if(mysqli_num_rows($result)>0){ while($row = mysqli_fetch_array($result)){ if($row['fldPath']==''){ $img = 'logo.jpg'; }else{ $img = $row['fldPath']; } if($row['fldRPath']==''){ $img2 = 'logo.jpg'; }else{ $img2 = $row['fldRPath']; } $menu_fldId=$row['fldId']; $menu_fldCatId=$row['fldCatId']; $menu_fldTitlePath=$row['fldTitlePath']; $menu_fldTitlePath2=$row['fldTitlePath2']; $menu_fldName=$row['fldName']; $menu_fldDescription=$row['fldDescription']; $menu_fldShortDescription=$row['fldShortDescription']; $menu_fldPageTitle=$row['fldPageTitle']; $menu_fldMetaDes=$row['fldMetaDes']; $menu_fldMetaKey=$row['fldMetaKey']; $menu_fldTable=$row['fldTable']; $menu_fldView=$row['fldView']; } ////////// $sqlQry2 = "(SELECT* FROM menu WHERE fldId='".$menu_fldCatId."' AND fldStatus='0' AND fldDel='0')"; $result2 = mysqli_query($conn, $sqlQry2); while($row = mysqli_fetch_array($result2)){ $cat_fldCatId=$row['fldCatId']; $cat_fldTable=$row['fldTable']; $V_menu_fldName=$row['fldName']; //$menu_fldMetaDes2=$row['fldMetaDes']; //$menu_fldMetaKey2=$row['fldMetaKey']; }//white end }else{ $sqlQry = "(SELECT* FROM menu WHERE fldStatus='0' AND fldDel='0')"; $result = mysqli_query($conn, $sqlQry); while($row = mysqli_fetch_array($result)){ $menu_2_fldId = $row['fldId']; $find_table = $row['fldTable']; $menu_fldMetaDes=$row['fldMetaDes']; $menu_fldMetaKey=$row['fldMetaKey']; $sqlQry7 = "(SELECT* FROM $find_table WHERE fldTitlePath='$table_name_path' AND fldDel='0')"; $result7 = mysqli_query($conn, $sqlQry7); if(mysqli_num_rows($result7)>0){ $find_fldId = $row['fldId']; $find_fldCatId = $row['fldCatId']; $find_name = $row['fldName']; $find_fldTable = $row['fldTable']; $sqlQry8 = "(SELECT* FROM $find_fldTable WHERE fldTitlePath='$table_name_path' AND fldDel='0')"; $result8 = mysqli_query($conn, $sqlQry8); while($row = mysqli_fetch_array($result8)){ if($row['fldPath']==''){ $find_fldTable_img = 'logo.jpg'; }else{ $find_fldTable_img = $row['fldPath']; } if($row['fldRPath']==''){ $find_fldTable_img2 = 'logo.jpg'; }else{ $find_fldTable_img2 = $row['fldRPath']; } $path_fldId=$row['fldId']; $path_fldCatId=$row['fldCatId']; $path_fldSCatId=$row['fldSCatId']; $menu_fldTitlePath2=$row['fldTitlePath2']; $path_fldName=$row['fldName']; $path_fldShortDis=$row['fldShortDis']; $path_fldDescription=$row['fldDescription']; $path_fldView=$row['fldView']; $menu_fldMetaDes=$row['fldMetaDes']; $menu_fldMetaKey=$row['fldMetaKey']; } $sqlQry99 = "(SELECT* FROM menu WHERE fldId='$path_fldCatId' AND fldDel='0')"; $result99 = mysqli_query($conn, $sqlQry99); while($row = mysqli_fetch_array($result99)){ $menu_fldName=$row['fldName']; $menu_fldMetaDesV=$row['fldMetaDes']; $menu_fldMetaKeyV=$row['fldMetaKey']; } $sqlQry88 = "(SELECT* FROM menu WHERE fldId='$path_fldSCatId' AND fldDel='0')"; $result88 = mysqli_query($conn, $sqlQry88); while($row = mysqli_fetch_array($result88)){ $menu_fldName=$row['fldName']; $menu_fldMetaDesV=$row['fldMetaDes']; $menu_fldMetaKeyV=$row['fldMetaKey']; } //mysql_close($sqlQry7); }else{} } }//if else and } ?>