基于Sql Server 2008的分布式数据库的实践（五）
程序设计
-----------------------------------------------------------------------------------------------------------------
Index.php————选择界面，并且实现学生和老师的注册
sql_ini.php————SQL配置文件
./student————学生的后台
./admin————老师的后台
-----------------------------------------------------------------------------------------------------------------
./student
cookie.php————cookie转跳文件
index1.php————后台界面
login.php————登录界面
loginout.php————cookie注销处理
main.php————主界面
menu.php————后台菜单
sclass.php————显示学生选课信息
score.php-————显示学生成绩
sinfo.php————显示学生资料
sql_ini.php————SQL配置文件
up.php————后台表单处理文件
-----------------------------------------------------------------------------------------------------------------
./admin
class.php————显示老师课程信息
cookie.php————cookie转跳文件
index1.php————后台界面
info.php————显示老师资料（有权限设置）
login.php————登录界面
loginout.php————cookie注销处理
main.php————主界面
menu.php————后台菜单
score.php-————登记学生成绩
sql_ini.php————SQL配置文件
up.php————后台表单处理文件
程序解释
学生注册
((['addstudent'
((['sname']=='')||(['sex']=='')||(['school']=='')||(['scount']=='')||(['spwd1']=='')||(['spwd2']=='' '请输全信息！'
=['sname' =['sex' =['school' =['scount' =['spwd1' =['spwd2' =(1,9999);
(==
="select * from [V3].[dbo].[V3_student]" = mssql_query(
( = mssql_fetch_array(,
(['scount']==
("已经有人申请了这个帐号！"
=" VALUES ("..",'".."','".."','".."','".."','".."')" = mssql_query(
( { "<center>注册成功！</center>"
{ "sql出错！"
("两次密码不对" }
老师注册
((['addadmin'
((['name']=='')||(['sex']=='')||(['age']=='')||(['count']=='')||(['pwd']=='')||(['pwd2']=='')||(['ageage']=='')||(['tel']=='')||(['address']=='' '请输全信息！'
=['name' =['sex' =['age' =['count' =['pwd' =['pwd2' =['ageage' =['tel' =['address' =1 =(1,9999
(==
="select * from [V3].[dbo].[teacher]" = mssql_query(
( = mssql_fetch_array(,
(['tcount']==
("已经有人申请了这个帐号！" ="EXEC [V3].[dbo].[V3_teacher] "..",'".."', '".."', '".."', '".."', '".."', '".."','".."','".."','".."'" = mssql_query( ( { "<center>注册成功！</center>"
{ "sql出错！"
("两次密码不对" }
学生登录和查看资料
=['uid'
= "SELECT * FROM [V3].[dbo].[V3_student] where [sid]=".."" = mssql_query(
=mssql_num_fields(
[0]='学号' [1]='姓名' [2]='学院' [3]='帐号' [4]='密码'
"<table border='1' >\n" "\t<tr>\n" (=0;<;++
"\t\t<td>".[]."</td>\n" "\t</tr>\n" ( = mssql_fetch_array(,
"\t<tr>\n" '<td>'.["sid"].'</td>' '<td>'.["sname"].'</td>' '<td>'.["school"].'</td>' '<td>'.["scount"].'</td>' '<td>******</td>';
"\t</tr>\n" "</table>\n"
mssql_free_result();
学生选课
(['action']=='do'
=["uid"
="SELECT * FROM [V3].[dbo].[class] where [sid]=".."" = mssql_query( =0;
( = mssql_fetch_array(, []=['cid' ++
="SELECT * FROM [V3].[dbo].[class] where [sid] = 0" = mssql_query( =0;
( = mssql_fetch_array(, []=['tid' []=['cid' []=['cname' ++
(=0;<;++ []="SELECT * FROM [V3].[dbo].[teacher] where [tid]=".[]."" []= mssql_query([ ( = mssql_fetch_array([], []=['tsex' []=['tage' []=['tname'
[0]='课号' [1]='课名' [2]='老师名字' [3]='老师编号' [4]='老师教学年龄' [5]='老师性别' [6]='选课'
'<form action="up.php" method="POST">' "<table border='1' >\n" "\t<tr><td colspan='7' align='center'>选课系统</td></tr>\n" "\t<tr>\n" "\t<tr>\n"
(=0;<7;++ "\t\t<td>".[]."</td>\n" (=0;<;++
= ''
([]=='0' []='男'
[]='女'
(=0;