当前位置：首页 > PHP

PHP实现显示列表信息

2026-04-03 10:21:11PHP

PHP 实现显示列表信息

方法一：使用数组和 foreach 循环

$items = ['Apple', 'Banana', 'Cherry', 'Date'];
foreach ($items as $item) {
    echo $item . "<br>";
}

方法二：从数据库获取数据并显示

$conn = new mysqli('localhost', 'username', 'password', 'database');
$result = $conn->query("SELECT name FROM products");
while ($row = $result->fetch_assoc()) {
    echo $row['name'] . "<br>";
}
$conn->close();

方法三：使用 HTML 表格格式化输出

$employees = [
    ['id' => 1, 'name' => 'John', 'position' => 'Developer'],
    ['id' => 2, 'name' => 'Jane', 'position' => 'Designer']
];
echo "<table border='1'>
        <tr>
            <th>ID</th>
            <th>Name</th>
            <th>Position</th>
        </tr>";
foreach ($employees as $employee) {
    echo "<tr>
            <td>{$employee['id']}</td>
            <td>{$employee['name']}</td>
            <td>{$employee['position']}</td>
          </tr>";
}
echo "</table>";

方法四：分页显示大量数据

$perPage = 10;
$page = isset($_GET['page']) ? (int)$_GET['page'] : 1;
$offset = ($page - 1) * $perPage;

$conn = new mysqli('localhost', 'username', 'password', 'database');
$total = $conn->query("SELECT COUNT(*) FROM products")->fetch_row()[0];
$result = $conn->query("SELECT name FROM products LIMIT $offset, $perPage");

while ($row = $result->fetch_assoc()) {
    echo $row['name'] . "<br>";
}

$totalPages = ceil($total / $perPage);
for ($i = 1; $i <= $totalPages; $i++) {
    echo "<a href='?page=$i'>$i</a> ";
}
$conn->close();

方法五：使用 PHP 框架（Laravel 示例）

PHP实现显示列表信息

// 在控制器中
public function index()
{
    $products = Product::paginate(15);
    return view('products.index', compact('products'));
}

// 在视图中
@foreach ($products as $product)
    {{ $product->name }}<br>
@endforeach

{{ $products->links() }}