php - 将句子拆分为单词并检查 MySQL 是否出现

Question

我有一个变量，它是一个句子，例如这是一个句子。我有一个 MySQL 数据库，其中的行中的一列包含以下内容:

"random sentences" 
"few random words" 
"this is cool"
"a car" 
"nice placement"

我需要打印出数据库行中存在的句子中任何单词的出现次数。对于上面给出的示例句子，结果将是:

"random sentences" 
"this is cool" 
"a car" 

这是我迄今为止尝试过的:

<?php
$servername = "localhost";
$username = "dsfdsfds";
$password = "sdfdfsdsf";
$dbname = "sdf";

$conn = new mysqli($servername, $username, $password, $dbname);

if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

$galleries = "This is a sentence";
$sql = "
SELECT * 
  FROM rawwords 
 WHERE origin LIKE '%" . $galleries. "%'
";
$result = $conn->query($sql);

if ($result->num_rows > 0) {
    while($row = $result->fetch_assoc()) {
        echo "id: " . $row["id"]. " - location: " . $row["sentence"]. " <br><br>";
    }
} else {
    echo "0 results";
}

$conn->close();
?> 

Answer 1

创建正确的 sql :D

$galleries ="This is a sentence";
$arr = explode(" ", $galleries);

$sql = "SELECT * FROM rawwords WHERE origin LIKE";

$lenght = count($arr);

for ($i=0; $i<$lenght; $i++) {
    if ($i == 0) {
        $sql .=" '% " . $arr[$i]. " %'";
    } else {
        $sql .=" or '% " . $arr[$i]. " %'";
    }
}