<?php
header('content-type:text/html;charset=utf-8');
require './publicfunction.php';
$link=mysqli_connect('127.0.0.1','root','','poemreg','3306');
if(!$link){
die('连接数据库失败!'.mysql_error());
}else{
echo '连接数据库成功!';
}
mysqli_query($link,"set names 'utf8'" );
mysqli_query($link,"use `poemreg`");
$sql = "SELECT * FROM `info`";
$info=fetchAll($sql);
require "./list_html.php";
(list_html.php):
<?php header("Content-Type:text/html;charset=UTF-8"); ?>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html;charset=utf8" />
<title>报名信息</title>
</head>
<body>
<table>
<tr>
<th>姓名</th><th>学号</th><th>专业</th><th>班级</th><th>自我介绍</th><th>宣言</th>
</tr>
<?php if(!empty($info)) {?>
<?php foreach($info as $row) {?>
<tr>
<td><?php echo $row['name'];?></td>
<td><?php echo $row['studentNo'];?></td>
<td><?php echo $row['tele'];?></td>
<td><?php echo $row['qq'];?></td>
<td><?php echo $row['major'];?></td>
<td><?php echo $row['grade'];?></td>
<td><?php echo $row['class'];?></td>
<td><?php echo $row['intro'];?></td>
<td><?php echo $row['target'];?></td>
</tr>
<?php }?>
<?php }else{?>
<tr><td colspan="6">暂无报名者</td></tr>
<?php }?>
</table>
</body>
</html>