$sql = "SELECT COUNT(*) AS rows FROM tbl_paypal WHERE `api_id` = '{$api_id}'"; $query = $this->conn->query($sql); $result = $query->fetch_object(); return $result; } function get_payment($api_id) { $sql = "SELECT * FROM tbl_paypal WHERE `api_id` = '{$api_id}'"; $query = $this->conn->query($sql); $result = $query->fetch_object(); return $result; } } $_ajax = new AJAX(); $ajx_id = filter_var($_POST['bank'], FILTER_SANITIZE_STRING); $count = $_ajax->count_payment(1); if ($count->rows > 0) { $bank = $_ajax->get_payment(1); $api_mode = $bank->api_mode; $api_username = $bank->api_username; $api_password = $bank->api_password; $api_signature = $bank->api_signature; $api_return_url = $bank->api_return_url; $api_cancel_url = $bank->api_cancel_url; $api_status = $bank->api_status; } else { $api_mode = ''; $api_username = ''; $api_password = ''; $api_signature = ''; $api_return_url = '';