Information-Management/getuser.php at master · LightFocus/Information-Management · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
<?php
session_start();
require_once "pdo.php";
if(!isset($_GET["sid"])){
  unset($_SESSION["name"]);
}
if(isset($_GET["c"])){
  $_SESSION["rank"]=$_GET["c"];
}
if(isset($_GET["n"])){
  $_SESSION["name"]=$_GET["n"];
}
$search="";
$search1="";
if(isset($_SESSION["rank"])){
  if($_SESSION["rank"]=="default"){
    $search="";
  }else if($_SESSION["rank"]=="name"){
    $search=" ORDER BY convert(name USING gbk)";
  }else if($_SESSION["rank"]=="number"){
    $search=" ORDER BY number";
  }
}
if(isset($_SESSION["name"])){
  $search1=" WHERE name like '".$_SESSION["name"]."%'";
}
$stmt=$pdo->query("SELECT name,number,English,Programming FROM students".$search1.$search);
$count=0;
while($row=$stmt->fetch(PDO::FETCH_ASSOC)){
   echo("<tr><td>");
   echo("<h3 align='center'>".$row['name']."</h3>");
   echo("</td><td>");
   echo("<h3 align='center'>".$row['number']."</h3>");
   echo("</td><td>");
   echo("<h3 align='center'>".$row['English']."</h3>");
   echo("</td><td>");
   echo("<h3 align='center'>".$row['Programming']."</h3>");
   echo("</td>");
   //echo("<h3 align='center'>".$row['password']."</h3>");
   echo("<td>");
   echo('<form action="change.php" method="post"><input type="hidden"');
   echo('name="stu_id" value="'.$row['stu_id'].'">'."\n");
   echo('<input type="hidden" value="'.$row['name'].'" name="name">');
   echo('<input type="hidden" value="'.$row['number'].'" name="number">');
   echo('<input type="hidden" value="'.$row['English'].'" name="e_score">');
   echo('<input type="hidden" value="'.$row['Programming'].'" name="p_score">');
   echo('<button class="btn btn-lg btn-primary btn-block" type="submit" value="Change" name="change1">更改</button>');
   echo("\n</form>\n");
   echo("</td></tr>");
 $count++;}?>