Add parameters to current URL's query string

I have a table used on several pages on my application. I would like users to be able to select a column to sort. Is there a better way to link to the same page with additional query parameters than this? <a href="{{ url(URL::full() . '&sortBy=YourMama&sort=asc' }}"></a>

grozavule's avatar
grozavule's avatar grozavuleLaravel
2

I don't use any query but the memory Usage is 17MG in Laravel 7

Hello Guys. I have new laravel 7 Project and I just add the css and js files to the style. But i don't have any DB Query Like this public function index() { return view('welcome'); } I install Laravel debugger and i show on the Memory Usage is 17MG. What the problem how can i find the it?

hasanhatem's avatar
hasanhatem's avatar sr57Laravel
1

Query ManyToMany relations

Have a good day... Cars and Owners are connected with Pivot table relation belongsToMany How to filter Cars by Owners age where age is 25? table cars = id, message..., timestamp; table owners = id, name, role ... timestamp; table car_owner = id, car_id, owner_id; I need to show All Cars that Owners with the age 25 used I had another filters also , this is code below tab

joha's avatar
joha's avatar NakovLaravel
1

Mysql query does not work

Hey there. Is there any problem with my query that does not work? "mysql -u root -p test < 'C:\Users\Amir\Desktop\package\storage\app\sql-tmp\db-dumps\mysql-test.sql'"

iamamirsalehi's avatar
iamamirsalehi's avatar SinnbeckLaravel
15

How to get records of two dates in a single query?

I have a has_many relationship with product_meta. Now I want to get product meta of all products but where product meta created on two dates like have 5/12/2020 and 09/12/2020. I don't want to get product meta between these two dates but I want to get product meta of only these two dates. $data = Product::with(['productMeta' => function ($query) use ($date_1, $date_2) { $

kfazil's avatar
kfazil's avatar kfazilEloquent
5

Relationship Returns Null But Query Shows No Errors

So I am running this eloquent query: $userInfo = $this->user->where('username', $username)->with('admin')->first(); When I do a dd() on $userInfo, it shows that the relations show null. I did a dd(DB::getQueryLog()); Added screenshots below. https://potentdevelopment.com/pictures/sql-dump.png https://potentdevelopment.com/pictures/result-dump.png And it shows tha

potentdevelopment's avatar
potentdevelopment's avatar potentdeve...Laravel
5

Query Builder: How to return 2 results from one query

I'm relatively new to Laravel and this is probably a basic question I have a following query using Query Builder and would like to send two query responses. If I can, I don't want to create another query. First one with -distinct('firstTable.firstTable_seq'), and the other one without. How can I accomplish this. Thank you in advance. $search = DB::table('firstTable') s

johnw65's avatar
johnw65's avatar Tray2Laravel
6

How to edit ajax request query

Hi, I got the required information with eloquent but I don't know how to display it in datatable. My controller: public function index(Request $request) { abort_if(Gate::denies('analysis_report_access'), Response::HTTP_FORBIDDEN, '403 Forbidden'); $user = Auth::user(); foreach ($user->roles as $role){ if ($role->title == 'Costumer'){ $anal

lilo's avatar
lilo's avatar liloEloquent
0

Make data from query available for live search

