--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
Address: No. 10, JLN. 4, Ampang Jaya
--------------------------------------------------------------------------------
Code: Select all
<?php
<?
$username="root";
$password="";
$database="db1";
mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");
$query="SELECT * FROM employee";
$result=mysql_query($query);
$num=mysql_numrows($result);
mysql_close();
echo "<b><center><h3>USER INFORMATION</center></h3></b>";
$i=0;
while ($i < $num) {
$ID=mysql_result($result,$i,"username");
$Pass=mysql_result($result,$i,"password");
$Access=mysql_result($result,$i,"AccType");
$Name=mysql_result($result,$i,"EmpName");
$Birth=mysql_result($result,$i,"EmpDOB");
$IC=mysql_result($result,$i,"EmpIC");
$Mobile=mysql_result($result,$i,"EmpMobileNO");
$House=mysql_result($result,$i,"EmpHouseNO");
$Address=mysql_result($result,$i,"EmpAdd");
$Des=mysql_result($result,$i,"EmpDes");
$Office=mysql_result($result,$i,"EmpOffice");
$Dept=mysql_result($result,$i,"EmpDept");
$Unit=mysql_result($result,$i,"EmpUnit");
$Super=mysql_result($result,$i,"EmpSuper");
$Ent=mysql_result($result,$i,"LeaveEnt");
$BF=mysql_result($result,$i,"LeaveBF");
$Annual=mysql_result($result,$i,"LeaveAnn");
$Med=mysql_result($result,$i,"LeaveMed");
?>
<hr>
<font color="#671247" size="3" face="Verdana, Arial, Helvetica, sans-serif">
<center><b>*****************************************</b></font></center>
<hr>
<div align="center"><center>
<table border="1" cellpadding="2" cellspacing="1" width="100%">
<tr>
<td align="left" valign="bottom" width="30%"
bgcolor="#FFFFFF" valign="TOP" marginwidth="12" marginheight="12">
<font color="#671247" size="3" face="Verdana, Arial, Helvetica, sans-serif">
<b>Username</b></font>
</td>
<td align="left" valign="top" width="70%"
bgcolor="#FFFFFF" marginwidth="12" marginheight="12">
<font color="#671247" size="3" face="Verdana, Arial, Helvetica, sans-serif">
<b><?echo "$ID";?></b></font>
</td>
</tr>
</table>
<div align="center"><center>
<table border="1" cellpadding="2" cellspacing="1" width="100%">
<tr>
<td align="left" valign="bottom" width="30%"
bgcolor="#FFFFFF" valign="TOP" marginwidth="12" marginheight="12">
<font color="#671247" size="3" face="Verdana, Arial, Helvetica, sans-serif">
<b>Password</b></font>
</td>
<td align="left" valign="top" width="70%"
bgcolor="#FFFFFF" marginwidth="12" marginheight="12">
<font color="#671247" size="3" face="Verdana, Arial, Helvetica, sans-serif">
<b><?echo "$Pass";?></b></font>
</td>
</tr>
</table>
<div align="center"><center>
<table border="1" cellpadding="2" cellspacing="1" width="100%">
<tr>
<td align="left" valign="bottom" width="30%"
bgcolor="#FFFFFF" valign="TOP" marginwidth="12" marginheight="12">
<font color="#671247" size="3" face="Verdana, Arial, Helvetica, sans-serif">
<b>Access Type</b></font>
</td>
<td align="left" valign="top" width="70%"
bgcolor="#FFFFFF" marginwidth="12" marginheight="12">
<font color="#671247" size="3" face="Verdana, Arial, Helvetica, sans-serif">
<b><?echo "$Access";?></b></font>
</td>
</tr>
</table>
<div align="center"><center>
<table border="1" cellpadding="2" cellspacing="1" width="100%">
<tr>
<td align="left" valign="bottom" width="30%"
bgcolor="#FFFFFF" valign="TOP" marginwidth="12" marginheight="12">
<font color="#671247" size="3" face="Verdana, Arial, Helvetica, sans-serif">
<b>Name</b></font>
</td>
<td align="left" valign="top" width="70%"
bgcolor="#FFFFFF" marginwidth="12" marginheight="12">
<font color="#671247" size="3" face="Verdana, Arial, Helvetica, sans-serif">
<b><?echo "$Name";?></b></font>
</td>
</tr>
</table>
</center></div>
<div align="center"><center>
<table border="1" cellpadding="2" cellspacing="1" width="100%">
<tr>
<td align="left" valign="bottom" width="30%"
bgcolor="#FFFFFF" valign="TOP" marginwidth="12" marginheight="12">
<font color="#671247" size="3" face="Verdana, Arial, Helvetica, sans-serif">
<b>Date Of Birth</b></font>
</td>
<td align="left" valign="top" width="70%"
bgcolor="#FFFFFF" marginwidth="12" marginheight="12">
<font color="#671247" size="3" face="Verdana, Arial, Helvetica, sans-serif">
<b><?echo "$Birth";?></b></font>
</td>
</tr>
</table>
</center></div>
<div align="center"><center>
<table border="1" cellpadding="2" cellspacing="1" width="100%">
<tr>
<td align="left" valign="bottom" width="30%"
bgcolor="#FFFFFF" valign="TOP" marginwidth="12" marginheight="12">
<font color="#671247" size="3" face="Verdana, Arial, Helvetica, sans-serif">
<b>IC No</b></font>
</td>
<td align="left" valign="top" width="70%"
bgcolor="#FFFFFF" marginwidth="12" marginheight="12">
<font color="#671247" size="3" face="Verdana, Arial, Helvetica, sans-serif">
<b><?echo "$IC";?></b></font>
</td>
</tr>
</table>
<div align="center"><center>
<table border="1" cellpadding="2" cellspacing="1" width="100%">
<tr>
<td align="left" valign="bottom" width="30%"
bgcolor="#FFFFFF" valign="TOP" marginwidth="12" marginheight="12">
<font color="#671247" size="3" face="Verdana, Arial, Helvetica, sans-serif">
<b>Mobile Phone No.</b></font>
</td>
<td align="left" valign="top" width="70%"
bgcolor="#FFFFFF" marginwidth="12" marginheight="12">
<font color="#671247" size="3" face="Verdana, Arial, Helvetica, sans-serif">
<b><?echo "$Mobile";?></b></font>
</td>
</tr>
</table>
<div align="center"><center>
<table border="1" cellpadding="2" cellspacing="1" width="100%">
<tr>
<td align="left" valign="bottom" width="30%"
bgcolor="#FFFFFF" valign="TOP" marginwidth="12" marginheight="12">
<font color="#671247" size="3" face="Verdana, Arial, Helvetica, sans-serif">
<b>House Phone No.</b></font>
</td>
<td align="left" valign="top" width="70%"
bgcolor="#FFFFFF" marginwidth="12" marginheight="12">
<font color="#671247" size="3" face="Verdana, Arial, Helvetica, sans-serif">
<b><?echo "$House";?></b></font>
</td>
</tr>
</table>
<div align="center"><center>
<table border="1" cellpadding="2" cellspacing="1" width="100%">
<tr>
<td align="left" valign="bottom" width="30%"
bgcolor="#FFFFFF" valign="TOP" marginwidth="12" marginheight="12">
<font color="#671247" size="3" face="Verdana, Arial, Helvetica, sans-serif">
<b>Address</b></font>
</td>
<td align="left" valign="top" width="70%"
bgcolor="#FFFFFF" marginwidth="12" marginheight="12">
<font color="#671247" size="3" face="Verdana, Arial, Helvetica, sans-serif">
<b><?echo "$Address";?></b></font>
</td>
</tr>
</table>
<div align="center"><center>
<table border="1" cellpadding="2" cellspacing="1" width="100%">
<tr>
<td align="left" valign="bottom" width="30%"
bgcolor="#FFFFFF" valign="TOP" marginwidth="12" marginheight="12">
<font color="#671247" size="3" face="Verdana, Arial, Helvetica, sans-serif">
<b>Designation</b></font>
</td>
<td align="left" valign="top" width="70%"
bgcolor="#FFFFFF" marginwidth="12" marginheight="12">
<font color="#671247" size="3" face="Verdana, Arial, Helvetica, sans-serif">
<b><?echo "$Des";?></b></font>
</td>
</tr>
</table>
<div align="center"><center>
<table border="1" cellpadding="2" cellspacing="1" width="100%">
<tr>
<td align="left" valign="bottom" width="30%"
bgcolor="#FFFFFF" valign="TOP" marginwidth="12" marginheight="12">
<font color="#671247" size="3" face="Verdana, Arial, Helvetica, sans-serif">
<b>Office</b></font>
</td>
<td align="left" valign="top" width="70%"
bgcolor="#FFFFFF" marginwidth="12" marginheight="12">
<font color="#671247" size="3" face="Verdana, Arial, Helvetica, sans-serif">
<b><?echo "$Office";?></b></font>
</td>
</tr>
</table>
<div align="center"><center>
<table border="1" cellpadding="2" cellspacing="1" width="100%">
<tr>
<td align="left" valign="bottom" width="30%"
bgcolor="#FFFFFF" valign="TOP" marginwidth="12" marginheight="12">
<font color="#671247" size="3" face="Verdana, Arial, Helvetica, sans-serif">
<b>Department</b></font>
</td>
<td align="left" valign="top" width="70%"
bgcolor="#FFFFFF" marginwidth="12" marginheight="12">
<font color="#671247" size="3" face="Verdana, Arial, Helvetica, sans-serif">
<b><?echo "$Dept";?></b></font>
</td>
</tr>
</table>
<div align="center"><center>
<table border="1" cellpadding="2" cellspacing="1" width="100%">
<tr>
<td align="left" valign="bottom" width="30%"
bgcolor="#FFFFFF" valign="TOP" marginwidth="12" marginheight="12">
<font color="#671247" size="3" face="Verdana, Arial, Helvetica, sans-serif">
<b>Unit</b></font>
</td>
<td align="left" valign="top" width="70%"
bgcolor="#FFFFFF" marginwidth="12" marginheight="12">
<font color="#671247" size="3" face="Verdana, Arial, Helvetica, sans-serif">
<b><?echo "$Unit";?></b></font>
</td>
</tr>
</table>
<div align="center"><center>
<table border="1" cellpadding="2" cellspacing="1" width="100%">
<tr>
<td align="left" valign="bottom" width="30%"
bgcolor="#FFFFFF" valign="TOP" marginwidth="12" marginheight="12">
<font color="#671247" size="3" face="Verdana, Arial, Helvetica, sans-serif">
<b>Superior</b></font>
</td>
<td align="left" valign="top" width="70%"
bgcolor="#FFFFFF" marginwidth="12" marginheight="12">
<font color="#671247" size="3" face="Verdana, Arial, Helvetica, sans-serif">
<b><?echo "$Super";?></b></font>
</td>
</tr>
</table>
<div align="center"><center>
<table border="1" cellpadding="2" cellspacing="1" width="100%">
<tr>
<td align="left" valign="bottom" width="30%"
bgcolor="#FFFFFF" valign="TOP" marginwidth="12" marginheight="12">
<font color="#671247" size="3" face="Verdana, Arial, Helvetica, sans-serif">
<b>Leave Entitlement</b></font>
</td>
<td align="left" valign="top" width="70%"
bgcolor="#FFFFFF" marginwidth="12" marginheight="12">
<font color="#671247" size="3" face="Verdana, Arial, Helvetica, sans-serif">
<b><?echo "$Ent";?></b></font>
</td>
</tr>
</table>
<div align="center"><center>
<table border="1" cellpadding="2" cellspacing="1" width="100%">
<tr>
<td align="left" valign="bottom" width="30%"
bgcolor="#FFFFFF" valign="TOP" marginwidth="12" marginheight="12">
<font color="#671247" size="3" face="Verdana, Arial, Helvetica, sans-serif">
<b>BF Leave</b></font>
</td>
<td align="left" valign="top" width="70%"
bgcolor="#FFFFFF" marginwidth="12" marginheight="12">
<font color="#671247" size="3" face="Verdana, Arial, Helvetica, sans-serif">
<b><?echo "$BF";?></b></font>
</td>
</tr>
</table>
<div align="center"><center>
<table border="1" cellpadding="2" cellspacing="1" width="100%">
<tr>
<td align="left" valign="bottom" width="30%"
bgcolor="#FFFFFF" valign="TOP" marginwidth="12" marginheight="12">
<font color="#671247" size="3" face="Verdana, Arial, Helvetica, sans-serif">
<b>Annual Leave Taken</b></font>
</td>
<td align="left" valign="top" width="70%"
bgcolor="#FFFFFF" marginwidth="12" marginheight="12">
<font color="#671247" size="3" face="Verdana, Arial, Helvetica, sans-serif">
<b><?echo "$Annual";?></b></font>
</td>
</tr>
</table>
<div align="center"><center>
<table border="1" cellpadding="2" cellspacing="1" width="100%">
<tr>
<td align="left" valign="bottom" width="30%"
bgcolor="#FFFFFF" valign="TOP" marginwidth="12" marginheight="12">
<font color="#671247" size="3" face="Verdana, Arial, Helvetica, sans-serif">
<b>Medical Leave Taken</b></font>
</td>
<td align="left" valign="top" width="70%"
bgcolor="#FFFFFF" marginwidth="12" marginheight="12">
<font color="#671247" size="3" face="Verdana, Arial, Helvetica, sans-serif">
<b><?echo "$Med";?></b></font>
</td>
</tr>
</table>
<?
$i++;
}
?>
<form action="homeAdmin.php" method="post">
<input type="submit" value="Back" name="Back"><br></form>
?>
How can I make only the current user to change some of the info about him/herself. Another one is for the admin to change it. UPDATE AND DELETE