Below is my query. I have commented that I tried in code
$query = "SELECT SUM(paymentAmount) From salepayment WHERE adminUserId ='$adminUserId' AND invoiceId = '$salesInvoiceId' ";
                    $this->res = $this->db->prepare($query);
                    $this->result = $this->res->execute();
                    $countAmount = $this->res->rowCount();
                    if ($countAmount > 0) {
                        $sumOfPaymentAmount = $this->res->fetch(PDO::FETCH_OBJ);
                        echo json_encode($sumOfPaymentAmount);
                        // $totalPaid = $sumOfPaymentAmount->"SUM(paymentAmount)";
                        // echo json_encode($totalPaid);
                    }else{
                        $paid = 0;
                    }
Here is my response
{
    "SUM(paymentAmount)": "350"
}
I want to get this value into the $paid variable.
Thanks for your help. I am a beginner at PHP and server-side coding so pardon me for my mistakes.
Advertisement
Answer
This should be able to be done by adding as paid after SUM(paymentAmount) in the query like so:
SELECT SUM(paymentAmount) as paid From...