Translate from SQL query to Eloquent

Question

Translate from SQL query to Eloquent

Navigation

#1 by (2 votes)

1

Hi, I'm new to eloquent and laravel, I have the following query, which runs perfectly from phpmyadmin:

SELECT * FROM vips_categories JOIN vips_products JOIN vip_archivos WHERE  vips_categories.parent_id = 1 AND vips_categories.parent_id = vips_products.id AND vip_archivos.id = vips_products.img

I wanted to do the following:

 $query = DB::table('vips_products AS Producto)
->join('vips_categories as Categoria.','Categoria.parent_id','=',$categoria)
->join('vips_categories as Categoria','Categoria.parent_id','=','Producto.id')
->join('vip_archivos', 'vip_archivos.id', '=', 'Producto.img')
->select('*');

But apparently it is incorrect, if someone could help me translate it I would be very grateful

mysql sql php eloquent

asked by BorrachApps Mex 04.08.2017 в 20:49

source

1 answer

Define a global variable to be used in several views independent of the controller of each view Table that does not load with php

score 2 · Accepted Answer

First of all, as I see, there is a syntax error in DB :: table ('vips_products AS Product), that string must be closed. Second, you are using Query Builder but not Eloquent. If what you need is to get that query in Query Builder it would be something like this:

$query = DB::table('vips_categories')
->join('vips_products','vips_categories.parent_id', '=', 'vips_products.id')
->join('vip_archivos', 'vip_archivos.id', '=', 'vips_products.img')
->where('vips_categories.parent_id', '1')
->select(['*']);