public function saveDonationInfo($donationDetail) { try { $sql = "INSERT INTO ngo_donation(campaign_id, donationAmount, email,postDate)\n\t\t\t\t\t\t\tVALUES \n\t\t\t\t\t\t\t(\n\t\t\t\t\t\t\t '" . $donationDetail->getCampaignId() . "',\n\t\t\t\t\t\t\t '" . $donationDetail->getDonationAmount() . "',\n\t\t\t\t\t\t\t '" . $donationDetail->getEmail() . "',\n\t\t\t\t\t\t\t '" . $donationDetail->getDonationPostDate() . "'\n\t\t\t\t\t\t\t )"; $isInserted = mysqli_query($this->con, $sql); if ($isInserted) { $this->data = "DONATION_DETAILS_SAVED_SUCCESSFULLY"; $SqlDonationDetails = "SELECT c.campaign_id,c.campaignName,c.email as ngoOwnerEmail,\n\t\t\t\t\t\t\t\t\t\t\t\t\tud.ngo_name,\n\t\t\t\t\t\t\t\t\t\t\t\t\tnd.donationAmount, nd.postDate as donation_Date,\n\t\t\t\t\t\t\t\t\t\t\t\t\tu.id as userId, u.name as donarName, u.email as donarEmail,u.mobileno as donarMobileNo\n\t\t\t\t\t\t\t\t\t\t\t\t\tFROM campaign c\n\t\t\t\t\t\t\t\t\t\t\t\t\tINNER JOIN userDetails ud\n\t\t\t\t\t\t\t\t\t\t\t\t\tON c.email=ud.email\n\t\t\t\t\t\t\t\t\t\t\t\t\tINNER JOIN ngo_donation nd\n\t\t\t\t\t\t\t\t\t\t\t\t\tON c.campaign_id = nd.campaign_id\n\t\t\t\t\t\t\t\t\t\t\t\t\tINNER JOIN userDetails u\n\t\t\t\t\t\t\t\t\t\t\t\t\tON u.email = nd.email \n\t\t\t\t\t\t\t\t\t\t\t\t\tWHERE c.campaign_id='" . $donationDetail->getCampaignId() . "'"; $result = mysqli_query($this->con, $SqlDonationDetails); $donationDetails = array(); while ($rowdata = mysqli_fetch_assoc($result)) { $donationDetails = $rowdata; } //print_r ($donationDetails); $campaign_id = $donationDetails['campaign_id']; $donation_Date = $donationDetails['donation_Date']; $donar_id = $donationDetails['userId']; $campaignName = $donationDetails['campaignName']; $ngoName = $donationDetails['ngoName']; $ngoOwnerEmail = $donationDetails['ngoOwnerEmail']; $donarName = $donationDetails['donarName']; $donarEmail = $donationDetails['donarEmail']; $donarMobileNo = $donationDetails['donarMobileNo']; $donationAmount = $donationDetails['donationAmount']; $objDonationEmailDetails = new DonationEmails(); $objDonationEmailDetails->SendDonationEmail($donation_Date, $donar_id, $campaign_id, $campaignName, $ngoName, $ngoOwnerEmail, $donarName, $donarEmail, $donarMobileNo, $donationAmount); } else { $this->data = "ERROR"; } //$this->data=array('donationDetails' => $donationDetails,'donationSave' => $response); } catch (Exception $e) { echo 'SQL Exception: ' . $e->getMessage(); } return $this->data; }