<html>
<body>
<?php
if(isset($_POST['sub']))
{
$empid=$_POST['empid'];
$con=mysql_connect("localhost","root","root");
if(!$con)
//die('problem occured",mysql_error());
echo "error in connecting";
else
{
mysql_query("use cat",$con);
// ****************** CODE FOR GENERATING PAY SLIP *****************//
$query1="select * from employee where eid=$empid";
$result1=mysql_query($query1,$con);
?>
<br/><h3 align="center">---PAY SLIP FOR EMPLOYEE ID <?php echo $empid; ?>---<h3><br/>
<br/>
<table border="1" align="center">
<?php
$row = mysql_fetch_row($result1);
$i=0;
while ($property = mysql_fetch_field($result1))
{
echo "<tr>";
echo "<th>$property->name</th>";
?>
<td><?php echo $row[$i]; ?></td></tr>
<?php
$i++;
}
?>
<!-- ****************** CODE FOR TO DISPLAY EMP going to take rest in 2012 *****************// -->
</table>
<br/><h3 align="center">---EMPLOYEES GONNA TAKE REST FROM 2012 ONWARDS--------</h3>
<br/>
<?php
$query2="select eid,ename,YEAR(CURDATE())-YEAR(dob) AS age from employee where dob IN(select dob from employee where (YEAR(CURDATE())-YEAR(dob))>65)";
$result3=mysql_query($query2,$con);
?>
<table border="2" align="center">
<tr>
<th>employee id</th>
<th>name</th>
<th>Age</th>
</tr>
<?php
while($row=mysql_fetch_array($result3))
{
?>
<tr>
<td> <?php echo $row['eid']?></td>
<td> <?php echo $row['ename']?></td>
<td> <?php echo $row['age']?></td>
</tr>
<?php
}
echo "</table>";
?>
<!--*******************Display the employee name starts with �J�************************//-->
<br/><h3 align="center">---EMPLOYEES Names starts with "J"--------</h3>
<br/>
<?php
$query3="select eid,ename from employee where ename LIKE 'J%'";
$result4=mysql_query($query3,$con);
?>
<table border="2" align="center">
<tr>
<th>employee id</th>
<th>name</th>
</tr>
<?php
while($row=mysql_fetch_array($result4))
{
?>
<tr>
<td> <?php echo $row['eid']?></td>
<td> <?php echo $row['ename']?></td>
</tr>
<?php
}
echo "</table>";
// *********************END********************************//
}
}
?>
</table>
</body>
</html>
PHP.rar （10个子文件） 
PHP programs 
student.php 549B online_reg_form.php 674B book_form.php 456B booksql.php 2KB email_sql.php 2KB employee_sql.php 1KB student_sql.php 2KB online_reg_form_validate.php 2KB email.php 597B employee_payslip.php 2KB资源评论
