Braibravies
New Member
Hi i have a booking system , which pulls data from AES encrypted database. in the data base the postcode and the destination is encrypted, used to have an old script with list input, so users can select their destination on the list, since the destination list is getting big, i wanted to do a form in which users type in few letters and the destination comes up using ajax auto-fill. the problem i have is, its pulling, data as Encrypted. the first booking script had this line to decrypt\[code\]$areafro = mysql_query("select AREA_NO, AES_DECRYPT(POSTCODE, 'qsi') as POSTCODE, AES_DECRYPT(AREA_NM, 'qsi') as AREA_NM from area_mst where AES_DECRYPT(POSTCODE, 'qsi') LIKE '$char%' group by POSTCODE");\[/code\]this is the new booking script code\[code\]if(isset($_GET['areas']) && isset($_GET['letters'])){$letters = $_GET['letters'];$letters = preg_replace("/[^a-z0-9 ]/si","",$letters);$res = mysql_query("select POSTCODE,AREA_NM from area_mst where (POSTCODE like '".$letters."1' or AREA_NM like '".$letters."1') order by AREATYPE") or die(mysql_error();while($inf = mysql_fetch_array($res)){ if($inf["POSTCODE"]!='') { echo $inf["POSTCODE"]."-".$inf["AREA_NM"]."|"; } else { echo $inf["AREA_NM"]."|"; }} \[/code\]could some one help me to how to get data decrypted ?