<?php
if($row=mysql_fetch_array($result))
{
echo "编号：".$row['no']."<br />";
echo "姓名：".$row['name']."<br />";
echo "性别：".($row['sex']==1?"女":"男")."<br />";
echo "年龄：".$row['age']."<br />";
echo "级别：".$row['level']."<br />";
echo "加入：".$row['join_date']."<br />";
}
?>
</body>
</html>
3 修改数据
3.1 建立level.php（修改数据）
<html>
<head>
<meta http-equiv="Content-Type" content="text/html;charset=GB2312" />
<title>俱乐部优惠活动</title>
</head>
<body>
<h1>俱乐部会员统计表</h1>
<?php
$link=mysql_connect("localhost","root","123"); //连接mysql服务器
$db=mysql_select_db("club"); //选择数据库
mysql_query("set name utf8",$link); //设定编码方式
$sql="Select level,count(*) as num from member group by level";
$result=mysql_query($sql,$link); //执行select查询
while($row=mysql_fetch_array($result))
{
switch($row['level']){
case 'bj':
echo "等级：白金会员 人数：".$row['num']."<br />";
break;
case 'hj':
echo "等级：黄金会员 人数：".$row['num']."<br />";
break;
default:
echo "等级：钻石会员 人数：".$row['num']."<br />";
}
}
?>
<form action="up_level.php" name="level" method="post">
会员优惠升级：从
<select name="old_level">
<option value="hj">黄金会员</option>
<option value="bj">白金会员</option>
</select>
升级至
<select name="new_level">
<option value="bj">白金会员</option>
<option value="zs">钻石会员</option>
</select>
<input type="submit" value="确定"/>
</form>
</body>
</html>
3.2 建立up_level.php
<html>
<head>
<meta http-equiv="Content-Type" content="text/html;charset=GB2312" />
<title>俱乐部优惠活动</title>
</head>
<body>
<?php
$link=mysql_connect("localhost","root","123"); //连接mysql服务器
$db=mysql_select_db("club"); //选择数据库
mysql_query("set name utf8",$link); //设定编码方式
$sql="update member set level='".trim($_POST['new_level'])
."' where level='".trim($_POST['old_level'])."'";
$result=mysql_query($sql,$link); //执行select查询
echo mysql_affected_rows($link)."人 从";
switch(trim($_POST['old_level'])){
case 'bj':
echo " 白金会员 " ;
break;
case 'hj':
echo " 黄金会员 ";
