php - Preg_match_all() - 正则表达式太大

Question

这个问题已经有答案了:

"Regular Expression is too large" error in PHP (3 个回答)

已关闭 3 年前。

我该如何改进以下preg_match_all模式，所以我没有这个警告:

preg_match_all(): Compilation failed: regular expression is too large at offset 32036

    $sql = "SELECT skills FROM weighted_skills_industry 
    WHERE industry = 'Engineering' ORDER by LENGTH(skills) DESC LIMIT 3000";

    $result = $con->query($sql); 
    while($row = $result->fetch_assoc()) {

         $skill[] = $row['skills'];

      }
        $pattern = '~(?<![\w-])(?:' . implode('|', array_map(function($i) { return preg_quote($i, '~'); }, $skill)) . ')(?![\w-])~i';

        if (preg_match_all($pattern, $text, $matchWords)) {

          //write something
        }

Answer 1

我可能会使用以下查询:

SELECT skills
FROM weighted_skills_industry 
WHERE
    industry = 'Engineering' AND
    skills REGEXP CONCAT('[[:<:]]', ?, '[[:>:]]')
ORDER BY
    LENGTH(skills) DESC
LIMIT 3000;

对于 ? 占位符，您可以绑定(bind) PHP 代码中的 $text 变量。上述逻辑将返回文本中可以找到的所有技能。