php实现员工管理系统

<? session_start(); require ('db_connect.php'); if(!isset($_SESSION['root'])) { echo "<p align=center>"; echo "<font color=#FF0000 size=5><strong><big>"; echo "您还没有登录,请<a href='index.php'>登录</a>后再操作!"; echo "</big></strong></font></p>"; exit(); } ?> <script language=javascript> function unselectall(){ if(document.form1.chkAll.checked){ document.form1.chkAll.checked = document.form1.chkAll.checked&0; } } function CheckAll(form1){ for (var i=0;i<form1.elements.length;i++){ var e = form1.elements[i]; if (e.Name != 'chkAll'&&e.disabled==false) e.checked = form1.chkAll.checked; } } </script> <?php $sql=mysql_query("select count(*) as total from yuangong ",$conn); $info=mysql_fetch_array($sql); $total=$info[total]; if($total==0){ echo "暂无成员信息!"; } else{ $pagesize=5; if ($total<=$pagesize){ $pagecount=1; } if(($total%$pagesize)!=0){ $pagecount=intval($total/$pagesize)+1; }else{ $pagecount=$total/$pagesize; } if(($_GET[page])==""){ $page=1; }else{ $page=intval($_GET[page]); } $sql1=mysql_query("select * from yuangong order by id desc limit ".($page-1)*$pagesize.",$pagesize",$conn); $info1=mysql_fetch_array($sql1); ?> <form name="form1" method="post" action="delete.php"> <table width="750" border="0" align="center" cellpadding="0" cellspacing="0"> <tr> <td height="20" bgcolor="#FFCF60"><div align="center" class="style1">查看信息 </div></td> </tr> <tr> <td height="40" bgcolor="#666666"><table width="828" height="44" border="0" align="center" cellpadding="0" cellspacing="1"> <tr> <td width="70" height="20" bgcolor="#FFFFFF"><div align="center">姓名</div></td> <td width="59" bgcolor="#FFFFFF"><div align="center">性别</div></td> <td width="81" bgcolor="#FFFFFF"><div align="center">出生日期</div></td> <td width="141" bgcolor="#FFFFFF"><div align="center">毕业院校</div></td> <td width="87" bgcolor="#FFFFFF"><div align="center">学历</div></td> <td width="85" bgcolor="#FFFFFF"><div align="center">部门</div></td> <td width="103" bgcolor="#FFFFFF"><div align="center">职位</div></td> <td width="193" bgcolor="#FFFFFF"><div align="center">操作&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 全选<input name='chkAll' type='checkbox' id='chkAll' onclick='CheckAll(this.form)' value='checkbox'> </div></td> </tr> <?php do{ ?> <tr> <td height="21" bgcolor="#FFFFFF"><div align="center"><?php echo $info1[name];?></div></td> <td height="21" bgcolor="#FFFFFF"><div align="center"> <?php switch($info1[sex]) { case 0: echo "男"; break; case 1: echo "女"; break; } ?></div></td> <td height="21" bgcolor="#FFFFFF"><div align="center"><?php echo $info1[birthday];?></div></td> <td height="21" bgcolor="#FFFFFF"><div align="center"><?php echo $info1[school];?></div></td> <td height="21" bgcolor="#FFFFFF"><div align="center"><?php switch($info1[education]) { case 0: echo "大专"; break; case 1: echo "本科"; break; case 2: echo "硕士"; } ?></div></td> <td height="21" bgcolor="#FFFFFF"><div align="center"><?php $sql3=mysql_query("select * from department where id='$info1[departid]'",$conn); $info3=mysql_fetch_array($sql3); echo $info3[departname];?></div></td> <td height="21" bgcolor="#FFFFFF"><div align="center"> <?php $sql2=mysql_query("select * from position where id='$info1[jobid]'" ,$conn); $info2=mysql_fetch_array($sql2); echo $info2[jobname]; ?> </div></td> <td height="21" bgcolor="#FFFFFF"><div align="center"> <input name="button" type="button" id="button" onclick="javascript:window.open('show.php?id=<?php echo $info1[id];?>','newwindow','width=600,height=600,left=100,top=100,menubar=yes,toolbar=yes,resizable=yes,location=yes,scrollbars=yes')" value="查看" /> <a href="change.php?id=<?php echo $info1[id];?>">修改</a>| <a href="add.php?id=<?php echo $info1[id];?>">增加</a> <input type="checkbox" name=<?php echo $info1[id];?> value=<?php echo $info1[id];?>></div></td> </tr> <?php }while($info1=mysql_fetch_array($sql1)) ?> </table></td> </tr> </table> <table width="750" height="20" border="0" align="center" cellpadding="0" cellspacing="0"> <tr> <td width="652"><div align="right"> 本站共有订单 <?php echo $total; ?> &nbsp;条&nbsp;每页显示&nbsp;<?php echo $pagesize;?>&nbsp;条&nbsp;第&nbsp;<?php echo $page;?>&nbsp;页/共&nbsp;<?php echo $pagecount; ?>&nbsp;页 <?php if($page>=2) { ?> <a href="list.php?page=1" title="首页"><font face="webdings"> 9 </font></a> <a href="list.php?id=<?php echo $id;?>&page=<?php echo $page-1;?>" title="前一页"><font face="webdings"> 7 </font></a> <?php } if($pagecount<=4){ for($i=1;$i<=$pagecount;$i++){ ?> <a href="list.php?page=<?php echo $i;?>"><?php echo $i;?></a> <?php } }else{ for($i=1;$i<=4;$i++){ ?> <a href="list.php?page=<?php echo $i;?>"><?php echo $i;?></a> <?php }?> <a href="list.php?page=<?php echo $page-1;?>" title="后一页"><font face="webdings"> 8 </font></a> <a href="list.php?id=<?php echo $id;?>&page=<?php echo $pagecount;?>" title="尾页"><font face="webdings"> : </font></a> <?php }?> </div></td> <td width="98"><div align="center"><input type="hidden" name="page_id" value=<?php echo $page;?>><input type="submit" value="删除选择项" ></div></td> </tr> </table> <?php } ?> </form> <a href="add.php">添加新成员</a>|<a href="update.php">修改成员信息</a>|<a href="logout.php">退出</a>