Create command can be used directly as follows : \Yii::$app->db->createCommand(“UPDATE table SET column1=:column1, column2=:column2 WHERE id=:id”) ->bindValue(‘:id’, your_id) ->bindValue(‘:column1’, :column1_value) ->bindValue(‘:column2’, :column2_value) ->execute();
As per the Definition of the Eloquent Model Method “updateOrCreate()” function updateOrCreate(array $attributes, array $values = []){} it takes two argument … one is the attributes using which you want to check in database if the record is present second is the new attribute values that you want to create or update AppInfo::updateOrCreate([‘app_id’ => $postData[‘appId’]], … Read more
Eloquent is Laravel’s implementation of Active Record pattern and it comes with all its strengths and weaknesses. Active Record is a good solution for processing a single entity in CRUD manner – that is, create a new entity with filled properties and then save it to a database, load a record from a database, or … Read more
@florian gave you the correct answer but let me try to explain it on example: In sql, joins are done like this: SELECT * FROM category LEFT JOIN product ON product.category_id = category.id (or something like this) Now in Doctrine, you don’t need to use ON clause because doctrine knows that from relations annotations in … Read more
Today I was working on similar task and remembered that I opened this issue. I don’t know since which doctrine version it’s working but right now you can easily join the child classes in inheritance mapping. So a query like this is working without any problem: $query = $this->createQueryBuilder(‘c’) ->select(‘c’) ->leftJoin(‘MyBundleName:ChildOne’, ‘co’, ‘WITH’, ‘co.id = … Read more
If you prefer to use Query Builder instead of Eloquent here is the solutions $result = DB::table(‘user’)->where(‘name’,=,’Jhon’)->get(); First Solution $array = (array) $result; Second Solution $array = get_object_vars($result); Third Solution $array = json_decode(json_encode($result), true);