douran6443 2015-09-21 09:12
浏览 119
已采纳

在字符串中查找字符串的出现

I am trying to find out whether a string contains any of the strings from a particular table of strings and assigning the string that is found to be a match to a variable and then inserting said variable into a database. However it doesn't seem to be able to find a match even when there clearly is a match. Any help would be appreciated.

This is the code:

$stringToMatch = 'Good Morning';
$string_list = "SELECT string FROM strings";
$resultStringList = mysqli_query($link, $string_list) or   die(mysqli_error($link));
$string_name = "Test";
while ($row = mysqli_fetch_array($resultStringList)) {
if (stristr($StringToMatch, $row)) {
$string_name = $row;
} 
}
mysqli_query($link, "INSERT INTO table (string) VALUES ('$string_name')") or die(mysqli_error($link));

At this point, what would appear in the table is "Test" in the string column. Ideally it should insert the word "Morning" instead which can be found in the table strings

  • 写回答

2条回答 默认 最新

  • dongou6632 2015-09-21 09:17
    关注
    stristr()
    

    Returns all of haystack starting from and including the first occurrence of needle to the end.

    You are fetching array form your query. SO need to pass string to your stristr function to match

     while ($row = mysqli_fetch_array($resultStringList)) {
        if (stristr($StringToMatch, $row['string'])) {// need to pass string instead of array
        $string_name = $row['string'];// here pass string instead if array
        } 
        }
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(1条)

报告相同问题?

悬赏问题

  • ¥20 Python安装cvxpy库出问题
  • ¥15 用前端向数据库插入数据,通过debug发现数据能走到后端,但是放行之后就会提示错误
  • ¥15 python天天向上类似问题,但没有清零
  • ¥30 3天&7天&&15天&销量如何统计同一行
  • ¥30 帮我写一段可以读取LD2450数据并计算距离的Arduino代码
  • ¥15 C#调用python代码(python带有库)
  • ¥15 矩阵加法的规则是两个矩阵中对应位置的数的绝对值进行加和
  • ¥15 活动选择题。最多可以参加几个项目?
  • ¥15 飞机曲面部件如机翼,壁板等具体的孔位模型
  • ¥15 vs2019中数据导出问题