<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>reg</title>
</head>
<body >
<h1 align="center" >球员信息维护</h1>
<hr>
<h3 align="center" ><a href="addInfo.php">添加</a></h3>
<div align="center">
<?php
//显示相应操作结果信息
if((!empty($_GET['errno']))&&($_GET['errno']==1)){
echo"添加成功";
}
if((!empty($_GET['errno']))&&($_GET['errno']==2)){
echo"添加失败";
}
if((!empty($_GET['errno']))&&($_GET['errno']==3)){
echo"删除成功";
}
if((!empty($_GET['errno']))&&($_GET['errno']==5)){
echo"修改失败";
}
if((!empty($_GET['errno']))&&($_GET['errno']==4)){
echo"修改成功";
}
?>
</div>
<br>
<?php
$conn=mysql_connect("localhost","root","root");
if (!$conn) {
die("连接失败".mysql_errno());
}
mysql_query("set names utf8",$conn) or die("设字符编码失败".mysql_errno());
mysql_select_db('footballplayerdb',$conn) or die("选择数据库失败".mysql_errno()) ;
$sqlCount="SELECT count(playerid) FROM playerinfo";
$pageSize=5;
$rowCountRes=mysql_query($sqlCount,$conn);
while ($row=mysql_fetch_row($rowCountRes)){
$rowCount=$row[0];
}
$pagecount=ceil($rowCount/$pageSize);
$pageNow=1;
if (!empty($_GET['pageNow'])) {
$pageNow=$_GET['pageNow'];
}
$sql="select playerid,playername,playerpositions,playerteam,playernum from playerinfo limit ".($pageNow-1)*$pageSize." , ".$pageSize;
$res=mysql_query($sql,$conn);
?>
<table width=""><tr align="centeer"><td width="21%"></td></tr></table>
<?php
echo "<table border='1px' width='54%' cellspacing='0' align='center'><tr align='centeer'><td width='12%' align='center'>球员ID</td><td width='12%' align='center' >球员姓名</td><td width='12%' align='center'>球员职责</td><td width='12%' align='center'>所属球队</td><td width='12%' align='center'>球衣号码</td><td width='12%' align='center'>操作</td><td width='12%' align='center'>操作</td></tr>";
while($row=mysql_fetch_assoc($res)){
echo "<tr align='centeer'><td align='center'>{$row['playerid']}</td><td align='center'>{$row['playername']}</td><td align='center'>{$row['playerpositions']}</td><td align='center'>{$row['playerteam']}</td><td align='center'>{$row['playernum']}</td><td align='center'><a href='getInfoForUpdate.php?playerid={$row['playerid']}''>修改</a></td><td align='center'><a href='deleteController.php?playerid={$row['playerid']}'>删除</a></td></tr>";
}
echo "<tr bgcolor='#CCFFFF'><td colspan='7' align='center' bordercolor='#CCFFFF'><a href='showInfo.php?pageNow=1'>首页</a> "; if ($pageNow>1){$pagePre=$pageNow-1; echo "<a href='showInfo.php?pageNow=$pagePre'>上一页</a>" ;}echo " "; if($pageNow<$pagecount){ $pageNext=$pageNow+1; echo "<a href='showInfo.php?pageNow=$pageNext'>下一页</a> "; }echo "<a href='showInfo.php?pageNow=$pagecount'>尾页</a></td></tr>";
echo "</table>";?>
</body>
</html>
footballplayermanager.zip （13个子文件） 
footballplayermanager 
.project 531B regController.php 834B .buildpath 174B addInfo.php 850B addInfoController.php 896B showInfo.php 3KB .settings org.eclipse.php.core.prefs 97B deleteController.php 543B updateInfo.php 913B index.php 960B loginController.php 852B reg.php 775B getInfoForUpdate.php 2KB资源评论
云南小白2013-11-07得自己研究的补充代码了
阿星7772014-07-15不错，结构简单，但是貌似查询的功能不太强！
qq_376345072017-10-21得自己研究的补充代码了，写的不错
liyuan128502017-06-26但是5分太高了- lhbaiya2013-12-17没怎么仔细看，但是5分太高了....
细剪一夜秋
- 粉丝: 0
- 资源: 5
