Replace method from Request facade not replacing data from query parameters #31683

Environment: Laravel Version: 6.8 (Replace method is actually the same in version 7 also) PHP Version: 7.2 Database Driver & Version: pgsql & Postgre 9.6 Description: The replace method from the Request facade is not replacing data from query parameters. The documentation of the method says "Replace the input for the current request.". I would assume that in

kalemdzievski's avatar
kalemdzievski's avatar kalemdziev...Laravel
7

How to return query search with wildcard?

I have a page where it shows product categories of all the items. So for example, for lightings, my page will be like below: My Featured categories: LED Wall Lights Office Light Table Light My featured deals(contains subcategories): led-light-1 led-light-2 wall-light-1 office-light-1 office-light-2 office-light-3 ....... You get the idea. It w

CookieMonster's avatar
CookieMonster's avatar jlrdwLaravel
7

How to return JSON response from a query with eloquent?

How to return JSON response from a query with eloquent?

JohnEC's avatar
JohnEC's avatar kingmaker_...Eloquent
1

Laravel 5.5 query (sub-query) pluck.

Hi, Please, I have: Laravel v5.5.48 Tables: ads ad_settings special_sections table: ads (among others): id (9) title table: ad_settings (among others): id (45) ad_id (9) is_active table: special_sections (among others): id (1) ad_setting_id (45) theme In my controller I have: $ad = AdSetting::with(["ad" => function($q){ $q->where('ad_id', '=', 'id');

PabloT's avatar
PabloT's avatar PabloTEloquent
2

How to return JSON response from a query with eloquent?

I am working on this query: (I wish I could pass this same query using eloquent and return a JSON as response.) public function getChart(Request $request) { $_orders = DB::table('users') ->join('orders','orders.user_id','=','users.id') ->join('model_has_roles', 'users.id', '=', 'model_has_roles.model_id')

rjruiz's avatar
rjruiz's avatar zsoltgyureEloquent
13

relationship groupBy in initial query

I am trying to groupBy a relationship in the initial query from my controller but not having such luck. For now I have a workout, but seems clunky: public function menu(Location $location) { $location->entrees = $location->entrees->groupBy(function ($entree) { return $entree->course->name; }); return view('food-order.menu'

packy's avatar
packy's avatar SnapeyEloquent
12

Laravel Query Builders.

Where to find list of all possible query builders. Not send me this examples from documentation. https://laravel.com/docs/7.x/queries

Ajvanho's avatar
Ajvanho's avatar IvanRadoje...Laravel
3

Beginner: Having trouble understanding how to extract the data out of a result from a query.

I am new to Laravel/Eloquent and I'm having trouble understanding how to extract the data out of a result from a query. I'm calling the following query in the controller $purchase['purchase_price_total_LY'] = DB::table('coins') ->select(DB::raw('SUM (purchase_price) as purchase_price_total_LY')) ->where('user_email', '=', auth()->user()->email) ->whereBetwe

scottsuhy's avatar
scottsuhy's avatar scottsuhyEloquent
3

OrWhereIn on Pivot Table Using Query Builder

I have a table of 'projects' with each project belonging to a primary group (e.g. belongsTo(Group::class)) associated by the column 'group_id' of which any users in that group have access to those projects. However, each project can also be shared with other groups, and these (id's) are stored in the pivot table 'group_project' with the two columns 'group_id' and 'project_id'.

WhosTheKimster's avatar
WhosTheKimster's avatar WhosTheKim...Laravel
0

Delete all but the first 50 rows in a query

I want to keep only the first 50 rows that are returned by a query. I tried using skip(50) but that didn't work. Any ideas?

jerauf's avatar
jerauf's avatar jeraufEloquent
2

query where Date_format() issue

I try to get value from the db with date_format(created_at, '%Y-%m-%d %H:%i'), but it seem i got the wrong query and could not find any solution on the issue. Anyone who knows how to retrieve created_at value with specific date_format? Can you help me on this?

akmadhwa's avatar
akmadhwa's avatar deansatchLaravel
3

Laravel Many-to-Many (on the same users table/Model): Query scopes to include related for the specified user

Users can block each other. One user can block many (other) users, and one user can be blocked by many (other) users. In User model I have these many-to-many relationships: /** * Get the users that are blocked by $this user. * * @return \Illuminate\Database\Eloquent\Relations\BelongsToMany */ public function blockedUsers() { return $this->belongsToMany(User::class, '

DoeJohn's avatar
DoeJohn's avatar DoeJohnEloquent
1

Ambiguous reference in query

Greetings! I have this error: Illuminate/Database/QueryException with message 'SQLSTATE[HY000]: General error: 0 [DataDirect][ODBC Progress OpenEdge Wire Protocol driver][OPEN EDGE]Column reference "persona_numero" is ambiguous. (13852) (SQLPrepare[0] at ext/pdo_odbc/odbc_driver.c:204) (SQL: select count(*) as aggregate from "PUB"."tl06_orden_trabajo_ca

MarcosKlender's avatar
MarcosKlender's avatar MarcosKlen...Eloquent
2

Laravel Query

Please I need with laravel complex query. I have post table, post files table, post comments table, user table, post like monitor table, post files like monitor table. i want to fetch post with files and comments and check if the user at the front end has already liked the post or each file associated with a particular post. i could find my way with post and check if already

beyond's avatar
beyond's avatar beyondEloquent
2

Laravel query builder

Hello all, I am in problem with my query,can anybody help ? my Input is $searchBy = column_name; $searchValue = 203; $numRec = 5; $sortBy = 'id'; $sortType = 'DESC'; my Query is $parentLis = Parent::selectRaw('parents.approval_status,parents.id, child.demurrage_id,child.child_number,child.agreement_type,child.agreement_id,

yusuf128's avatar
yusuf128's avatar SnapeyLaravel
3

useing Eloquent in blade file make another query?

In controller I got all users with this: $users = User::all(); return view('users, compact('users')); if I use this code in blade, does this make another query? @foreach($users->where('active', true) as $user) <li>$user->name</li> @endforeach

Armani's avatar
Armani's avatar ArmaniEloquent
6

How to Write Sql query in laravel

how to write this query in laravel select products.id, products.name, (select ifnull(sum(stocks.qty),0) from stocks where stocks.pid=products.id and DATE(stocks.created_at) = CURDATE()) as total_stock , (select ifnull(sum(loadings.qty),0) from loadings where loadings.pid=products.id and DATE(loadings.created_at) =

melx's avatar
melx's avatar EMfinangaLaravel
20

How to query same column name and id in multiple table

$Query = DB::tables('melanine_finishes','melamine_out_finishes', 'plastic_out_finishes',) ->select('item_no', 'id', DB::raw('SUM(qty) AS qty'),) ->groupBy('item_no', 'id') ->orderBy('created_at','desc')->paginate(5);

tomasosho's avatar
tomasosho's avatar SnapeyCode Review
3

merge two query

how can i have one query of the below code $yesterday = date("Y-m-d", strtotime( '-1 days' ) ); $stockSummary=\DB::table('stocks') ->select('products.name','stocks.pid','stocks.qty as stockin','loadings.qty as issued') ->join('products','products.id', '=', 'stocks.pid') -&

melx's avatar
melx's avatar NakovLaravel
3

DB query grouping sum each

i want to achieve *OrgName #1 - PayPal - 2020-01-01 [ array_booking ] - Count Total (LBP) - Total Sum(LBC) commison - 2020-01-02 [ array_booking ] - Count Total (LBP)

Aronaman's avatar
Aronaman's avatar jlrdwLaravel
6

Add query parameter in middleware

For a demo mode (used in an iframe) I open my website with a query parameter, e.g. ?demo=true I use this in order to do some other stylings conditionally. To keep this state while browsing to other links, I want to keep this get parameter in every single url. To do so, I created a middleware that checks whether the parameter is present or not and adds this parameter for the ne

julian2020's avatar
julian2020's avatar julianfaer...Requests
5

Livewire and Spatie's Query Builder

If anyone is struggling with Livewire and Spatie's Query Builder, here's a quick tip on how to get it working with filters: Component: <?php namespace App\Http\Livewire; use App\Item; use Livewire\Component; use Spatie\QueryBuilder\QueryBuilderRequest; class Table extends Component { /** @var QueryBuilderRequest */ protected $request; /** @var array<string

CliffordAtCaveoDotNL's avatar
CliffordAtCaveoDotNL's avatar authanramLivewire
5

How do i translate my SQL query to a Laravel Query

i have this sql Query and i've tried to translate it to a laravel query but to no avail. SELECT t.topic_id, ti.id, ti.name FROM canvas_posts_topics AS t, canvas_topics AS ti WHERE t.topic_id = ti.id Can anyone take a look at it?

Anthonynzube's avatar
Anthonynzube's avatar jlrdwLaravel
3

Pin items to the top of query builder result

Hi! I want to query a list of restaurants, ordered by date of creation. Restaurants with specific attributes, stored in a JSON column, must be always pinned to the top of the list, regardless of creation date. The list must be paginated. This is an example of a restaurant data row: name (String): Burger King created_at (Timestamp): 2020-02-12 12:04:33 extras (JSON): ['family_fr

JScheele200's avatar
JScheele200's avatar Tray2Laravel
1

query relationship existance with scope

Here are my model classes: Conversation: public function reports() { return $this->hasMany('App\ConversationReport'); } ConversationReport public function scopeActiveReports($query) { return $query->whereNull('processed_by'); } Is there a way I can check if a conversation has an active report? I tried using: $this->reports()->activeReports()->exists();

t0berius's avatar
t0berius's avatar STEREOHEloquent
1

Question mark in raw sql query cause problem

Hi. I have a problem in my raw query select. Example query: DB::select( DB::raw( "SELECT * FROM event e WHERE e.repeat_every->'daysInWeekRepeat' ? :dayNow" ), ['dayNow' => 'mon' ] ); (Original query is much more complicate this is only example.) Column "repeat_every" is a jsonb column, and I have to use question mark to search param value in array.

klik's avatar
klik's avatar rodrigo.pe...Laravel
6

is url path in model make a query ?

Hello, in Post model i use this method to get the path of current post Post Model : public function path () { return url ( 'posts/'.{$this->id} ); } when i make loop throw posts like foreach ( $posts as $post) { $post->path } is $post->path here will make another query to the database or will take the id from current $post of loop of course i'dont want to make anoth

TarikAli's avatar
TarikAli's avatar TarikSalahLaravel
8

Error for Valid MySQL Query!

Hello everyone, I'm working on a project that needs to work with MySql spatial features in Laravel, I currently have a model that has a location field (POINT type in mysql) which represents its location on map (earth). In a part of app, I want to select all models that are inside a Polygon, so I'm trying this code: Laravel Code (a part of code - some WHEREs and a ORDER_BY are a

mehranabi's avatar
mehranabi's avatar rodrigo.pe...Laravel
6

Relationship query Issue

I did this query : http://127.0.0.1:8000/api/auth/products?filter[category]=1 Result: It returns the product with no category as well and the first one with category not matching to queried one. { "data": [ { "id": "51", "name": "test", "cats": [ ], &

ntn0de's avatar
ntn0de's avatar ntn0deEloquent
8

Some Assistance with the query PLEASE!!

$products = QueryBuilder::for(Product::class) ->allowedFilters(['name', 'user_id', AllowedFilter::scope('category')]) ->allowedSorts('id') ->latest() ->whereRaw('(quantity - total_sold) > 0') ->get(); return ProductCollection::collection($products); From the above query i would like to query

ntn0de's avatar
ntn0de's avatar Tray2Code Review
3

Write query builder with group_concat

I have following MySQL query SELECT employee_id, GROUP_CONCAT(`value` SEPARATOR '') AS 'phone' FROM employee_contacts where channel='phone_dial' or channel='phone_number' GROUP BY employee_id and I need to run this inside this code block, but getting syntax error. $this->builder ->where(function ($query) use ($value) { collect($value)->each(function ($value, $inde

SneJ's avatar
SneJ's avatar rodrigo.pe...Code Review
9

Need Help Converting Complex MySQL Query

I tend to write my complex queries in raw SQL and then try to fit them into Laravel. I'm not succeeding getting the two arguments, $parent and $node into the DB::select. The query works perfectly well inside an SQL console. In a previous post from me I was advised to simply wrap my raw query in DB::select(). additionally I found further advice on Laracasts on how to lock tab

vincej's avatar
vincej's avatar Tray2Laravel
16

GET URL Query Parameters

Hi, can someone confirm the difference between the two following Query methods for a GET URL: domainexample.com/route/name1/var1 2.domainexample.com/route/?name=name1&variable=var1 If I understood well, both are GET requests both I'm not sure when I should use one or the other. As for (1): I usually set the GET route as follows: route/{name}/{variable}. For (2) I should s

lukegalea16's avatar
lukegalea16's avatar lukegalea1...Laravel
5

Trying to do a SQLSRV Query using cte_sum in Eloquent

I have a Laravel 6 app that uses a MySQL connection for authentication and storing user settings, but it also uses a SQL Server connection to read data for dashboarding. I have a pretty intense SQL query that uses cte_sum that I would really like to convert to Eloquent. I can run the query in RAW just fine from a controller, but I really don't want to do that for a lot of reaso

tduffy's avatar
tduffy's avatar tduffyEloquent
6

Laravel DB::raw query using multiple WHERE clauses

So I have a query that I would want to add some extra conditions to. Query: $providers = BusinessDetail::select( 'business_details.name as description', DB::raw('SUM(review_details.param_value) / COUNT(review_headers.id) AS avgUserReview') ) ->leftJoin('review_headers', 'business_details.id', '=', 'review_headers.business_detail_id') ->lef

bobmyles's avatar
bobmyles's avatar bobmylesEloquent
2

How can I query using Accessor that I defined in Model

Model.php public function getStatusAttribute() { if($this->profit == 0 && $this->loss == 0){ return 'Not Traded'; }elseif($this->loss > $this->profit ) { return 'Loss'; }elseif($this->profit == $this->loss){ return 'Neutral'; }else{ return 'Profit'; } } Controller.ph

FareedR's avatar
FareedR's avatar FareedRLaravel
10

Need help for a query to be solved.

Hi, i am trying to figure out the right query to achieve a Total Targets, Total Sales summary table. #Relitionships - A `store` has many `sales` - A `store` has many `targets` - A `target` belongs to a `store` - A `sale` belongs to a `store` #stores table | id | name | |----|---------| | 1 | Store A | | 2 | Store B | #targets table | id | store_id | apply_date | amount

muzafferdede's avatar
muzafferdede's avatar jlrdwLaravel
1

Easy to fix Pivot Eloquent query

Hi, Newbie at laravel so have a pretty basic question I'm looking for a pointer on if possible. I have a simple manytomany DB setup. Users Docs DoctoUserLinks (this is the table linking the two up). So one user can be linked to many documents One document can be linked to many users Critically, a document can also NOT be linked to any user, in which case it's a 'community doc'

mtm81's avatar
mtm81's avatar mtm81Eloquent
2

SQL query to Eloquent

hi mates, I was trying to convert from SQL query to Laravel eloquent. can anyone help me how to write this SQL query into eloquent? any help that would be great. thanks in advance. SELECT * FROM "messages" LEFT JOIN "message_phone" ON "messages"."id" = "message_phone"."message_id" LEFT JOIN "phones

deepu07's avatar
deepu07's avatar willvincen...Laravel
2

How to resolve Page not found. No query results for model []

I have this controller: public function goal_review() { $userCompany = Auth::user()->company_id; $userEmployee = Auth::user()->employee_id; $identities = DB::table('appraisal_identity')->select('id')->where('company_id', $userCompany)->where('is_current', 1)->first(); $goals = AppraisalGoal::where('employee_id', $userEmployee)->where('

noblemfd's avatar
noblemfd's avatar SinnbeckLaravel
3

SELECT Query for fetching data

I have two tables; users - id invoices - user_id, invoice_date(current_date), invoice_number and I have also set up a cron job that calls the query every hour. I have to write a query/stored procedure that fetches only the data from the users table that doesn't exist in the invoices table on that day. Eg: If user_id 1 exists on invoices table on 2/19/2020 then, then user_id

BikashKatwal's avatar
BikashKatwal's avatar willvincen...Laravel
10

Displaying data from the database - complex query

Hello guys, I have 3 tables in relationship: Categories 1:N Products N:N Attributes how can I display something like this: Show attributes where category id = ? I have in my view sidebar: @foreach($categories as $category) <div class="sidebar-box-2"> <h2 class="heading mb-4"><a href="#">{{ $category->title }}</a>

ziben69's avatar
ziben69's avatar SinnbeckEloquent
5

Query nested 2 layers deep collections in laravel

I have the following nested collection: Collection {#1195 #items: array:2 [ "ip_address" => "192.168.1.89" "supplier" => "HitchHiker" "flights" => array:2 [ 0 => Collection {#1196 #items: array:1 [ "id" => "3559ee11-fc99-4b43-a86f-67f0e3257f4c" ]

ncltours's avatar
ncltours's avatar SinnbeckLaravel
15

Use variable inside query with

Hello, I have the next code on my controller: public function week($league) { $user = auth()->user(); $puntos = 0; $positions = array('top_id', 'jungle_id', 'mid_id', 'adc_id', 'sup_id'); $league_id = League::where('LINK', $league)->firstOrFail(['id']); $weeks = Weeks::where('active', 1)->first(); if (request('we

haritz's avatar
haritz's avatar SinnbeckLaravel
1

Check if the route have any query string?

I want to check if the current route have any query string on it no matter the key or value, Which method should i use in $request instance?

untymage's avatar
untymage's avatar thinkverseLaravel
10

Eloquent vs. custom query

Hi. Recently I joined a company. the project that my team is maintaining and developing is made by Lumen. but they haven't used Eloquent. they query the database using Laravel query builder. As I see it, the queries are awful. but when I talked to them and asked them why they have avoided Eloquent, they said that Eloquent queries are not efficient. they said Eloquent is slow an

kiasaty's avatar
kiasaty's avatar martinbeanEloquent
15

Laravel 6.14 Convert a raw sql query to laravel query builder

SELECT * FROM events LEFT JOIN user_events ON events.id = user_events.event_id AND user_events.user_id = 1; Please help me to convert this query to Laravel query builder

royvarghese's avatar
royvarghese's avatar krishantal...Laravel
3

Loop through query items before paginating

Hey guys i have an array like this 'A52D4F3A-1236-4E35-A452-B948E5A33521' : "Effective" '77DC1BE4-9B38-4926-B5B9-B0850A592B8B' : "Effective" 'CEA780EB-E293-4649-8419-759F0BBC66D0' : "Effective" '56CA0131-2169-4CE8-AF37-1C6E0560BE35' : "Effective" '516F7FDB-6272-4A00-9846-96B1E8943C46' : "Effective" '3476636B-E8D3-4FFA-B628-DBF16

FallOutBoi's avatar
FallOutBoi's avatar kevinbuiEloquent
3

Query builder not working

Hello! I have a difficult time building the query for the table. There is what I need to do: dd(Bookings::where('status', '!=', 'in-progress')->where('game_id', 2)->where('method', 'online')->count()); I need to split that query for a few pieces. $totalBookings = Bookings::query()->where('status', '!=', 'in-progress'); ... $totalBookings = $totalBookings->where(

ya-ya-it's avatar
ya-ya-it's avatar ya-ya-itEloquent
8

Laravel Eloquent query through array

If I have a column in a table that stores data as an array, how could I query that column to return all the rows that have an element in the array that matches a variable?

hcphoon01's avatar
hcphoon01's avatar Sti3basEloquent
2