What does a successful Delete Query via Query Builder return?

$result = DB::table('table_name')->where('GENDER', '=', $data['GENDER'])->delete(); this query will delete multiple records. But when I do a dd($result) it always shows 0. How do I ensure my delete query worked properly?

Sushant97's avatar
Sushant97's avatar NakovGeneral
1

query help

hello, i try change my codeigniter app to laravel and i have this problem in query i use this query in codeigniter and work fine with me when i try use in laravel not work $date = date('Y-m-d'); $this->db->select(" season_match.team_id, (IFNULL(hometeam.play, 0) + IFNULL(vistor.play, 0)) as `play`,

AdhamLap's avatar
AdhamLap's avatar jlrdwEloquent
9

Laravel 5.8: how to perform query building for bulk data from a form

I have a form which contains a table that has 3 editable fields, lets call them A,B,C. The table's number of rows is variable, and so the number of A,B,C attribute values is not fixed. For example, if there are 5 rows, there will be five A, five B and five C values, which is 15 values in total: |A |B |C | ------------ |0 |1 |2 | |3 |4 |5 | |6 |7 |8 | |9 |10 |11 | |1

Sushant97's avatar
Sushant97's avatar ftierschLaravel
1

Query execution time

how can i get execution time of query ? thanks

mustafaabdujalil's avatar
mustafaabdujalil's avatar Sergiu17Laravel
1

Question about query builder add table without join

Hey! I am beginner at Laravel and would like to know if possible in query builder add some tables without join? For example, I have table "users" with "user_id" column and I want to add table "reg_info" with column "id". In first table we have more user ids than in second table, but I want to select student's which are registered and stud

sparkyLTU's avatar
sparkyLTU's avatar primordialLaravel
2

Converting a complex sql query to query builder

Hay does anybody have any idea how to turn this SQL query into a laravel builder query? select * from ( select `entry_date` as "entry_since", @streak := @streak+1 streak, datediff(curdate(),`entry_date`) diff from ( select distinct date(`entry_date`) `entry_date` from tracker_entries where user_id = {$this->id} and tracker_id = {$trackerId} ) t1

geraintp's avatar
geraintp's avatar jlrdwLaravel
1

mysql index key not provided when not limiting query result

I have two index group on my table called smp, when I run explain on the same query without limiting the query results, no key is selected, but a key is selected when limiting is added. I have these two indexes: smp_time_updated_group_name_sub_group_index (time_updated, group_name, sub_group) smp_time_updated_group_name_sub_group_name_index (time_updated, group_name, sub_gr

Sabonzy's avatar
Sabonzy's avatar Tray2General
7

Query regarding fetching data

Hi, I have three tables namely, users,user_membership,user_payment_details, Users have more than 1 user_membership and user_payment_details data. so that relation would be hasmany. right now I am fetching all users data using below query, $users = User::select('users.*','chapters.chapter_name as chapter_name','membership_payment_structure.name as fee_name','membership.name as m

Deekshith's avatar
Deekshith's avatar jlrdwGeneral
1

Query regarding fetching data,

Hi, I have three tables namely, users,user_membership,user_payment_details, Users have more than 1 user_membership and user_payment_details data. so that relation would be hasmany. right now i am fetching all users data using below query, $users = $users->select('users.*','chapters.chapter_name as chapter_name','membership_payment_structure.name as fee_name','membership.name

Deekshith's avatar
Deekshith's avatar jlrdwGeneral
1

Laravel query in database

am new in laravel and I am getting it hard in building difficult queries. I have a project where I need to get which product is most sold for a week or for a month. I have three tables in database: products orders order_items The table of order_items is attached below.enter image description here This is the query that I have done to get mos sold product for this week. But I kn

Alphal's avatar
Alphal's avatar jlrdwLaravel
3

Query runs ok in phpmyadmin but DB::select() throws exception

I have this weird issue - this query below in one of my controller method is throwing me an exception error. $sql = "SELECT acd.*, DATE_FORMAT(acd.cdate, '%d/%m/%Y') cdate_disp, GROUP_CONCAT(CONCAT_WS(', ', car.type, car.session, crd.name) SEPARATOR '<br />') rd_names, acb.booking_status my_booking_status FROM app_data acd INNER JOIN crmaccounts ca ON ca.id = acd

appyapp's avatar
appyapp's avatar appyappEloquent
12

Stuck setting up a query builder that accesses contents of other relational table

Hello all, I'm a confessed noob and new to the world of web app development with Laravel. I'm a little bit stuck and was wondering if I'm missing something really obvious or need to change the way I'm working entirely. I'm creating a side bar that allows a user to search the database for stored entries (products), using a checkbox style form. When submitted, the get form submit

ws11's avatar
ws11's avatar ws11Laravel
2

Validation and database query redundancy

Hey folks, I have a question to improve my code and the performance of my laravel apps. I was wondering if there is any query cache or something like that when querying the same ressource multiple times. Let's say I have the following validation rule: 'group' => 'exists:groups,id|required', The validator will query the group with id X. After the validation I need the group

DerAndi's avatar
DerAndi's avatar clemLaravel
3

Query returning wrong results

It's ignoring the "where" part. Showing courses that the user_id is the current logged in user. What am I doing wrong? public function index() { echo auth()->id(); $courses = \App\Course::withCount(['modules' => function ($query) { $query->where('user_id', auth()->id()); }])->get(); return view('courses.sh

behnampmdg3's avatar
behnampmdg3's avatar behnampmdg...Eloquent
4

Query through JSON file

Is it possible to query through my JSON file without using a database. When i return my JSON object I am only able to get it in raw. If I try to access an element in my array I get Trying to get property 'name' of non-object. This is my method in the route for testing. Route::get('/test', function(){ $jsonString = file_get_contents(base_path('database/db.json')); $data

Ibzy's avatar
Ibzy's avatar jlrdwLaravel
5

Is this the correct way of rewriting this query in Eloquant?

Is this the correct way of rewriting this query in Eloquant? SELECT name, email FROM members INNER JOIN member_course ON members.id = member_course.member_id INNER JOIN courses ON courses.id = member_course.course_id AND courses.user_id = 3 GROUP BY members.id public function index() { $members = \DB::table('members')

behnampmdg3's avatar
behnampmdg3's avatar behnampmdg...Eloquent
3

How do you query this months records with epoch time?

I need to SUM all the values for a given month. The beginning of that process is to query the records for that month. I'm pretty sure I'm going to need Carbon to convert the UNIX timestamp to something I can filter from. So that is the route I was going with this. There might be a better way to do this. So any suggestion is appreciated. I'm trying to do something like this:

fbc's avatar
fbc's avatar fbcLaravel
4

Getting my query to look at the year

I'm trying to have my query do this. Grab all the orders where the order_date equals to the year and where the user_id equals users id. I have managed to get the year buy I'm struggling to get it check the database for all orders that has that year. My code public function sortOrders(Request $request) { $menus_child = Menu::where('menu_id', 0)->with('menusP')->get();

Shiva's avatar
Shiva's avatar ShivaLaravel
2

From SQl to Laravel Query builder

I have this SQL query but had no idea how to write it in Laravel Query Builder select state_id, state_name, sum(inactifs) as inactifs, sum(actifs) as actifs, sum(inactifs) + sum(actifs) as total from ( select distinct s.id as state_id, s.name as state_name, u.id as user_id, case when uga.id is null then 1 else 0 end as inactifs, case when uga.id is null then 0 else 1 end as a

ladhari's avatar
ladhari's avatar jlrdwLaravel
4

Query Builder + Where + Inner Select

I have a SQL query: SELECT tms.id, tms.user_id, tms.dayoff FROM tmteher_monthly_stats AS tms WHERE tms.stat_date = '2019-03-01' AND tms.id = ( SELECT MAX(tms2.id) FROM tmteher_monthly_stats AS tms2 WHERE tms2.user_id = tms.user_id

rajcsanyiz's avatar
rajcsanyiz's avatar rajcsanyizEloquent
4

Get pagination for full MySql and DB::select query

Hi, is there a way to use Laravel pagination in this situation : Query for full mysql search : $key = ' test word'; $q = DB::select(' SELECT * , MATCH(col 1,col 2) AGAINST ("'.$key.'" IN BOOLEAN MODE) AS score FROM test WHERE MATCH(col 1,col 2) AGAINST ("'.$key.'" IN BOOLEAN MODE)'); Query is ok, I get good results, but cant use clasic ->paginat

pavlen's avatar
pavlen's avatar pavlenLaravel
2

Writing a SQL Query into Eloquent

I have a query as below, I am struggling to write it into Eloquent, SELECT id, description FROM turnovers ORDER BY CASE WHEN id = (SELECT MAX(id) FROM turnovers) THEN 0 ELSE 1 END, id; The model is Turnover. Any help is appreciated.

bobmyles's avatar
bobmyles's avatar bobbybouwm...General
1

Query Keeps return data if Match or doesn't match id

Query Keeps return data if Match or doesn't match id // Api.php Route::get('/products/category/{category}','ProductController@productsCategory'); public function ProductsCategory($id) { $products = Product::where('category_id', $id) ->where('price_before','!=',0) ->orWhere('price_after','!=',0) ->

Respect's avatar
Respect's avatar RespectLaravel
6

Nova Filter Query - Translate from SQL

I've a Model with some ratings. With the Nova filter, I want only to show the results with a selected rating ($value = 1|2|3|4|5| >= 3| ...). This SQL is working fine: SELECT p.*, AVG(pr.rating) as rating FROM `posts` p JOIN post_ratings pr ON pr.post_id = p.id GROUP BY p.id, p.brand, p.company, p.url, p.is_public, p.created_at

adrian_cmd's avatar
adrian_cmd's avatar jlrdwNova
1

SQL Query with inner join of Select to Laravel Eloquent

Is it possible to convert to Eloquent a INNER JOIN of a SELECT or will I have to use DB Builder? Seems hard enough for me ... The query I'm trying to convert SELECT V.idStart, F.id, F.nome FROM familias F INNER JOIN ( SELECT CA.idStart, SUBSTRING(idStart, 1, LENGTH(idStart)-3 ) AS idFam FROM afirmacoes CA WHERE CA.idStart IS NOT NULL ) AS V ON F.id = V.idFam My mo

Penaf's avatar
Penaf's avatar mvdEloquent
1

Hello How To Apply This Query In Laravel

Hello How To Apply This Query In Laravel i need select all products price_before and price_after not = 0 i tested this ------------------- $products = Product::where([ ['price_before', '!=', 0], ['price_after', '!=', 0] ])->get(); return ProductResource::collection($products); and also this $products = Product::where('price

Respect's avatar
Respect's avatar RespectLaravel
12

Multiple query results not merging

HI there I have a table that I run a query on to get all the users records in the table and then I return a datatable with the data. This works 100%. My problem is I need to add data to this datatable from another table in the db as well currently I have tried the following but I just get a datatable error. Both tables structure is the same. And I just can't get the table to di

riaanv1987's avatar
riaanv1987's avatar riaanv1987Code Review
1

Query model with calculations from two relation tables

I have 3 tables and 3 models for each : Invoice / Payment / Item invoices : table ---------------------------------------------------------------- | id | user_id | discount_amount | due_at ---------------------------------------------------------------- items : table ------------------------------------------------------- | id | invoice_id | description | price -------------

Calid's avatar
Calid's avatar CalidLaravel
0

Nested Relationships Query

Hello, I'm having hard time to build proper eloquent query for the following models chain and their relationships: very short table representation: users (user_id); apps (id, user_id); fees (id, app_id); purchases (id, fee_id, payment_id); payments (id); refunds (id, payment_id); relations: users.id 1-M apps.user_id; apps.id 1-M fees.app_id; fees.id 1-M purchases.fee_id

n-other's avatar
n-other's avatar n-otherEloquent
7

how to query pivot table in eloquent before retrieving any data?

hello I am working on an ecommerce application please consider following models: Product Attribute ProductAttribute and tables(simplest form): products id name attributes id name product_attribute id product_id attribute_id value Product and Attribute both have belongsToMany relationship and ProductAttribute is pivot model. I want to be able to get all products which

danimohamadnejad's avatar
danimohamadnejad's avatar danimohama...Eloquent
1

Eloquent Query

i have two model one is user other one is userprofile with relationship this query is work perfect User::with('profile')->find($id)->get(); but i know to get record to set condition on userprofile table how i can put condition on userprofile table and get record in this above case i can only put condition only in user table like find, where etc....

UsmanFarzand's avatar
UsmanFarzand's avatar CronixLaravel
1

how to write this mysql query using eloquent?

Hi, I have a model with name Game and I want to write a eloquent query with multiple Date where, I was write this query as raw but can't write it using eloquent to fetch data as model. game model class: { // other parameters .... timestamp created_at; timestamp updated_at; timestamp started_at; timestamp finished_at; timestamp deleted_at; } php code

alihoushyaripour's avatar
alihoushyaripour's avatar LiamHammet...Eloquent
10

Get query string from card

I want to create a button which will download a CSV of the current resource from its index page. To do this I have created a card, with a button in it, and added this card to the resource: <template> <card class="flex flex-col items-center justify-center"> <h1 class="text-center text-3xl text-80 font-light">Export</h1>

unlikenesses's avatar
unlikenesses's avatar unlikeness...Nova
2

Query Builder To Array work a round

In a post someone wanted some array results, I told them to add toArray after get: ->get()->toArray(); But I was using eloquent, they were using query builder. They got an array of objects. I created an issue #27722 since I expected query builder would also work with toArray(). So you can read @mfn reply there, but bottom line if you want array from query builder: Just a

jlrdw's avatar
jlrdw's avatar jlrdwGuides
1

Optimizing my Auth::User()->withCount()->with() query

Hi laravel community, i have a problem understanding the query i do to fetch some hasMany relations count. Actually to fetch relations count on my user i do the following query : $user = Auth::user()->withCount('announces', 'events')->with('badges', 'votes', 'image')->where('id', Auth::id())->first(); First of all this query work just fine, but i get a verry new mo

Farstone's avatar
Farstone's avatar FarstoneEloquent
4

Local query scopes vs. Collection macros --- shaping complex data

Hi, I already defined scopes like scopePublished, scopeActive and so on. Then I needed to return some complex statistics and I decided to first fetch all the data and then shape it with collection methods to determine e.g. "How many published per group and period", "How many not" and so on. So I already had filter logic defined in scopes. But query scopes ne

michapietsch's avatar
michapietsch's avatar michapiets...Laravel
2

Get error message from raw database query DB::getPdo()

How can I get the errror message from the raw query, for example: DB::connection('mysql2')->getPdo()->exec($sql); this just returns 1 or 0 I need to know if the query was unsuccessful because of an error or if the data was unchanged, I'm running an UPDATE query. PDO has errorInfo() in php but unsure how to access this in laravel. I can't use eloquent, it needs to be raw.

stemie's avatar
stemie's avatar TalinonLaravel
1

Order By Query not being displayed correctly on view

So I have an order by query that is in the correct order when I dd. But on my view, when I loop through results, it is displaying order by ID and NOT using my Query Order. $pages = DB::table('pages')->orderBy('order_list', 'asc')->get(); so on dd it is in the correct order by 'order_list'. Order List is a DB column int(10) value. So my pages can be order by this order_

laracasts9924's avatar
laracasts9924's avatar dxladnerLaravel
6

Raw Query To Eloquent Query builer

I want to convert this raw query to eloquent, but it seems to be complex, please help me out. select one.emp_id,one.date,one.punch_in,one.punch_out,two.type_code,two.start_date,two.end_date,three.week_off,three.month,three.year,four.holidaydate from punchreports as one left join (SELECT applyleaves.emp_id,leavetypes.type_code,applyleaves.start_date,applyleaves.end_date FROM app

kshitizmittal's avatar
kshitizmittal's avatar devfreyEloquent
1

How to attach query data from model and display it in view per user?

Hello guys, how to attach query data from model to display in view per user? I have a query here to get the average rating in my user model. public static function getRate($rate){ $rateUser = DB::table('users') ->join('rating', 'users.id', '=', 'rating.user_id') ->select('users.*', DB::raw( 'AVG( rating.rating ) as

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

Adding a subquery to an eloquent query

I want to add a field to the result set of an eloquent query that its value is provided by a subquery. In other words I want the returned eloquent models have an extra field using that subquery. SELECT * FROM (SELECT fair_gift_id, (SELECT count(*) FROM fair_gift_bus WHERE FG.id = fair_gift_id ) as bus_count FROM fair_g

corean's avatar
corean's avatar jlrdwEloquent
2

Same Columns in two tables, query builder

Hi! I've a sql Query DB::table('table1')->join('table2','table1.id','=','table2.table1_id')->orderByRaw('position')->get(); In both tables, table1 and table2 is a column id. After the request I get a collection with one attribute id, the id attribute ist from table2 Why? How can I change this to id from table1? So I need something like table1.id or?

baeckerman83's avatar
baeckerman83's avatar manelgaval...Laravel
1

How can i re-use Query Builder result to create multiple collections?

Hi, I am trying to find a way to not write hardcoding to solve an issue. I got this index method as: public function index() { $posts = Post::where('status','published')->paginate(4); $featured = Post::where('featured',true)->get(); return view('posts.list', compact('posts','featured')); } As you can see i made 2 query on Post model

muzafferdede's avatar
muzafferdede's avatar lexionluLaravel
3

laravel query builder error

SELECT id,account_name,parent_id FROM (SELECT id,account_name,parent_id, CASE WHEN id = 1 THEN @idlist := CONCAT(id) WHEN FIND_IN_SET(parent_id,@idlist) THEN @idlist := CONCAT(@idlist,',',id) END as checkId FROM chart_of_account ORDER BY id ASC) as T WHERE checkId IS NOT NULL When i run this query in mysql i work fine result fetch perfect but i run it in laravel like this $acc

Umarshah's avatar
Umarshah's avatar jlrdwLaravel
2

How to implement oracle query to select from different tables in laravel

I'm trying to select distinct from different tables in laravel. In oracle I have implemented successfully the query and works. Now I'm trying to "translate" it into laravel. How can I do that? In oraclesql the query is the following. TEMP table exists as well as all other tables used in this query. Is it possible to do this with DB::raw? Could you give me your advice

konrms's avatar
konrms's avatar konrmsEloquent
12

Raw query not running

I am trying to run raw query as follow: $rawStatement = 'SELECT table_rows "Rows Count" FROM information_schema.tables WHERE table_name="table_name" AND table_schema="db_name"'; DB::statement(DB::raw($rawStatement)); ERROR: Too few arguments to function Illuminate\Database\Connection::raw(), 0 passed in D:\wamp64\www\project\vendor\laravel\framewo

ssquare's avatar
ssquare's avatar nisekuLaravel
1

condition inside query builder

I need to have an condition inside an relation query builder $jobs = Job::where('disabled_job', '=', '0')->with(['positions' => function ($queryPositions) { if( $queryPositions->where('option', '=', '10')) ) { //Here i need again all $jobs } I need to write an condition then retrieve all jobs where option is equal to 10, not one entry. At

petritr's avatar
petritr's avatar bobbybouwm...Laravel
3

Query Builder (where and orderBy)

I have a model Thread and Reply, and that is one to many relationship. so every time I query thread I will have the replyCount with it. protected static function boot() { parent::boot(); static::addGlobalScope('replyCount', function (Builder $builder) { $builder->withCount('replies'); }); } so I can do Thread::orderBy('replies_co

AndySong's avatar
AndySong's avatar staudenmei...Eloquent
3

Convert this query to eloquent

I want to convert this query to eloquent select result.degname,COUNT(result.emp_id) from (Select ed.emp_id,deg.degname from employeedetails as ed LEFT JOIN designations as deg on ed.designation = deg.degid) as result GROUP BY result.degname

kshitizmittal's avatar
kshitizmittal's avatar mariohbrin...Eloquent
1

Two different databases on same query

Hello everyone, I learned a nice trick from one of our members here where you can use a connection like this when you have multiple databases used in Laravel. DB::connection('conn_2')->select(...) However, I came to a scenario where I need to use two connections on the same query. Something like this; SELECT * FROM conn_1.db.users JOIN conn_2.db.user_rights on ... Is there a

cevizmx's avatar
cevizmx's avatar nikulpalad...Laravel
2