您的位置:

php学生信息查询,php成绩查询

本文目录一览:

用php实现利用数组完成学生分数的增删查询。--学生信息包括:学号,分数。求大神

xuesheng=array(

'001'=100,

'002'=200,

'003'=300,

'004'=400

);

//增加

xuesheng['输入的学号']=输入的分数;

//修改

xuesheng['输入的学号']=输入的分数;

//删除

unset(xuesheng['输入的学号']);

//查找

$chazhao=’输入的查找学号‘.',';//后面这个逗号是为了方便即使输入一个学号也可以用数组

$chazhao=explode(',',$chazhao);

foreach($chazhao as $k){

if($k!='' !empty($k)){

echo $k.'学号:'.$k.'分数:'.xuesheng[$k].'/br';

}

}

随手写的没调试,具体的你要调试,实际中应该还要过滤用户输入的数据

服务端还要保存这个数组内容,或者客户端服务端来回传递数组,也可以序列化数组serialize(),这个题目出的没水准,应该是个JS操作更适合

php 学生信息管理系统 修改怎么写

都是很简单的东西,新手用得着、、、

省略部分前端代码、、、

首先是登录的校验:

?php

session_start();

$user = $_POST['userName'];

$pass = $_POST['passWord'];

$_SESSION['user'] = $user;

/*$Enter = $_POST['Login_undo'];

管理员登录的校验*/

$flag = false;

if($user == "Admin" $pass == "root")

{

setcookie("userName",$user,time()+1200);

setcookie("userName",$pass,time()+1200);

$flag = true;

header('location:adminPage.php?user=' . $user);

}

else

header('location:Login.php?login=relog');

/*

// 学生登录免校验

if($Enter)

header('location:StuPage.php');

*/

然后是注册的校验:

?php

session_start();

$s_ID = $_POST['s_ID'];

$Name = $_POST['Name'];

$IDcard = $_POST['IDcard'];

$Major = $_POST['Major'];

$sex = $_POST['sex'];

$_SESSION['student'][$s_ID]['s_ID'] = $s_ID;

$_SESSION['student'][$s_ID]['Name'] = $Name;

$_SESSION['student'][$s_ID]['IDcard'] = $IDcard;

$_SESSION['student'][$s_ID]['Major'] = $Major;

$_SESSION['student'][$s_ID]['sex'] = $sex;

header('location:tisi.html');

/*foreach($_SESSION['student'] as $v)

{

if($v == $s_ID)

{

header("location:stu_reg.php?action=lookmsg=更新user=employeeempno=" . $empno . "idcard=" . $idcard);

}

else

header("location:stu_reg.php?action=lookmsg=增加user=employeeempno=" . $empno . "idcard=" . $idcard);

}*/

毕业操作及加入历史校验:

?php

session_start();

$s_ID=$_GET['s_ID'];

$_SESSION['history'][$s_ID]['s_ID']=$s_ID;

$_SESSION['history'][$s_ID]['Name']=$_SESSION['student'][$s_ID]['Name'];

$_SESSION['history'][$s_ID]['IDcard']=$_SESSION['student'][$s_ID]['IDcard'];

$_SESSION['history'][$s_ID]['sex']=$_SESSION['student'][$s_ID]['sex'];

$_SESSION['history'][$s_ID]['Major']=$_SESSION['student'][$s_ID]['Major'];

unset($_SESSION['student'][$s_ID]);

header('location:graduate.php?user=Adminaction=delete');

任意关键词查询:

?php

session_start();

$search=$_POST['search'];

unset($_SESSION['search']);

/*echo 'pre';

var_dump($_POST['search']);

return ;*/

foreach ($_SESSION['student'] as $k1 = $value) {

# code...

if($search==$_SESSION['student'][$k1]['s_ID']||$search==$_SESSION['student'][$k1]['IDcard']||$search==$_SESSION['student'][$k1]['Name']||$search==$_SESSION['student'][$k1]['sex']||$search==$_SESSION['student'][$k1]['Major']){

$i = 1;

$stu = $_SESSION['student'][$k1]['s_ID'];

$_SESSION['search'][$stu] = $stu;

}

}

if(isset($i))

header("location:stu_Query.php?user=Adminaction=search");

else

header("location:stu_Query.php?user=Adminaction=q_error");

遍历学生信息:

!DOCTYPE HTML

html

head

link href="file/Style.Css" rel="stylesheet" type="text/css" /

/head

body

table width="100%" border="0" cellpadding="1" cellspacing="1" class="css_table" bgcolor='#E1E1E1'

?php

session_start();

$user = isset($_SESSION['user'])?$_SESSION['user']:'';

if($user =='Admin'){

if(isset($_SESSION['student'])){

foreach($_SESSION['student'] as $k1) {

echo "tr";

foreach($k1 as $k2=$k3) {

echo "td" ;

if($k2=='s_ID') {echo "学号:" ;} else if($k2=='IDcard'){echo "身份证号:";}else if($k2=='sex'){echo "性别:";}else if($k2=='Name'){echo "姓名:";}else if($k2 =='Major'){echo "专业:";};

echo "/td";

echo "td";

if($k2=='s_ID') $s_ID=$k3; echo "$k3";

echo "/td";

}

}

}

}

