Query db array field from form multi-checkbox array?

I can't wrap my mind around how this would be done or if its even the right way to go about it. I have a database field called power that can have multiple values in it. Ex: Solar,Battery,Line So what I need to do if query the database based off of which checkboxes a user submits. Form <form class="productcomparison"> <div> <p>Size/Width&

jpeterson579's avatar
jpeterson579's avatar CronixEloquent
3

Is there a cleaner way to loop conditions on a query?

I keep having to add little loops to my eloquent queries, it's not the end of the world, it just adds a few extra lines where I might be missing a potential callback function somewhere that might make things a bit cleaner: $query = Place::where($place->type_1 . '_id', $place->id) ->whereType_1($child_type) ->limit(1);

JackJones's avatar
JackJones's avatar JackJonesEloquent
2

Do not query if primary key field is empty

I'm using eager loading, and a lot of the time the primary key id is null Eloquent is still running the query for the null values: select * from `continents` where `continents`.`id` in ('1', '3') select * from `countries` where `countries`.`id` in ('') select * from `dependencies` where `dependencies`.`id` in ('') select * from `macro_regions` where `macro_regions`.`id` in ('')

JackJones's avatar
JackJones's avatar shez1983Eloquent
10

Search Query Showing Lat and Long, is that a problem?

Hi, I am trying to create a search bar for users to see events near the area they search. I am using the google places api to get the lat and long when the user enters the address. I attach the lat and long to hidden fields and submit the query. This does work in sending the lat and long, but I end up with a search bar looking like this http://showbelow.test/search?term=New+Yor

chrisgrim's avatar
chrisgrim's avatar chrisgrimLaravel
2

Add pivot table data to model query results?

I've set up a simple little laravel site with users, playlists, and videos. Users can create videos, they can create playlists, and they can add ANY videos (that they or someone else created) to their own playlists. I'm trying to figure out how to perform a single query to lookup ALL of the playlists that a user has created, and somehow add an additional column to the output l

rickkettner's avatar
rickkettner's avatar rickkettne...Eloquent
1

Mysql query raw to laravel eloquent

Hey people, i dont know how to write this query in eloquent? SELECT user_from_id, SUBSTRING_INDEX(GROUP_CONCAT(seen ORDER BY seen, created_at DESC SEPARATOR ','), ',', 1) AS seen, SUBSTRING_INDEX(GROUP_CONCAT(chat ORDER BY seen, created_at DESC SEPARATOR ','), ',', 1) AS chat, SUBSTRING_INDEX(GROUP_CONCAT(created_at ORDER BY seen, created_at DESC SEPARATOR ','), ',', 1) AS cr

niiwill's avatar
niiwill's avatar Tray2Eloquent
1

converting sql query to laravel ( 5.2 )

I have this sql query - SELECT t1.id as album_id, t3.id as photo_id, t3.hash FROM ow_photo_album t1 JOIN ow_protectedphotos_passwords t2 ON t2.albumId = t1.id JOIN ow_photo t3 ON t3.albumId = t1.id WHERE t1.userId = '$id' AND t2.privacy = 'password' ORDER BY t3.id ASC what i need this for is to pull specific 2 collumns from the 3rd join that has to be filtered by the 2nd join.

Zaphieon's avatar
Zaphieon's avatar jlrdwLaravel
5

Long Query

Hey! Was looking for some help on this possibly. I have a query that is averagin about 3.5s and was looking to get it down. I am using a 3rd party tagging package: https://github.com/rtconner/laravel-tagging It's great so far, but this is the query that is taking a long time...was wondering if anyone knew a way of optimizing it... $filters = ['filter']; $categoryId = 1; $invent

futurefuture's avatar
futurefuture's avatar rodrigo.pe...Laravel
7

No query results for model [App\Like]

I am trying to develop a liking ability of posts for my website. This method detects if a user already liked the post and if so deletes his like. It will always create the like but the majority of the time I get this error when I try to unlike the post. When I try to unlike the post I get this error No query results for model [App\Like]. public function store(Request $request)

jmurphy1267's avatar
jmurphy1267's avatar D9705996Code Review
1

Query where, groupby in Redis using Laravel

Hi I have data stored in Redis. I want to query like in Sql like SELECT * FROM TABLE WHERE id = 1; How Can I accomplish this in Redis database?

