Detailed explanation of the solution to the error id returned by Laravel related query in PHP

墨辰丷
Release: 2023-03-27 19:04:02
Original
1619 people have browsed it

This article mainly introduces the solution to the error id returned by Laravel's related query. It is very good and has reference value. Friends who need it can refer to it.

Use join related query in Laravel Eloquent. If two If a table has a field with the same name, such as id, then its value will be overwritten by a later field with the same name by default, and the result returned is not expected. For example, the following related query:

PHP

$priority = Priority::rightJoin('touch', 'priorities.touch_id', '=', 'touch.id')
 ->where('priorities.type', 1)
 ->orderBy('priorities.total_score', 'desc')
 ->orderBy('touch.created_at', 'desc')
 ->get();
Copy after login
Copy after login

$priority = Priority::rightJoin('touch', 'priorities.touch_id', '=', 'touch.id')
 ->where('priorities.type', 1)
 ->orderBy('priorities.total_score', 'desc')
 ->orderBy('touch.created_at', 'desc')
 ->get();
Copy after login
Copy after login

Both the priorities and touch tables have id fields. If the query is constructed like this, the returned query results are as follows:

Laravel 关联查询返回错误的 id

Laravel related query returns the wrong id

The value of id here is not the id field of the priorities table, but the id field of the touch table. If the executed sql statement is printed out:

select * from `priorities` 
right join `touch` 
on `priorities`.`touch_id` = `touch`.`id` 
where `priorities`.`type` = '1' 
order by `priorities`.`total_score` desc, `touch`.`created_at` desc
Copy after login
Copy after login

select * from `priorities` 
right join `touch` 
on `priorities`.`touch_id` = `touch`.`id` 
where `priorities`.`type` = '1' 
order by `priorities`.`total_score` desc, `touch`.`created_at` desc
Copy after login
Copy after login

The query result is as shown in the figure:

The result of using sql query is actually correct. In addition The id field of a table with the same name is named id1 by default, but the id value returned by Laravel is not the id field in the figure, but has been overwritten by the field of another table with the same name.

The solution is to add a select method to specify the field and correctly construct the query statement code:

PHP

$priority = Priority::select(['priorities.*', 'touch.name', 'touch.add_user'])
 ->rightJoin('touch', 'priorities.touch_id', '=', 'touch.id')
 ->where('priorities.type', 1)
 ->orderBy('priorities.total_score', 'desc')
 ->orderBy('touch.created_at', 'desc')
 ->get();
Copy after login
Copy after login

$priority = Priority::select(['priorities.*', 'touch.name', 'touch.add_user'])
 ->rightJoin('touch', 'priorities.touch_id', '=', 'touch.id')
 ->where('priorities.type', 1)
 ->orderBy('priorities.total_score', 'desc')
 ->orderBy('touch.created_at', 'desc')
 ->get();
Copy after login
Copy after login

This solves the problem, so you should pay attention to it in the future. It is best to specify the fields returned when joining two tables in Laravel.

Is this a bug in Laravel? If the value of a field is overwritten by a field value with the same name, should an error be reported instead of continuing execution by default?

Someone on github also raised the same problem, and the author also provided a solution, but there is no other better solution.

Laravel version: 5.3

Link: https://github.com/laravel/framework/issues/4962

The above is the entire content of this article, I hope it will be helpful to everyone Learning helps.


Related recommendations:

PHPProcessing the secondary verification to the server after in-app purchases in Apple APP (project experience)

DVWA's php mysql manual injection

PHP project integration WeChat terminal scan code payment API (domestic payment)

The above is the detailed content of Detailed explanation of the solution to the error id returned by Laravel related query in PHP. For more information, please follow other related articles on the PHP Chinese website!

Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template
About us Disclaimer Sitemap
php.cn:Public welfare online PHP training,Help PHP learners grow quickly!