?

/table

/body

/html

更新数据的页面及校验:

!DOCTYPE HTML

!-- 使用HTML5规范,省略多余部分 --

html

head

?php

session_start();

$user = isset($_SESSION['user'])?$_SESSION['user']:'';

$action = isset($_GET['action'])?$_GET['action']:'';

?

link href="file/Style.Css" rel="stylesheet" type="text/css" /

/head

body

?php if($user =='Admin'$action==''){ ?

table width="100%" border="0" cellpadding="3" cellspacing="1" class="css_table" bgcolor='#E1E1E1'

tr class="css_menu"

td colspan="3"

table width="100%" border="0" cellpadding="4" cellspacing="0" class="css_main_table"

tr

td class="css_main"注意/td

/tr

/table

/td

/tr

tr

td class="css_col11"strongfont color=#50691B一旦确定不可更改/font/strong/td

/tr

form name = "check_stu" method="post" action="check_stu.php"

tdlable请输入修改学生的学号:

input name = "c_ID" type="text"

input name = "submit" type="submit" value="确定"

/lable/td

/form

/table

?php }else if ($action == 'change') {?

form name="login_f" method="post" action="update_check.php"

div class = "login" align="center"

lable可以修改的项目:/lable

input name = "c_ID" type="hidden" value = "?php echo $_GET['c_ID'];?"

lip学生姓名:

input name = "Name" type = "text" id = "Name"/p/li

lip专业:

input name = "Major" type = "text" id = "Major"/p/li

li

p性别:

!-- input name = "sex" type = "text" id = "sex"/p/li --

input type="radio" name="sex" value="男"/男

input type="radio" name="sex" value="女"/女 /br

/li

lip确定修改:

input name = "submit" type = "submit" value = "确定"

input class="Renew" value="重写" type="reset" / /p/li

/form

/div

?php }else if ($action == 'enchange') {

# code...

echo "h1已经改变/h1";

}?

/body

/html

?php

session_start();

$s_ID = $_POST['c_ID'];

$Name = $_POST['Name'];

$Major = $_POST['Major'];

$sex = $_POST['sex'];

$_SESSION['student'][$s_ID]['s_ID'] = $s_ID;

$_SESSION['student'][$s_ID]['Name'] = $Name;

$_SESSION['student'][$s_ID]['Major'] = $Major;

$_SESSION['student'][$s_ID]['sex'] = $sex;

header("location:stu_Update.php?action=enchange");

thinkphp查询所有的信息,整个表都查,取出某个字段

$res=$student-field('id,name')-select();

/*

你要查询出所有的id和name 那么条件就不写了,否则不能查询出所有的

最好在后面加个limit限制下数据量,万一是大型网站,海量数据,你的查询工具就卡了,浏览器刷屏了!

*/

php中怎样通过输入课程名称,点击查询,搜索所选课程的所有学生成绩信息,并存放到表格中!

首先,你用的数据库,起码要把你的数据库表贴出来吧,不然我们怎么给你具体的语句呢,智能猜测你的表

猜测数据课程名称字段 classname 然后拿到这个课程的所有学生成绩信息

如果要一条语句出来就是连表了

假设你一个学生信息表 stuInfo,一个课程表 class,一个成绩表 score

那么就是更具课程名字拿到课程id,然后再成绩表中拿到这个课程id的所有信息,然后再根据score表的uid拿到学生名字等信息

我只能写个推测的写法

select stuInfo.name,class.classname,score.score

from score

left join class on score.class_id = class.id

left join stuInfo on score.uid = stuInfo.id

where class.classname = "查询框拿到的课程名字"

如果你不用联表查

那就先课程表查询出class_id 然后成绩表拿到这个class_id 的所有数据 当然要用户信息可能要连个表,我就不写了

PHP select条件查找代码,按照学号查询,即从后台舒服学生学号即可查询到该学号学生的表中信息

$result=mysql_query("select * from xscjb group by xsxh");

因为你写的就是查全表啊,要是相查某个学号的

你这样写啊 "select * from xscjb where `学号名称`='学号' group by xsxh

php写学生成绩管理系统,能说一下学生成绩查询和输入的思路。

学生成绩管理系统,学生一定要是一个表,成绩是一个表,成绩里面要存入学生的id当关联外键,数学,小红的id,数学;英语成绩,小红的id,英语类别;数学成绩,小亮的id,数学;英语成绩,小亮的id,英语。 查询直接查小红的就直接id=小红id 就把所有成绩查询出来了,如果显示所有人的,可以直接分组下就可以了。

也可以直接就把成绩都放入一条记录里面,小红id,数学成绩,英语成绩,小亮id ,数学,英语。。。。,这样查询就更好查了