We've got three pages:
(1), new Student Information Registration module (register.php):
Class Registration Form
Henan University of Science and Technology sincerely welcome Class 2012 New students to school study
Freshman registration System
(2), Information query login module (mysql_stu.php):
<title>New Landing System</title> <?php//connection database; $link = mysql_connect (' localhost ', ' root ', ' Dongsheng '); if (! $link) {echo] failed to connect to the database! "; Die (' Could not connect: '. Mysql_error ()); } $createdb = "CREATE database if not exists mis_stu"; $result =mysql_query ($createdb) or Die ("
Database creation failed: ". Mysql_error ()); $result =mysql_select_db (Mis_stu) or Die (' Select Mis_stu database failed: '. mysql_error ()); $createtable = "CREATE table if not exists Stu_reg (stu_name varchar ($) Not null,stu_sex char (2), Stu_age Int,stu_class Varc Har (+), stu_id varchar (stu_tele), Stu_email varchar (30)) "; $result =mysql_query ($createtable) or Die ('
Data table creation failed: '. mysql_error ()); Select Database mysql_select_db (MIS_STU); if (!empty ($_post[' reg_name ')) {$name =$_post[' reg_name ']; $sex =$_post[' Reg_sex ']; $age =$_post[' reg_age ']; $class =$_post[' Reg_class ']; $id =$_post[' reg_id ']; $tele =$_post[' Reg_tele ']; $email =$_post[' Reg_email ']; Defines the SQL string mysql_query ("Set names gb2312") that inserts data into the Stu_reg table; $SQL = "INSERT into Stu_reg (stu_name,stu_sex,stu_age,stu_class,stu_id,stu_tele,stu_email) VALUES (' $name ', ' $sex ', ' $ Age ', ' $class ', ' $id ', ' $tele ', ' $email '); mysql_query ($SQL); mysql_query ("COMMIT"); echo "
Congratulations, your registration is successful!
Enter the following to log in system query registration information
"; } mysql_close ($link); Please register before?> login
Information Query Login
>
New students need to know:
Please go to each college to improve the registration information,
Do a good job of reporting registration,
At the same time, as required to improve electronic file information.
Hope that the majority of students adapt to the new environment as soon as possible
Meet new people and get into the study work as soon as possible!
Academic Office Tel: 12345678
Security Branch Tel: 87654321
(3), Query information display module (stu_info.php)
<title>Basic information</title> <?php if ($_post[' log_name ']== ') {echo "
The name cannot be empty! Please re-enter!
"; echo "
Re-Login
"; } else {$link = mysql_connect (' localhost ', ' root ', ' Dongsheng '); if (! $link) {echo] failed to connect to the database! "; Die (' Could not connect: '. Mysql_error ()); } $result =mysql_select_db (Mis_stu) or Die (' Select Mis_stu database failed: '. mysql_error ()); mysql_query ("Set names gb2312"); $slt =mysql_query ("SELECT * from Stu_reg"); $arr =mysql_fetch_assoc ($SLT); $flag = 0; while ($arr) {if ($_post[' log_name ']== $arr [' stu_name ']) {$flag = 1; if ($_post[' log_id ']== $arr [' stu_id ']) {echo "login is successful, your basic information is:
"; echo "Name:". $arr [' Stu_name ']. "
"; echo "Gender:". $arr [' Stu_sex ']. "
"; echo "Age:". $arr [' Stu_age ']. "
"; echo "Class:" $arr [' Stu_class ']. "
"; echo "ID Number:" $arr [' stu_id ']. "
"; echo "Contact Phone:" $arr [' Stu_tele ']. "
"; echo "e-mail:". $arr [' Stu_email ']. "
"; Break } else {echo '
Wrong password! Please re-enter.
"; Break }} $arr =mysql_fetch_assoc ($SLT); } if ($flag ==0) echo "
I am sorry! The user you are querying does not exist, please return to registration first
"; Mysql_close ($link); echo "
Switch users
"; }?>