我有一個(gè)在 Laravel 應(yīng)用程序中使用的 MariaDB 查詢，我希望它返回 7 列。當(dāng)我使用 PHP 轉(zhuǎn)儲(chǔ)結(jié)果數(shù)組時(shí)，它似乎只返回 4。但是，當(dāng)我采用相同的查詢并在 PhpMyAdmin SQL 編輯器中運(yùn)行它時(shí)，它返回的全部 7 與我的預(yù)期完全一致。只是想知道是什么導(dǎo)致 Laravel 將結(jié)果過(guò)濾為只有四列：狀態(tài)、姓名、電話號(hào)碼和描述？謝謝！拉拉維爾查詢： $entries = DB::select('SELECT status, contacts.name, contacts.telephone_number, companies.name, roles.name, stages.description, actions.description FROM entries JOIN contacts ON entries.contact_id = contacts.id JOIN companies ON contacts.id = companies.contact_id JOIN roles ON companies.id = roles.company_id JOIN stages ON roles.id = stages.role_id JOIN actions ON stages.id = actions.stage_id');PHPMyAdmin SQL 編輯器的查詢： SELECT status, contacts.name, contacts.telephone_number, companies.name, roles.name, stages.description, actions.description FROM entries JOIN contacts ON entries.contact_id = contacts.id JOIN companies ON contacts.id = companies.contact_id JOIN roles ON companies.id = roles.company_id JOIN stages ON roles.id = stages.role_id JOIN actions ON stages.id = actions.stage_id
2 回答
一只萌萌小番薯
TA貢獻(xiàn)1795條經(jīng)驗(yàn) 獲得超7個(gè)贊
兩種情況的結(jié)果相同。他們只是使用相同的屬性，因此雄辯的結(jié)果相互覆蓋。使用別名來(lái)解決問(wèn)題
SELECT status, contacts.name as contact_name, contacts.telephone_number, companies.name as company_name, roles.name as role_name , stages.description, actions.description FROM entries JOIN contacts ON entries.contact_id = contacts.id JOIN companies ON contacts.id = companies.contact_id JOIN roles ON companies.id = roles.company_id JOIN stages ON roles.id = stages.role_id JOIN actions ON stages.id = actions.stage_id
慕容3067478
TA貢獻(xiàn)1773條經(jīng)驗(yàn) 獲得超3個(gè)贊
您應(yīng)該設(shè)置別名以避免覆蓋。另一件事是，如果你使用 Laravel，那么 eloquent 就是你的朋友：
$entries = DB::table('entries')
->join('contacts', 'entries.contact_id', '=', 'contacts.id')
->join('companies', 'contacts.id', '=', 'companies.contact_id')
->join('roles', 'companies.id', '=', 'roles.company_id')
->join('stages', 'roles.id', '=', 'stages.role_id')
->join('actions', 'stages.id', '=', 'actions.stage_id')
->select('status', 'contacts.name AS contact_name', 'contacts.telephone_number', 'companies.name AS company_name', 'roles.name AS role_name', 'stages.description AS stage_description', 'actions.description AS action_description')
->get();
更好的方法是使用模型和集合關(guān)系。
- 2 回答
- 0 關(guān)注
- 164 瀏覽
添加回答
舉報(bào)
0/150
提交
取消