HRMS/confirm_bootform3b2.php at master · essnine/HRMS · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
<?php
session_start();
include_once('include/Connection.php');

//Fetching Values from URL
$title=mysqli_real_escape_string($conn,$_POST['title']);
$organiser=mysqli_real_escape_string($conn,$_POST['organiser']);
$type=mysqli_real_escape_string($conn,$_POST['type']);
$date=mysqli_real_escape_string($conn,$_POST['date']);
$username=mysqli_real_escape_string($conn,$_SESSION['user']);
//Insert query

$count_query=mysqli_query($conn,"SELECT COUNT(*) as total FROM `bootform3b2` WHERE `username`='$username'");
$count=mysqli_fetch_assoc($count_query);

$count1=$count['total']+1;
$sttprecog = $username.'_sttpa_'.$count1;
$query ="INSERT INTO `bootform3b2`(`title`,`organiser`
,`type`,`date`,`username`,sttprecoga) VALUES ('$title', '$organiser', '$type',
'$date','$username','$sttprecog')";
	//	echo $query;
//echo $_SESSION['user'];
		$result=mysqli_query($conn,$query) or die("Error Inserting Data".mysqli_error($conn));

		if($query){
			Print 'Details Saved Successfully!'; //Prompts the user
		}
else
		{
			Print 'Contact Server admin'; //Prompts the user
			Print '<script>window.location.assign("bootform2.php");</script>'; // redirects to login.php
		}

?>