Laravel Query to Laravel Eloquent

Hi Everyone, Am new at Laravel, I want to get the list of Applications on the base of logged-in user. I have two tables LEVELS & APPLICATIONS. Both have two fields SEC_ID & LEVEL as well LEVELS table also contains USER_ID field. I want to get the list of APPLICATIONS if both table have same SEC_ID & LEVEL on the base of Logged-in USER_ID Which matched in LEVELS tabl

umairakram500's avatar
umairakram500's avatar aurawindsu...Laravel
1

changing DB::connection() to query()

*** please delete this, I'm an idiot *** Hello, I want to change my method of searching from DB::connection(mysql2) to query() so I can use multiple dynamic filters, but not sure what I need to 'use', or what the correct syntax is. I've looked through the docs but can't find what I'm looking for. I'm a moron. spent 6 hours searching and reading documentation yesterday only for

louischappell's avatar
louischappell's avatar louischapp...Laravel
2

Query is takes only first id

I wanted to show the products only from mentioned by using below query but which is showing only first one. $productIds = "1,2,3,5,6,8"; $query = GP::table('gp_products') ->select('gp_products.*', 'gp_product_details.*', 'gp_product_status.*') ->join('gp_product_details', 'gp_product_details.product_id', '=', 'gp_products.product

mkrahamath's avatar
mkrahamath's avatar NOMGUYEloquent
12

Displaying time from database query in Vue without the seconds.

I pass data from an eloquent query to Vue using props. I want then to display the time data in this collection as 00:00 instead of 00:00:00. I have tried moment.js with no luck. How can I do this. The data is stored in item.start and item.finish in the vue instance. <template> <div> <div v-for="item in todays_hours"> <div

finchy70's avatar
finchy70's avatar kyliewilli...Vue
8

Nubee trying to do a select distinct query...

I am trying to get the following query to work in laravel. I am doing a great job of showing the 'Woops, it looks like you are doing something wrong' error but not accomplishing it... Any help would be great: SELECT distinct CONCAT(users.first_name, ' ',users.last_name, ' ', TIME_FORMAT(emp_trained_courses.start_time, "%h:%p"), ' ', DATE_FORMAT(emp_trained_courses.co

bireland's avatar
bireland's avatar birelandEloquent
3

Display Avarage of rating with Query Builder? | Laravel 5.6

Hi, I have a query and I need average rating number (ex: 5, 3, 2 etc..) of single article. Now I have two table posts and ratings, that I get from a simple Eloquent query Post::where('id', '=', '1')->first(); This articles can have multiple ratings, that are stored in an other table. I need to get the average of ratings. So my query is now like this: public function view

NoneNameDeveloper's avatar
NoneNameDeveloper's avatar m7vm7vLaravel
1

Query to get the last registrations is not working properly

I have this query because I want to show in the conference management page some info in a table about the last 3 registrations in a specific conference (the name of the user that did the registration, the quantity of selected registration types and the value of the total prices of the selected registration types): <table> <thead> <tr>

adamjhn's avatar
adamjhn's avatar SnapeyLaravel
1

I need following output of query using laravel.

table-1 id 1 table-2 fk_id deleted_at 1 null 1 not null 1 not null output :- Not Need any output because id-1 one record are not deleted. In short I need all those id that all records are deleted like this, table-1 id 1 2 table-2 id fk_id deleted_at 1 2 not null 2 2 not null 3 2 not null 4 1 null 5 1 n

heyIm's avatar
heyIm's avatar imdadLaravel
4

Laravel Query Builder Counting problem | laravel 5.6

There is my query function using fluent query builder. And I want to count id from some tables. $my_jobs = DB::table('jobs') ->leftJoin('job_categories', 'jobs.cat_id', '=', 'job_categories.id') ->leftJoin('location', 'jobs.location_id', '=', 'location.id') ->leftJoin('jobtypes', 'jobs.jobtype', '=', 'jobtypes.id') ->leftJoin('users', 'jobs.user_id', '=', 'users.id')

NoneNameDeveloper's avatar
NoneNameDeveloper's avatar tykusLaravel
1

query multiple data

Hi all, I need to return a result with multiple query, here is my code and it only return with '[ ]' symbol. $tags = DB::table('game_id')->where('status',0)->where('wallet',$player_id)->pluck('game_id'); $data = oldwork::where(function($query) use($tags) { foreach($tags as $tags) { $qu

kankai's avatar
kankai's avatar MikeMacDow...Laravel
1

Laravel Magic Query Builder

How much magic can be used in the query builder? Just curious. Looking for examples that are not in the documentation

ITellMyselfSecrets's avatar
ITellMyselfSecrets's avatar bobbybouwm...Eloquent
1

Get model's class name from eloquent collection even if the query does not return any results

Say there are no users in the system yet and I am running this query: $users = User:all(); How do I resolve the model's class name from the $users collection even if it does not return any results?

jd_itsme's avatar
jd_itsme's avatar topvillasEloquent
5

Raw SQL query with variable as data

I have SQL query with WHERE IN statement where I use variable that I pass by ajax data. The value of variable is fine, I check that under network and also by simply returning it back. So the value of variable is for example "1" or "1,3". It works fine in both cases if I execute query on phpmyadmin and it works when there is only one number like "1 "

Miko55's avatar
Miko55's avatar Miko55Laravel
7

my search query is not displaying posts results 100%.

error1: Undefined property: stdClass::$user (View: C:\xampp\htdocs\infoblog\resources\views\page\search.blade.php) error2: Undefined property: stdClass::$photo (View: C:\xampp\htdocs\infoblog\resources\views\page\search.blade.php) see the SearchPostsController@store: namespace App\Http\Controllers; use Illuminate\Support\Facades\Auth; /* use Illuminate\Http\Request; */ use Re

ralphdns's avatar
ralphdns's avatar ralphdnsLaravel
5

Query to return totals by job number

I have a table that stores job numbers and hours as shown here. Data table I need to total all hours per job number for a specific period. Therefore period 1 result would look like this. Data table and results The data table extends to include 3 job number entries for each day. Anyone able to help me build the query for this? Thanks in advance.

finchy70's avatar
finchy70's avatar Danielopla...Eloquent
1

Getting a value from query on blade via further query

I have the following query in controller... $employees = Employee::with('timepunch', 'PayRate') ->whereHas('timepunch', function($q) use($start, $end){ $q->whereRaw("time_in >= '$start' AND time_in <= '$end'"); })

joshblevins's avatar
joshblevins's avatar joshblevin...Laravel
5

db query to relationship

my query $data = DB::table('countries') ->leftJoin('matches', function ($join) { $join->on('matches.hometeam', '=', 'countries.id') ->orOn('matches.awayteam', '=' ,'countries.id'); }) ->where('countries.id', $id)->get(); return dd($data); how i can get same results use relationship

AdhamLap's avatar
AdhamLap's avatar AdhamLapEloquent
4

SQLSTATE[HY000] [2002] Connection refused SELECT Query - Remote DB

Hello all, I am new to Laravel and I have been learning this pretty well however I am stuck at a particular position, that position is to query the phpMyAdmin db. What I am attempting to do is to build the application locally on my machine while tapping into the database that is hosted. I have done this through basic php but I'm getting a connection refused when loading the pa

rmlakhani's avatar
rmlakhani's avatar jlrdwLaravel
12

Sql query

Hi Folks, I'm super confused that calling JOIN after making many LEFT JOIN's in SQL query is technical wrong ? I googled but I haven't find any info. Can anyone helped me on this. Looking forward. Thanks in advance.

deepu07's avatar
deepu07's avatar CronixGeneral
1

Set a default per page in a query unless the user has selected a per page limit

Hello, I would like to be able to specify a default number of results per page unless the user has selected a value for this. The problem is that I don't know how to fetch the results if I use an if/else statement for the "per_page" input element. Here's what I have so far. Any help is appreciated. public function index(Request $request) { $query = (new User)->

cosminc's avatar
cosminc's avatar cosmincEloquent
2

Can't use whereIn to query a SQL Server 2000 using freetds driver

Hi. I'm using Laravel 5.6.29 to connect to an old SQL Server 2000 from Ubuntu 18.04 using ODBC with FreeTDS. This query works perfectly: \DB::connection('sqlsrv')->select("select * from [tb_Organizaciones] where [NivelDependiente] in (1,2,3,4)") This one doesn't App\CAD_Organizacion::whereIn('NivelDependiente', [1,2,3])->get() tinker prints this exception messag

xNicolas's avatar
xNicolas's avatar xNicolasEloquent
0

How to give priority to one query over another in multiple union in Laravel 5

I am writing query that return search results from multiple union statements. Query is running fine and results are showing but results are randomly showing. I want them as per some priority. I know how to do it in core php. how can i do this in laravel 5. SearchController.php : $first = DB::table('info') ->select('id','name') ->where('name', 'LIKE', $searchs

Vinay22's avatar
Vinay22's avatar Vinay22Laravel
0

No query results for model [App\Product] updateAll in Vue

I'm trying to create a page where I can drag and drop rows and have there position number change. The problem I'm getting is this error in my network tab "message": "No query results for model [App\Product] updateAll", "exception": "Symfony\Component\HttpKernel\Exception\NotFoundHttpException", "file": "/home/vagra

Nikki's avatar
Nikki's avatar MikeMacDow...Laravel
8

reading query where clause conditions as JSON and converting it to SQL query

what I want is accessing query whereClause parameters and converting it to a string query to read records from database by eloquent where or whereRaw method ex: converting this: {"working_years":{"$greaterThan":2,"$lowerThan":6},"car_name":"someName","car_company":"companyName"} to: working_years > 2 AND w

winner1's avatar
winner1's avatar winner1Laravel
5

Need help to convert general sql query to query builder

Hello guys, my following query is running well. But I am finding it quite difficult to use it as query builder. I am just willing to make equivalent query builder of following: /*DONATION RANGE*/ $donation_range = '1 = 1'; if($request->donation_range_checkbox){ $donation_range = "(D.donation_amount >= '".$request->min_donati

ssquare's avatar
ssquare's avatar Inquisitiv...Laravel
2

Join many relationship laravel Query Builder

Hello everyone ! I'm have issue with select result of Query builder. Four Tables musics => [id, title, file, image, ............ ] albums => [id, name, image, ....... ] singers => [id,name] music_singer [id,music_id,singer_id] return DB::table('musics') ->select( 'musics.id as id', 'musics.title as title',

phuongphally's avatar
phuongphally's avatar CronixLaravel
3

Need help for query parent model constraints

I have 3 Models which is Chain, Customer & Chain-Invoice class Chain extends Model { public function invoices() { return $this->hasMany('\App\Invoice'); } public function customer() { return $this->hasOne('\App\Customer', 'id', 'customer_id'); } } class Customer extends Model { public function chain() { return

priyanganamal's avatar
priyanganamal's avatar priyangana...Eloquent
7

How to select many relationships to single field in Laravel Query Builder.

Hello everyone ! I'm have issue with select result of Query builder. Four Tables musics => [id, title, file, image, ............ ] albums => [id, name, image, ....... ] singers => [id,name] music_singer [id,music_id,singer_id] return DB::table('musics') ->select( 'musics.id as id', 'musics.title as title',

phuongphally's avatar
phuongphally's avatar phuongphal...Laravel
2

SQL Query Relationship

Below is my query. The main query (on "books") returns 100+ records which all belong to "user" requested. The internal query (on "book_user") returns 3 records (which is what I want). However, the entire query below returns 4 records (which is all the records inside the "book_collection" table, including books that do not belong to the us

jabshire's avatar
jabshire's avatar Tray2Eloquent
3

Use union in a query

Hi there, I'm trying to create a query with union this are my query: $code = DB::table('articles') ->leftjoin('aliquoteiva', 'vat_id', '=', 'serial') ->where('code', 'like', '%'.$nome.'%') ->where('company_id',$company_id) ->get(); $articles = DB::table('articles') ->leftjoin('aliquoteiva', 'vat_id', '=', 'serial') ->where('ar

X-Mac's avatar
X-Mac's avatar EksilenteEloquent
3

mysql query take long time

i have table (languages) has only tow records and 4 columns when i run this query in laravel (select id, name, alies, dir from language where alies = 'ar' and status = '1' limit 1) it takes 34ms any reason for this long time

TarikAli's avatar
TarikAli's avatar TarikSalahLaravel
8

Query builder - Distinct rows (with multiple columns)

Hello. I want to make query with Query Builder for returning rows with distinct columns. For example: SELECT DISTINCT ip, DATE(FROM_UNIXTIME(unix_time)), location_id FROM test_table This MySQL query returns unique triples from test_table for each day. But i could not do it with Laravel/Lumen Query Builder. Thank you in advance! NOTE: I use mongoDB.

jije's avatar
jije's avatar TomiLaravel
1

Query Builder use where and orWhere

Hello folks, im using a query builder to get a filtered list of files in the database. A logged in user should only see files which he is permitted to see. The files have a name in the Database where the permission is integrated, e.g. ****-AR_Filename.pdf where -AR is the permission. I can get the user permissions as an array. An with it i wanted to loop over the permissions ar

s3nior's avatar
s3nior's avatar tykusLaravel
1

Modifying dates returned by query

I'm teaching myself Laravel by porting an API I wrote in vanilla PHP. The API does nothing too fancy -- a scheduled task takes an assortment of text files, grabs the values and dates within and stores them in the database. Later, when requested, the data is just grabbed, almost verbatim from the database, and returned as JSON. One feature of my original API was the ability to m

mr-grayda's avatar
mr-grayda's avatar andonovnLaravel
5

Change the Kiosk, user search query

I would like to change the user search in Kiosk. As it is now I have to enter an exact user name or email to get a search result. I have "Laravel-Searchy" installed so I would like to change the query in Kiosk searchController.php to: return Searchy::users('name', 'email')->query($query)->get(); I tried but I can't get it to work. (The query works in php artis

Stockholm's avatar
Stockholm's avatar StockholmSpark
2

Related models in query filter

Hello, Laracasts! I try to make search by my related models, parameters to query filter I pass from search form inputs. Models are: class Card extends Model { public function Doer() { return $this->hasMany('App\Doer,'card_id'); } } class Doer extends Model { public function Card() { return $this->belongsTo('App\Card'); } pub

jenya's avatar
jenya's avatar jenyaLaravel
0

Doing a correlated query in a subquery

I'm trying to accomplish the following in Eloquent: SELECT post_id,id,(SELECT browser from visits as v1 WHERE v1.post_id = v.post_id group by browser ORDER BY count(browser) DESC limit 1), count(post_id) as n FROM `visits` as v group by post_id And I have the following code in the query builder $item = visitsModel::select('*', DB::raw('count(post_id) as n'))->with('posts')-

Hitostacha's avatar
Hitostacha's avatar HitostachaEloquent
10

Eloquent, query condition based on relation

I have got a little problem. Take a look on it: I have first relation: public function statuses() { return $this->morphMany('App\Models\Status', 'statusable')->orderBy('id', 'DESC'); } and: public function currentStatus() { return $this->morphOne('App\Models\Status', 'statusable')->orderBy('id', 'DESC'); } Second relation wo

themate0's avatar
themate0's avatar tykusLaravel
1

Query model based on variable input that can be null?

I am trying to search my products table with the following form. I want people to have the option to be able to just search by 1 filter or all filter options. The issue I am running into is that then sometimes field values can/will be null OR equal to 'any'. So how can I run a query where if 'any' is selected, it will return all results for that filter, and if null is the value

jpeterson579's avatar
jpeterson579's avatar 36864Eloquent
4

DB select returning array, not result of query

hello, i tried query with DB::select like bellow, it is return a query array . not result of query: how to fix my query select ? DB::statement('SET @sql = NULL'); $db = DB::statement(" SELECT GROUP_CONCAT(DISTINCT CONCAT ( 'SUM(IF(criteria_id = ', criteria_id, ', scores, N

rizqari's avatar
rizqari's avatar netostsEloquent
4

Query that has a where clause and with clause.

I'm writing a ajax call to a controller with a function to return $courses I have two tables/Models... Courses and Instructors. Instructor has... public function Courses() { return $this->hasMany('App\Course'); } Courses has... public function Instructor() { return $this->belongsTo('App\Instructor'); } I have a query that's working but w

jhutto's avatar
jhutto's avatar SnapeyEloquent
6

How to bind parameter to query?

I'ma trying to log SQL query executed, but I'd like to have a plain sql. $query_array = DB::getQueryLog(); foreach ($query_array as $query) { DB::table('sql_logger')->insert([ 'user_id' => $request->user() ? $request->user()->id : null, 'query' => addslashes ($query["query"]),

realtebo's avatar
realtebo's avatar jlrdwLaravel
1

Eloquent query is taking an extremely long time

So I am trying to get my friends and followers statuses with a left join, here is my query: `/** * Scope a query to friends and followers statuses. * * @param \Illuminate\Database\Eloquent\Builder $query * * @return \Illuminate\Database\Eloquent\Builder */ public function scopeFriendsAndFollowers(Builder $query): Builder { $user_id = auth()->user()->id; ret

nc1991's avatar
nc1991's avatar kbush83Eloquent
4

query with distinct and order by

I have this query to get the conferences where the column "city" is equal to the $search. $cities = Conference::where('city', 'LIKE', '%'.$search.'%')-> distinct()->get(['city']); But I want to also order by the results by the conference 'start_date' column. But like this is not working: $cities = Conference::where('city', 'LIKE', '%'.$search.'%

adamjhn's avatar
adamjhn's avatar SnapeyLaravel
22

How do I query for a field of an Eloquent model's relationship?

So when a Member buys a Product, a Sales object is saved into the database. It contains the member_id and the product_id among other fields. Now, I'd like to implement a search field in which the user can search through the Sales product name. public function index(Request $request) { $term = $request->query('term'); $sales = /** Find all Sales objects in wh

alchermd's avatar
alchermd's avatar alchermdLaravel
2

Laravel MySQL apply product filters with eloquent (what is the correct query?)

I'm trying to filter my products with eloquent but my where statement for the filters would never work the way I have it currently. My database tables look like this: The products table +---------------+ | id | name | +---------------+ | 1 | product1 | | 2 | product2 | | 3 | product3 | | 4 | product4 | +---------------+ The properties table +-------------------------

stefanastecom's avatar
stefanastecom's avatar staudenmei...Eloquent
3

How can I use replace in Query?

I try to use Replace in my Query because I have categories in the Database, which might have a - inside them and my URL got - so to make sure I can compare, they both need to be the same. In MySQL it would look like this: select * from `posts` inner join `categories` on `posts`.`category_id` = `categories`.`id` where REPLACE(category,' ','-') = 'Bits-Bobs and others' So

Luka's avatar
Luka's avatar LukaLaravel
2

How to construct Eloquent query from this SQL statement

Hey Gang I am hitting my head against the wall trying to figure out how to convert this simple SQL statement to a relevant Eloquent query SELECT players.nameFirst, players.nameLast, batting.* FROM batting INNER JOIN players ON batting.playerID = players.playerID WHERE batting.id = 72548; I can get the data I want using App\Batting::whereId(72548)->with('pl

codedungeon's avatar
codedungeon's avatar codedungeo...Laravel
11

query to check there are registration types with price "> 0"

I have a table registration_types that is associated with a conference, a conference can have multiple registration types. So the registration_types table have columns like: id, name, price, conference_id. And I want to do a query to check if for a specific conference there are registration types where the price is not free, that is the price is ">0". I already hav

adamjhn's avatar
adamjhn's avatar HitostachaLaravel
6

Has Many Through query.

I have three models : topic, class and enrollment Topic : id name class : id topic_id name enrollment : id class_id I want to query enrollment model, to get the details of topic associated with each class. I am using hasManyThrough relation like following: return $this->hasManyThrough('Topic', 'Class', 'topic_id', 'id', 'class_id', 'id'); but its not working. Please h

himanshu-dhiman's avatar
himanshu-dhiman's avatar himanshu-d...Eloquent
1