ncltours's avatar
ncltours's avatar ncltoursLaravel
2

How to fix NotFoundHttpException No query results for model [App\Upload] 8

I am working with Laravel 5.6 and MySQL DB. in my application I have some form data edit link from vehicles table, My edit link is this, {{route('vehicles.edit',$vehicule->id.'/edit/')}}" >Edit</a> and I have vehicle images show table as uploads and relationship between Vehicle model and Upload model is like this, vehicle model public function uploads() {

Amalmax's avatar
Amalmax's avatar SnapeyLaravel
8

Divide a column by another column created from Sub query

I've this query - $employees = Employee::where('user_id', $user->id)->withCount([ 'answers as questions_received' => function ($query) use($date) { $query->where('created_at', '>=', $date); }, 'answers as correct' => function ($query) use($date)

zahedkamal87's avatar
zahedkamal87's avatar zahedkamal...Eloquent
0

Laravel Nova partition metrics count query

Hi everyone! I'm fairly new on Laravel and currently working on a project using Laravel Nova. I want to use the partition metrics to display the percentage of "Loan Applications Per Company". Basically my table structures are like this: loan_application: (id, user_id) user: (id, user_name, company_id) company: (id, company_name) I'm a little lost on how I will query

noahainsworth's avatar
noahainsworth's avatar gbritsNova
3

Do I need to use query builder for this?

Can I use Eloquents active record to create this query or do I need to use the query builder? SELECT * FROM chat inner join chat_member as member1 on member1.chat_id = chat.chat_id inner join chat_member as member2 on member2.chat_id = chat.chat_id WHERE member1.chat_member_id = $member1ID and member2.chat_member_id = $member2ID

corybaumer's avatar
corybaumer's avatar corybaumerEloquent
2

How can I execute a query with nested select?

How can I execute the following query in Laravel using Eloquen? If not with Eloquent, how would it be with the Query Builder? SELECT grupos.id, grupos.grupo_nombre, grupos.grupo_alumnospermitidos, (SELECT COUNT(grupos_alumnos.id) FROM grupos_alumnos WHERE grupos_alumnos.grupo_id = grupos.id) AS numAlumnos FROM grupos ORDER BY grupos.clasificacion_id ASC, grupos.grupo_nombre ASC

uicabpatweyler's avatar
uicabpatweyler's avatar SnapeyEloquent
3

Include min max in pagination count query

Hey guys first time I ask something here. I have the following problem - I see, when I use the paginate() method on my eloquent models, Laravel makes 2 queries - a count query and select one. My goal is to get the min and max values in table for a specific column. Is there a way to add select min(),max() in the count query or I have to make a separate one. Thanks

blader4o's avatar
blader4o's avatar SnapeyLaravel
7

Laravel Outputs Different Output Than MySQL For Query

Hi, I generated a MySQL query which gives the correct output I require (tested on MySQL Workbench). But when I apply the same SQL query using Laravel DB::select(DB::raw()) I'm receiving a varied output. Would really appreciate some advice on how to overcome this, also would really appreciate if anyone could advise how to use DB methods to write this. I apologize in advance if i

KirenJames's avatar
KirenJames's avatar KirenJamesEloquent
4

Eloquent query picking wrong database for the User model

I'm currently setting up my own role-based access-control-system on my website. You can add Entities (eg. an Artist). | permissions | You can add Roles (eg. Administrator, Blogger, Developer). | role_user | The users are located within another database (the Internal database) in order to reuse the authentication I'm able to assign a role

pdc's avatar
pdc's avatar pdcEloquent
5

Search Query

