PK!A7��n 0) { while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) { $data[] = $row; } return $data; } else { return null; } } else { return null; } } function getPendingTransactions() { $link = connectDB(); $query = "select * from payments where status=1 "; $d = getData($query, $link); mysqli_close($link); if (null != $d) { return $d; } else { return false; } } function paymentStatusUpdate($status, $transactionId) { $link = connectDB(); $status = mysqli_real_escape_string($link, $status); $transactionId = mysqli_real_escape_string($link, $transactionId); $query = "UPDATE payments set status=$status where reference_id= '$transactionId'"; mysqli_query($link, $query); mysqli_close($link); return true; } function addAccountCredits($userId, $quantity) { $link = connectDB(); $userId = mysqli_real_escape_string($link, $userId); $quantity = mysqli_real_escape_string($link, $quantity); $query = "UPDATE account_credits set sms=sms+$quantity where user_id=$userId"; mysqli_query($link, $query); mysqli_close($link); return true; }