Viewing file:  sendStudentRequest.php (1.93 KB) -rw-rw-r--
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?php
require("connection.php");
include 'functions.php';
session_start();
$request_type = $_POST["request_type"];
$course = $_POST["course"];
$date = $_POST["date"];
$message = $_POST["message"];
if($request_type=='1')
{
$subject="New Leave Request";
}
else{
$subject="New Class Change Request";
}
$userid=$_SESSION['user_id'];
$result = $con->query("SELECT * FROM student_requests WHERE student_id=$userid and course_id=$course and requested_date='$date' and request_type='$request_type' ");
if($result->num_rows ==0){
$sql1="INSERT into student_requests(student_id,course_id,requested_date,message,request_type,approve_status) VALUES ('$userid','$course','$date','$message','$request_type','0') ";
$result1=$con->query($sql1);
$packages = $con->query("SELECT name FROM course_details where id=$course");
$row1 = mysqli_fetch_assoc($packages);
$to = 'srishticampusteam@srishtis.com';
// $to = 'jisha.sics@gmail.com';
$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".
'X-Mailer: PHP/' . phpversion();
$output = "<div style='font-size:15px;border-style: outset;'>"
. "<table style='margin-left:40px;'>"
. "<tr><td><caption><h4>".$subject."</h4></caption></td></tr>"
. "<tr><td>Name:</td><td>".$_SESSION['user_name']." </td></tr>"
. "<tr><td>Message:</td><td>".$message."</td></tr>"
. "<tr><td>Date:</td><td>".date("d-m-Y",strtotime($date))."</td></tr>"
. "<tr><td>Course:</td><td>".$row1['name']."</td></tr></table></div></br>";
mail($to,$subject,$output,$headers);
echo 1;
}else{
echo 0;
}
?>
|