1.搭建一个简单的apache+mysql+php组合:点击红帽子—>系统设置-->服务器设置 服务勾上httpd然后点开始之后保存,如图:在浏览器测试如图:打开文件夹file:/var/www/html 在其中建一个about.php的文件,代码如下:<?Phpinfo();?>打开浏览器测试如图:点击红帽子—>系统设置-->服务器设置 服务勾上mysqld然后点开始之后保存,然后在终端输入如图所示代码,给MYSQL设定密码,如图:2.根据题目要求需要数据库中建立学生个人信息(学号、性别、年龄),所修课成,所在院系三个表,不是独立的。
所以我建了一个名为php的数据库以及名为register(用户),student(学生),faculty(学院),course(课程)的数据表,代码如下:CREATE TABLE IF NOT EXISTS student (name varchar(30) NOT NULL,id int(30) NOT NULL,class char(30) NOT NULL,sex varchar(30) NOT NULL,age int(20) NOT NULL);CREATE TABLE IF NOT EXISTS register (username char(25) NOT NULL,password int(20) NOT NULL);INSERT INTO register VALUES('admin','111111');CREATE TABLE IF NOT EXISTS course (id int(30) NOT NULL,classname char(30) NOT NULL,classid int(20) NOT NULL,teacher varchar(30) NOT NULL,socre int(10) NOT NULL);CREATE TABLE IF NOT EXISTS faculty (id int(30) NOT NULL,name char(30) NOT NULL,academical char(30) NOT NULL);建数据库及数据表如图:3.下面进行管理员与数据库的连接:在file:/var/www/html file:/var/www/html建立一个名为学生信息管理系统的文件夹,然后建一个register.phpy以及denglu.html,代码如下:Register.php:<?php$username=$_POST['username'];$password=$_POST['password'];$con=mysql_connect("localhost","root","root");mysql_select_db("php");$sql="select * from register where username='$username' AND password='$password'";$re=mysql_query($sql);$row=mysql_num_rows($re);if($row!=1){echo "登录失败";}else echo "<meta http-equiv=refresh content=1;url=caozuo.html>";?>denglur.html:<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="/1999/xhtml"><head><meta http-equiv="Content-Type" content="text/html; charset=gb2312" /><title>无标题文档</title><style type="text/css"><!--.STYLE1 {font-family: "黑体", "宋体";font-size: 30px;}.STYLE2 {font-size: 24px}.STYLE3 {font-family: "黑体";font-size: 40px;}body {background-image: url(images/登录.bmp);}--></style></head><body><form id="form1" name="form1" method="post" action="register.php"><p class="STYLE3">欢迎登录学生信息管理系统</p><p> </p><table width="640" border="0" align="center" cellpadding="0" cellspacing="10"> <tr><td><div align="right"><span class="STYLE1">登录名:</span><span class="STYLE2"></span></div></td><td><label><input type="text" name="username" /></label></td></tr><tr><td><div align="justify" class="STYLE1"><div align="right">登录密码:</div></div></td><td><label><input type="password" name="password" /></label></td></tr></table><p align="center"><input type="submit" name="Submit" value="登录" /></p><p> </p></form></body></html>如图:登录之后进入选择操作界面如图:4.下面进行信息录入操作,如图:代码如下:luru.php:<?php$id=$_POST['id'];$name=$_POST['name'];$sex=$_POST['sex'];$age=$_POST['age'];$classid=$_POST['classid'];$class=$_POST['class'];$classname=$_POST['classname'];$teacher=$_POST['teacher'];$socre=$_POST['socre'];$academical=$_POST['academical'];$con=mysql_connect("localhost","root","root");mysql_select_db("php");$sq1="insert into student values('$name','$id','$class','$sex','$age')";$sq2="insert into course values('$id','$classname','$classid','$teacher','$socre')";$sq3="insert into faculty values('$id','$name','$academical')";$re1=mysql_query($sq1);$re2=mysql_query($sq2);$re3=mysql_query($sq3);if($re1&&$re2&&$re3){echo "录入成功";/*echo "<meta http-equiv=refresh content=3;url=w登.html>";*/}else echo"录入失败";mysql_close($con);?>Luru.html:<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="/1999/xhtml"><head><meta http-equiv="Content-Type" content="text/html; charset=gb2312" /><title>无标题文档</title><style type="text/css"><!--.STYLE1 {font-family: "黑体";font-size: 44px;color: #000000;}body {background-image: url(images/登录.bmp);}.STYLE13 {font-family: "黑体", "楷体"; font-size: 16px; color: #000000; }--></style></head><body><form id="form1" name="form1" method="post" action="luru.php"><p align="right" class="STYLE1">学生信息录入</p><p> </p><p> </p><table width="640" border="0" align="center" cellpadding="0" cellspacing="10"> <tr><td><div align="center" class="STYLE13">学号:</div></td><td><div align="center"><input type="text" name="id" /></div></td></tr><tr><td><div align="center" class="STYLE13">姓名:</div></td><td><div align="center"><input type="text" name="name" /></div></td></tr><tr><td><div align="center" class="STYLE13">性别:</div></td><td><div align="center"><input type="text" name="sex" /></div></td></tr><tr><td><div align="center" class="STYLE13">年龄:</div></td><td><div align="center"><input type="text" name="age" /></div></td></tr><tr><td><div align="center" class="STYLE13">课程ID:</div></td><td><div align="center"><input type="text" name="classid" /></div></td></tr><tr><td><div align="center" class="STYLE13">班级:</div></td><td><div align="center"><input type="text" name="class" /></div></td></tr><tr><td><div align="center" class="STYLE13">所修课程:</div></td><td><div align="center"><input type="text" name="classname" /></div></td></tr><tr><td><div align="center" class="STYLE13">任课教师:</div></td><td><div align="center"><input type="text" name="teacher" /></div></td></tr><tr><td><div align="center" class="STYLE13">该课程成绩:</div></td> <td><div align="center"><input type="text" name="socre" /></div></td></tr><tr><td><div align="center" class="STYLE13">所属院系:</div></td><td><div align="center"><input type="text" name="academical" /></div></td></tr></table><p align="center"><label><input type="submit" name="Submit" value="确定" /></label></p><p align="center"> </p></form></body></html>5.下面是信息的查询操作代码如下:chaxun.php<?php$a=$_POST['id'];$con=mysql_connect("localhost","root","root");mysql_select_db("php",$con);$result = mysql_query("SELECT student.class,faculty.academical,course.classname,course.id,course.teacher,course.s ocre,student.sex,student.age,FROM student, faculty, courseWHERE ( (student.id =$a)AND (course.id =$a)AND (faculty.id =$a))");echo "<table border='1' bordercolor='#ff0000'><tr><th>姓名</th><th>性别</th><th>年龄</th><th>班级</th><th>所属学院</th><th>学号</th><th>所选课程</th><th>该课成绩</th><th>任课教师</th></tr>";while($row = mysql_fetch_array($result)){echo "<tr>";echo "<td>". $row['8']."</td>";echo "<td>". $row['6']."</td>";echo "<td>". $row['7']."</td>";echo "<td>". $row['0']."</td>";echo "<td>" . $row['1'] . "</td>";echo "<td>" . $row['3'] . "</td>";echo "<td>" . $row['2'] . "</td>";echo "<td>" . $row['5'] . "</td>";echo "<td>" . $row['4'] . "</td>";echo "</tr>";}echo "</table>";?>Cahxun.html<style type="text/css"><!--body {background-image: url(images/1.jpg);background-repeat: no-repeat;}.STYLE4 {color: #000000;font-weight: bold;font-family: "黑体", "楷体";}--></style><form id="form1" name="form1" method="post" action="chaxun.php"><p> </p><p> </p><table width="640" border="0" cellspacing="10" cellpadding="0"><tr><td><div align="center"><span class="STYLE4">输入您要查询的ID:</span><input type="text" name="id" /></div></td></tr><tr><td><div align="center"><input type="submit" name="Submit" value="提交" /></div></td></tr></table><p> </p><p align="left"> </p><p> </p></form>6.下面进行信息的修改操作代码如下:Xiugai.php<?php$mm=$_POST['id'];$a=$_POST['class'];$b=$_POST['academical'];$c=$_POST['classname'];$d=$_POST['socre'];$e=$_POST['teacher'];$f=$_POST['name'];$g=$_POST['sex'];$h=$_POST['age'];$con=mysql_connect("localhost","root","root");mysql_select_db("php");mysql_query("update course set socre='$d',classname='$c',teacher='$e' where id=$mm");mysql_query("update student set class='$a',name='$f',sex='$g',age='$h'where id=$mm");mysql_query("update faculty set academical='$b' where id=$mm");echo "<meta http-equiv=refresh content=1;url=jingquechaxun.html>"?>Xiugai.html<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="/1999/xhtml"><head><meta http-equiv="Content-Type" content="text/html; charset=gb2312" /><title>无标题文档</title><style type="text/css"><!--body {background-image: url(images/1.jpg);}.STYLE1 {color: #FFFFFF}.STYLE2 {color: #CCCCCC}.STYLE3 {color: #000000}--></style></head><body><form id="form1" name="form1" method="post" action="xiugai.php"><table width="640" border="0" align="center" cellpadding="0" cellspacing="10"> <p align="center"><span class="STYLE1">请输入需要修改信息的学生ID:</span> <input type="text" name="id" /></p><tr><td><div align="center" class="STYLE2">姓名:</div></td><td><div align="center" class="STYLE3"><input type="text" name="name" /></div></td></tr><tr><td><div align="center" class="STYLE2">性别:</div></td><td><div align="center" class="STYLE3"><input type="text" name="sex" /></div></td></tr><tr><td><div align="center" class="STYLE2">年龄:</div></td><td><div align="center" class="STYLE3"><input type="text" name="age" /></div></td></tr><tr><td><div align="center" class="STYLE2">班级:</div></td><td><div align="center" class="STYLE3"><input type="text" name="class" /></div></td></tr><tr><td><div align="center" class="STYLE2">所属学院:</div></td> <td><div align="center" class="STYLE3"><input type="text" name="academical" /></div></td></tr><tr><td><div align="center" class="STYLE2">所选课程:</div></td> <td><div align="center" class="STYLE3"><input type="text" name="classname" /></div></td></tr><tr><td><div align="center" class="STYLE2">该课成绩:</div></td> <td><div align="center" class="STYLE3"><input type="text" name="socre" /></div></td></tr><tr><td><div align="center" class="STYLE2">任课教师:</div></td> <td><div align="center" class="STYLE3"><input type="text" name="teacher" /></div></td></tr></table><p align="center"><input type="submit" name="Submit" value="提交" /></p><p> </p><p> </p><p> </p></form></body></html>至此一个简单的具有学生信息录入、查询、修改功能的学生信息管理系统完成!。