1 建立数据库表: 代码如下: create database club; create table member( id int(11) not null auto_increment, no varchar(5) not null, name varchar(10) not null, age int(2) not null, level varchar(10) not null, sex tinyint(1) not null, date datetime not null, primary key(id) )engine=MyISAM default charset=GB2312; insert into member(id,no,name,age,level,sex,date)values (1,'A001','wanxia',30,'hj',1,'2008-04-02 00:00:00'), (2,'C022','liyan',29,'zs',1,'2007-05-31 00:00:00'), (3,'A006','zhangyan',36,'hj',1,'2007-06-20 00:00:00'), (4,'B052','luanying',42,'bj',1,'2007-02-12 00:00:00'), (5,'A007','duxiang',26,'hj',2,'2008-03-26 00:00:00'), (6,'C060','liuyu',38,'zs',1,'2008-10-16 00:00:00');
$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']." "; break; case 'hj': echo "等级:黄金会员 人数:".$row['num']." "; break; default: echo "等级:钻石会员 人数:".$row['num']." "; } } ?> 会员优惠升级:从
升级至
3.2 建立up_level.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 " 黄金会员 "; break; default: echo " 钻石会员 "; } echo "成功升级到"; switch(trim($_POST['new_level'])){ case 'bj': echo " 白金会员 " ; break; case 'hj': echo " 黄金会员 "; break; default: echo " 钻石会员 "; } ?>