class-ified/infoinst.php at main · sreecharan-m/class-ified · 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
<?php


session_start();
$usr= $_SESSION['username'];
$conn=mysqli_connect('localhost','shaun','test1234','dproject');

$sql= "SELECT id,name,username,password,email,type FROM users WHERE username = '$usr'";

$result = mysqli_query($conn, $sql); //result set of rows
$data= mysqli_fetch_all($result, MYSQLI_ASSOC);
$name=($data[0]['name']);
$type=($data[0]['type']);

?>


<!DOCTYPE html>
<html>

<head>

<style type="text/css">


#middle {

 color: #000;
 font:20px Open Sans;
 margin: 20px;
 display: flex;
 flex-direction: column;

}
#type {

	margin-left: 5vw;
	padding: 1px 8px 5px 8px;
	background-color: #00bfff;
	color: #fff;
	font-weight: 900;
}

#top {

 color: #000;
 font:20px Open Sans;
 margin: 20px;
 display: flex;
 flex-direction: row;
}


</style>

</head>


<?php include('templates/leftbar.php'); ?>


<div id="middle">

    <div id="top">

         <div>
          Welcome <?php echo "$name"; ?>
         </div>

         <div id="type">
	         <?php echo "$type"; ?>
         </div>

    </div>

</div>


</div>


</body>

</html>