在Laravel 5中编写自定义查询

本文介绍了在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....' );

阅读本文