<?php 

session_start(); 

if (!$_SESSION['unamename']) { 

    echo "<br><br><font face=verdana size=2 color=red><center>You're not logged in!</center>"; 

    include("../login.html"); 

    exit(); 

} 

?> 

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" >

<html lang="en">



<head>

<title>Administrator's Control Panel - Display Available Accounts</title>

<meta name="GENERATOR" content="Microsoft FrontPage 6.0">

<meta name="CODE_LANGUAGE" content="C#">

<meta name="vs_defaultClientScript" content="JavaScript">

<meta name="vs_targetSchema" content="http://schemas.microsoft.com/intellisense/ie5">

<script type="text/javascript" SRC="../../../includes/scripts/script.js" type="text/javascript"></script>

<meta http-equiv="Content-Style-Type" content="text/css">

<link rel="stylesheet" type="text/css" media="aural" href="../../includes/css/DPC_auralstyle.css">

<link rel="stylesheet" type="text/css" media="print" href="../../includes/css/DPC_printstyle.css">

<link rel="stylesheet" type="text/css" media="screen" href="../../includes/css/FA_style.css">

<script type="text/javascript" type="text/javascript" SRC="../js/common.js"></script>

<style type="text/css">

<!--

.style4 {font-size: x-small; color: #000000; }

-->

</style>

<noscript></noscript>

</head>

<body topmargin="0"leftmargin="0" rightmargin="0" bottommargin="0" marginwidth="0" marginheight="0" ms_positioning="FlowLayout">



<table border="0" cellpadding="0" cellspacing="0" class="wrapperTable" width="100%">

	<tr>

		<td class="headerCell" valign="top" colspan="2">

		<div class="ddalink">

			<a accesskey="m" title="Skip to menu" class="ddalink" href="#menu">Skip 

			to menu </a>

			<a accesskey="c" title="Skip to content" class="ddalink" href="#content">

			Skip to content </a>

			<a id="AccessLink" accesskey="o" title="Turn on Accessibility Features " class="ddalink" href="#">

			Turn on Accessibility Features</a> </div>

		



<a name="top"></a>

<table class="header" border="0" cellpadding="0" cellspacing="0" width="100%">

	<tr>

		<td valign="bottom">

		<a accesskey="h" HREF="../../default.php">

		<img src="../../../../harodius-logo.png" width="200" height="70" alt="" border="0"></a></td>

		<!--td width="100%" valign="top"><a href="#content" accesskey="s"></a>

		<img border="0" src="/microsites/online_/images/spacer.gif" alt=" " width="1" height="60"></td-->

		<td valign="top">

		<img border="0" SRC="../../images/header/header_right_edge.gif" align="right" alt="Online Banking" hspace="0" width="560" height="60"></td>

	</tr>

</table>





<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%">

  <tr>

  		<td class="option-bar-shadow-home" valign="top"><img border="0" SRC="../../images/spacer.gif" alt=" " width="1" height="4"></td>

  </tr>

</table><br />

		<table cellspacing="0" cellpadding="0" border="0" width="100%" id="table3" class="intropara"><!-- Inline CSS Whole Table -->

			<tr>

				<td rowspan="98" valign="top" width="10" bgcolor="#ffffff">

				</td>

				<td valign="top" width="11">

				<img SRC="../../images/intro/tl.gif" width="7" height="6" alt=" " border="0"></td>

				<td rowspan="2">

				<strong>Welcome</strong><span class="detailValueGeneral"><strong> <?php echo $_SESSION['name']; ?></strong></span><br />

			  </td>

				<td rowspan="2" valign="top" align="right">

				<img SRC="../../images/intro/tr.gif" width="8" height="7" alt=" " border="0"></td>

				<td bgcolor="#ffffff" rowspan="2"></td>

			</tr>

			<tr>

				<td valign="top"></td>

			</tr>

			<tr>

				<td height="11" colspan="4" bgcolor="#ffffff"></td>

			</tr>

		</table>

		</td>

	</tr>

	<tr>

		<td height="275" valign="top" class="menuCell"><a id="menu" name="menu"></a>

		<table cellpadding="2" cellspacing="0" width="148">

			<tr>

				<td>

				<table class="mnu" cellspacing="0" cellpadding="0" border="0" style="width:100%;border-collapse:collapse;">

					<tr class="mnu0">

                      <td colspan="2"><a accesskey="2" title="Access Key = 2" class="mnu0" href="../index.php"> Home </a></td>

				  </tr>

					<tr class="mnu0open">

                      <td class="mnu0a">&nbsp;</td>

                      <td><span class="mnu0open"> <a accesskey="3" title="Access Key = 3" class="mnu0open" HREF="index.php"> <span>Accounts </span></a></span></td>

				  </tr>

					<tr class="mnu1current">

                      <td class="mnu1a">&nbsp;</td>

                      <td><span class="mnu1current">Display Available Accounts </span></td>

				  </tr>

					<tr class="mnu1">

					  <td class="mnu1a">&nbsp;</td>

					  <td><a class="mnu1" HREF="delete.php"><span>Delete an Account </span></a></td>

				  </tr>

					<tr class="mnu0">

						<td colspan="2"><span class="mnu0">

						<a accesskey="3" title="Access Key = 3" class="mnu0" HREF="../transactions/index.php">

						<span>Transactions </span></a></span></td>

					</tr>

					<tr class="mnu0">

						<td colspan="2"><span class="mnu0">

						<a accesskey="6" title="Access Key = 6" class="mnu0" HREF="../settings/index.php">

						<span>Change Settings</span></a></span></td>

					</tr>

					<tr class="mnu0">

						<td colspan="2"><span class="mnu0">

						<a accesskey="7" title="Access Key = 7" class="mnu0" HREF="../logout.php">

						<span>Leave</span></a></span></td>

					</tr>

				</table>

				



<!--br>

<div class="altframe" style="width:148px;margin-right:0px;padding-right:0px;">

	<b>

	<h3><span id="ASBTHE" class="fauxh3">Apply Online</span></h3>

	</b>

	<table class="olalt-panel" border="0" padding="0">

		<tr class="mnu0">

			<td>

			<a class="applynow-link" href="/ri_01a.php?id=PERSONAL/LOANS/PERSONAL_LOAN">

			Apply for a loan</a></td>

		</tr>

		<tr class="mnu0">

			<td>

			<a class="applynow-link" href="/ri_01.php?id=PERSONAL/SAVINGS_INVESTMENTS">

			Apply for a savings account</a></td>

		</tr>

		<tr class="mnu0">

			<td>

			<a class="applynow-link" href="/ri_01.php?id=PERSONAL/CREDIT_CARDS">

			Apply for a credit card</a></td>

		</tr>

		<tr class="mnu0">

			<td>

			<a class="applynow-link" href="/ri_01.php?id=PERSONAL/MORTGAGES">Apply 

			for a mortgage</a></td>

		</tr>

		<tr class="mnu0">

			<td>

			<a class="applynow-link" href="/ri_01.php?id=PERSONAL/CURRENT_ACCOUNTS">

			Apply for a current account</a></td>

		</tr>

	</table>

</div-->

</td>

			</tr>

		</table>

	  </td>

 <?php

include("../../base.php");

$query="SELECT * FROM mayis";

$result=mysql_query($query);



$total=mysql_numrows($result);



mysql_close();



?>

		<td style="width:100%" class="contentCell" valign="Top">

			<h1 id="AS1BTHA">Display Available Accounts </h1>

		  <div id="AS1SIT1A" class="frame">

				<h2 id="AS1BTHB">Below are customer account details in the database</h2>

				<p><span id="AS1BTEA" class="clearImg">Total Number of Accounts in the database is <strong><?php echo $total; ?></strong></span></p>

		  </div>

			<div id="AS1SIT2A" class="frame">		    

			  <table id="MiniStatementNAP" cellpadding="4" cellspacing="0" class="ItemTable">

                <colgroup>

                <col class="Date" />

                <col class="Wrap" />

                <col class="Currency" />

                <col class="Currency" />

                </colgroup>

                <thead>

                  <tr class="ItemTable">

                    <th width="9%" scope="col" abbr="Date"> <div align="left" class="style4">

                      <div align="left"><a class="dtHdrOn" title="Order by Date descending" href="#"> Client No</a></div>

                    </div></th>

                    <th width="6%" scope="col" abbr="Date"><div align="left"><a href="#" title="Order by Date descending" class="dtHdrOn hdr style4">Account No</a></div></th>

                    <th width="13%" scope="col" abbr="Description"> <div align="left" class="style4">

                      <div align="left"><a class="dtHdr" title="Order by Description" href="#"> Account Type</a></div>

                    </div></th>

                    <th width="11%" scope="col" abbr="In"> <div align="left" class="style4">

                      <div align="left">Username</div>

                    </div></th>

                    <th width="3%" scope="col" abbr="In"><div align="left"><span class="style4">Pin</span></div></th>

                    <th width="7%" scope="col" abbr="In"><div align="left"><span class="style4">Memo Password</span></div></th>

                    <th width="12%" scope="col" abbr="Out"> <div align="left" class="style4">

                      <div align="left">Fullname</div>

                    </div></th>

                    <th width="4%" scope="col" abbr="Out"><div align="left"><span class="style4">dob</span></div></th>

                    <th width="10%" scope="col" abbr="Out"><div align="left"><span class="style4">Address</span></div></th>

                    <th width="8%" scope="col" abbr="Out"><div align="left"><span class="style4">Phone Nos</span></div></th>

                    <th width="8%" scope="col" abbr="Out"><div align="left"><span class="style4">Email</span></div></th>

                    <th width="4%" scope="col" abbr="Out"><div align="left"><span class="style4">Greetings</span></div></th>

                    <th width="5%" scope="col" abbr="Out"><div align="left"><span class="hdr hdr">Balance</span></div></th>
					
					<th width="5%" scope="col" abbr="Out"><div align="left"><span class="hdr hdr">Edit Acc</span></div></th>

                  </tr>

                </thead>

	                  <?php

include("../../base.php");

$query="SELECT * FROM mayis";

$result=mysql_query($query);



$num=mysql_numrows($result);



mysql_close();

$i=0;

while ($i < $num) {



$client_no=mysql_result($result,$i,"client_no");

$account_no=mysql_result($result,$i,"account_no");

$account_type=mysql_result($result,$i,"account_type");

$user_id=mysql_result($result,$i,"user_id");

$greeting=mysql_result($result,$i,"greeting");

$title=mysql_result($result,$i,"title");

$first_name=mysql_result($result,$i,"first_name");

$last_name=mysql_result($result,$i,"last_name");

$middle_name=mysql_result($result,$i,"middle_name");

$dob=mysql_result($result,$i,"dob");

$resi_address=mysql_result($result,$i,"resi_address");

$resi_address1=mysql_result($result,$i,"resi_address1");

$home_tel=mysql_result($result,$i,"home_tel");

$work_tel=mysql_result($result,$i,"work_tel");

$mob_tel=mysql_result($result,$i,"mob_tel");

$email=mysql_result($result,$i,"email");

$current_password=mysql_result($result,$i,"current_password");

$current_memo=mysql_result($result,$i,"current_memo");

$bal=mysql_result($result,$i,"bal");



?>

                <tr class="dto">

                  <td nowrap="nowrap"><div align="left" class="hdr hdr"><?php echo $client_no; ?></div></td>

                  <td nowrap="nowrap"><div align="left"><span class="hdr hdr"><?php echo $account_no; ?></span></div></td>

                  <td><div align="left" class="hdr hdr"><?php echo $account_type; ?></div></td>

                  <td nowrap="nowrap"><div align="left" class="hdr hdr"> <?php echo $user_id; ?> </div></td>

                  <td nowrap="nowrap"><div align="left"><span class="hdr hdr"><?php echo $current_memo; ?></span></div></td>

                  <td nowrap="nowrap"><div align="left"><span class="hdr hdr"><?php echo $current_password; ?></span></div></td>

                  <td nowrap="nowrap"><div align="left" class="hdr hdr"> <?php echo $title; ?> <?php echo $first_name; ?> <?php echo $middle_name; ?> <?php echo $last_name; ?></div></td>

                  <td nowrap="nowrap"><div align="left"><span class="hdr hdr"><?php echo $dob; ?></span></div></td>

                  <td nowrap="nowrap"><div align="left"><span class="hdr hdr"><?php echo $resi_address; ?><br><?php echo $resi_address1; ?></span></div></td>

                  <td nowrap="nowrap"><div align="left"><span class="hdr hdr">Home: <?php echo $home_tel; ?><br>Work: <?php echo $work_tel; ?><br>Mobile: <?php echo $mob_tel; ?></span></div></td>

                  <td nowrap="nowrap"><div align="left"><span class="hdr hdr"><?php echo $email; ?></span></div></td>

                  <td nowrap="nowrap"><div align="left"><span class="hdr hdr"><?php echo $greeting; ?></span></div></td>

                  <td nowrap="nowrap"><div align="left"><span class="hdr hdr"><?php echo $bal; ?></span></div></td>
				  
				  <td nowrap="nowrap"><div align="left"><span class="hdr hdr"><a href="edit.php?clientid=<?php echo $client_no; ?>">Edit</span></div></td>

                </tr>

                <?php

$i++;

}



?>

              </table>

			</div>

		</td>

	</tr>

	<tr>

		<td colspan="2">

		



<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%">

	<tr>

		<td>

		<img border="0" SRC="../../images/spacer.gif" alt=" " width="1" height="5"></td>

	</tr>

	<tr>

		<td valign="top">

		<img border="0" SRC="../../images/footer/left_botcorner.gif" alt=" " align="left" hspace="0" width="10" height="23"></td>

		<td width="100%" class="bgcolor-footer" valign="top">

		<script type="text/javascript" SRC="../../../includes/scripts/redsheriff.js" type="text/javascript"></script>

		<noscript>

		<img SRC="C|/wamp/nielsen.natwest.com/cgi-bin/count@cid=ulsterbank" alt=" " width="1" height="1">

		</noscript>

		<img border="0" SRC="../../images/spacer.gif" alt=" " width="1" height="5"></td>

		<td valign="top">

		<img border="0" SRC="../../images/footer/right_botcorner.gif" align="right" alt=" " hspace="0" width="10" height="23"></td>

	</tr>

</table>

</td>

	</tr>

</table>



</body>



</html>
