Online PHP editor | output for KRVFT

<?php // 1- connect to db require("DatabaseConfigegb1.php"); // define quesry //StartFrom $decrypted_txt = decrypt(str_replace(" ", "+",$_GET['number'])); // $decrypted_txt = str_replace(" ", "+",$_GET['number']); if( empty($decrypted_txt) ) { die("Error in number");} if( mb_substr($decrypted_txt, 0, 2)== "20"){ $decrypted_txtnew= substr_replace($decrypted_txt, "", 0, 2); }elseif (mb_substr($decrypted_txt, 0, 4)== "0020"){ $decrypted_txtnew= substr_replace($decrypted_txt, "", 0, 4); }elseif (mb_substr($decrypted_txt, 0, 3)== "020"){ $decrypted_txtnew= substr_replace($decrypted_txt, "", 0, 3); }elseif (mb_substr($decrypted_txt, 0, 1)== "0"){ $decrypted_txtnew= substr_replace($decrypted_txt, "", 0, 1); }else{ $decrypted_txtnew= $decrypted_txt; } $query="SELECT id as 'id' ,name as 'name', number as 'number', ' ' as 'addrass' FROM list_numbers WHERE MATCH(number,name) AGAINST('%" . $decrypted_txtnew. "') GROUP BY name UNION SELECT id as 'id' ,name as 'name', number as 'number', ' ' as 'addrass' FROM list_numbers WHERE MATCH(number,name) AGAINST('0" . $decrypted_txtnew . "') GROUP BY name UNION SELECT id as 'id' ,name as 'name', number as 'number', ' ' as 'addrass' FROM list_numbers WHERE MATCH(number,name) AGAINST('20" . $decrypted_txtnew . "') GROUP BY name UNION SELECT id as 'id' ,name as 'name', number as 'number', ' ' as 'addrass' FROM list_numbers WHERE MATCH(number,name) AGAINST('0020" . $decrypted_txtnew . "') GROUP BY name "; $query1="SELECT numberphone as 'id' ,name as 'name', numberphone as 'number', addrass as 'addrass' FROM list_numbers WHERE MATCH(numberphone,name) AGAINST('20" . $decrypted_txtnew . "') GROUP BY name "; $query2="SELECT id as 'id' ,name as 'name', number as 'number', ' ' as 'addrass' FROM list_numbers WHERE MATCH(number,name) AGAINST('0020" . $decrypted_txtnew . "') AND codecoutnry='EG' GROUP BY name "; $startTime = time(); $result= mysqli_query($connecteg1, $query); $result1= mysqli_query($connecteg2, $query1); $result2= mysqli_query($connect2, $query2); if(! $result && ! $result1 && ! $result2 ) { die("Error in query");} //get data from database $output=array(); while($row= mysqli_fetch_assoc($result)) { $output[]=escapeJsonString($row); //$row['id'] } while($row2= mysqli_fetch_assoc($result2)) { $output[]=escapeJsonString($row2); } while($row1= mysqli_fetch_assoc($result1)) { $output[]=escapeJsonString($row1); } $endTime = time(); if ($output) { print( "{". "'info':'". json_encode($output) ."'}");// this will print the output in json } else{ print("error"); } function encrypt($wordEnc) { $key16 = substr("egbti23456122313", 0, 16); $key16Hex = unpack('H*', $key16); return openssl_encrypt($word, 'AES-128-CBC', $key16, 0, hex2bin($key16Hex[1])); } function decrypt($wordDec) { $key16 = substr("egbti23456122313", 0, 16); $key16Hex = unpack('H*', $key16); return openssl_decrypt($wordDec, "AES-128-CBC", $key16, 0, hex2bin($key16Hex[1])); } function escapeJsonString($value) { $escapers = array( "\"", '\'',"+"); $replacements = array(" ", " ",""); $result = str_replace($escapers, $replacements, $value); return $result; } // 4 clear mysqli_free_result($result); //5- close connection mysqli_close($connecteg1); ?>