摘要:<?php $pdo = new \PDO('mysql:host=localhost;dbname=php_edu','root','root'); $stmt = $pdo->prepare("SELECT * FROM user");
<?php $pdo = new \PDO('mysql:host=localhost;dbname=php_edu','root','root'); $stmt = $pdo->prepare("SELECT * FROM user"); $stmt->execute(); $rows = $stmt->fetchAll(PDO::FETCH_ASSOC); //$rows = []; //空数据测试 ?> <table> <caption><h2>用户信息表</h2></caption> <tr> <th>ID</th> <th>姓名</th> <th>性别</th> <th>年龄</th> <th>邮箱</th> <th>入职时间</th> </tr> <?php foreach ($rows as $row) : ?> <tr> <td><?php echo $row['id'] ?></td> <td><?php echo $row['name'] ?></td> <td><?php echo $row['sex'] ? '女' : '男' ?></td> <td><?php echo $row['age'] ?></td> <td><?php echo $row['email'] ?></td> <td><?php echo date('Y 年 m 月 d 日',$row['create_time']) ?></td> </tr> <?php endforeach; ?> </table>
批改老师:天蓬老师批改时间:2018-12-12 11:26:50
老师总结:如果表格加点样式, 会更好点吧, 你说呢?