This repository has been archived by the owner on Feb 6, 2020. It is now read-only.
-
Notifications
You must be signed in to change notification settings - Fork 1
/
mygene.php
62 lines (52 loc) · 1.52 KB
/
mygene.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
<?php
//start session
require_once('startsession.php');
//Insert header
$page_title='My Genes';
require_once('header.php');
//Insert nabigation menu
require_once('navmenu.php');
?>
<!--display genes here-->
<?php
//check if logged in
if (!isset($_SESSION['u_id'])){
echo '<p>Please login to display your genes</p>';
}else{
//dispaly any necessary mesage
if (!empty($_GET['msg'])) {
echo '<p class="message">' . $_GET['msg'] . '</p>';
}
//connect to database
require_once('connectvars.php');
$dbc=mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME) or die('Error connecting to MySQL Database');
//get all genes under this user
$u_id=$_SESSION['u_id'];
$query="SELECT genes.g_name, genes_of_user_$u_id.g_expression, genes_of_user_$u_id.g_update_time" .
" FROM genes INNER JOIN genes_of_user_$u_id" .
" ON genes.g_id=genes_of_user_$u_id.g_id" .
" ORDER BY genes_of_user_$u_id.g_update_time DESC";
$data=mysqli_query($dbc, $query) or die('Error retrieving user\'s genes');
echo '<table border="0">';
echo '<tr><th>Gene</th><th>Expression</th><th>Last Mutation</tr>';
while($row = mysqli_fetch_array($data)){
echo '<tr>';
echo '<td>';
echo '(<a href="evolve.php?g_name=' . $row['g_name'] . '">evolve</a>)';
echo $row['g_name'];
echo '</td>';
echo '<td>';
echo $row['g_expression'];
echo '</td>';
echo '<td>';
echo $row['g_update_time'];
echo '</td>';
echo '</tr>';
}
echo '</table>';
}
?>
<?php
//insert footer
require_once('footer.php');
?>