Viewing file:  add_receipt_admin_action.php (1.31 KB) -rw-rw-r--
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?php
require 'connection.php';
$student_id=$_POST['student_name'];
$student_email=$_POST['student_email'];
$mobile_num=$_POST['mobile_num'];
$amount=$_POST['amount'];
$course_id=$_POST['course'];
$txn_type = $_POST['txn_type'];
$remarks=$_POST['remarks'];
$Payment_date=$_POST['Payment_date'];
// $query1 = "select * from course_details order by id desc";
$query1 = "select * from course_details where id='$course_id'";
$result1 = $con->query($query1);
while ($row1 = $result1->fetch_assoc()) {
$course= $row1["name"];
}
$sql = "INSERT INTO `tb_paymet`( `user_id`, `email`, `phone`, `txn_amount`,`course`,`course_id`,`txn_date`,`auth_status`,`txn_type`,`txn_reference_no`,`bank_reference_no`,`item_code`)
VALUES ('$student_id','$student_email','$mobile_num','$amount','$course','$course_id','$Payment_date','$remarks','$txn_type','test','test','test')";
$result=$con->query($sql);
$count=$con->affected_rows;
$last_id = $con->insert_id;
if ($count>0) {
echo json_encode(array("statusCode"=>$last_id));
}
else {
echo json_encode(array("statusCode"=>0));
}
?>
|