SWEGroupProject/user.php at master · aevl/SWEGroupProject · 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
<?php
	session_start();
	if(!isset($_SESSION['email'])){
		echo"You are not logged in, redirecting";
		header('Location: http://pikachu-swacy.centralus.cloudapp.azure.com/login.php');
	}

?>
<html>
	<head>
		<title> User Page </title>
		<link rel="stylesheet" href="../bootstrap/3.3.6/css/bootstrap.min.css">
		<link rel="stylesheet" href="../bootstrap/3.3.5/css/bootstrap-theme.min.css">
		<link rel="stylesheet" href="w3.css">
		<link rel="stylesheet" href="https://fonts.googleeapis.com/icon?family=Material+Icons">
	</head>
	<style type="text/css">
	.form-control:focus{
			border-color: #ff9900;
        		box-shadow: 0px 1px 1px rgba(0, 0, 0, 0.075) inset, 0px 0px 8px rgb(255, 153, 0);
		}

	</style>
	<body>
		<header class="w3-topnav w3-black">
			<p class="header"><center><?php $j = $_SESSION['email']; echo '<h1>' . "Welcome $j" . '</h1>';?></center></p>
		</header>

		<nav class="w3-topnav w3-black">
			<div>
			<ul class="nav navbar-nav">
				<li><a href="http://pikachu-swacy.centralus.cloudapp.azure.com/user.php"><span class="glyphicon glyphicon-user"></span> User Page </a></li></ul>
			</div>

			<div class="pull-right">
			<ul class="nav navbar-nav">
			<li><a href="http://pikachu-swacy.centralus.cloudapp.azure.com/logout.php"><span class="glyphicon glyphicon-off"></span> Logout</a></li>
			</ul>
			</div>

</nav>
<div class="jumbotron">
				<center><h1>Your Profile</h1></center>
			</div>
<?php
$i = $_SESSION['id'];
$link = mysqli_connect("localhost", "root", "Thisistheultimatepassword1337", "mydb") or die ("Connection Error " . mysqli_error($link));
$sql = "SELECT first_name, last_name, bio, industry, location, picture from user WHERE id = 'i'";
$stmt = mysqli_query($link, $sql);
$result= mysqli_fetch_assoc($stmt);

$first_name= $result[first_name];
$last_name= $result[last_name];
$bio= $result[bio];
$industry= $result[industry];
$location= $result[location];
$picture= $result[picture];

echo "$first_name";
echo "$last_name";
echo "$bio";
echo "$industry";
echo "$location";
echo("<img src=\"$picture\" />");

?>
</html>