WordPress的MySQL查询结果

WordPress的MySQL查询结果 - 如何突出显示表中找到的字符串(Wordpress MySQL Query Results - How to Highlight Strings Found in Displayed Table)

我创建了一个有效的WordPress页面，其中包含两个搜索框（以及它们之间的一对和/或按钮），用于查询SQL数据库并返回一个包含一个（或两者都包含）的行的两列表格，搜索字符串（$ search和$ search2），然后在结果超过100行时进行分页。我尝试了三种突出显示表中这些字符串的不同方法，但无法使其正常工作。所以我非常感谢一些帮助。 php代码的相关部分（为此我使用WordPress插入PHP插件）是：

[insert_php] * * * * if ($andor == "and"){ $result = mysql_query("SELECT DATE(start_date), EVENT FROM {$table} WHERE EVENT REGEXP '$search' >0 AND EVENT REGEXP '$search2' >0 LIMIT {$limits}"); } else{ $result = mysql_query("SELECT DATE(start_date), EVENT FROM {$table} WHERE EVENT REGEXP '$search' >0 OR EVENT REGEXP '$search2' >0 LIMIT {$limits}"); } * * * * while($row = mysql_fetch_row($result)) { echo "<tr>"; foreach($row as $cell) echo "<td>$cell</td>"; echo "</tr>\n"; } [/insert_php]

首先，我在functions.php文件中添加了一个函数，并尝试调用它并且无法使其工作

function highlight_word( $content, $word) { $replace = '' . $word . ''; $content = str_replace( $word, $replace, $content ); return $content; };

然后我尝试在单独的while循环中更换字符串。最后我试着改变现有的while循环，如下所示：

while($row = mysql_fetch_row($result)) { echo "<tr>"; foreach($row as $cell) echo "<td>" . str_replace($search, '' . $search . '', $cell) . "</td>"; echo "</tr>\n"; }

如果我可以将突出显示限制在第二列（“事件”），这将会很有帮助，但这并不比简单地将它起作用重要。而且，是的，我将在完成之前将代码升级到mysqli并转义查询字符串。一如既往，感谢这个伟大的社区。

I have created a functioning WordPress page with two search boxes (and a pair of and/or buttons between them) that queries an sql database and returns a two-column table with rows that contain one (or both, as the case may be) of the searched-for strings ($search and $search2) and then paginates when results exceed 100 rows. I have tried three different methods of highlighting these strings in the table but can't get it to work. So I'd much appreciate some help. The relevant portion of the php code (for which I am using the WordPress Insert PHP plug-in) is:

[insert_php] * * * * if ($andor == "and"){ $result = mysql_query("SELECT DATE(start_date), EVENT FROM {$table} WHERE EVENT REGEXP '$search' >0 AND EVENT REGEXP '$search2' >0 LIMIT {$limits}"); } else{ $result = mysql_query("SELECT DATE(start_date), EVENT FROM {$table} WHERE EVENT REGEXP '$search' >0 OR EVENT REGEXP '$search2' >0 LIMIT {$limits}"); } * * * * while($row = mysql_fetch_row($result)) { echo "<tr>"; foreach($row as $cell) echo "<td>$cell</td>"; echo "</tr>\n"; } [/insert_php]

First, I added a function to the functions.php file and tried calling it and couldn't make it work

function highlight_word( $content, $word) { $replace = '' . $word . ''; $content = str_replace( $word, $replace, $content ); return $content; };

Then I tried a string replacement in a separate while loop. Finally I tried changing the existing while loop as follows:

while($row = mysql_fetch_row($result)) { echo "<tr>"; foreach($row as $cell) echo "<td>" . str_replace($search, '' . $search . '', $cell) . "</td>"; echo "</tr>\n"; }

It would be helpful if I could limit the highlighting to the second column("EVENTS") only, but this is much less important than simply getting it to work. And, yes, I will upgrade code to mysqli and escape query strings before finalizing. As always, thanks to all in this great community.