学生管理信息
信息浏览
ID | 姓名 | 性别 | 年龄 | 班级 | 操作 |
//连接数据库
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 "
";echo "
{$row['id']}";echo "
{$row['name']}";if($row['sex']=='m'){
echo "
男";}else if($row['sex']=='w'){
echo "
女";}
echo "
{$row['age']}";echo "
{$row['cla