程序设计
-----------------------------------------------------------------------------------------------------------------
Index.php————选择界面，并且实现学生和老师的注册
sql_ini.php————SQL配置文件
./student————学生的后台
立即学习“PHP免费学习笔记（深入）”；
./admin————老师的后台
-----------------------------------------------------------------------------------------------------------------
./student
cookie.php————cookie转跳文件
index1.php————后台界面
login.php————登录界面
loginout.php————cookie注销处理
main.php————主界面
menu.php————后台菜单
sclass.php————显示学生选课信息
score.php-————显示学生成绩
sinfo.php————显示*
华友协同办公自动化OA系统
下载
华友协同办公管理系统(华友OA)，基于微软最新的.net 2.0平台和SQL Server数据库，集成强大的Ajax技术，采用多层分布式架构，实现统一办公平台，功能强大、价格便宜，是适用于企事业单位的通用型网络协同办公系统。 系统秉承协同办公的思想，集成即时通讯、日记管理、通知管理、邮件管理、新闻、考勤管理、短信管理、个人文件柜、日程安排、工作计划、工作日清、通讯录、公文流转、论坛、在线调查、
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————后台表单处理文件
程序解释
学生注册
<span> <span if>(<span isset>(<span>['addstudent'<span><span> <span><span> <span><span>
<span> <span if>((<span>['sname']=='')||(<span>['sex']=='')||(<span>['school']=='')||(<span>['scount']=='')||(<span>['spwd1']=='')||(<span>['spwd2']==''<span><span> <span><span> <span echo> '请输全信息！'<span><span> <span exit><span><span> <span><span> <span><span>
<span> <span>=<span>['sname'<span><span> <span>=<span>['sex'<span><span> <span>=<span>['school'<span><span> <span>=<span>['scount'<span><span> <span>=<span>['spwd1'<span><span> <span>=<span>['spwd2'<span><span> <span>=<span rand>(1,9999);<span><span><span> <span>
<span> <span if>(<span>==<span><span><span> <span><span> <span><span sql server>
<span> <span sql><span> <span><span sql>
<span> <span>="select * from [V3].[dbo].[V3_student]"<span><span> <span> = mssql_query(<span><span><span> <span><span>
<span> <span while> (<span> = mssql_fetch_array(<span>,<span mssql_assoc><span> <span><span> <span><span>
<span> <span if>(<span>['scount']==<span><span><span> <span><span> <span><span>
<span> <span echo> ("已经有人申请了这个帐号！"<span><span> <span exit><span><span> <span><span> <span><span> <span><span sql>
<span> <span>="<span insert into><span> VALUES (".<span>.",'".<span>."','".<span>."','".<span>."','".<span>."','".<span>."')"<span><span> <span> = mssql_query(<span><span><span> <span><span>
<span> <span if>(<span><span><span> {<span echo> "<center>注册成功！</center>"<span><span> <span else>
<span> {<span echo> "sql出错！"<span><span> <span><span> <span else>
<span> <span><span> <span><span>
<span> <span echo> ("两次密码不对"<span><span> <span exit><span><span> <span><span> }</span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span>
老师注册
<span> <span if>(<span isset>(<span>['addadmin'<span><span> <span><span> <span><span>
<span> <span if>((<span>['name']=='')||(<span>['sex']=='')||(<span>['age']=='')||(<span>['count']=='')||(<span>['pwd']=='')||(<span>['pwd2']=='')||(<span>['ageage']=='')||(<span>['tel']=='')||(<span>['address']==''<span><span> <span><span> <span echo> '请输全信息！'<span><span> <span exit><span><span> <span><span> <span><span>
<span> <span>=<span>['name'<span><span> <span>=<span>['sex'<span><span> <span>=<span>['age'<span><span> <span>=<span>['count'<span><span> <span>=<span>['pwd'<span><span> <span>=<span>['pwd2'<span><span> <span>=<span>['ageage'<span><span> <span>=<span>['tel'<span><span> <span>=<span>['address'<span><span> <span>=1<span><span> <span>=<span rand>(1,9999<span><span> <span><span>
<span> <span if>(<span>==<span><span><span> <span><span> <span><span sql server>
<span> <span sql><span> <span><span sql>
<span> <span>="select * from [V3].[dbo].[teacher]"<span><span> <span> = mssql_query(<span><span><span> <span><span>
<span> <span while> (<span> = mssql_fetch_array(<span>,<span mssql_assoc><span> <span><span> <span><span>
<span> <span if>(<span>['tcount']==<span><span><span> <span><span> <span><span>
<span> <span echo> ("已经有人申请了这个帐号！"<span><span> <span exit><span><span> <span><span> <span><span> <span>="EXEC [V3].[dbo].[V3_teacher] ".<span>.",'".<span>."', '".<span>."', '".<span>."', '".<span>."', '".<span>."', '".<span>."','".<span>."','".<span>."','".<span>."'"<span><span> <span> = mssql_query(<span><span><span> <span if>(<span><span><span> {<span echo> "<center>注册成功！</center>"<span><span> <span else>
<span> {<span echo> "sql出错！"<span><span> <span><span> <span else>
<span> <span><span> <span><span>
<span> <span echo> ("两次密码不对"<span><span> <span exit><span><span> <span><span> }</span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span>学生登录和查看资料
<span> <span><span cookie> <span> <span>=<span>['uid'<span><span> <span sql><span> <span><span sql> <span> <span> = "SELECT * FROM [V3].[dbo].[V3_student] where [sid]=".<span>.""<span><span> <span> = mssql_query(<span><span><span> <span><span> <span> <span>=mssql_num_fields(<span><span><span> <span><span> <span> <span>[0]='学号'<span><span> <span>[1]='姓名'<span><span> <span>[2]='学院'<span><span> <span>[3]='帐号'<span><span> <span>[4]='密码'<span><span> <span><span><span> <span html><span> <span><span> <span> <span echo> "<table border='1' >\n"<span><span> <span echo> "\t<tr>\n"<span><span> <span for>(<span>=0;<span><<span>;<span>++<span><span> <span><span> <span><span> <span> <span echo> "\t\t<td>".<span>[<span>]."</td>\n"<span><span> <span><span> <span echo> "\t</tr>\n"<span><span> <span while> (<span> = mssql_fetch_array(<span>,<span mssql_assoc><span> <span><span> <span><span> <span> <span echo> "\t<tr>\n"<span><span> <span echo> '<td>'.<span>["sid"].'</td>'<span><span> <span echo> '<td>'.<span>["sname"].'</td>'<span><span> <span echo> '<td>'.<span>["school"].'</td>'<span><span> <span echo> '<td>'.<span>["scount"].'</td>'<span><span> <span echo> '<td>******</td>';<span><span> <span> <span echo> "\t</tr>\n"<span><span> <span><span> <span echo> "</table>\n"<span><span> <span><span> <span> mssql_free_result(<span>);</span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span>
学生选课
<span> <span><span get> <span> <span if>(<span>['action']=='do'<span><span> <span><span> <span><span cookie> <span> <span>=<span>["uid"<span><span> <span sql><span> <span><span sid> <span> <span>="SELECT * FROM [V3].[dbo].[class] where [sid]=".<span>.""<span><span> <span> = mssql_query(<span><span><span> <span>=0;<span><span> <span> <span while> (<span> = mssql_fetch_array(<span>,<span mssql_assoc><span> <span><span> <span>[<span>]=<span>['cid'<span><span> <span>++<span><span> <span><span> <span> <span><span sql> <span> <span>="SELECT * FROM [V3].[dbo].[class] where [sid] = 0"<span><span> <span> = mssql_query(<span><span><span> <span>=0;<span><span> <span> <span while> (<span> = mssql_fetch_array(<span>,<span mssql_assoc><span> <span><span> <span>[<span>]=<span>['tid'<span><span> <span>[<span>]=<span>['cid'<span><span> <span>[<span>]=<span>['cname'<span><span> <span>++<span><span> <span><span> <span><span sql> <span> <span for>(<span>=0;<span><<span>;<span>++<span><span> <span><span> <span>[<span>]="SELECT * FROM [V3].[dbo].[teacher] where [tid]=".<span>[<span>].""<span><span> <span>[<span>]= mssql_query(<span>[<span><span><span> <span while> (<span> = mssql_fetch_array(<span>[<span>],<span mssql_assoc><span> <span><span> <span>[<span>]=<span>['tsex'<span><span> <span>[<span>]=<span>['tage'<span><span> <span>[<span>]=<span>['tname'<span><span> <span><span> <span><span> <span><span> <span> <span>[0]='课号'<span><span> <span>[1]='课名'<span><span> <span>[2]='老师名字'<span><span> <span>[3]='老师编号'<span><span> <span>[4]='老师教学年龄'<span><span> <span>[5]='老师性别'<span><span> <span>[6]='选课'<span><span> <span><span><span> <span html><span> <span><span> <span> <span echo> '<form action="up.php" method="POST">'<span><span> <span echo> "<table border='1' >\n"<span><span> <span echo> "\t<tr><td colspan='7' align='center'>选课系统</td></tr>\n"<span><span> <span echo> "\t<tr>\n"<span><span> <span echo> "\t<tr>\n"<span><span> <span><span> <span> <span for>(<span>=0;<span><7;<span>++<span><span> <span><span> <span echo> "\t\t<td>".<span>[<span>]."</td>\n"<span><span> <span><span> <span for>(<span>=0;<span><<span>;<span>++<span><span> <span><span> <span><span check> <span> <span> = ''<span><span> <span><span> <span> <span if>(<span>[<span>]=='0'<span><span> <span>[<span>]='男'<span><span> <span else> <span> <span>[<span>]='女'<span><span> <span><span> <span> <span for>(<span>=0;<span><<span>;<span>++<span><span> <span><span> <span if>(<span>[<span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span>
