}
} else {
$ret = mysqli_query($con, "update login set login_date='" . date('Y-m-d') . "',count=0 where email='" . $_SESSION['email'] . "'");
}
echo "<center><br /><br/><br /><br /><h2>Complaint added Successfully.....Redirecting</h2></center>";
$ret = mysqli_query($con, "update login set count=count+1 where email='" . $_SESSION['email'] . "'");
$q1 = "select roomno from registration where regno = '" . $_SESSION['roll'] . "'";
$ret = mysqli_query($con, $q1) or die("Error in execution");
$row = mysqli_fetch_array($ret);
$room = $row['roomno'];
$name = $_SESSION['name'];
$q = $mysqli->prepare("insert into complaints(category, roomno, details, name, comp_type,comp_date) values (?,?,?,?,?,?)");
$q->bind_param('ssssss', $cat, $roomno, $det, $nam, $type, date('Y-m-d H:i:s'));
$cat = $_SESSION['type'];
$roomno = $room;
$det_with_comma = string_validate($_SESSION['msg']);
$det = str_replace(",", ";", $det_with_comma);
$nam = $name;
if ($roomno == "Mess") {
$type = "Mess";
} else {
$type = $_SESSION['level'];
}
$q->execute();
//echo $q->error." ".$q->affected_rows;
unset($_SESSION['type']);
unset($_SESSION['msg']);
unset($_SESSION['level']);
echo "<script> setTimeout(function(){document.location.assign('complaint.php')}, 2000)</script>";
}
?>
</form>
</div>
</section>
<?php
if ($count > 2) {
echo "hello";
}
?>
<?php
if (isset($_POST['name']) && isset($_POST['email']) && isset($_POST['message'])) {
$stmt = $mysqli->prepare('insert into contact(name, email, message) values (?,?,?)');
$stmt->bind_param('sss', $name, $email, $msg);
$name = string_validate($_POST['name']);
$email = string_validate($_POST['email']);
$msg = string_validate($_POST['message']);
$stmt->execute();
$to = $_POST['email'];
$subject = "Regarding your Feedback/Request at Hostel-J online portal";
$message = "We have received your feedback/request. Its being processed and we will get back to you as soon as possible.";
$headers = "From:Hostel-J<*****@*****.**>";
mail($to, $subject, $message, $headers);
$to = "*****@*****.**";
$subject = "New request or feedback";
$message = "Name = " . $_POST['name'] . " Email = " . $_POST['email'] . " Message = " . $_POST['message'];
$headers = "From:" . $_POST['name'] . "<" . $_POST['email'] . ">";
mail($to, $subject, $message, $headers);
}
?>
<!-- Footer -->
</select>
</div>
</div>
<div class="row uniform">
<div class="12u">
<ul class="actions align-center">
<li><input type="submit" value="Add Category" /></li>
</ul>
</div>
</div>
</form>
</div>
</section>
<?php
if (isset($_REQUEST['category']) && isset($_REQUEST['level'])) {
$q = $mysqli->prepare("insert into category (category, level) values (?,?)");
$q->bind_param('ss', $category, $level);
$category = string_validate($_REQUEST['category']);
$level = $_REQUEST['level'];
$q->execute();
}
?>
<!-- Footer -->
<?php
require_once "footer.php";
?>
</body>
</html>
