RTI_Automation/index.php at master · codeb1ooded/RTI_Automation · 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
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
<?php
	if(!isset($_SESSION)) {
		session_start();
	}
	$_SESSION['database_access'] = true;

	include 'db/config_database.php';

	$_SESSION['database_access'] = false;
	$result = 'No';

	// Php code to check validation of entered username and password
	if(isset($_POST['submit'])){
		if($_SERVER["REQUEST_METHOD"] == "POST") {
			$myusername = mysqli_real_escape_string($con, $_POST['username']);
			$password = mysqli_real_escape_string($con, $_POST['password']);
			$mypassword = hash('sha256', $password);

			// If username or password is empty tell user,
			if($myusername == '' || $mypassword == ''){
				$result = 'empty';
			}
			else {
				// Access database to check if entered login username and password exist
				$sql = "SELECT Account_type, DEPARTMENT FROM login WHERE name = '$myusername' and password = '$mypassword'";
				$result = mysqli_query($con, $sql);
				$row = mysqli_fetch_array($result, MYSQLI_ASSOC);
				$count = mysqli_num_rows($result);

				// If result matched $myusername and $mypassword, table row must be 1 row
				if($count == 1) {
					$_SESSION['user_name'] = $myusername;
					$_SESSION['login_access'] = $row['Account_type'];
					$_SESSION['department'] = $row['DEPARTMENT'];
					$result = 'Yes';
					// Redirect to select_option page
					header("location: select_option.php");
				}
				else {
					// Username & password are incorrect
					$result = 'incorrect';
				}
			}
		}
	}
?>


<html>
   <head>
		<meta charset="UTF-8">
		<title> Login </title>
		<link rel='stylesheet prefetch' href='http://maxcdn.bootstrapcdn.com/font-awesome/4.2.0/css/font-awesome.min.css'>
		<link rel="stylesheet" href="bootstrap/css/bootstrap.min.css">
		<link rel="stylesheet" href="css/style.css">
		<link rel="stylesheet" href="css/a.css">
		<script src="bootstrap/js/bootstrap.min.js"></script>
		<script type="text/javascript">

			function fpassoverlay(){
				alert("Please Contact Admin");
			}
			// Reset message in html if user click either username or password element
			window.onload = function(){
				document.getElementById('username').onclick = function(){
					document.getElementById("message").innerHTML="";
				}
				document.getElementById('password').onclick = function(){
					document.getElementById("message").innerHTML="";
				}
			}

			//On clicking button demo table is shown
			function show_demo_table() {
				var x = document.getElementById('Demo_Table');
				if (x.style.display === 'none') {
				   											x.style.display = 'block';
				}

				else {
															x.style.display = 'none';
							  }
				}

		</script>
	</head>
	<body>
	<div class="container">
		<br>
		<h2>RTI APPLICATION SYSTEM</h2><br>
			<div class="form">
				<form  method="post" action="">
					<div class="form-group">
						<input type="text" class="form-control" placeholder="Username " id="username" name="username">
						<i class="fa fa-user"></i>
					</div>

					<!-- Html to show login form -->
					<div class="form-group log-status">
						<input type="password" class="form-control" placeholder="Password" id="password" name="password">
						<i class="fa fa-lock"></i>
					</div>

					<button class="btn btn-log" type='submit' name ='submit' value='Log in' >Log in</button>
				</form>
				<button class="btn btn-log" id="fpass" onclick="fpassoverlay()"> Forgot Password?</button>

			</div>
				<br>
				<br>

				<div class="demo" style="position: absolute; right: 120; top: 10; width: 200px; height: 100px;">
				<!--Showing Demo table-->
				<div class="btn btn-log" id="button_demo" onclick="show_demo_table()" value='Demo Table for Login'>Demo Table for Login</div>

				<div id="Demo_Table" style="display:none">
					<img src ="table/demo.png" alt='Demo Table'></img>
				</div>
			</div>

	</div>

	<?php
		// Set message as per mistake in username & password
		if($result == 'incorrect'){
			echo '<script type="text/javascript"> document.getElementById("message").innerHTML="Wrong Username or Password"; document.getElementById("message").style.color = "#ff0000";</script>';
		}
		if($result == 'empty'){
			echo '<script type="text/javascript"> document.getElementById("message").innerHTML="Empty Username & Password"; document.getElementById("message").style.color = "#ff0000";</script>';
		}
	?>

	</body>
</html>