<?php 
include 'check.php';
include '../db.inc.php';
include 'check_msg.php';
$ac=$_GET['user'];
$sql="SELECT * FROM users WHERE number='$ac'";
$query=mysqli_query($connectionString,$sql);
$curr_user=mysqli_fetch_array($query,MYSQLI_ASSOC);

?>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>Administrator</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<link href="css/style.css" rel="stylesheet" type="text/css">
</head>

<body>
<table width="96%" height="421" border="0" cellspacing="5">
  <tr>
    <td width="14%" height="274" valign="top" style="border:#003399 1px solid;"><table width="100%" border="0" cellpadding="0" cellspacing="0">
      <tr>
        <td height="21" bgcolor="#de0011" class="headers">Navigation</td>
      </tr>
      <tr>
        <td><table width="100%" border="0" cellspacing="1">
          <tr>
            <td bgcolor="#E8FFF8"><p><font size="2" face="Arial, Helvetica, sans-serif"><strong><a href="./">Home</a></strong></font></p></td>
          </tr>
           <tr>
            <td bgcolor="#E8FFF8"><p><font size="2" face="Arial, Helvetica, sans-serif"><strong><a href="smssender.php">SMS 
              Sender</a></strong></font></p></td>
          </tr>
          <tr>
            <td bgcolor="#E8FFF8"><p><font size="2" face="Arial, Helvetica, sans-serif"><strong><a href="add.php">Add 
              User</a></strong></font></p></td>
          </tr>
          <tr>
            <td bgcolor="#E8FFF8"><font size="2" face="Arial, Helvetica, sans-serif"><strong><a href="addact.php">Add Activity </a></strong></font></td>
          </tr>
          <tr>
            <td bgcolor="#E8FFF8"><a href="viewact.php"><font size="2" face="Arial, Helvetica, sans-serif"><strong>View Activities </strong></font></a></td>
          </tr>
          <tr>
            <td bgcolor="#E8FFF8"><a href="messages.php"><font size="2" face="Arial, Helvetica, sans-serif"><strong>View Messages (<?php echo $umsg; ?>)</strong></font></a></td>
          </tr>
          <tr>
            <td bgcolor="#E8FFF8"><a href="alerts.php"><font size="2" face="Arial, Helvetica, sans-serif"><strong>View Alerts</strong></font></a></td>
          </tr>
          
          <tr>
            <td bgcolor="#E8FFF8"><a href="sql.php"><font size="2" face="Arial, Helvetica, sans-serif"><strong>SQL</strong></font></a></td>
          </tr>
		  
          <tr>
            <td bgcolor="#E8FFF8"><font size="2" face="Arial, Helvetica, sans-serif"><strong><a href="logout.php">Log 
              Out</a></strong></font></td>
          </tr>
        </table>
        <p>&nbsp;</p>
          </td>
      </tr>
    </table>      
      <p>&nbsp;</p>
    </td>
    <td width="86%" valign="top" style="border:#003399 1px solid;"><table width="100%" border="0" cellspacing="1" bgcolor="#de0011">
      <tr>
        <td width="14%" bgcolor="#E8FFF8"><strong>Name </strong></td>
        <td width="86%" bgcolor="#E8FFF8"><?php echo stripslashes($curr_user['firstname'])." ".stripslashes($curr_user['lastname']); ?></td>
      </tr>
	  <tr>
        <td width="14%" bgcolor="#E8FFF8"><strong>Date of Birth  </strong></td>
        <td width="86%" bgcolor="#E8FFF8"><?php echo strftime('%B %d, %Y',strtotime($curr_user['dob'])); ?></td>
      </tr>
      <tr>
        <td width="14%" bgcolor="#E8FFF8"><strong>Gender :</strong></td>
        <td width="86%" bgcolor="#E8FFF8"><?php echo stripslashes($curr_user['gender']); ?></td>
      </tr>
      <tr>
        <td bgcolor="#E8FFF8"><strong>Address:</strong></td>
        <td bgcolor="#E8FFF8"><?php echo stripslashes($curr_user['address']) ?></td>
      </tr>
      <tr>
        <td bgcolor="#E8FFF8"><strong>City, State, Zip:</strong></td>
        <td bgcolor="#E8FFF8"><?php echo stripslashes($curr_user['city']).", ".stripslashes($curr_user['state']).", ".stripslashes($curr_user['zip']) ?></td>
      </tr>
      <tr>
        <td bgcolor="#E8FFF8"><strong>Country:</strong></td>
        <td bgcolor="#E8FFF8"><?php echo stripslashes($curr_user['country']) ?></td>
      </tr>
      <tr>
        <td bgcolor="#E8FFF8"><strong>Email:</strong></td>
        <td bgcolor="#E8FFF8"><?php echo stripslashes($curr_user['email']) ?></td>
      </tr>
      <tr>
        <td bgcolor="#E8FFF8"><strong>Phone:</strong></td>
        <td bgcolor="#E8FFF8"><?php echo stripslashes($curr_user['phone']) ?></td>
      </tr>
      <tr>
        <td bgcolor="#E8FFF8"><strong>Occupation:</strong></td>
        <td bgcolor="#E8FFF8"><?php echo stripslashes($curr_user['occupation']) ?></td>
      </tr>


    </table>    
    <p>&nbsp;</p>
    </td>
  </tr>
</table>


</body>
</html>
