<?php session_start();
 if(!isset($_SESSION['email'])) { $_SESSION['email'] = $_POST[email]; }
if(!isset($_SESSION['password'])) { $_SESSION['password'] = $_POST[password]; } ?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>

  <title>The Science Network</title>
  <link rel="stylesheet" type="text/css" href="style.css">
</head>
<body style="background-color: rgb(232, 232, 232);">
<center>
<table style="background-color: rgb(102, 102, 102);" border="0"
 width="768">
  <tbody>
    <tr>
      <td colspan="2"><img src="./logo2.gif" alt="logo" height="108"
 width="763"></td>
    </tr>
    <tr>
      <td colspan="2" style="background-color: rgb(102, 102, 102);"
 valign="middle">&nbsp;&nbsp;&nbsp;<a href="./profile.php">Home</a>&nbsp;&nbsp;&nbsp;&nbsp;
      <a href="./myfriends.php">Friends</a>&nbsp;&nbsp;&nbsp;&nbsp;
      <a href="./mygroups.php">Groups</a>&nbsp;&nbsp;&nbsp;&nbsp;
      <a href="./mail.php">Mail</a>&nbsp;&nbsp;&nbsp;&nbsp;
      <a href="./logout.php">Log
Out</a> </td>
    </tr>
    <tr>
      <td
 style="background-color: rgb(255, 255, 255); vertical-align: top; text-align: center;"
 width="585"> <br>
      <h3>Profile Page</h3>
      <p>
<?php $con = mysql_connect("localhost","root","mysql"); 
$email = $_SESSION[email];
 $password = $_SESSION[password]; 
if(!$con) { die("Could not connect:" . mysql_error()); } 
mysql_select_db("ScientistNet", $con); 
$idquery = mysql_query("SELECT id FROM Scientist WHERE email='$email' AND password='$password';"); 
$viewid = mysql_result($idquery, 0) or die("Query error, load aborted ".mysql_error());
if ($_GET[userid]) 
{ 
	$testid=$_GET[userid]; 
} 
else 
{ 
	$testid=$viewid; 
	if (!$testid) 
	{ 
		session_destroy(); 
		die("No known user, login aborted. Click <a href='./login.html'>here</a> and Try again."); 
	} 
}
$namequery = mysql_query("SELECT name FROM Scientist WHERE id=$testid;"); 
$aboutmequery = mysql_query("SELECT about_me FROM Scientist WHERE id=$testid;"); 
$emailquery = mysql_query("SELECT email FROM Scientist WHERE id=$testid;"); 
//$friendquery = mysql_query("SELECT sci_id, fri_id FROM Friend WHERE sci_id = $viewid AND fri_id = $testid;");

$useremail=mysql_result($emailquery, 0) or die("Query error, load aborted ".mysql_error()); 
$name=mysql_result($namequery, 0) or die("Query error, load aborted ".mysql_error()); 
$aboutme=mysql_result($aboutmequery, 0) or die("Query error, load aborted ".mysql_error()); 


if($id = NULL) { echo "Invalid username or password. Please log in again."; } mysql_close($con); ?><br>
      <right><?php if($testid == $viewid)
{
echo "<a href=\"./editprofile.php\">Edit Profile</a>";
}
else if(mysql_fetch_array($friendquery))
{
echo "<a href=\"./addprofile.php?u=$testid&m=r\">Remove Friend</a>";
}
else
{
echo "<a href=\"./addprofile.php?u=$testid&m=a\">Add Friend</a>";
}
?></right>
      <table align="center">
        <tbody>
          <tr>
            <td style="font-weight: bold;">Name:</td>
            <td><?php echo $name ?></td>
          </tr>
          <tr>
            <td style="font-weight: bold;">Email:</td>
            <td><?php echo $useremail ?></td>
          </tr>
          <tr>
            <td style="font-weight: bold;">About
Me:</td>
            <td><?php echo $aboutme ?></td>
          </tr>
        </tbody>
      </table>
      <br>
      </p>
      <p> </p>
      </td>
      <td class="sidebar" style="background-color: rgb(204, 204, 204);"
 align="center" valign="middle" width="173"><br>
      <form action="./results.php" method="post"> <input
 name="searchterm" type="text">
        <select name="searchtype">
        <option>Friends</option>
        <option>Groups</option>
        </select>
        <input value="Search" type="submit"> </form>
      <a href="./editprofile.php">Edit
Profile</a><br>
      <br>
      <a href="./myfriends.php">My
Friends</a><br>
      <br>
      <a href="./mygroups.php">My
Groups</a><br>
      <br>
      </td>
    </tr>
    <tr>
      <td colspan="2"
 style="background-color: rgb(102, 102, 102); color: rgb(255, 255, 255);"
 align="center" valign="middle">The Science
Network, 2012&copy;</td>
    </tr>
  </tbody>
</table>
</center>
</body>
</html>
