请帮我美化一下这个代码
时间: 2024-03-18 22:41:07 浏览: 20
好的,以下是经过美化的代码,增加了注释,缩进和空格,更加易读:
```php
<?php
// 每页显示的记录数
$records_per_page = 10;
// 当前页码
$current_page = isset($_GET['page']) ? $_GET['page'] : 1;
// 数据库连接
$conn = mysqli_connect('localhost', 'username', 'password', 'database');
// 获取总记录数
$total_records_query = "SELECT COUNT(*) FROM table_name";
$total_records_result = mysqli_query($conn, $total_records_query);
$total_records = mysqli_fetch_array($total_records_result)[0];
// 计算总页数
$total_pages = ceil($total_records / $records_per_page);
// 计算偏移量
$offset = ($current_page - 1) * $records_per_page;
// 获取当前页的数据
$data_query = "SELECT * FROM table_name LIMIT $offset, $records_per_page";
$data_result = mysqli_query($conn, $data_query);
// 输出数据
while ($row = mysqli_fetch_array($data_result)) {
// 输出数据...
}
// 输出分页链接
for ($i = 1; $i <= $total_pages; $i++) {
echo '<a href="?page=' . $i . '">' . $i . '</a> ';
}
?>
```
希望这样更加易读和易于理解!