第五部分：创建一个学校的兴趣小组报名系统

3. 前面代码段将表单数据发送至Start.php页面，其中Start.Php将连接数据库进行数据的存取访问，核心代码如下:

<?php

\$UID = \$_REQUEST["UID"];

\$SEX = \$_REQUEST["SEX"];

\$Department = \$_REQUEST["Department"];

\$Major = \$_REQUEST["Major"];

\$Year = \$_REQUEST["Year"];

\$Month = \$_REQUEST["Month"];

\$Place = \$_REQUEST["Place"];

\$LinkID = mysql_connect("localhost", "nobody", "");

mysql_select_db("computer");

mysql_query("set names gb2312 ");//设置显示字体为简体中文

\$sql .= "insert into user_info values (";

\$sql .="'\$UID',";

\$sql .="'\$SEX',";

\$sql .="'\$Department',";

\$sql .="'\$Major',";

\$sql .="'\$Year',";

\$sql .="'\$Month',";

\$sql .=")";

\$Result = mysql_query(\$sql);

\$affectedrow = mysql_affected_rows(\$LinkID);

if (\$affectedrow != 1 ){

die("数据库发生输入错误，请重新登陆该系统！");}

\$_SESSION["name"] = \$UID;

\$_SESSION["current"] = "0000";

\$_SESSION["time"] = time();

echo "用户：";

echo \$_SESSION["name"] ;

mysql_close(\$LinkID);

?>

课后练习：