<html>
<head>
<title>学生管理信息</title>
</head>
<body>
<center>
<?php include 'menu.php';?>
<h3>信息浏览</h3>
<table width="600" border="1">
<tr>
<td>ID</td>
<td>姓名</td>
<td>性别</td>
<td>年龄</td>
<td>班级</td>
<td>操作</td>
</tr>
<?php
//连接数据库
try {
$pdo=new PDO("mysql:host=localhost;dbname=test;","root","562436");
} catch (Exception $e) {
die("数据库连接失败".$e->getMessage());
}
//执行SQL语句
$sql='select * from cms_stu';
foreach ($pdo->query($sql) as $row){
echo "<tr>";
echo "<td>{$row['id']}</td>";
echo "<td>{$row['name']}</td>";
if($row['sex']=='m'){
echo "<td>男</td>";
}else if($row['sex']=='w'){
echo "<td>女</td>";
}
echo "<td>{$row['age']}</td>";
echo "<td>{$row['classid']}班</td>";
echo "<td><a href='javascript:doDel({$row['id']})'>删除</a> | <a href='edit.php?id={$row['id']}'>修改</a></td>";
echo "</tr>";
}
?>
</t
php实现简单的CRUD操作
最新推荐文章于 2024-08-06 11:33:47 发布