-
Notifications
You must be signed in to change notification settings - Fork 1
/
profile.php
119 lines (89 loc) · 3.34 KB
/
profile.php
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
<?php
session_start();
if (!isset($_SESSION['sess_user'])) {
header("location:index.php");
# code...
}
include "connection_db.php";
$user=$_SESSION['sess_user'];
$sql = "SELECT user_info.id,user_info.email,user_info.user_name,
profile.name,profile.education,profile.experience,profile.rating,profile.university,profile.interest,profile.domain,profile.accomplishment,profile.image,profile.lastname
FROM user_info inner join profile on user_info.id=profile.id where user_info.id=$user ";
$result = $conn->query($sql);
?>
<?php
if ($result=mysqli_query($conn,$sql))
{
// Fetch one and one row
while ($row=$result->fetch_assoc())
{
$id=$row["id"];
$name= $row["user_name"];
$lname=$row["lastname"];
$edu =$row["education"];
$experience= $row["experience"];
$email=$row["email"];
$rating=$row["rating"];
$uni=$row["university"];
$interest=$row["interest"];
$domain=$row["domain"];
$accom=$row["accomplishment"];
$image=$row["image"];
}
// Free result set
mysqli_free_result($result);
}
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>Profiles - TheCounsellor</title>
<meta name="description" content="Website for Counselling">
<meta name="author" content="Maaz">
<meta name="viewport" content="width=device-width, initial-scale=1, maximum-scale=1">
<link rel="shortcut icon" href="images/icon.png">
<link rel="stylesheet" href="css/style.css">
</head>
<body>
<?php include "header.php"; ?>
<br><br>
<a style="margin-left: 85%" href="profile_edit.php"> <button type="button" class="button button2" > Edit Profile</button></a>
<br>
<?php $sql1 ="SELECT image FROM profile where id='$user'";
$result = $conn->query($sql1);
while ($row = mysqli_fetch_array($result))
{
echo '<img class=proavatar style="margin-left:10%;" src="data:image;base64,'.$row["image"].' ">';
} ?>
<h3 style="margin-left: 10%"> <?php echo "<p> $lname</p>" ?></h3>
<h5 style="margin-left: 10%"><?php
for($j=0;$j<$rating;$j++){
echo "<span style=font-size:200%;color:#195199;>★</span>";
}?></h5>
<table class="text" border= "1px solid" style="margin-left: 10%;">
<tr >
<td><h2 style= "text-align: left;">Experience</h2><br>
<h4 class="p"><?php echo $experience?></h4>
</td>
</tr>
<tr><td><h2 style= "text-align: left;">Education</h2><h4 class="p"><?php echo $edu?></h4>
</td></tr>
<tr><td><h2 style= "text-align: left;" >University</h2><h4 class="p"><?php echo $uni ?></h4>
</td></tr>
<tr><td><h2 style= "text-align: left;">Interests/Experties</h2><h4 class="p"><?php echo $interest ?></h4>
</td></tr>
<tr><td><h2 style= "text-align: left;">Accomplishment/Certifications</h2><h4 class="p"><?php echo $accom ?></h4>
</td></tr>
<tr><td><h2 style= "text-align: left;">Domains</h2><h4 class="p"><?php echo $domain ?></h4>
</td></tr>
</table>
<br>
<br>
<div class="main supporting" id="zen-supporting" role="main">
<footer>
<?php include "footer.php";?>
</footer>
</div>
</body>
</html>