laravel如何实现yii2的这种写法？？

Created 5 years ago by zhangzeyun, Updated 5 years ago    Revision #1    2043 views    0 likes    0 collects
yii2有这种写法：
```
$articleList = Article::find()->joinWith("article_class as class")->where([])->all();
foreach ($articleList as $article) {
        $class = $article['article_class'];
        if($article['is_del']==1){//文章刪除\
              $class->is_del = 1;//刪除分類\  
              $class->save();\
    }
}
```
请问下，用laravel框架，这种写法如何实现啊？需要在循环中，使用对象操作数据(这里只是举个例子，必须在循环里面处理，因为循环里面还有很多其他的业务需要处理)
备注说明：
1.文章对应的分类是一对一的关系，每一篇文章都可以找到对应的文章分类
2.上面的例子是将所有的文章列表，和文章对应的一对一文章分类信息都给查询出来了，并且是对象的形式
Laravel
PHP
Yii2
Vote Vote Cancel Collect Collect Cancel

<< 上一篇: PHP 已开启openssl扩展却依然报错 Call to undefined function Illuminate\Encryption\openssl_cipher_iv_length()

>> 下一篇: laravel 上传文件数据库存储.tmp

4 Comments
#1    skys215   skys215 commented 5 years ago 
class Article extends Eloquent{
   public function cls(){  //class是关键字，所以换个名字
       return $this->hasOne('App\Cls');
    }
}

class IndexController extends Controller{
    public function index(){
        $articles = App\Article::with('cls')->get();
        dd($articles);
    }
}

我想问一下，你例子里的article怎么是数组，class却是对象啊

#2    zhangzeyun   zhangzeyun commented 5 years ago
In reply to #1

谢谢，他这个是数据嵌对象的形式，就和laravel一样，如下：

object(Illuminate\Database\Eloquent\Collection)#218 (1) {
  ["items":protected]=>
  array(1) {
    [0]=>
    object(App\Models\Articles)#217 (26) {
      ["timestamps"]=>
      bool(false)
      ["connection":protected]=>
      string(5) "mysql"
      ["table":protected]=>
      string(8) "Articles"
      ["primaryKey":protected]=>
      string(2) "id"
      ["keyType":protected]=>
      string(3) "int"
      ["incrementing"]=>
      bool(true)
      ["with":protected]=>
      array(0) {
      }
      ["withCount":protected]=>
      array(0) {
      }
      ["perPage":protected]=>
      int(15)
      ["exists"]=>
      bool(true)
      ["wasRecentlyCreated"]=>
      bool(false)
      ["attributes":protected]=>
      array(10) {
        ["id"]=>
        int(44)
        ["article_title"]=>
        string(19) "张泽云文章5555"
        ["article_desc"]=>
        int(3456)
        ["article_content"]=>
        NULL
        ["views_count"]=>
        int(0)
        ["created_at"]=>
        NULL
        ["updated_at"]=>
        NULL
        ["class_id"]=>
        int(3)
        ["status"]=>
        int(1)
        ["is_hot"]=>
        int(0)
      }
      ["original":protected]=>
      array(10) {
        ["id"]=>
        int(44)
        ["article_title"]=>
        string(19) "张泽云文章5555"
        ["article_desc"]=>
        int(3456)
        ["article_content"]=>
        NULL
        ["views_count"]=>
        int(0)
        ["created_at"]=>
        NULL
        ["updated_at"]=>
        NULL
        ["class_id"]=>
        int(3)
        ["status"]=>
        int(1)
        ["is_hot"]=>
        int(0)
      }
      ["changes":protected]=>
      array(0) {
      }
      ["casts":protected]=>
      array(0) {
      }
      ["dates":protected]=>
      array(0) {
      }
      ["dateFormat":protected]=>
      NULL
      ["appends":protected]=>
      array(0) {
      }
      ["dispatchesEvents":protected]=>
      array(0) {
      }
      ["observables":protected]=>
      array(0) {
      }
      ["relations":protected]=>
      array(1) {
        ["articles_class"]=>
        object(App\Models\Articles_class)#222 (26) {
          ["timestamps"]=>
          bool(false)
          ["connection":protected]=>
          string(5) "mysql"
          ["table":protected]=>
          string(14) "Articles_class"
          ["primaryKey":protected]=>
          string(2) "id"
          ["keyType":protected]=>
          string(3) "int"
          ["incrementing"]=>
          bool(true)
          ["with":protected]=>
          array(0) {
          }
          ["withCount":protected]=>
          array(0) {
          }
          ["perPage":protected]=>
          int(15)
          ["exists"]=>
          bool(true)
          ["wasRecentlyCreated"]=>
          bool(false)
          ["attributes":protected]=>
          array(4) {
            ["id"]=>
            int(3)
            ["class_name"]=>
            int(333)
            ["class_order"]=>
            int(1)
            ["is_header"]=>
            int(1)
          }
          ["original":protected]=>
          array(4) {
            ["id"]=>
            int(3)
            ["class_name"]=>
            int(333)
            ["class_order"]=>
            int(1)
            ["is_header"]=>
            int(1)
          }
          ["changes":protected]=>
          array(0) {
          }
          ["casts":protected]=>
          array(0) {
          }
          ["dates":protected]=>
          array(0) {
          }
          ["dateFormat":protected]=>
          NULL
          ["appends":protected]=>
          array(0) {
          }
          ["dispatchesEvents":protected]=>
          array(0) {
          }
          ["observables":protected]=>
          array(0) {
          }
          ["relations":protected]=>
          array(0) {
          }
          ["touches":protected]=>
          array(0) {
          }
          ["hidden":protected]=>
          array(0) {
          }
          ["visible":protected]=>
          array(0) {
          }
          ["fillable":protected]=>
          array(0) {
          }
          ["guarded":protected]=>
          array(1) {
            [0]=>
            string(1) "*"
          }
        }
      }
      ["touches":protected]=>
      array(0) {
      }
      ["hidden":protected]=>
      array(0) {
      }
      ["visible":protected]=>
      array(0) {
      }
      ["fillable":protected]=>
      array(0) {
      }
      ["guarded":protected]=>
      array(1) {
        [0]=>
        string(1) "*"
      }
    }
  }
}
#3    zhangzeyun   zhangzeyun commented 5 years ago
In reply to #1

我现在又遇到一个新的问题，也是这个问题延伸出来的，我写的示例是这样的，

           $where = [];
            $where['id'] = 44;
            $article = Articles::with("articles_class")->where($where)->get();
            foreach ($article as $k => $v) {
                $v->article_desc = 3456;
                $v->save();
                if ($v['id'] == 44) {
                    $classA = $v['articles_class'];
                    $classA->class_name = 333;
                    $classA->save();
                }
            }

程序可以正常执行，只是我用的phpstorm会在{$classA->save();}这里报错，报Method 'save' not found 的错误，请问下，你有什么好的办法解决吗？

#4    skys215   skys215 commented 5 years ago
In reply to #3

$v['articles_class'];这个是字符串吧？ 是的话，需要先new $classA();，再调save

登录后即可添加评论