Hello Guys, I have a question here. I have the following code <!--Application--> <select class="form-control" id="application_id" name="application_id" required> <option value="">--- Please choose an application ---</option> @foreach($applications as $application) @if($application->deleted ==

dk4210's avatar
dk4210's avatar bugsyshaVue
1

SQL exists query does not return relevant result

I have a Laravel application with this Eloquent query: $products = Product::where('name', 'LIKE', "%{$value}%") ->whereHas('categories', function($q) { $q->where( 'slug', 'tonery-cartridge' ); })->with('manufacturer') ->with('sm_image') ->orderBy('created_at','DESC') ->take(10) ->get(); This code generates the sql

Čamo's avatar
Čamo's avatar ČamoGeneral
18

Eloquent Query Nested relationships

I am writing a query to get the correct product_id where $stock->orderProduct->product->generic_name is equal to $item. My relationships are: class Stock extends Miioj { public function orderProduct() { return $this->belongsTo(OrderProduct::class, 'order_product_id', 'id'); } class OrderProduct extends Miioj { public function product() {

shiro_'s avatar
shiro_'s avatar shiro_Eloquent
5

Reorder clauses of existing Query Builder instance

Hi I would need to reorder the clauses of a query builder instance. In my situation I have to extend an existing query that is coming from some code that is not mine and I cannot change. I have the problem that I want to do some filtering and with my whereNotExists() call this doesn't work because it gets appended to the end of the query and there are some OR WHERE clauses befo

iPurpl3x's avatar
iPurpl3x's avatar iPurpl3xLaravel
1

put an if condition around where clause in laravel query

Hi, Laravel query, we have a where clause. ->where('addresses.city_id',$city_id) I want to apply this where clause if the city_id > 0. If the city_id =0, then I would not like to pass this where clause to the query. Can I do something like $query = DB::table('users')->select('first_name') If($city_id > 0) { ->where('addresses.city_id',$city_id) } ->get(); If n

arifshah180's avatar
arifshah180's avatar NakovLaravel
1

Laravel Accessors on Query Builder

I am currently working on a Laravel API project and I am retrieving a lot of records. I used eloquent, however it is slow when retrieving at least 500 records. I have seen on other posts that it would be better to use query builder but I have Laravel accessors to retrieve some data which can only be called upon retrieving records with eloquent. Is it possible to use it on a que

syntaxerron's avatar
syntaxerron's avatar erronLaravel
4

3 table Eloquent Query Build up

User Model public function courses() { return $this->belongsToMany(Course::class); } public function meetings() { return $this->belongsToMany(Meeting::class)->withPivot('unique_join_url'); } Meeting Model public function users() { return $this->belongsToMany(User::class)->withPivot('unique_join_url'); }

DDSameera's avatar
DDSameera's avatar DDSameeraEloquent
3

Laravel query has wrong output

Laravel provide me the wrong output for date field query. I have a uploaded_at column in database having type as timestamp. This is my query- $from = date("d-m-Y", strtotime("-2 months")); $data = Post::where('uploaded_at' , '>' $from)->paginate(20); This piece of code is giving all the data from the post table where I needed only the last 2 months p

ipibk's avatar
ipibk's avatar MichalOrav...Laravel
4

What is the Eloquent equivalent of this Query Builder query?

I'm trying to switch from Query Builder to Eloquent models. How can I make my model, VisualLogin, return the last activity per user id and machine id? Here is my Query Builder equivalent: $visualLogins = DB::connection('vmfg') ->table('LOGINS') ->select('USER_ID', 'MACHINE_ID', DB::raw('MAX(LAST_ACTIVITY) as LAST_ACTIVITY')) ->groupB

grozavule's avatar
grozavule's avatar MichalOrav...Eloquent
4

Laravel eloquent belongs to many query returns entries multiple time

I have a products, users and products_marks table. Users can "mark" products. When they mark one product the database stores the user_id and the product_id in the products_marks table. Marks basically mean a user wants to watch this product and has a watchlist. Of course I want to show the user all products he has marked. This means I have to get all products where th

FrazeColder's avatar
FrazeColder's avatar rodrigo.pe...General
5

Error when query on User model

I'm getting this error when i do a query on the User model, the column notification emails is cast to array, so i don't really know what that means, any idea? Call to undefined cast [Array] on column [notification_emails] in model [App\Models\User].

socieboy's avatar
socieboy's avatar rodrigo.pe...Eloquent
11

timed query that takes place every morning at 08

Hello I have this table: Polls(id,name,...ecc); I would like to run a query every morning at 08 that does some operations on it. Like deleting some content. give example: $trash= App\Models\Poll::where('name','=','running')->delete(); possible to create a cron tab on laravel? if yes how should i implement it given such a query?

Antonella's avatar
Antonella's avatar tykusLaravel
3

WhereIn not working in working in Query Builder

I have this Eloquent Query Builder in Laravel: $userCompany = Auth::user()->company_id; $userEmployee = Auth::user()->employee_id; $employeeCode = Auth::user()->employee_code; $employeeemptypeid = HrEmployee::where('employee_code', $employeeCode)->where('company_id', $userCompany)-&g

noblemfd's avatar
noblemfd's avatar noblemfdLaravel
2

How to query array inside JSON column

I have successfully done some queries using JSON, but I can't figure out how to query a value from an object inside an array like this: In column "attributes", there is : { "products": [ { "media": "1", "code": "4186GSB", }, { "media": "2&

gilbertoalbino's avatar
gilbertoalbino's avatar gilbertoal...Eloquent
1

How to add a additional condition in left join using query builder

I have this Eloquent Query Builder in Laravel: $userCompany = Auth::user()->company_id; $userEmployee = Auth::user()->employee_id; $employeeCode = Auth::user()->employee_code; $employeeemptypeid = HrEmployee::where('employee_code', $employeeCode)->where('company_id', $userCompany)-&g

noblemfd's avatar
noblemfd's avatar vincent150...Laravel
1

Creating table/columns combinations using SQL Query or Laravel SQL Query Builder

I have an existing scheme for products variations. I want to create a combination of each production time, quantities and variation options. I will create a selection form by accessing the quantities, production times, variation and variation options from the product. table_groups +------------+ | id | title | +----+-------+ | 1 | rug | +----+-------+ table_days +----+-----

mertasan's avatar
mertasan's avatar rodrigo.pe...Laravel
3

Aggregating Query

Hi, I have a mysql subscribers table and I wanted to pull aggregate hourly data. Can anyone help with Query Builder or Eloquent. Example: Hour 1 : 10 Subscribers Hour 2 : 10 (previous) + 5 (new) = 15 subscribers Hour 3 : 15 (previous) + 10 (new) =. 25 subscribers Output could be: [08:00:00 => 10, 09:00:00 => 15, 10:00:00 => 25

geetpurwar's avatar
geetpurwar's avatar automicaLaravel
1

Laravel duplicating path as a query string

Hi, I am facing a weird problem and not sure why or how to fix it. When visiting a url, something is duplicating the path as a query string. For example if I am visiting "xxxx.com/admin" the url that's reported by Laravel by calling $request->fullUrl is "xxxx.com/admin?admin=". I am not sure what exactly is causing that, but I printing out the full url in

aem99's avatar
aem99's avatar jlrdwServers
1

How translate this SQL query to Eloquent?

Hi guys, I am trying to understand Eloquent to use it as easily as SQL native, but I find it confusing. This query with SQL RAW works, but how would it be in Eloquent version? It returns a logged user's rating (if any) and the average of other users' ratings. SELECT books.*, GROUP_CONCAT(DISTINCT(bu_logged.rating) SEPARATOR ", ") AS logged_rating, ROUND(AVG(bu_all

narachamus's avatar
narachamus's avatar KumaravelEloquent
4

Nova: using query builder instead Eloquent

I have an app which has huge queries and multiple relationships. Over 10-15 milions of records. Thinking at improving performance on resources, I want to migrate from classic eloquent models to query builder for all the resources. How can I do that without affecting the nova flow? Thank you.

Solvando's avatar
Solvando's avatar SolvandoLaravel
0

How to query by row's column value?

I've got a few tables constructed in this manner:completed: group|type|user_id and for every type I have a table user_id|group. I need to count how many of the second type table entries are correspoding with first table rows. So, I am doing this: $query->withCount(['completed' => function ($query) use ($user) { $query->where('user_id', $user->id); }]); Howev

Zyberg's avatar
Zyberg's avatar laracoftEloquent
9

Make a query where a relationship matches all elements of an array

How to make a query that will only return the Foo elements containing all the given colors (from $colors_array) in its relationship colors, and not the results containing one of the listed colors like below ? $colors_array = ['red', 'green', 'blue']; Foo::with('colors') ->whereHas( 'colors', function ($query) use ($colors_array) { if ($filters) {

devondahon's avatar
devondahon's avatar devondahonEloquent
2

Querying from table using Query Builder

Ok here's the thing both are working just want to know which is more ideal on Query Buillder Doing a subquery or Joining the table? DB::raw('(SELECT Name FROM client_types WHERE client_types.id = taxonomy.Type ) AS Type'), DB::raw('(CASE WHEN taxonomy.isVerified = "0" THEN "UNVERIFIED"

whodoes's avatar
whodoes's avatar gitwithrav...Laravel
1

convert mysql query into eloquent

I have a MySQL query which is working fine, but I want to convert it into an Eloquent query, is this possible? This query will get the sum the earnings of a user from different tables. Query: SELECT c.id, c.username, c.first_name, c.last_name, ( a.amount + b.amount + d.amount + e.amount + f.amount ) AS total FROM tbl_users c LEFT JOIN

NoLAstNamE's avatar
NoLAstNamE's avatar rodrigo.pe...Eloquent
10

How to carbon query output as dd-mm-yy

I have this Laravel Query: $nationalholidays = HrHolidayDate::select('holiday_date')->where('company_id', $userCompany)->whereYear('created_at', '=', date('Y'))->get(); How do I carbon the output, that is, holiday_date as dd-mm-yy

noblemfd's avatar
noblemfd's avatar MichalOrav...Laravel
5

if condition inside the query,

Hi, I have below query to get total no of questions, Tables structre, tests => 'test_id','test_name','test_type'; user_tests =>user_test_id,marks_scored,time_taken,user_id questions => question_id, question_text, a,b,c,d,correct_option,question_level,language user_answer => user_answer_id,user_test_id,question_id,user_answer, So here i am fetching total number of e

Deekshith's avatar
Deekshith's avatar RamlashkarLaravel
1

laravel vuejs form submit returns to the same page with query string

i am trying to submit a form with laravel and vuejs in a component like below : <form action="#" @submit.prevent="submitMobile"> <div class="container my-5 z-depth-1"> <!-- Form --> <form class="" action=""> <!-- Sectio

farshadf's avatar
farshadf's avatar farshadfLaravel
4

Converting MySQL query to Eloquent

I have a MySQL query which is working fine, but I want to convert it into an Eloquent query, is this possible? This query will get the sum of quantity by product from all orders and show it's current stock. Query: SELECT p.name, SUM(op.quantity) AS quantity, p.stock FROM `orders` o JOIN order_items op ON op.order_id = o.id LEFT JOIN products p ON p.id = op.item_

NoLAstNamE's avatar
NoLAstNamE's avatar whoami1509Eloquent
2

SQL Query in Laravel QueryBuilder

Hey Guy's, i have a problem with an SQL Statment in php. How can I rewrite this SQL query in Laravel Query Builder? This is my Query before i use Laravel: $sql = "SELECT khk.*, pft.*, tank.* from KHKAdressen khk, PFTankgasBestellungen pft, ECCTanks tank WHERE pft.Adresse = khk.Adresse and pft.Tank = tank.Tank AND pft.Mandant = khk.Mandant and pft.Status = '$statu

Nosean's avatar
Nosean's avatar rodrigo.pe...Laravel
5

Query Builder for my shop filters

Hi everyone, I need some guidance on how to setup my queries for my shop filters. Tables: products product_categories How would i return all products with a category id from ajax request. Lets say the id from the request is 17 how would i query the db to return all products with a product_category of 17? thank you in advance.

madsynn's avatar
madsynn's avatar MichalOrav...Laravel
3

SQLSTATE[IMSSP]: The active result for the query contains no fields.

I have this code on my controller that updates the table. The controller runs but the issue is that its giving me error. $query = "UPDATE dispatch SET deptId = '$department', type= '$type', destination = '$dest', purpose = '$purpose', passengers = '$pa

jamols09's avatar
jamols09's avatar rodrigo.pe...General
2

How to get a query instance of two differents tables (not a Collection), join two different tables?

I have two completely different tables and want to get all the records of these two tables and merge the records, is it possible to do that? I could do that with Collections but i would like to paginate this records, and only with a Query instance is possible to paginate (yes, i know, i can paginate a collection with a custom code, but i'm just checking the options here before

JoaoHamerski's avatar
JoaoHamerski's avatar JoaoHamers...Laravel
10

Query too slow when operating with 1 million data on table

How to optimize the query? any idea? How to speed up this query ?? $members = DB::table('users') ->where('users.type', 'member') ->join('user_profiles', 'users.id', '=', 'user_profiles.user_id') ->where('user_profiles.profile_status', 'approved') ->select('users.name', 'users.email', 'users.location', 'users.type', 'users.ip', 'users.last_login', 'users.created_at',

jinsonjose's avatar
jinsonjose's avatar jinsonjoseLaravel
11

Query works on local environment but fails on shared hosting???

Not sure what's the issue whit this query? It works just fine in local environment (with mysql v8.0.21) but doesn't work on shared hosting with (mysql 5.6). @snapey Any suggestions???? $query = DB::table('campaigns') ->join('categories', 'campaigns.category_id', '=', 'categories.id') ->leftJoin('donations', 'campaigns.id', '=', 'donations.campaign_id') ->s

SunnyBoy's avatar
SunnyBoy's avatar arpitvishw...Eloquent
11

Use data from method with() in models for using self-written sql query Laravel

I'm using Laravel 6.16. I wanna use data what I receive from Order and OrderDetail models in self-written SQL query in "prod" function, data like product_id from order_detail table. Have request like this $orders = Order::where('store_id', $store_id) ->where('company_id', $company_id) ->with('order_details.prod') ->

hik200's avatar
hik200's avatar aleahyEloquent
3

Add extra parameter or query string to socialite google signin

I am using laravel socialite public function redirectToGoogle() { return Socialite::driver('google')->with(['redirect' => $redirect])->redirect(); } i tried to $request->all() for above response but not getting redirect value. I want to add query string like redirectto?=http://localhost/project/checkout so when user logs in with facebook b

Deekshith's avatar
Deekshith's avatar DeekshithGeneral
4

Query through tables

Hey so I have models like so: Show -> hasOne -> Show Details -> belongToMany -> Actors (I have a table actor_show_details for the belongsToMany) So far so good. Now I'm trying to find the Shows of an Actor as a query (need it to be paginated!) but I can't find how to do it with Eloquent. I can retrieve all the shows as a collection: $actor = Actor::find($actorId);

Romain's avatar
Romain's avatar RomainLaravel
11

How to use updateOrCreate for a specific Query

I have this Query: $goaltypes = GoalType::where('company_id', $userCompany)->whereNotNull('parent_id')->get(); $ids = $goaltypes->pluck('id'); $goaltypedetails = Goal::whereIn('goal_type_id', $ids)->where('employee_id', $userEmployee)->whereNull('deleted_at')->get(); foreach($goaltypes as $goalt

noblemfd's avatar
noblemfd's avatar noblemfdLaravel
8

How do I query through Many-to-Many?

In my Contact.php I have the relationship defined as: ... public function roles() { return $this->belongsToMany('App\Models\contact\ContactRole'); } ... in my controller, I have this query: ... $data = Contact::select("id", "company_id", "first_name", "last_name") ->where('first_name'

fbc's avatar
fbc's avatar fbcLaravel
5

Advanced Query Help

I have a query with multiple joins. The logged in User belongs to a facility. There is a pivot table for a many to many facility to tech relationship. Where a tech can belong to many different facilities and A facility can have many different techs. A tech can have multiple files attached to them. $user_id = Auth::id(); $data = DB::table('facilities')->where('user_id', '

laracasts9924's avatar
laracasts9924's avatar rodrigo.pe...Eloquent
7

How to get each column of my DB :: Select query

Hello everyone, I need to get each data from each column of my query from the database. In this query I will obtain more than one row and then I will have to generate all the information obtained in a string to deliver to another function It's my code $querycon="SELECT c.nombre AS acuerdo_nombre, c.fecha_inicio, c.fecha_fin, ce.numero_mantenciones AS mantenci

nicovillas's avatar
nicovillas's avatar rodrigo.pe...Laravel
9

SQL Query TO Laravel Query Builder Format

Can any body help me to convert this raw sql query to laravel query builder syntax `` SELECT YEAR(matches.init_ts) AS YEAR , MONTH(matches.init_ts) AS MONTH, WEEK(matches.init_ts) AS WEEK , DAY(matches.init_ts) AS DAY , AVG(stat_value) AS avg_stat , player_id AS Id, 'player' AS NAME FROM matches_stats JOIN matches ON matches.id = matches_stats.match_id WHERE player_id = 1

sarmadindhar's avatar
sarmadindhar's avatar rodrigo.pe...Laravel
2