php数据库如何构建搜索功能 php数据库商品搜索的实现案例

CREATE TABLE products (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(255) NOT NULL,
    price DECIMAL(10,2),
    description TEXT,
    category VARCHAR(100)
);

<form method="GET" action="search.php">
    <input type="text" name="keyword" placeholder="请输入商品名称或描述..." required>
    <button type="submit">搜索</button>
</form>

<?php
$host = 'localhost';
$db   = 'shop_db';
$user = 'root';
$pass = '';
$charset = 'utf8mb4';
<p>$dsn = "mysql:host=$host;dbname=$db;charset=$charset";
$options = [
PDO::ATTR_ERRMODE            => PDO::ERRMODE_EXCEPTION,
PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC,
];</p><p>try {
$pdo = new PDO($dsn, $user, $pass, $options);
} catch (&#36;e) {
die("数据库连接失败: " . &#36;e->getMessage());
}</p><p>// 获取搜索关键词
&#36;keyword = trim(&#36;_GET['keyword'] ?? '');</p><p>if (!&#36;keyword) {
echo "请输入搜索关键词。";
exit;
}</p><p>// 使用LIKE进行模糊匹配，支持名称和描述
&#36;sql = "SELECT id, name, price, description, category 
FROM products 
WHERE name LIKE ? OR description LIKE ?";
&#36;stmt = &#36;pdo->prepare(&#36;sql);
&#36;searchTerm = "%&#36;keyword%";
&#36;stmt->execute([&#36;searchTerm, &#36;searchTerm]);
&#36;results = &#36;stmt->fetchAll();</p><p>if (&#36;results):
?>
<h3>搜索结果：</h3>
<ul>
<?php foreach (&#36;results as &#36;row): ?>
<li>
<strong>&#36;{row['name']}</strong> </p><ul><li>¥&#36;{row['price']} 
(&#36;{row['category']})<br>
&#36;{row['description']}
</li>
<?php endforeach; ?>
</ul>
<?php else: ?>
<p>未找到相关商品。</p>
<?php endif; ?>

ALTER TABLE products ADD FULLTEXT(name, description);

$sql = "SELECT * FROM products WHERE MATCH(name, description) AGAINST (? IN NATURAL LANGUAGE MODE)";