duanhuang2804 2017-05-20 05:11
浏览 41
已采纳

使用laravel的eloquent命令,数据库查询无法按预期工作

I am trying to query my database that is connected to my model "Address" to find any addresses that are 'LIKE' any input into my form in the address input field. My model code is:

public function CheckForPrevious($verify)

{
  $matches = \App\Address::where('address', 'like', '%'.$verify.'%')

  ->get();

  foreach($matches as $match)
  {
    echo "$match";
  }



}

My controller code is:

public function show()
    {
      $address = new Address;
      $check = $_POST['address'];

      $address->CheckForPrevious($check);

      return $address;

    }

Any help would be greatly appreciated

  • 写回答

3条回答 默认 最新

  • doune1000 2017-05-20 05:26
    关注
    public function show()
    {
      $address = new Address();
      $check = $_POST['address'];
    
      $address->scopeCheckForPrevious($check);
    

    }

    public function scopeCheckForPrevious($verify)

        {
          $query = App\Address::where('address', 'like', '%'.$verify.'%')
    
          ->get();
    
          foreach($query as $match)
          {
            echo "$match";
          }
    
    
    
        }
    

    use this

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(2条)

报告相同问题?

悬赏问题

  • ¥15 CVRP 图论 物流运输优化
  • ¥15 Tableau online 嵌入ppt失败
  • ¥100 支付宝网页转账系统不识别账号
  • ¥15 基于单片机的靶位控制系统
  • ¥15 真我手机蓝牙传输进度消息被关闭了,怎么打开?(关键词-消息通知)
  • ¥15 下图接收小电路,谁知道原理
  • ¥15 装 pytorch 的时候出了好多问题,遇到这种情况怎么处理?
  • ¥20 IOS游览器某宝手机网页版自动立即购买JavaScript脚本
  • ¥15 手机接入宽带网线,如何释放宽带全部速度
  • ¥30 关于#r语言#的问题:如何对R语言中mfgarch包中构建的garch-midas模型进行样本内长期波动率预测和样本外长期波动率预测