自定义模板格式化输出数据表中的数据

<?php

// $pdo=new PDO(mysql:host=127.0.0.1;dbname=php_edu;charset=utf8,root,root);

// 1.创建PDO对象，连接数据库

try {

$pdo = new PDO('mysql:host=127.0.0.1;dbname=php_edu;charset=utf8', 'root', 'root');

} catch (PDOException $e) {

exit($e->getMessage());

}

//2.创建预处理对象STMT

$sql = 'SELECT `user_id`,`name`,`email`,`create_time` FROM `user` WHERE `user_id` > :user_id';

$stmt = $pdo->prepare($sql);

//3.执行

$stmt->execute([':user_id' => 2]);

$stmt->setFetchMode(PDO::FETCH_ASSOC);

//4.遍历

$res = $stmt->fetchAll();

//5.释放结果集

$stmt = null;

//6.关闭连接

$pdo = null;

// foreach ($res as $row) {

//     echo print_r($row, true), '<hr>';

// }

// echo '共有 '.count($res).' 记录满足要求'.'<br>';

?>

<style>

table,th,td{

border:1px solid #666;

}

table{

text-align:center;

border:1px solid #666;

width:50%;

margin:30px auto;

border-collapse:collapse;

}

table caption{

font-size:1.5em;

font-weight:bolder;

margin-bottom:15px;

}

table tr:first-child{

background-color:lightblue;

}

</style>

<table>

<caption>用户信息表</caption>

<tr>

<th>ID</th>

<th>姓名</th>

<th>邮箱</th>

<th>注册时间</th>

</tr>

<?php foreach ($res as $row): ?>

<tr>

<td style="color:#666;background:lightblue;"><?php echo $row['user_id']; ?></td>

<td><?php echo $row['name']; ?></td>

<td><?php echo $row['email']; ?></td>

<td><?php echo $row['create_time']; ?></td>

</tr>

<?php endforeach; ?>

<tr>

<!-- <td colspan='4' style="color:red;background:lightblue;"><?php echo '共有 '.count($res).' 记录满足要求'; ?></td> -->

</tr>

</table>