private $conn; function __construct() { $this->conn = new mysqli(DB_HOST, DB_USER, DB_PASS, DB_NAME); } function get_payment($post_payment_id) { $sql = "SELECT * FROM tbl_account WHERE id = '{$post_payment_id}'"; $query = $this->conn->query($sql); $result = $query->fetch_object(); return $result; } } $_ajax = new AJAX(); $ajx_id = filter_var($_POST['bank'], FILTER_SANITIZE_STRING); $bank = $_ajax->get_payment($ajx_id); } if (is_numeric($ajx_id)) { ?> <li class="form-group row" id="id-row-name"> <label class="control-label col-xs-3" for="">Bank Name</label> <div class="col-xs-9"> <input type="text" class="form-control" id="id-name" name="name" value="<?php echo $bank->account_bank; ?> "> <p class="help-block">The name of the bank, e.g. BCA, Mandiri</p> </div> </li>
$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 = ''; $api_cancel_url = ''; $api_status = 0;