eloquent - Select from table where column in select from another table in laravel -

-

i have following query 

select * answers (id_question in (select id questions id_quiz = 3))

i need know how write in laravel eloquent

answer::wherein('id_question', function($query) {     $query->table('questions')->where('id_quiz', 3) })->get();

Comments

Post a Comment

Popular posts from this blog

node.js - How to mock a third-party api calls in the backend -

-
i'm testing application mocha , supertest, test like var request = require('supertest'), app = require('./bootstrap.js'); describe('...', function() { it('...', function() { request(app) .get('/some/url') // ... }); }); the bootstrap.js real application before listen ports all works perfect have add calls third-party api , testing slow so when do, test example takes 5 seconds request(app) .get('/my/endpoint/that/makes/call/others') // ... how can make fake calls during test real when running application? you can use nock purpose.
Read more

php - How to Access to Laravel 5 with Pingpong-Modules to a specific Module -

-
i new laravel 5 , pingpong-modules https://github.com/pingpong-labs/modules i want access outsite of modules-directory specific module-function. my actual configuration is: i want access method "test()" dashboardcontroller - here best practice? code of controller 1: <?php namespace app\http\controllers\admin; use app\http\controllers\admincontroller; use app\news; use app\newscategory; use app\user; use app\video; use app\videoalbum; use app\photo; use app\photoalbum; use \pingpong\modules\facades\module; use app\helpers\moduleshelper; class dashboardcontroller extends admincontroller { public function __construct() { parent::__construct(); } public function index() { $title = "dashboard"; $news = news::count(); $newscategory = newscategory::count(); $users = user::count(); $photo = photo::count(); $photoalbum = photoalbum::count(); $video = video::count(); ...
Read more

sql server - Sharing data between stored procedures -

-
i have stored procedure called dbo.match . looks : create procedure [dbo].[match] @parameterfromuser nvarchar(30), @checkbool int begin --some code select rowid, percentmatch @matches end this procedure being called stored procedure : create procedure matchmotherfirstname @motherfn nvarchar(20) , @checkbool int begin select @constval = functionweight dbo.functionweights functionweights.functionid = 20; /* code execute `dbo.match` procedure in above procedure called `matchmotherfirstname` , retrieve `rownumber` , `percentmatch`, insert #temp in respective fields , , calculate `percentmatch * constval`, , insert in corresponding column called `percentage` in `#temp` */ end i need execute dbo.match stored procedure in above procedure, retrieve rowid , pecrntmatch value, @constval value have above, multiply @constval , percentmatch , store in percentage column of #temp , insert results dbo.match procedure in temporary table. dbo.match ...
Read more