php mysql数据库课设_数据库课程设计 PHP web实现

最新推荐文章于 2024-09-02 16:11:29 发布

或许不想懂

最新推荐文章于 2024-09-02 16:11:29 发布

阅读量228

点赞数

CC 4.0 BY-SA版权

文章标签： php mysql数据库课设

本文链接：https://blog.youkuaiyun.com/weixin_36410516/article/details/113127031

这篇博客展示了如何使用PHP连接到MySQL数据库，并根据用户输入的课程名称或学生姓名查询学生信息。通过设置不同条件，查询学生的学号、姓名以及对应课程的成绩。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

课程查询

}

$dbhost = "localhost:3306";

$dbuser = "root";

$dbpass = "";

$conn = mysqli_connect($dbhost, $dbuser, $dbpass);

if(!$conn)

{

die('Could not connect: ' . mysqli_error());

}

mysqli_query($conn , "set names utf8");

mysqli_select_db($conn, 'demo');

$sqlll = $_POST["fname"];

$sqlcheck = $_POST["vehicle"];

echo "
";

if($sqlcheck === 'course')

{

echo "

学号";

echo "

姓名";

echo "

$sql = "SELECT `学号`, `姓名`, `课程1`, `课程2`, `课程3`, `课程4`, `课程5` FROM `stu` WHERE `课程1` LIKE '$sqlll'";

$retval = mysqli_query($conn, $sql);

while($row = mysqli_fetch_array($retval, MYSQLI_ASSOC))

{

echo "

{$row['学号']} ";

echo "

{$row['姓名']} ";

echo "

}

$sql = "SELECT `学号`, `姓名`, `课程1`, `课程2`, `课程3`, `课程4`, `课程5` FROM `stu` WHERE `课程2` LIKE '$sqlll'";

$retval = mysqli_query($conn, $sql);

while($row = mysqli_fetch_array($retval, MYSQLI_ASSOC))

{

echo "

{$row['学号']} ";

echo "

{$row['姓名']} ";

echo "

}

$sql = "SELECT `学号`, `姓名`, `课程1`, `课程2`, `课程3`, `课程4`, `课程5` FROM `stu` WHERE `课程3` LIKE '$sqlll'";

$retval = mysqli_query($conn, $sql);

while($row = mysqli_fetch_array($retval, MYSQLI_ASSOC))

{

echo "

{$row['学号']} ";

echo "

{$row['姓名']} ";

echo "

}

$sql = "SELECT `学号`, `姓名`, `课程1`, `课程2`, `课程3`, `课程4`, `课程5` FROM `stu` WHERE `课程4` LIKE '$sqlll'";

$retval = mysqli_query($conn, $sql);

while($row = mysqli_fetch_array($retval, MYSQLI_ASSOC))

{

echo "

{$row['学号']} ";

echo "

{$row['姓名']} ";

echo "

}

$sql = "SELECT `学号`, `姓名`, `课程1`, `课程2`, `课程3`, `课程4`, `课程5` FROM `stu` WHERE `课程5` LIKE '$sqlll'";

$retval = mysqli_query($conn, $sql);

while($row = mysqli_fetch_array($retval, MYSQLI_ASSOC))

{

echo "

{$row['学号']} ";

echo "

{$row['姓名']} ";

echo "

}

echo "

}

else {

if($sqlcheck === 'name') {$sql = "SELECT * FROM `stu` WHERE `姓名` LIKE '$sqlll'";}

else {$sql = "SELECT * FROM `stu` WHERE `学号` LIKE '$sqlll'";}

echo "

学号";

echo "

姓名";

echo "

课程1";

echo "

课程2";

echo "

课程3";

echo "

课程4";

echo "

课程5";

$retval = mysqli_query($conn, $sql);

while($row = mysqli_fetch_array($retval, MYSQLI_ASSOC))

{

echo "

{$row['学号']} ";

echo "

{$row['姓名']} ";

echo "

{$row['课程1']} ";

echo "

{$row['课程2']} ";

echo "

{$row['课程3']} ";

echo "

{$row['课程4']} ";

echo "

{$row['课程5']} ";

echo "

}

echo "

}?>

返回首页