当前位置：首页 > PHP

php实现筛选

2026-02-14 14:40:17PHP

PHP实现数据筛选的方法

在PHP中实现数据筛选通常涉及对数组或数据库查询结果进行条件过滤。以下是几种常见的实现方式：

使用array_filter函数筛选数组

php实现筛选

$numbers = [1, 2, 3, 4, 5, 6];
$evenNumbers = array_filter($numbers, function($num) {
    return $num % 2 == 0;
});

数据库查询中使用WHERE条件

$pdo = new PDO('mysql:host=localhost;dbname=test', 'username', 'password');
$stmt = $pdo->prepare("SELECT * FROM products WHERE price > :minPrice");
$stmt->execute([':minPrice' => 50]);
$filteredProducts = $stmt->fetchAll();

多维数组筛选

php实现筛选

$users = [
    ['name' => 'John', 'age' => 25],
    ['name' => 'Jane', 'age' => 30]
];
$filteredUsers = array_filter($users, function($user) {
    return $user['age'] > 28;
});

使用自定义筛选类

class ProductFilter {
    public static function filterByPrice(array $products, float $minPrice) {
        return array_filter($products, function($product) use ($minPrice) {
            return $product['price'] >= $minPrice;
        });
    }
}

表单筛选实现

if ($_SERVER['REQUEST_METHOD'] === 'POST') {
    $filters = [
        'category' => $_POST['category'] ?? null,
        'price_min' => $_POST['price_min'] ?? 0
    ];

    $query = "SELECT * FROM products WHERE 1=1";
    if ($filters['category']) {
        $query .= " AND category = '{$filters['category']}'";
    }
    if ($filters['price_min']) {
        $query .= " AND price >= {$filters['price_min']}";
    }
}