query($sql) === TRUE) { $merchant_ID = 'bicycletown'; //THIS NEED TO CHANGE $verify_key = '59376789d94b88fcafc9e3ffd80ad9be'; // THIS NEED TO CHANGE $vcode = md5($fees.$merchant_ID.$order_id[0].$verify_key); $event_title="JKSB RIDE 2015"; $return['order_id']=$order_id[0]; $return['result']=200; $return['fee']=$fees; $return['full_name']=$full_name[0]; $return['email']=$email[0]; $return['mobile']=$mobile_phone[0]; $return['event_title']=$event_title; $return['vcode']=$vcode; } else { $return['sql']=$sql; $return['result']=500; } $conn->close(); echo json_encode($return); ?>