如果要给table里面的td添加颜色，有两种方法：
<html>
<head>
<meta http-equiv="Content-Type" content="text/html;charset=UTF-8"/>
<!-- 第一种是用stylecss-->
<style type="text/css">
tr:nth-child(even){ /*even：偶数 odd：基数*/
background-color: red;
}
</style>
</head>
<body> </body>
<!-- 第二种是用js+css-->
<script>
function changeColor(){ //改变颜色的函数
var trs = document.getElementsByTagName("tr"); //找到table中的所有的tr
for(var i=0;i<trs.length;i++){
if( i%2 == 0){
trs[i].style.background="#cad9ea";
}
}
}
window.onload = changeColor; </script>
</html>
<?php
$sql = "select * from movie limit 0,5"; //0:从第一条显示 5：显示5条 $totalPage = $count % $pageSize == 0 ? intval($count / $pageSize) : intval($count / $pageSize) + 1;
//intval是强制换成整型
//intval($count / $pageSize) =(int)($count / $pageSize)
echo $totalPage;
?>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html;charset=UTF-8"/>
<style>
tr:nth-child(even){
background: #cad9ea;
}
</style>
</head>
<body>
<table border="1">
<tr style="background-color: #afbcff">
<td>序号</td>
<td>电影名称</td>
<td>主演</td>
<td>类型</td>
<td>操作</td>
</tr>
<?php
$conn = mysql_connect("localhost","","") or die("链接数据库失败");
mysql_select_db("test");
mysql_query("set names 'utf8'"); $page = "";
if(@$_GET['page']){
$page = $_GET['page'];
}else{
$page = 1;
} $pageSize = 3;
$sum = ($page-1)*$pageSize; $sql = "select * from movie limit $sum,$pageSize";
echo $sql;
$result = mysql_query($sql) or die(mysql_error()); $sqlAll = "select * from movie";
$resultAll = mysql_query($sqlAll) or die(mysql_error()); $count = mysql_num_rows($resultAll); $n = 0; while($row = mysql_fetch_array($result)){
?>
<tr>
<td><?php echo $row['id'] ?></td>
<td><a href="movie_detail.php?id=<?php echo $row['id'] ?>"> <?php echo $row['movieName'] ?> </a></td>
<td><?php echo $row['actor'] ?></td>
<td><?php echo $row['type'] ?></td>
<td><a href="#">删除</a></td>
</tr>
<?php
$n++;
}
mysql_close($conn);
?>
</table> <span>共有 <?php echo $count ?>电影</span>
<span>共有<?php
$totalPage = $count % $pageSize == 0? intval($count / $pageSize) : intval($count / $pageSize)+1;
echo $totalPage;
?>页</span>
<a href="movie_About.php?page=<?php echo $page-1 ?>">上一页</a> <?php
for($i=1;$i<=$totalPage;$i++){
?>
<a href="movie_About.php?page=<?php echo $i ?>"><?php echo $i ?></a>
<?php
}
?>
<a href="movie_About.php?page=<?php if($page >= $totalPage){echo $totalPage;}else{echo $page+1;} ?>">下一页</a> 跳转到 <input type="text" name="page" maxlength="5" size="5" id="txt"/> 页
</body>
</html>
<html>
<head>
<title></title>
<meta http-equiv="Content-Type" content="text/html;charset=UTF-8"/>
</head>
<?php
$conn = mysql_connect("localhost","","") or die("链接数据库失败");
mysql_select_db("test");
mysql_query("set names 'utf8'"); if(@$_GET['id']){
$id = $_GET['id'];
$sql = "select * from movie where id = $id";
$r = mysql_query($sql);
$row = mysql_fetch_array($r);
}
?>
<body>
<form action="mov_update.php" method="post">
<input type="hidden" value="<?php echo $row['id'] ?>" name="id" readonly="readonly"/>
电影名称: <input type="text" value="<?php echo $row['movieName'] ?>" name="movieName"/> <br/>
主 演: <input type="text" value="<?php echo $row['actor'] ?>" name="actor"/> <br/>
<input type="submit" name="submit" value="修改"/>
</form>
</body> </html>
<?php
$conn = mysql_connect("localhost","","") or die("链接数据库失败");
mysql_select_db("test");
mysql_query("set names 'utf8'"); if(@$_POST['submit']){
$id = $_POST['id'];
$moviename = $_POST['movieName'];
$actor = $_POST['actor'];
$sql = "UPDATE `movie` SET `movieName`='$movieName',`actor`='$actor' WHERE id = $id";
$r = mysql_query($sql);
if($r){
echo "<script>location.href='movie_About.php'</script>";
}
}
?>
<html>
<head>
<title></title>
<meta http-equiv="Content-Type" content="text/html;charset=UTF-8"/>
</head>
<body> <table border="1">
<tr style="background-color: #afbcff">
<td>序号</td>
<td>电影名称</td>
<td>主演</td>
<td>时长</td>
<td>类型</td>
<td>导演</td>
<td>描述</td>
</tr>
<?php
if(isset($_GET['movieid'])){
$id = $_GET['movieid']; $conn = mysql_connect("localhost","","") or die("链接数据库失败");
mysql_select_db("test");
mysql_query("set names 'utf8'"); $sql = "select * from movie where id = $id";
$result = mysql_query($sql);
$row = mysql_fetch_array($result); echo "<td>".$row['id']."</td>";
echo "<td>".$row['movieName']."</td>";
echo "<td>".$row['actor']."</td>";
echo "<td>".$row['timer']."</td>";
echo "<td>".$row['type']."</td>";
echo "<td>".$row['dirctor']."</td>";
echo "<td>".$row['intro']."</td>";
}else{
echo "<script>alert('you dont request this page by url!,please into by A tag');</script>";
}
?>
</table>
</body>
</html>