在Laravel 5中编写自定义查询 [英] Write Custom query in laravel 5

问题描述

我想获取一些数据以及该雇员的最后休假日期及其雇员姓名 所以我写了这个查询 我如何在laravel 5中做到这一点

I want to get the some data and also last leave date of the employee with their employee name so i wrote this query how can i do this in laravel 5

SELECT employee.firstname,employee.lastname,employee.id,hr_leave.*,LAST(hr_leave.date) AS lastleaveday
FROM employee
INNER JOIN hr_leave
ON employee.id=hr_leave.hrid
WHERE hr_leave.oid=$id

employee
id  oid  firstname  lastname

id is primary key

hr_leave
id  oid  hrid  leave_from  leave_to  days  reason

id is primary key hrid is the foreign key

推荐答案

For Select --> DB::select('your query here.....');
For Insert --> DB::insert('your query here.....');
For Update --> DB::update('your query here.....');
For Delete --> DB::delete('your query here.....');
For General -->  DB::statement( 'your query here....' );

阅读本文

这篇关于在Laravel 5中编写自定义查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！