<?php
session_start();
include_once 'conn.php';
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>员工信息</title>
<script type="text/javascript" src="js/My97DatePicker/WdatePicker.js" charset="gb2312"></script>
<link rel="stylesheet" href="images/hsgcommon/common.css" type="text/css">
<link rel="stylesheet" href="images/hsgcommon/div.css" type="text/css">
</head>
<body>
<p>已有员工信息列表：</p>
<form id="form1" name="form1" method="post" action="">
搜索: 工号：<input name="gonghao" type="text" id="gonghao" class="form-control2" /> 姓名：<input name="xingming" type="text" id="xingming" class="form-control2" /> 性别：<select name='xingbie' id='xingbie' class="form-control2"><option value="">所有</option><option value="男">男</option><option value="女">女</option></select> 电话：<input name="dianhua" type="text" id="dianhua" class="form-control2" /> 部门：<select name='bumen' id='bumen' class="form-control2"><option value="">所有</option><option value="人事部">人事部</option><option value="财务部">财务部</option><option value="技术部">技术部</option><option value="销售部">销售部</option><option value="售后部">售后部</option><option value="后勤部">后勤部</option></select> 排序
<select name="paixu" id="paixu" class="form-control2">
<option value="addtime">添加时间</option>
</select>
<select name="px" id="px" class="form-control2">
<option value="desc">降序</option>
<option value="asc">升序</option>
</select>
<input type="submit" name="Submit" value="查找" class="btn btn-info btn-small" />
</form>
<table width="100%" border="1" align="center" cellpadding="3" cellspacing="1" bordercolor="#CCCCCC" >
<tr>
<td width="25" bgcolor="#CCCCCC">序号</td>
<td bgcolor='#CCCCCC'>工号</td>
<td bgcolor='#CCCCCC'>密码</td>
<td bgcolor='#CCCCCC'>姓名</td>
<td bgcolor='#CCCCCC'>性别</td>
<td bgcolor='#CCCCCC'>电话</td>
<td bgcolor='#CCCCCC'>部门</td>
<td bgcolor='#CCCCCC'>入职时间</td>
<td width="120" align="center" bgcolor="#CCCCCC">添加时间</td>
<td width="120" align="center" bgcolor="#CCCCCC">操作</td>
</tr>
<?php
$sql="select * from yuangongxinxi where 1=1";
if ($_POST["gonghao"]!=""){$nreqgonghao=$_POST["gonghao"];$sql=$sql." and gonghao like '%$nreqgonghao%'";}
if ($_POST["xingming"]!=""){$nreqxingming=$_POST["xingming"];$sql=$sql." and xingming like '%$nreqxingming%'";}
if ($_POST["xingbie"]!=""){$nreqxingbie=$_POST["xingbie"];$sql=$sql." and xingbie like '%$nreqxingbie%'";}
if ($_POST["dianhua"]!=""){$nreqdianhua=$_POST["dianhua"];$sql=$sql." and dianhua like '%$nreqdianhua%'";}
if ($_POST["bumen"]!=""){$nreqbumen=$_POST["bumen"];$sql=$sql." and bumen like '%$nreqbumen%'";}
if($_POST["paixu"]!="")
{
$sql=$sql." order by ".$_POST["paixu"]." ".$_POST["px"]."";
}
else
{
$sql=$sql." order by id desc";
}
$query=mysql_query($sql);
$rowscount=mysql_num_rows($query);
if($rowscount==0)
{}
else
{
$pagelarge=10;//每页行数；
$pagecurrent=$_GET["pagecurrent"];
if($rowscount%$pagelarge==0)
{
$pagecount=$rowscount/$pagelarge;
}
else
{
$pagecount=intval($rowscount/$pagelarge)+1;
}
if($pagecurrent=="" || $pagecurrent<=0)
{
$pagecurrent=1;
}
if($pagecurrent>$pagecount)
{
$pagecurrent=$pagecount;
}
$ddddd=$pagecurrent*$pagelarge;
if($pagecurrent==$pagecount)
{
if($rowscount%$pagelarge==0)
{
$ddddd=$pagecurrent*$pagelarge;
}
else
{
$ddddd=$pagecurrent*$pagelarge-$pagelarge+$rowscount%$pagelarge;
}
}
for($i=$pagecurrent*$pagelarge-$pagelarge;$i<$ddddd;$i++)
{
?>
<tr>
<td width="25"><?php echo $i+1;?></td>
<td><?php echo mysql_result($query,$i,gonghao);?></td>
<td><?php echo mysql_result($query,$i,mima);?></td>
<td><?php echo mysql_result($query,$i,xingming);?></td>
<td><?php echo mysql_result($query,$i,xingbie);?></td>
<td><?php echo mysql_result($query,$i,dianhua);?></td>
<td><?php echo mysql_result($query,$i,bumen);?></td>
<td><?php echo mysql_result($query,$i,ruzhishijian);?></td>
<td width="120" align="center"><?php echo mysql_result($query,$i,"addtime");?></td>
<td width="220" align="center"><a class="btn btn-info btn-small" href="del.php?id=<?php echo mysql_result($query,$i,"id");?>&tablename=yuangongxinxi" onclick="return confirm('真的要删除？')">删除</a> <a class="btn btn-info btn-small" href="yuangongxinxi_updt.php?id=<?php echo mysql_result($query,$i,"id");?>">修改</a> <a class="btn btn-info btn-small" href="yuangongxinxi_detail.php?id=<?php echo mysql_result($query,$i,"id");?>">详细</a> </td>
</tr>
<?php
}
}
?>
</table>
<p>以上数据共<?php echo $rowscount;?>条,
<input type="button" name="Submit2" onclick="javascript:window.print();" value="打印本页" class="btn btn-info btn-small" /> <input type="button" name="Submit3" onclick="javascript:location.href='yuangongxinxi_listxls.php';" value="导出EXCEL" class="btn btn-info btn-small" />
</p>
<p align="center" class="fy"><a href="yuangongxinxi_list.php?pagecurrent=1">首页</a> <a href="yuangongxinxi_list.php?pagecurrent=<?php echo $pagecurrent-1;?>">前一页</a> <a href="yuangongxinxi_list.php?pagecurrent=<?php echo $pagecurrent+1;?>">后一页</a> <a href="yuangongxinxi_list.php?pagecurrent=<?php echo $pagecount;?>">末页</a> 当前第<?php echo $pagecurrent;?>页,共<?php echo $pagecount;?>页 </p>
</body>
</html>
基于PHP MySQL实现公司考勤管理系统【优质毕业设计、课程设计项目】.zip
版权申诉
5星 · 超过95%的资源 82 浏览量
2023-05-31
23:02:01
上传
评论
收藏 1.51MB ZIP 举报 
基于PHP MySQL实现公司考勤管理系统【优质毕业设计、课程设计项目】.zip （122个子文件） 
common.css 118KB style.css 14KB datepicker.css 4KB datepicker.css 4KB div.css 4KB divqt.css 3KB css.css 3KB commonqt.css 2KB WdatePicker.css 158B index.css 100B
img.gif 2KB img.gif 2KB datePicker.gif 1KB Upload.gif 111B
login.html 2KB
1.jpg 151KB 1608190954o5zr.jpg 90KB touxiang88.jpg 59KB touxiang28.jpg 56KB touxiang85.jpg 45KB touxiang84.jpg 43KB nopic5.jpg 32KB nopic2.jpg 32KB nopic3.jpg 32KB nopic4.jpg 32KB nopic1.jpg 32KB touxiang10.jpg 30KB touxiang17.jpg 28KB touxiang8.jpg 25KB nopic.jpg 24KB touxiang6.jpg 16KB touxiang48.jpg 15KB yhtx2.jpg 12KB touxiang38.jpg 11KB touxiang7.jpg 10KB yhtx1.jpg 8KB yhtx4.jpg 8KB touxiang41.jpg 7KB touxiang15.jpg 5KB touxiang63.jpg 5KB touxiang69.jpg 4KB touxiang55.jpg 4KB touxiang39.jpg 4KB touxiang71.jpg 4KB touxiang78.jpg 4KB touxiang68.jpg 4KB touxiang40.jpg 3KB yhtx5.jpg 3KB touxiang76.jpg 3KB touxiang87.jpg 3KB yhtx3.jpg 3KB bg.jpg 307B echarts.min.js 727KB jq.js 284KB jquery.js 82KB bootbox.js 38KB common.js 36KB calendar.js 21KB WdatePicker.js 9KB Particleground.js 7KB verificationNumbers.js 2KB zh-cn.js 1KB zh-tw.js 1KB en.js 644B MANIFEST.MF 39B yuangongxinxi_list.php 6KB yuangongxinxi_add.php 5KB yhzhgl.php 5KB yuangongxinxi_updt.php 4KB kaoqinqiandao_list.php 4KB yuangongxinxi_updt2.php 4KB kaoqinqiandao_list2.php 4KB kaoqinqiandao_add.php 4KB left_guanliyuan.php 4KB left_yuangong.php 3KB kaoqinqiandao_updt.php 3KB mod.php 3KB sy.php 3KB conn.php 2KB upfile.php 2KB yuangongxinxi_detail.php 2KB yuangongxinxi_listxls.php 2KB yuangongxinxi_tj_xingbie.php 2KB yuangongxinxi_tj_bumen.php 2KB kaoqinqiandao_listxls.php 1KB top.php 1KB shanchushuju.php 1KB databack.php 1KB login.php 1KB code.php 1KB main.php 769B sh.php 478B del.php 393B mygo.php 284B checkA.php 252B logout.php 184B updatefile.php3 489B
16092200754jy3.png 306KB 1608792580x715.png 22KB home_current.png 2KB共 122 条
- 1
- 2
资源评论
2201_755267582023-06-20果断支持这个资源，资源解决了当前遇到的问题，给了新的灵感，感谢分享~
不脱发的程序猿
- 粉丝: 24w+
- 资源: 5763
