Where to change query

Hi! Have installed a laravel + vue project Using datatable to show records for users But cant figer out where to change query. Now its show ALL records. But like to filter the records Please help

birdietorerik's avatar
birdietorerik's avatar birdietore...Laravel
2

How to get this query using the Laravel query builder?

Hi everyone, I'm new to joins and I created this query: select threads.*, count(replies.id) replies_count from threads where replies_count = 0 left join replies on replies.thread_id = threads.id group by threads.id How do I get this query into a Laravel Query Builder object? This is what I was trying (but I got stuck): $builder ->selectRaw('threads.*, count(replies

jeroenvanrensen's avatar
jeroenvanrensen's avatar jeroenvanr...Eloquent
2

Why does select in query not speed things up?

When I use $project = Project::select(['id', 'subdomain']) ->where([ 'subdomain' => $subdomain, 'published' => true ]) ->first(); instead of $project = Project::where('subdomain', $subdomain)->where('published', true)->first(); (causing select *... ) and I check things in debug bar the query executio

rhand's avatar
rhand's avatar rhandEloquent
11

DB raw query issue - cannot get count

Hi, I have this query: $users = DB::table('users') ->leftjoin('games', 'games.id', '=', 'games.user_id') ->select( DB::raw("count(games.*) AS active_games WHERE status='active'"), DB::raw("count(games.*) AS pending_games WHERE status='pending'"), ) ->orderBy($se

User1980's avatar
User1980's avatar Olcso Ulog...Eloquent
15

Conditional search query

Hi Devs, I have a live wire class that is supposed to get all the books at first render and then conditional query depending on user input for example if a user clicks on a certain category it returns a book that related to the category. So my question is how can I render my component with books without queries and when needed I serve the user with requested data? public $typ

Wakanda's avatar
Wakanda's avatar WakandaLaravel
4

How to return Multiple values from a while loop from an SQL query.

I have an issue where I have a function like this which outputs: while ($row = mysqli_fetch_array($sql_result)) { $division_name = stripcslashes($row['name']); return $division_name; } This works to fetch a single value, but it doesn't when I need multiple values from the query. (in that case it only returns the first match row). If I substitu

Daniel1836's avatar
Daniel1836's avatar frankieleeGeneral
7

Query foreign key

Hi i have two tables charges and customers(foreign) is it possible to make additional select to for table customers to get name ? as you can see inserted the join(commented) but cant find the way to make second select on the same query, i get error. the query $charges = charge::query() ->search($this->search) ->select(\DB::raw('charges.*,SUM(task

Chris1989's avatar
Chris1989's avatar Chris1989Eloquent
4

Maximum execution time of 60 seconds exceeded for simple query

Hi I have written a simple query for checking email id already exist or not. In local it is working fine. when I uploaded in plesk server I am getting this error . Is anything wrong in my code? Maximum execution time of 60 seconds exceeded controller public function update(Request $request, $id) { $checkEmailExist = User::where('email',$request->email)->whe

shariff's avatar
shariff's avatar siangboonLaravel
7

Issue with ajax post when changing the query string

Hi, I am facing one issue like in my application i am using query string pattern like for instance user section where i am doing edit user URL is domain.com/edituser?uid=21 Route::get('edituser','UserController@getuser')->middleware('validuser'); Route::post('processuseredits','UserController@doUpdate')->middleware('ajax','validuser'); This works perfect with ajax also. B

wontonesaju's avatar
wontonesaju's avatar laracoftLaravel
10

Some of the ways to optimize eloquent query on Laravel

Hello everyone, is there a way to run a single query instead of three like this in the same model? $type = Tag::with('attributs') ->where([['slug', '=', 'type']]) ->get()->pluck('attributs'); $relationship = Tag::with('attributs') ->where([['slug', '=', 'relationship']]) ->get()->pluck('attribut

Manouher's avatar
Manouher's avatar MichalOrav...Laravel
3

Laravel: Order query using relationship

Hello guys. Please, I need help with the following issue. I have two tables, user and contents. users has many contents and content belongs to user. I want to query: All users with their contents ordered by the users with the most recent content users with their contents that were uploaded within the last 24hrs Any suggestion with working code samples will be appreciated.

fcode's avatar
fcode's avatar fcodeLaravel
3

Laravel Query problem.

Entries::orderBy('id','desc)->where('user_id',Auth::id())->paginate(4); some times this query send what sign after user_id. below select * from pass_entries where user_id = ? order by id desc limit 4 offset 0 why it is add what sign after 'user_id'= ? & and when? Please help —Thanks

Jarjis's avatar
Jarjis's avatar Tray2Laravel
9

Query still running even after page timeout

I needed to update all of my users with some settings in a new table. I wrote this: $users = User::all(); foreach($users as $u) { $settings = Settings::query()->where('user_id', $u->id)->doesntExist(); if ($settings) { $s = new Settings(); $s->user_id = $u->id; $s->show_alltime_

Mick79's avatar
Mick79's avatar Mick79General
6

Converting a SQL query to Eloquent

hi guys, I have an SQL query that works just fine but it has a problem, here is the query: $products = DB::connection('mysql2') ->select(DB::raw(" select p.ID as id, p.post_title as title, p.post_name as url, max(case when m.meta_key = 'preview' then m.meta_value end) as preview, max(case when m.meta_key = '_thumbnail_id' then m.meta_value end) as

mozex's avatar
mozex's avatar mozexEloquent
2

Laravel having() query not returning expected result

Hi, Having the following scope query: public function scopeAvailable($query) { $query->select('id', 'available_replies') ->withCount(['emails' => function (Builder $query) { $query->whereDate('created_at', Carbon::today()); }]) ->having('emails_count', '<', 'available_replies'); } I execu

bufferoverflow's avatar
bufferoverflow's avatar CorvSEloquent
1

Problem with memory size of a giant query over a Collection

Hi, I've a query executed as follows: $data = Application::select(['id','numinst','nomapp','idapp','fabricante','version','carpeta','comentarios']); $numTotal = $numRecords = $data->count(); And then I have to get all the results to peform the next operation: /* * Heres is some code that adds optinonally where clause to the query */ if(!empty($searchPhrase)) {

mp3man's avatar
mp3man's avatar mp3manEloquent
8

Query to display the intended results

So currently ive been working on a project and this is one of the problem that i had. I want to have this data in my application and want the data to be viewed as a progressbar in my view. I want the data to be like this | CaseName | Duration | VerdictPass | VerdictFail | Total | Config | | --------- | -------- | ------------ | ----------- | ----- | ------ | | Case1 | 3654

rafaeladi's avatar
rafaeladi's avatar rafaeladiEloquent
3

How to make a scope with a raw SQL query?

Hi guys, So I am trying to make a scope with this SQL query: SELECT * FROM ro_container_events WHERE (container_id, location_timestamp, id) IN ( SELECT distinct container_id, MAX(location_timestamp) AS lts, MAX(id) AS rce_id FROM ro_container_events GROUP BY container_id ) My scope looks like this: public function scopeLatestEventForContainers($query) { return $query->select

fleroux's avatar
fleroux's avatar jlrdwLaravel
1

Livewire Sortable Group Eloquent Query?

This is probably a huge newb question, but I can't seem to find any tutorials or examples for how to write out the livewire public function to make the group thing work. Any links to a guide would be much appreciated as well :) In this documentation https://github.com/livewire/sortable there is only an example of the blade view. I was able to find how to make the sortable work

Jakub003's avatar
Jakub003's avatar Jakub003Eloquent
5

How do I convert this query to Laravel eloquent ?

How do I convert this query to Laravel eloquent ? $search = $request->get('search'); User::where('lastName', 'like', '%'. $search.'%') ->join('stalls', 'users.id', '=', 'stalls.user_id') ->join('locations', 'locations.id', '=', 'stalls.location_id') ->join('activities', 'activities.id', '=', 'stalls.activity_id') ->select('use

estudiante_uap's avatar
estudiante_uap's avatar tykusEloquent
1

User is re-authed after failed Eloquent query

Spent some time tracking this down, and still quite confused. Short of it is, when a user logs in, a card on the dashboard makes an AJAX request to get a list of Purchase Orders. For troubleshooting this issue, I made it timeout after 30 seconds. It logs "Starting PO Query" when it starts, and in the try/catch it logs "Ending PO Query". IF the user logs out

CreamyT's avatar
CreamyT's avatar CreamyTLaravel
2

Laravel slow query for 30000 db rows

Hi I have 32000 occurrence of transactions in my db, this query takes too long about 10 sec or more, how can i optimize please $data = DB::table('transactions') ->when($merchantId, function($query) use($merchantId) { return $query->where('user_id', $merchantId); }) ->whereBetween('created_at', [ Carbon::now()->startOfYear(), Carbon::

Kkstar34's avatar
Kkstar34's avatar Tray2Laravel
6

Probleme querying roles with db query

Hi all, I have that must run the DB query and not eloquent as it is a complicated query. The problem is that in my query I also need to pull the user spattie role The user table -id The "model_has_role" table -role_id -model_type -model_id roles table: -id -name <----I need to get to this one from the DB query when querying the table user. -guard_name How

User1980's avatar
User1980's avatar User1980Laravel
2

Query with multiple join : what's wrong with my query ?

Hello, Here are my tables. trainings : id, name sources : id, name fundings : training_id, source_id, amount Here is an example of datas. Trainings - 1, training 1 Sources - 1, source 1 - 2, source 2 - 3, source 3 Fundings - 1, 1, 50 - 1, 3, 60 And here is my MySQL query. SELECT sources.name, fundings.amount FROM sources LEFT JOIN fundings ON fundings.source_id = sources.

vincent15000's avatar
vincent15000's avatar vincent150...Eloquent
11

Check if the relation is empty or not within the query?

I have this structure; products table; name - .... - brand_id(null) brands table: name - visible - .... The relation of brand in Product model in belongsTo My query: $products = Product::whereHas('brand', function ($query) { $query->where('visible',false); }) ->where('special',false) ->paginate($this

ahmeda's avatar
ahmeda's avatar SnapeyLaravel
1

laravel charts with query builder

Is there any documentation on https://shareit.onl/ how to use laravel charts with data from DB but the one with query builder not eloquent? I cant seem to find it anywhere and how the data being passed is kind of different so i need some help in this https://appvn.onl/

EdenZhiweis's avatar
EdenZhiweis's avatar fylzeroMix
1

Laravel Inertia and VueJS Query data

I want to query data from database using 3 dropdown values as filters and update props / data in the blade. My current code is: generateData: function (data){ this.$inertia.get(this.route('report.generate'),{ data:data, onSuccess:(res) => { // this.records=res.records.data; //alert(res.received.data); } }) } But it keep giving me white popup some sort of modal. Please Help.

ynoth25's avatar
ynoth25's avatar ynoth25Inertia
0

Needed Help for Query

This is my Seller Table.I need to find all sales from seller id 1 id | name | phone | 1 | Coder | 98653271039 | This is my Sales table id | action_date | seller_id | quantity | product_id | 1 | 2021-01-01 | 1 | 50 | 1 | 2 | 2021-01-01 | 1 | 100 | 2 | 3 | 2021-01-01 | 1 | 150 | 2 | 4 | 2021-01-03

coder72's avatar
coder72's avatar coder72Laravel
2

get null values at last in query orderBY

i have a query like below, public function getTest() { return StudentMap::orderBy('project_number') ->get(); } The model is, public function getProjectNumberAttribute($value) { if($value == "0") { return NULL; } else { return $value; } } The response is, [ { "student

Deekshith's avatar
Deekshith's avatar tykusLaravel
3

how to stop page redirected from query stirng?

Hello, after sign up i am redirecting page from my code to verifyotp route. in url it's showing "https://www.page.com/verifyotp " now verifyotp is my route name. is there is any way to stop it if some one trying it by typing in url query string i want to show it 404 forbidden . i do not know i make you understand my question or not? but i just want if user manually tr

ZahidGopang's avatar
ZahidGopang's avatar chaudigvLaravel
1

Trying to query geolocation using selectRaw with my ShippingAddress model

I'm trying to build a search so that a user can put in a zip code and we search a 20 mile radius in order to get locations close to them. I've followed this example online and modified it to fit my needs. I'm using this articles Eloquent model example https://www.techalyst.com/posts/laravel-find-nearest-restaurants-from-certain-gps-latitude-and-longitude My code looks like this

m615's avatar
m615's avatar m615Eloquent
1

Query with subqueries with group by - Help ;)

Hello, I'm trying to write a query with multiple subqueries with group by. Difficult to explai, so here is an example. The models tables. societies : id, name employees : id, name, society_id trainings : id, name sources : id, name, subsidie (bool), plan (bool) The pivot tables. training_employee : training_d, employee_id fundings : amount, training_id, source_id An example o

vincent15000's avatar
vincent15000's avatar aletiaitso...Eloquent
1

laravel charts with query builder

Is there any documentation on how to use laravel charts with data from DB but the one with query builder not eloquent? I cant seem to find it anywhere and how the data being passed is kind of different so i need some help in this

rafaeladi's avatar
rafaeladi's avatar fylzeroLaravel
6

Derive a Laravel search query from a provided test.

Hi, I am working on a project that has some tests implemented and i would want to derive a search query based on the provided test case Test public function test_index_returns_based_on_name_search() { Company::factory()->count(20)->create(); Company::factory()->create(['name' => 'Test Name']); $result = $this->getJson(route("c

Wakanda's avatar
Wakanda's avatar WakandaLaravel
5

Eloquent query on a belongsToMany relation

Hello! trying to run a query on the result of a belongsToMany relation.. This query runs fine and return all results of my 'services' return DB::table('services') ->select('id', 'Name', 'Address1', 'lat', 'lng', 'Postcode', DB::raw('3959 * acos( cos( radians(?) ) * cos( radians( lat ) ) * cos( radians( lng ) - radians(?) ) + sin( radians(?) ) * si

PoblTech's avatar
PoblTech's avatar tykusEloquent
1

Disable Sanctum's update query for last used at field

How to disable Sanctum's feature for updating the last_used_at field? This query is updated on every request and I am not even using it. It's just an extra load on the server's side.

NikaKvatadze's avatar
NikaKvatadze's avatar nanosoluti...Laravel
3

Save array of objects in one mysql query

Hi! How can I insert in mysql the following array of objects in one query using eloquent or query builder? [ { "name": "John", "surname": "Doe" }, { "name": "Jane", "surname": "Doe" }, { "name": "John", "surname": "Dean" } ] Thank you!

RimiCsani's avatar
RimiCsani's avatar MichalOrav...Eloquent
14

Laravel fill with custom query fields

Prior Laravel 6 when i filled a model using a raw query, fields created in this query were assigned using the fill function even though the model does not have these fields in the database. When i upgraded from Laravel 5.8 this is no longer working. Is there any workaround for this? Code example: $sql = "SELECT SUM(S.amount) AS total_amount, SI.* [...]" $data =

ethor's avatar
ethor's avatar ethorLaravel
4

Refactoring of Eloquent Query - Properly The Worst Query I've Ever Written

To start with, I have this application developed using Laravel (It's an SMS application that anyone can signup for and send messages anywhere in the world (120+ countries literally). Now for every country that I add from the admin section, I can manually assign a price for that country's network e.g. in the USA, we've various telcos like AT&T, Verizon, etc. now each of them

VimKanzo's avatar
VimKanzo's avatar VimKanzoGeneral
3

Accessors using Query Builder

Hey, I have been trying to use an accessor with query builder, but no luck so far. I have tables that have a column called user_id and others client_id that relate to this polymorphic table. With eloquent, since I have appends and accessors I have no problems but with query builder I get that the column does not not exist. This is how I am trying with query builder: $query->

bellini's avatar
bellini's avatar tykusEloquent
1

Convert SQL raw query to Laravel ORM or Query Builder

Hello, I have some raw queries I'm getting stuck while converting them into Laravel query builder or in ORM. If someone can please convert them thank you. $data = DB::select("select to_char(submit_date, 'YYYY-MM-DD') AS sent_at, status as stat, count(username) as t from logs where username=? and (submit_date between (

VimKanzo's avatar
VimKanzo's avatar bugsyshaEloquent
12

Date format changing between query and eloquent

I cant figure out how to get the timestamps formated the same running eloquent and with a query $query = DB::table('libros'); if ($request->user()->isTutor()) { $query->where('desactivado', false); } $libros = $query->get(); // "created_at":"2021-03-24 14:03:19","updated_at":"2021-03-24 14:03:19" $libros = Libro::all(

gcbenlloch's avatar
gcbenlloch's avatar gcbenllochLumen
5

Query builder => is it possible to mix with() and addSelect() methods ?

Hello, I am trying to do this in a Livewire component. $alertes = Alerte:: with('salarie') ->with('formation') ->join('formations', 'formations.id', '=', 'alertes.formation_id') ->addSelect(DB::raw('date_add(formations.date_fin, interval formations.duree_validite month) as date_recyclage')) ->where('formations.entreprise_id', $this->entreprise

vincent15000's avatar
vincent15000's avatar vincent150...Eloquent
5

Adding data to charts using query builder

So i want to make a chart using laravel charts and i want to use my own data from database. As far as i can tell there is no example on how to do it with query builder, only eloquent. So i want to pass this information, the labels is going to be get from 'test_suites' table and from 'name' column. the data is going to be retrieved from 'test_cases' table in which already connec

rafaeladi's avatar
rafaeladi's avatar rafaeladiLaravel
0

How does this query work? Is it efficient?

I am looking at filtering my database notifications with an attribute in my data column. We're talking about the default notifications table created by Laravel. I was (pleasantly) surprised to see that the following query actually works! : auth()->user()->unreadNotifications->where('data.tenant_id', 1); I'm wondering if this query is efficient if my data column is te

thebigk's avatar
thebigk's avatar thebigkLaravel
1

Help with a simple query

I need to translate the query below in the laravel DB:: query builder. Any ideas please? SELECT u1.name from users as u1, users as u2 where u1.id<>u2.id AND u1.lastname=u2.lastname; Please note that I can use Raw() however, I need to paginate and so on that need the query builder. My try: DB::table('users')->select('u1.name')->where('u1.lastname','!=','u2.lastname')

hameti's avatar
hameti's avatar hametiLaravel
5

Export Data into excel using raw query

Hi there, I am trying to explore "maatwebsite/excel" using raw query. I am having problem doing it and I am not sure whether I am doing it correctly or not. Or many maatwebsite does not support raw query statement to export to excel format. Here are my existing code. Thanks for the help in advance. <?php namespace App\Exports; use Maatwebsite\Excel\Concerns\From

mozziehin's avatar
mozziehin's avatar ZaliinaaLaravel
4

How to use orderBy on a with() property in a query ?

Hello, I have this code and I wonder if it is possible to do something to order my documents according to the ordre field of the join table without using join. $documents = Document:: with('doctype') ->where('formation_id', $this->formation_id) ->get(); And I would like to orderBy('doctypes.ordre') or orderByRaw('doctypes.ordre'). $documents = Document:: with('do

vincent15000's avatar
vincent15000's avatar piljac1Eloquent
4

Laravel query with subqueries and foreach

I wanna to show common users verified, not out of date and unbanned: a) all songs b) songs by title or text c ) songs by tag Two additions: The user, which is an admin, can see unverified, banned and out of date songs and the user, which is an artist, can see unverified or banned songs too, but only his own ones. It has been exhausting for several days, 'where in where, which i

halotukozak's avatar
halotukozak's avatar halotukoza...Laravel
0

Eloquent closures insert to query - "SELECT *" and "is null"

After update Laravel from 5.5 to 8.0 I noticed strange SQL errors: General error: 1096 No tables used. I found out that it was caused by the closers on the Eloquent model like this: $results = Product::where('products.id', '=', 10)->where(function($query) { }); generate SQL Query like this ($results->toSql()): select * from `products` where `products`.`id` = ? and (se

gpi's avatar
gpi's avatar gpiEloquent
8