Viewing file:  enroll_action_new.php (5.82 KB) -rw-rw-r--
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?php
require 'connection.php';
$responseMessage = $_POST["msg"];
$dataP = explode('|',$responseMessage);
$user_id1 = $saveP['user_id'] = $dataP['17']; //user id
$email1 = $saveP['application_id'] = $dataP['16']; //application id
$saveP['customer_id'] = $dataP['1']; //customer id
$txn_reference_no = $saveP['txn_reference_no'] = $dataP['2']; //transaction reference number
$bank_reference_no = $saveP['bank_reference_no']= $dataP['3']; // bank reference number
$txn_amount = $saveP['txn_amount'] = $dataP['4'];
$bank_id = $saveP['bank_id'] = $dataP['5'];
$bank_merchand_id = $saveP['bank_merchand_id'] = $dataP['6'];
$txn_type = $saveP['txn_type'] = $dataP['7'];
$currency_name = $saveP['currency_name'] = $dataP['8'];
$item_code = $saveP['item_code'] = $dataP['9'];
$security_type = $saveP['security_type'] = $dataP['10'];
$security_id = $saveP['security_id'] = $dataP['11'];
$security_password = $saveP['security_password']= $dataP['12'];
$txn_date = $saveP['txn_date'] = $dataP['13'];
$auth_status = $saveP['auth_status'] = $dataP['14']; //succccess and failure
$phone = substr($saveP['customer_id'], 11);
list($a, $b) = explode($phone, $email1);
$email=$a; // "5"
$fname=$b; // "8"
$user_id1;
list($a1, $b1) = explode($phone, $user_id1);
$user_id=$a1; // "5"
$course_id=$b1; // "8"
//save payment data in database....
if($saveP['auth_status']=='0300')
{
//show success message
echo"success";
$fname = $fname;
$phone = $phone;
$email = $email;
$course_id = $course_id;
$result = $con->query("SELECT * FROM course_details WHERE id='" . $course_id . "'");
$row = $result->fetch_assoc();
$course = $row['name'];
$amount = $txn_amount;
$pay = 'Billdesk';
$message = 'test';
/* MAIL TO ADMIN */
//$to = "athirasurendran.sics@gmail.com";
$to = 'srishticampusteam@srishtis.com';
//$to ="srishticampusteam@srishtis.com";
$subject = "Srishti-Enrollment Info";
$headers = 'MIME-Version: 1.0' . "\r\n";
$headers .= 'Content-type: text/html; charset=iso-8859-1' . "\r\n";
$headers .= 'From: Srishti <srishticampusteam@gmail.com>' . "\r\n";
$output = "<div style='font-size:15px;border-style: outset;'><table style='margin-left:40px;'><tr><td><caption><h4>New Candidate Details</h4></caption></td></tr><tr><td>Name:</td><td>" . $fname . " </td></tr><tr><td>Phone:</td><td>" . $phone . "</td></tr><tr><td>Email:</td><td>" . $email . "</td></tr><tr><td>Course:</td><td>" . $course . "</td></tr><tr><td>Payment:</td><td>" . $pay . "</td></tr><tr><td>Amount:</td><td>" . $amount . "</td></tr><tr><td>Message:</td><td>" . $message . "</td></tr></table></div></br>";
/* MAIL TO ADMIN */
$sql = "insert into enrolldetails(user_id,course_id,course,amount,paymethod,message,paymentstatus) values('$user_id','$course_id','$course','$amount','$pay','$message','Completed')";
$result = $con->query($sql);
$lastid = $con->insert_id;
$count = $con->affected_rows;
if ($count > 0) {
$i=1;
/* MAIL TO USER */
$to1 = $email;
$subject1 = "Srishti-Enrollment Info";
$headers1 = 'MIME-Version: 1.0' . "\r\n";
$headers1 .= 'Content-type: text/html; charset=iso-8859-1' . "\r\n";
$headers1 .= 'From: Srishti <srishticampusteam@gmail.com>' . "\r\n";
$output1 = "<div style='font-size:15px;border-style: outset; padding:10px;'> Dear User,<br><br>
Thank you for choosing Srishti Campus. We have received your Course package purchase request on our portal srishticampus.com <br><br>
Request Number : SICS ".$i++."".$lastid."<br><br>
A confirmation message will be sent on completion of the registration process.<br><br>
Thank you,<br>
Srishti Campus Team
</div>";
$sql123="insert into tb_payment_s2s(user_id,course_id,course,email,phone,txn_reference_no,bank_reference_no,txn_amount,bank_id,bank_merchand_id,txn_type,currency_name,item_code,security_type,security_id,security_password,txn_date,auth_status) values('$user_id','$course_id','$course','$email','$phone','$txn_reference_no','$bank_reference_no','$txn_amount','$bank_id','$bank_merchand_id','$txn_type','$currency_name','$item_code','$security_type','$security_id','$security_password','$txn_date','$auth_status')";
$result123 = $con->query($sql123);
$lastid123 = $con->insert_id;
/* MAIL TO USER */
header("Location:enroll.php?id=$course_id&s=Success&l=$lastid");
$sent = mail($to, $subject, $output, $headers);
$sent1 = mail($to1, $subject1, $output1, $headers1);
}
else {
header("Location:enroll.php?Failed");
}
}
else if($saveP['auth_status']=='0399')
{
//show failure message....
header("Location:enroll.php?Failed");
}
?>
|