doujingtang6580 2016-11-07 21:27
浏览 63

检查laravel中数据库中序列化数组中的值

I have a database where i have multiple "shoutouts". Each of these can have multiple hashtags.

In the database it looks like this:

a:2:{i:0;s:6:"#hello";i:1;s:6:"#world";}

I am trying to create a function where I find each shoutout that has a specific keyword, for example all shoutouts that have a hashtag #world

I want to go trough all shoutouts and check if they have the keyword in the array.

public function shoutoutSpecific($hashtag) {
        $hashtag = '#' . $hashtag;
        $shoutoutsIn = Shoutout::get();

        foreach($shoutoutsIn as $shoutout) {

          $hashtags = unserialize($shoutout->hashtag);

          //add to a new object 'shoutouts' if it has the keyword

          }

        return view('shoutout', compact('shoutouts'));
    }

I don't know what to do with the data I have unserialized from the database to check if the array contains #world. The serialized data is stored as shown above.

How do I check if the data I unserialized have #world in it?

All help much appreciated!

  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥15 R语言Rstudio突然无法启动
    • ¥15 关于#matlab#的问题:提取2个图像的变量作为另外一个图像像元的移动量,计算新的位置创建新的图像并提取第二个图像的变量到新的图像
    • ¥15 改算法,照着压缩包里边,参考其他代码封装的格式 写到main函数里
    • ¥15 用windows做服务的同志有吗
    • ¥60 求一个简单的网页(标签-安全|关键词-上传)
    • ¥35 lstm时间序列共享单车预测,loss值优化,参数优化算法
    • ¥15 Python中的request,如何使用ssr节点,通过代理requests网页。本人在泰国,需要用大陆ip才能玩网页游戏,合法合规。
    • ¥100 为什么这个恒流源电路不能恒流?
    • ¥15 有偿求跨组件数据流路径图
    • ¥15 写一个方法checkPerson,入参实体类Person,出参布尔值