Help me with my Search Query, I get this error Call to undefined method App\User::search() My Controller <?php namespace App\Http\Controllers; use App\User; use Illuminate\Http\Request; class SearchController extends Controller { >public function search(Request $request) { if ($request->has('search')) { $users = User::search($request->

lawkunchi's avatar
lawkunchi's avatar jaelyncyru...Laravel
10

Laravel query structure

Hi all, i have a query where i need to collect my agent's commission daily transaction, select a.fullname , DATE_FORMAT(b.created_at, "%M %d %Y") as mydate, sum(c.commission) from agent a, job_orders b, service c where a.id = b.therapist_fullname and b.service = c.id group by a.fullname , mydate, c.commission and i get this result with the format | Agent Name | Frid

pordonez's avatar
pordonez's avatar pordonezLaravel
0

Query 2 tables

What I am trying to do is at registration I need check 2 tables for the 'slug' for the user so obviously it has to be unique to the user table, and I have a restrictions table so user can also user banned words, offensive and general stuff like that. User query looks like: $valid = !DB::table('profiles')->where('slug', $value['value'])->select([$same])->first(); return

movepixels's avatar
movepixels's avatar movepixelsLaravel
2

convert sql query

Quiero convertir una consulta sql en formato eloquent select * from usuarios where usuario_ad = "danielad"; to Usuarios::where("usuario_ad","=",'danielad'); But in eloquent it does not work I just receive this, Illuminate\Database\Eloquent\Builder {#2892} How could the correct translation of this query be in eloquent?

daniel21gt's avatar
daniel21gt's avatar daniel21gtLaravel
2

problem with query where select

I have tried to do a where query with a select options Code with error https://paste.laravel.io/de1569e9-6fe5-477c-b6fc-eac5fb3d59d9 "Trying to get property of non-object (View: C:\laragon\www\crudgobernaciontres\resources\views\Usuario\index.blade.php)" In this module I consult all the records, but I also want to select by username, I still do not get it. view https:

daniel21gt's avatar
daniel21gt's avatar bobbybouwm...Laravel
4

It is posible a query for my data?

Hi, Good night. I have a doubt with a query. I have this tables Schema::create('patients', function (Blueprint $table) { $table->bigIncrements('id'); // Example 12 $table->string('name',100); //Example Jonh Con $table->date('birthDate'); // Example 2018-01-01 }); schema::create('consultations', function (Blueprint $table)

joseluisac's avatar
joseluisac's avatar shez1983Eloquent
1

How to do hasManyThrough() query??

Hi, so I am trying to retrieve data using the hasManyThrough() relationship and at this point I am able to get a response but the data is missing. Im not sure if it is including the client_id to grab the correct client from the table but im looking for any suggestions. Thanks. My relationships are Engagement belongsTo Client Client hasMany Engagements Task belongsTo User User

boldstar's avatar
boldstar's avatar boldstarLaravel
5

Query scopes for reservation system with multiple rooms.

I am working on a hotel reservation system, where user|admin can select multiple rooms. I am facing a problem in the edit functionality. I am looking for help and suggestions on how to make this right. My schema. Rooms: room_number price reserved(Boolean) Reservations: customer_id checkin checkout Reservation_Room room_id reservation_id TotalPrice Query scope on rooms pub

shahzadsarwar's avatar
shahzadsarwar's avatar shahzadsar...Eloquent
2

Help with a query..... please

I'm struggling with what seems to be a more complicated query than I thought. I have a client who requires a dashboard showing a bunch of his company's main KPIs. all of this is fine except one. Sample data set... hmm how do you add images in here? The rule Give me a number of all the meals that were "available" for at least 90 minutes. what this means in SQL: count

Mick79's avatar
Mick79's avatar Mick79Eloquent
3

transforming a 'advanced' mysql query to a laravel query

Hey i need help with transforming a mysql to laravel. My query is: SELECT ct.position, (SELECT position FROM chart_track WHERE `chart_id` = (SELECT id FROM charts ORDER BY id DESC LIMIT 1, 1) AND track_id = t.id) AS last_week, (SELECT count(*) FROM chart_track WHERE track_id = t.id) AS number_of_weeks, t.artist, t.title FROM charts c INNER JOIN chart_track ct ON c.id = ct.cha

djrasmusp's avatar
djrasmusp's avatar djrasmuspLaravel
2

Strange query problem

Hi all, i have a very strange problem. I'm joining tables with this query: $studentsCount = DB::table('cities as c') ->select('c.id', 'c.lat', 'c.lng', 'ct.name', 'ct.slug', DB::raw('count(sj.student_id) as student_count')) ->join('city_translations as ct', 'ct.city_id', '=', 'c.id') ->join('companies as comp', 'comp.city_id', '=', '

nadj's avatar
nadj's avatar nadjEloquent
6

Laravel Query builder IfElse

Hey folks, Can anyone help me that how to apply if else condition in query builder? for example if my status =1 i want to execute one cond and status !=1 execute other cond. Any help that would be appreciated. Thanks in advance. Here is my query `//Query Builder $this->db->select('id, status, new_class') ->from('table1 a') ->join('table2 b',

deepu07's avatar
deepu07's avatar jlrdwLaravel
1

Multiple for Submission or Issue with Insert Query?

Hi All, i have a weird issue, i have a form that a user submits with a card number, my script does some checking and ultimately submits a transaction to the database. recently, it has been running the insert query multiple times and i cant figure out why. At first i thought it was form submitting more than once but I have all my error or success for the form redirecting back to

TuffRivers's avatar
TuffRivers's avatar TuffRiversLaravel
0

DB Builder Query

Hi, I am not able to take value of variable outside. Let me know of what I am doing wrong? $sentArray = array(); //Match if existing Subscriber has already been sent the message array_push($sentArray, 0); $query = \DB::table('subscribers'); $query ->select('id', 'endpoint', 'publicKey', 'authToken') ->where('website_id', $websiteId) ->orderBy('id')->chunk(200, fu

geetpurwar's avatar
geetpurwar's avatar wilk_randa...Laravel
3

Laravel query builder

Hey folks, I'm stuck-up with query builder. I wanna merge duplicate column values into one row. for example I have id name age rollnum 1 bob 24 null 2 bob 24 1234 i wanna see 1 bob 24 1234. How can i do that in below query. Any help that would be appreciated. Thanks in advance. `//Query Builder $data = \DB::table("table1 AS a&

deepu07's avatar
deepu07's avatar deepu07Laravel
2

What is the proper way to query "Kill ID"

Hello guys, What is the proper query of KILL ID in Laravel DB query? I have this $id from ajax and in my controller is DB::select('Kill $id'); but it doesn't work.

anonymouse703's avatar
anonymouse703's avatar anonymouse...Laravel
0

How to use `NOT` operator in query builder?

For example how can I build a query like this ? SELECT * FROM users WHERE not (level > 50 and sex = 1); I don't want to convert it to this manually, I just want to reverse the whole result with the NOT operator. Can I do it with the query builder? SELECT * FROM users WHERE level <= 50 and sex = 0;

molts's avatar
molts's avatar moltsEloquent
2

Distinct Query

I am trying to query distinct, but because of the params conditions I am getting duplicate records for a user. Situation: User has Profile and the profile can be listed under many areas (cities) via areas_profile pivot table. So a user ( Say Johnny) can be listed in Los Angeles, and Long Beach, so if a regular user clicks Los Angeles presto Johnny is listed there, same with Lon

movepixels's avatar
movepixels's avatar movepixelsLaravel
3

Query Help

I am trying to do a query based on these params / conditions. The site has a database table of "areas" consisting of a nested table of countries / states or regions/ and cities so the user can select Los Angeles ( say area.id = 123) so there is a pivot table called area_profiles that stores profile_id and area_id. Now when a regular user visits the site and clicks on

movepixels's avatar
movepixels's avatar movepixelsLaravel
2

One to many realationship with where query

I have two tables, one is Scores and other one is Leagues. In Leagues I have ID, LeagueName In Scores I have ID, league_id, user_id, points class League extends Model { public function scores(){ //return $this->hasMany(Score::class,"user_id","id"); $this->hasMany(Score::class,'league_id');; } } class Score extends Model { p

Miko55's avatar
Miko55's avatar SnapeyEloquent
1

Laravel query Builder

Hey folks, I'm stuck-up with query builder. I have one raw sql query it is working when you execute in sequel Pro. but not working in code. can anyone help me on this? Thanks in advance. SELECT a.* FROM table1 a JOIN (SELECT name, age, COUNT(*) FROM table2 GROUP BY name, age HAVING count(*) > 1 ) b ON a.name = b.name AND a.age = b.age ORDER BY a.name //Query Builder

deepu07's avatar
deepu07's avatar deepu07Laravel
2

Query optimization, ORDER BY slows my query

I have a query: SELECT P.* FROM `products` AS P JOIN `category_product` AS CP ON P.id = CP.product_id JOIN `categories` AS C ON CP.category_id = C.id WHERE C.id = 26 ORDER BY P.`created_at` DESC LIMIT 4 Which I wrote in Laravel like that: $products = Product::whereHas('categories', function ($query) use ($categoryId) { $query->where('categories.id', '=', $ca

dust's avatar
dust's avatar CronixLaravel
7

query execution test

I want to know that does laravel have any builtin way that, "if i have multiple query between a single function/method ,then if any of those query return an exception , the all query result (data saving in the table) that is being executed successfully before the unsuccessful query, will be removed from database table." ????

nionta's avatar
nionta's avatar niontaMix
1

How To Execute 'LIKE' Raw Query with Binding?

Hi, This works DB::select("SELECT * FROM `users` WHERE `name` = :name", ['name' => $request->name]); But this returns empty result DB::select("SELECT * FROM `users` WHERE `name` LIKE '%:name%'", ['name' => $request->name]); What is wrong with second query? Thanks!

Laraveldeep's avatar
Laraveldeep's avatar Laraveldee...Laravel
4

complexe sql query

hy, i have this sql query : SELECT DISTINCT * FROM image_models t1 WHERE EXISTS ( SELECT * FROM image_models t2 WHERE t1.ID <> t2.ID AND t1.hashkey = t2.hashkey ) what is the best/safe way to use it in my project ? I'm trying with this : $results = DB::select( DB::raw("SELECT DISTINCT * FROM image_models t1 WHERE EXISTS (SELECT * FROM image_models t2 WHERE t1.ID <

nine's avatar
nine's avatar nineLaravel
5

Query with Count and GroupBy

Good afternoon. I have the following tables: one for students, one for the regions where students live, they are related through the IdRegioes field. I would like to bring the data on student counts by region, according to some criteria to be displayed in my summary view, using SQL in the database I would have the following query: SELECT i.regioes_idregioes, r.regiao, COUNT(i.

Carlos_rsd's avatar
Carlos_rsd's avatar Carlos_rsdEloquent
2

Accessing multiple users withPivot in one query

I have a Many to Many Relationship between Users and Accounts with a pivot table that has a flag is_owner and pulling the accounts withPivot for 1 user works fine but if I had a list of 5 User IDs and want to pull all the accounts withPivot is_owner true as one query, how can I do that? I'm looking for the results to be a list of accounts with user with pivot.

yougotnet's avatar
yougotnet's avatar yougotnetEloquent
20

How to append query string to new url?

To explain this, I’m gonna try to use an example and maybe it’ll give you a better picture of it hopefully. I’m using pagination on my project and added $variable->appends(get)->links to keep query strings in the next page of pagination. Is there a way to use or mimic this when pressing a form button for submission, which would have action attribute with a url, to add a

mufasaparadox's avatar
mufasaparadox's avatar CronixLaravel
6

Modifying URL Search Query With JavaScript

I am using JavaScript to paginate a data set with ajax, and once the result is returned, I update the query string with the current query by modifying the history. const replaceQueryString = newQueryString => { window.history.pushState(null, '', `?${newQueryString}`); }; This part works fine and does what I want, which is modifying the string in the URL without actually

rawilk's avatar
rawilk's avatar rawilkJavaScript
0

How to convert mysql query filtered by TIME() function to laravel query builder?

So far this is the MySQL query and it works perfectly. It filters records by matching passed value to TIME(fecha_hora): select nombre_departamento, categoria_respuesta, count(valor_evaluacion) from detalle_evaluaciones JOIN departamentos ON departamentos.id = detalle_evaluaciones.departamentos_id JOIN tipo_respuestas ON tipo_respuestas.id = detalle_evaluaciones

mufasaparadox's avatar
mufasaparadox's avatar mufasapara...Laravel
8

No query results for model [App\Requisition].

When I go to address http://localhost:8000/requisitions/5/edit I get this error. No query results for model [App\Requisition]. Of course I putted use App\Requisition; in my code. namespace App\Http\Controllers\Admin; use App\School; use Illuminate\Http\Request; use App\Http\Controllers\Controller; use Alert; use App\Requisition; class RequisitionController extends Controlle

mozew's avatar
mozew's avatar andonovnLaravel
1

How to convert laravel query to db::raw

Hi, i have this query $array = ["1","2","3"]; Leads::whereIn('lead_agent', $array); i want to convert this query to a simple db::raw like this DB::select('select * from leads where???'); i dont know how to pass the $array into the simple db::raw query

pordonez's avatar
pordonez's avatar tylernatha...Laravel
3