Query-builder Questions

I need to subquery where data doesn't exist in another db table. i tried with db::connection('dbconfigname') first db

The id field in the foreach loop exists in both of the tables that i am joining, i need to reference it to one table only (ie. program_types.id)

I'm trying to do this query in laravel. select distinct curriculum.course_code, transcript.course_grade, transcript.course_comp,

Having hard time to do self join with query builder but getting unexpected results or query while using tosql() or

I can not extract the result in groupby, the query builder below works very well but i want it to eloquent. i want to display only the folders

Users can block each other. one user can block many (other) users, and one user can be blocked by many (other)

I have two tables, salaries and pointages, and a belongsto/hasmany relationship between them.

I wanted to do a custom ordering for marketing_status_id in this: $prospect =

I have table with next columns (price, special_price, is_special). +-------+------+-----------------+--------------+---------+ |

I have a single column in db named session and i want to insert all below data in single column in a form of array. data available

I would like to ask.i am having trouble where i could not get the id instead i am getting the whole row.

I have this query, i would like to obtain only the data created on the current month public function index(request $request) {

I have the next table..

How can i find duplicate values in database with laravel. i want the results like this: name_data - amount

I want to show $personnals and $users in a table in the blade. i know, i have to use @foreach.

I want to transform my mysql query into a query in laravel but i really don't know how to do this. i don't know how to rename in from like in

I have this function to register my users protected function validator(array $data) { return validator::make($data, [

According to laravel documentation if you need to work with thousands of database records, consider

I am struggling to make this sql query to a laravel pdo query. does anyone know how i can do this? (especially the 'as' statements

How can i use query function inside blade without using controller something like this::-

I have this code: $classic_games_money = db::table('bets') ->where('user_id', $this->user->id) ->sum('price');

I have @entity('procedures') export class procedureentity { @primarygeneratedcolumn() id: number; @onetomany(type

I got stuck in this problem i encountered in laravel query. firstly i have this query that i use in order to get transactions

I have these 2 models. i want to get sum of 12 columns comment_count in youtube_video_insights table.

Select apartment_id, count(created_at) as n_view, date_format(created_at, '%y-%m-%d') as day_view from views where apartment_id=36 group

Basically i have two tables. answers and choices . in my choices table, i got a column

I have the following two tables: customers: | phones: -------------------------------------- id | id name |

Recently i just realized that laravel generates a static method with column name when joined in a where clause using camel case example

I have search page and there is 3 select lists as input. when user select one or more option and click search button, page will show result that

I have this query... and i would like to make a distinct only in (tbl_holdings) this is my query $holdings =

I have got a condition and i want to use mysql temporary tables. i have tasks table and jobs table.

Here my code : $sum = $pipes->sum(function ($pipe) use ($filter) {

I am using 2 tables upon displaying my users in my users>index.blade these 2 user table

I have a column in my db table which has multiple comma separated values and i have a comma separated array below:

I am very new to laravel and trying to get the all permission rows from the permissions table that set into the roles -

I have two models in my laravel 5.8 project, relationships is shown below in both model classes. how can i get every single post

I have defined 3 tables in laravel as follow: schema::create('locales', function (blueprint

I want to make a count by the first letters... i have this column

I have two table following: tb_category id |name | ---------------- 1 |category a| 2 |category b| 3 |category c| 4

I can't exclude the number one and two from my count... i used wherenotin but didn't work, why? $data =

How to return, with eloquent, all files where column deleted_at is null. i can access the value of deleted_at like this

I am fetching data of user with the subject model and review model. there is a rating column in the

I have this list of dates

I tried to make tree joins with this code, but didn't work... $av = db::table('rifcliente_filtro')

I have two tables in my database my first table

I have this query $data = db::table('incidencias') ->select(db::raw("str_to_date(fecha_notif, '%d/%m/%y %h:%i:%s') as

I would like to count how many hours are between this two formats using laravel query builder.. how could i do that? i would like to know if it

I'm inserting a group of elements in database, i'm trying to get one element for each row but i'm obtaining all elements in one row and every row

So i have a table in mysql which looks like this

Some time ago i've read here on stackoverflow an accepted answer which was claiming that select("sql query") is excused from sql

I have a request that returns documents to me. i would like to join the sums of goods of each document and summarize them. it looks like

I using laravel and its \illuminate\database\eloquent\builder. i would like to select all columns from "table_1" a have custom column

Here my code : $search = request()->get('search'); $conciergerieselect = request()->get('conciergerie'); $services

Here my code : list($orderby, $orderdirection) = explode('.', request()->get('sort_by')); $prestations =

I am using db to store values in database. i have "course fees" column i what to "increment" the "course_fees"

I’m a beginner in laravel but have a problem at first. i wrote this query and i’m waiting for sonya bins as result

Here my code : $prestations = prestation::with('service','facility','conciergeries.network') ->wherehas('service',

Here my code : $prestations = prestation::with('service','facility','conciergeries.network') ->wherehas('service',

Here my code : $prestations = prestation::with( [ 'service' => function($service) use($searchservice)

I have three models: user image post and their relationship is: user hasmany

I tried to code a request with search system. here the code: $search =

I need to count revisited customer in one month. it means need to count customer_id has more than one entry in table within a month. my

Is it possible to make this a single query? $yl_min = db::connection($this->db2)->table('historical')

Is there a way of adding a scope to the belongstomany fields, such that when you attach related models you can only do so from restricted

I need all users data in one blade, i have table1 and table2. table1

I'm trying to decrypt the data from mysql database provided by our partner. they encrypted it using this in mysql aes_encrypt(fld_code,

I have a problem when trying to import some excel data into the database with query builder, i got undefined offset: 4 even though the column of

I have one table which stores some records as json. i'm trying to increment the numeric value of a key from json column. below is the query i'm

I have an export functionality and i want to query and export using given ids. i found a solution of querying using skip() and

How can i convert following laravel db query builder to eloquent? is it possible to do laravel eloquent? $reports =

Important : i didn't get my data from a model, but from a query builder query. the following first function build a view

I have a query that returns a boolean field (by the way, i'm on an sql server) on my rest api developed with laravel and a few days ago it was

I am working on a website that uses php and sql to connect to the database, i'm trying to replace all the sql with laravel query builder commands.

I have two tables for example users and orders. i have to join users with orders on users.id = orders.user_id - which is

My code is as followed: return user::wherehas('roles', function ($role, $query) {

I'm very new to laravel, how can i make this query in laravel using eloquent model: select (

The following is my sql query. i'm googling to convert laravel query builder but can't find a good solution. please help me.

How can i convert this query in query builder. public function ajaxsearch(string $value = null) //for search, from sidebar {

Edit: for clarity, this is laravel 5.8. this is for a hr app i'm working on. they requested a report to show people who have

I am actively working on a laravel project and have ran into some issues with the query builder. i am trying to avoid using db::raw but it is

I have the following query : $top_cont = db::table('quests') ->wherebetween('created_at',

I am using laravel eloquent to crud data. my problem is, i don't know how to make union queries using laravel eloquent orm. can you help me to

How to get a list of category and subcategories like this: 1 mobile apple samsung

I am new to the laravel, i am joining three tables based on conditions every thing is working fine but i need to write conditionally if the $field

I have a selection of plots which each belong to a development by a hasmanythrough relationship through housetypes. i want to filter these by

In my database, there is a table called vehicle_schedule, and all the vehicle schedules are stored there. in that table, there is two columns name

I have array of id's i want to delete all of them with one query without foreach and eloquent, is there any way of it?

I have a problem with the laravel query builder. when i try to bind a variable, which would include some sort of sql code, into my binding

Take a look at the following query: $testquery = customer::where('company_id', auth()->user()->company_id);

I am tying to retrieve data from my data base using leftjoin in laravel. i have two table name users and

I am building an advanced table filter using laravel. the client sends an array of filters to the server to apply on a model and send back the

I have this sql query for mysql which works fine. but i need to rewrite it using query builder and need to avoid db::raw() completely

Reading the documentation it's pretty much clear how to build queries, but i couldn't find any tutorial how to connect to the database - i.e.

I have multiple mysql connections to different databases in my laravel application. i understand that i cannot override the default connection

I have a table quotations id lead_id subject created_at 1 2 quotation 1

I have some query and i just know how to query on mysql (phpmyadmin) i got information if using db::select we cannot to use

I would like to load posts from users of a certain age from the database. the user can save the minimum(users->profile->min_age) and maximum

I have three table: table1: jobposts (id,user_id,qualification_id) table2: appliedjobs (id,jobposts_id,message) table3:

I want to read and overwrite existing data projectcontroller.php public function update(request

I want to run this custom query in laravel app and save the result in a variable select min(t1.id + 1) as nextid rom