1#@!#!123s

: / home / schoolcampuserp / dpsgsitamarhi.co.in / api / app_api /

Filename : get_discount_test.php

back

<?php
include 'connection.php';
$student_session_id = $_POST['student_session_id'];
$query_discount = "SELECT student_fees_discounts.id, student_fees_discounts.student_session_id, student_fees_discounts.status, student_fees_discounts.payment_id, student_fees_discounts.description as student_fees_discount_description, student_fees_discounts.fees_discount_id, fees_discounts.name, fees_discounts.code, fees_discounts.amount, fees_discounts.description, fees_discounts.session_id FROM student_fees_discounts JOIN fees_discounts ON fees_discounts.id = student_fees_discounts.fees_discount_id WHERE student_fees_discounts.student_session_id = " . $student_session_id . " ORDER BY student_fees_discounts.id LIMIT 1";

$result_discount = $con->query($query_discount);
$row_discount = $result_discount->fetch_assoc();

$discount = $row_discount['amount'];

echo "Discount Amount: " . $discount;

?>