Trying to get property of non-object. Harvasine query scope.

I'm essentially trying to find the users closest to me with the harvastine algorithm. ProfilesController public function index(User $user, Request $request) { //$location = GeoIP::getLocation($request->ip()); $authUser = Auth::user(); $users = $user->scopeIsWithinMaxDistance($authUser, 5 )->all(); return view('profiles.index', c

Corbin's avatar
Corbin's avatar CorbinEloquent
1

Query with one to many relationship

This is a very common situation with DB and I just want to learn how do you guys solve this type of problem using Laravel? Let's say we have a common Model User and one more model WorkHour. Relationship User has many WorkHours. users table: id, name, email there are 10.000 users in this table workhours table: id, user_id, start_time, end_time, hours_worked -> in seconds ther

lewis4u's avatar
lewis4u's avatar jlrdwLaravel
8

How can I solve NotFoundHttpException No query results for model on laravel?

My code like this : return redirect()->route('camp.don.summary', ['id'=>$dons->id]); If the code executed, it will call route The route like this : Route::prefix('camp')->group(function(){ ... Route::prefix('don')->group(function(){ ... Route::get('summary/{id}', 'CampController@summary')->name('camp.don.summary'); }); }); Then th

moses's avatar
moses's avatar ThunderBir...Laravel
1

Query always returns a value

I am running this query: ['id', '=', $value], ['attribute_question_id', '=', $question->id]])->select(['id', 'attribute_question_id'])->firstOrFail(); and it always returns a value when it should not. If I have $value = 0 I know there is no record in the database with id = 0 so it should fail, but it simply moves along and pulls the record where 'attri

movepixels's avatar
movepixels's avatar SnapeyLaravel
8

Order or filter paginated query results

Hi there, After doing a paginated query on a model, I manually add some custom fields to my query result collection. These fields are calculated based on queries made on an external database so there is no way I can merge all this in a single query, which obviously would solve everything. So I would like to know if there is way either to post-filter wither to post-sort a query

saimiris's avatar
saimiris's avatar jlrdwLaravel
6

How to catch custom MySQL exceptions through query builder?

Scenario: Application can only run MySQL functions and stored procedures. MySQL functions throw custom errors through procedure. But query builder returns null when error occurs. And PDOException doesn't catch the error. This works in Slim 3. //lumen $param = $request->input('param'); $pdo = DB::connection()->getPdo(); try { $sql = "SELECT `db_cbs`.

rojer's avatar
rojer's avatar rojerLumen
0

Pagination issue with search query

I'm getting an issue where that if i run a search with constraints on a set of data and the returned data is more than my pagination number then when i press on page two of the search results, it returns me to the default query (localhost/page=2) and cancels/ignores the search which had been run. Is there a way around this?

dionarap's avatar
dionarap's avatar tobyLaravel
2

Mysql Full Text query with eloquent relationship

I have defined many to many relationship between my Post and Category models. I need to perform FULL TEXT search on column title and body in posts table. The search may also have supplied ids of category when submitted from search form. How can i perform this search? My current codes //Post.php public function categories() { return $this->belongsToMany('App\Category', '

sannjay's avatar
sannjay's avatar sannjayEloquent
3

Query Builder DB:: sentencia IF

Good afternoon friends, I have a problem I want to make an if statement within a Query Builder to avoid having to do reworked queries. This is what I want to do but it gives me error. $history=DB::table('history_inventory as H') ->join('products as P','H.idproduct','=','P.id') ->join('actions as A','H.action','=','A.id') if(isset($i

rafaelg21's avatar
rafaelg21's avatar rafaelg21Laravel
2

Add query string to current url

Hello, folks! I want to add a query string to the current URL when clicking on a button or radio button. For example: /subjects becomes /subjects?popular and /subjects?new becomes /subjects?new&popular Thanks!

mvww11's avatar
mvww11's avatar ChristoferLaravel
6

Query JSON column on MariaDB?

My webhost's MySQL version is 10.0.32-MariaDB. Whenever I try to query a JSON column like so: where('data->model', $reply->id) I get the following error: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '>'$."model" This is because my

Samer_J's avatar
Samer_J's avatar staudenmei...General
6

No query results for model [RampUp\Skills].

Whenever I try to access /skills/add I get No query results for model [RampUp\Skills]. Tried using dd("test") but won't even appear This are my routes for skills/add Route::put('/skills/add', 'SkillsController@add'); Route::get('/skills/add', 'SkillsController@addIndex'); Here are my functions in SkillsController public function addIndex() { if (Auth::check

frutos93's avatar
frutos93's avatar andonovnLaravel
1

Raw query eloquent

I have two time columns on a table, timeFrom and timeTo, and I am trying to get all rows where current time is between timeFrom and timeTo using this query which is working $query->whereRaw('curtime() between timeFrom and timeTo'); I was wondering if there is a better way not using whereRaw on query because of sql injection!

petrit's avatar
petrit's avatar ParasoulEloquent
1

Laravel Query Builder get error

I posted this question on laravel.io as well: I'm following the Laravel from Scratch series from laracasts and am trying to build my own website. I have a method in Posts that allows me to establish the relationship between comments and post public function comments() { return $this->hasMany(Comment::class); } Let's say I have an integer valued attribute, attr, in Comme

rjin's avatar
rjin's avatar JayteeEloquent
2

How to Query two tables in one query statement

i have a table that contains all job offers.. but some have gotten approved by the client.. so i want all those that are approved to not show.. i'm using relations.. i have two tables.. one is where the jobs are (jobs) and the other (applied_jobs) are the ones that someone has applied too and it contains a status column which tells me the status of the job (status) so now assum

king_eke's avatar
king_eke's avatar king_ekeLaravel
21

Possible to create a "belongsTo" using a raw query?

I am building the following model for Eloquent. In our system we have users and each user belongs to a profile. Additionally each user also has a bunch of a clicks. We want to build able to write a custom query that will help us calculate those clicks. There's a lot of logic required to do so, but here is my setup currently: <?php namespace App\Models\Eloquent; use Illumin

rfsn's avatar
rfsn's avatar rfsnEloquent
0

Passing custom query results to layout template part

Hi I'm a bit confused on how to do this. I have a template part (budget.blade.php) that I'm including in my template (@include). I need to get variables from a custom query based on user into this template part . (users company budget, orders total,...). I tried with a Service provider namespace App\Providers; use Illuminate\Support\ServiceProvider; use Illuminate\View\View; u

baguus's avatar
baguus's avatar baguusLaravel
2

Database query bad method

I get following error in Yajra Datatables in google chrome develper tool BadMethodCallException Method getQuery does not exist. code: <?php namespace App\DataTables; use App\Staff; use App\CompanyGroup; use Yajra\Datatables\Services\DataTable; use DB; class EmpDataTable extends DataTable { /** * Build DataTable class. * * @return \Yajra\Datatables\Engines\BaseEngine */ pub

wicky's avatar
wicky's avatar wickyEloquent
3

How to use like query after with clause

If there are two table student and course , Now if i want to use like query in course after relation with student. eg Student::where(id,5)->with("havecourse")->where('course_name','LIKE','%'.'BC','%')->get() How to do that thanks.

mithilesh999's avatar
mithilesh999's avatar mithilesh9...Laravel
3

How do i write below query to update the login status currently logged in adminusers

$status = \DB::table('admin')->where(['login_status',"no"]); $status->update(['login_status'=>"yes"]); //above query is updating status for all the adminusers i need to update only adminusers who are logged in..

Shawdow's avatar
Shawdow's avatar NaveenaLaravel
7

What is the best way to write an update query if there is multiple choice selection for the data to be updated?

This is the sample query. $cat = DB::table('tesing') ->where('id', $id) ->update(['a' => $a,'b'=>$b,'c'=>$c,'d'=>$d']); E.g. when user is allow to choose whether want to just only update 'a' value or 'b' value and so on. How can i ensure that only update the field where selected by the user. $cat = DB::

Crazylife's avatar
Crazylife's avatar SnapeyGeneral
8

count and get in same query

hello guys i have 2 different table one is job_postings and second one is mi_rec_applicants here i just want to count value of mi_rec_applicants and hole data of job_postings in single query like this 0 => {#354 ▼ +"id": 12 +"userid": "[email protected]"

bipin's avatar
bipin's avatar bipinLaravel
7

Query not found Exception

i am facing this error in my laravel project after i installed elqouent sluggable package....i dont know what is causing this error...it was working just fine! any help please? Sorry, the page you are looking for could not be found. (2/2) NotFoundHttpException No query results for model [App\Tag]. in Handler.php (line 131) at Handler->prepareException(object(ModelNotFoundExc

Ab.net's avatar
Ab.net's avatar Ab.netLaravel
2

Polymorphic relation returns query like "Is null and is not null"

I created polymorphic relation and it works just fine, but when I query it I get query like this one: select * from `storage_loads` where `storage_loads`.`storage_id` is null and `storage_loads`.`storage_id` is not null and `storage_loads`.`storage_type` = ? The problem is this part where `storage_loads`.`storage_id` is null and `storage_loads`.`storage_id` is not null This

darkec's avatar
darkec's avatar darkecEloquent
1

Populating multiple relations from the same query result

I have a couple of models that have similar relations to a third model. I'd like to reduce database queries by either caching the query result or reusing one result to populate relations. This is how my models are set up: public class A{ public function relatedC(){ return $this->belongsTo(C::class); } } public class B{ public function relatedC(){

36864's avatar
36864's avatar 36864Eloquent
3

Help with eloquent query

Guys, can you please help me build the query using eloquent? I'll explain how things are. I have users which have a role, and I want to filter only those that have role.Name == 'Student'. Also, each student can belong to many classes, so i have a classes table and users_classes where matching occurs. So far I have: $students = User::where('school_id', '=', $school->id)->g

mikoo's avatar
mikoo's avatar mikooLaravel
1

Query collection with Laravel Scout and Algolia

Is it possible to search a collection returned by a pivot relationship with the search('...') function? // Arbitrary account model instance $account = App\Models\Account::first(); // Pulling the pivot relationship and attempting to query // a collection of models with the search function $account->invites()->search('...')->paginate() I know at th

Colin_Laws's avatar
Colin_Laws's avatar Colin_LawsLaravel
0

Many to Many Query

I have Company and each of them would be assigned with Categories (many to many). How do I query the company based on the specific Categories. In Laracasts, I have only learned this: public function searchtest(Request $request) { return Company::with('categories')->has('categories')->get(); } This only return companies that has categories. How do I

msyaukat's avatar
msyaukat's avatar msyaukatLaravel
4

Help on a complex query

Hi guys, I have two models, User and Event. An user can own events (he is the creator of the event) and he also can be a guest of many events. The first relation is a OneToMany and the other one is a ManyToMany (an event can have many guests and an user can be a guest of many events). This is my User model : class User extends Authenticatable { /** * Get the events of

Wizix's avatar
Wizix's avatar m7vm7vLaravel
2

Laravel fluent query builder

hello every one please i need help how would I go about this select using Laravel's fluent query builder? I am aware I can use a raw sql query but I would like to avoid that if possible. Any help would be appreciated, thanks in advance! SELECT SUM(COST) FROM ( SELECT COUNT(STOCK_ID)*PRICE COST FROM STOCK ST INNER JOIN PRODUCT PDT ON PDT.PROD_ID=ST.PROD_ID WHERE

pafait's avatar
pafait's avatar jlrdwEloquent
1

DB Connection without hitting any query

Hi, Currently i am facing issue that on home page loading Laravel creates database connection even without hitting any query to database. Last week we got DDOS attack on website and our database went down, cause of this our users were unable to access our website. So please help me to prevent database connection without hitting any query Thanks

rex.sateesh's avatar
rex.sateesh's avatar saurabhdLaravel
1

Laravel/Eloquent - getting the property from morph to many relationship in a single query

I have tables contents, taxonomies, and taxonomy_types and I have set up their relationship like this: Content: public function taxonomies() { return $this->morphToMany('App\Taxonomy', 'taxonomical'); } Taxonomy: public function contents() { return $this->morphedByMany('App\Content', 'taxonomical'); } public function type() { return $this->hasOne('App\Tax

Leff7's avatar
Leff7's avatar tunelessEloquent
1

Handle "No query results for model" from model binding

I am following the series Let's Build A Forum with Laravel and TDD (https://laracasts.com/series/lets-build-a-forum-with-laravel). I want to filter my threads by the channel. To show a thread I go to forum.dev/threads/channelSlug/threadID To view all the threads of a particular channel, I visit forum.dev/threads/channelSlug The problem is that anytime I try viewing all the thre

princelionelnzi's avatar
princelionelnzi's avatar mushketer8...Laravel
4

where between in query builder using date values is not working as expected.

I'm trying to get the data between 2 dates. and this code returns 0 results return Model::whereBetween('created_at', [$this->carbon->startOfWeek(), $this->carbon->endOfWeek()])->get(); this is the query statement it creates when I use toSql(); select * table where created_at between ? and ? but this query works return $this->appointment->whereRaw('`create

skeith22's avatar
skeith22's avatar skeith22Eloquent
1

Using Form Data to Query Table

I have two different roles in my application, Applicants and Agencies. Applicants submit a form (30 questions, all radio buttons) and their answers get saved to the database with question_id, user_id and answer unless they answer "not applicable". Agencies can then use the same form to find people that match the same answers. Something like question_id = 2 and answer

ewistrand's avatar
ewistrand's avatar ewistrandLaravel
7

How can i write mySQL query in laravel controller?

I have a query look like this select t.prod_id, t.datetime,b.branch_id from A t inner join ( select prod_id, max(datetime) as MaxDate from A group by prod_id ) tm on t.prod_id = tm.prod_id and t.datetime = tm.MaxDate inner join B b on b.prod_id = t.prod_id inner join C c on b.prod_id = c.prod_id I wrote in my controller DB::select("select t.prod_id, t.datetime

Crazylife's avatar
Crazylife's avatar dreamxyzGeneral
2

Query builder help

Ministry model public function messages() { return $this->hasMany(Message::class); } public function series() { return $this->hasMany(Series::class); } public function profile() { return $this->hasOne(Profile::class); } I have this method that fetches all messages. The issue is that I want the result to also return th

simioluwatomi's avatar
simioluwatomi's avatar simioluwat...Laravel
4

Laravel Query

I want to build a query in laravel from the given SQL query. select if(count(*) = 0, 'insert', if(count(*) = 1, 'update', if(count(*) > 1, 'multiple records found', 'nothing'))) as required_action from test_importer where 1 and record_id = 1881 and date_time = "1999-21-19 22:33:18";

DoppyWoppy's avatar
DoppyWoppy's avatar DoppyWoppyLaravel
5

Laravel Query

I want to build a query in laravel from the given SQL query. select if(count(*) = 0, 'insert', if(count(*) = 1, 'update', if(count(*) > 1, 'multiple records found', 'nothing'))) as required_action from test_importer where 1 and record_id = 1881 and date_time = "1999-21-19 22:33:18";

DoppyWoppy's avatar
DoppyWoppy's avatar DoppyWoppyLaravel
3

map array DB query

Hi friends ,how to map array DB query sql , i try mapWithKey but it work with eloquent not DB query sql. Db query gives me this result : [{"reference":"maroc1","id":1},{"reference":"maroc2","id":2},{"reference":"maroc3","id":3}] i want this result : {"1":"maroc1","

djmhdi's avatar
djmhdi's avatar djmhdiLaravel
2

ORM scope query with left join and group_concat

Hi guys I want to prepare queries for Excel download. I have 2 models. User and Company with belongsTo/hasMany relationship. User belongs to one company and company can have many users (or none). I have relations defined /* User model*/ public function company() { return $this->belongsTo(Company::class); } /* Company model */ public function users() { return

baguus's avatar
baguus's avatar baguusLaravel
1

Is it possible to create a local query scope that's dependent on an eloquent model relation?

I want to be able to do something like this: //App\User public function membershipType() { return $this->belongsTo(MembershipType::class); } public function scopeMembershipTypeName($query, $membershipTypeName) { return $query->membershipType()->where('name', $membershipTypeName); } This obviously doesn't work because "membershi

bwrice's avatar
bwrice's avatar IgorBabkoEloquent
1

How do you test query to Json columns using sqlite?

Hey folks, I came across an issue testing my queries using SQLite. I need to perform query similar to Product::whereRaw('features->"$.color"', 'red')->first(); This trows sintax error, but works with MySQL Also, I tried the laravel docs way, like so: Product::where('features->color', 'red')->first() but I get null as the result but works with MySQL Th

gocanto's avatar
gocanto's avatar bobbybouwm...Laravel
2

Query Builder is rly slow?

So i make this query $mainData = DB::table('table') ->where('id', $id) ->where('param1', '>', 0) ->where('param2', '>', 0) ->orderBy('param1', 'DESC') ->where('param1', '>=', DB::raw('UNIX_TIMESTAMP((LAST_DAY(DATE_SUB(NOW(), INTERVAL ' . intval($month) . ' MONTH))

dekros's avatar
dekros's avatar SnapeyLaravel
5

Concat Conditionals With Query Builder

Hello, I would like to know if there is a way to concat conditionals on query builder. I'm going to show you an example that doesn't work but gives the idea: $first_name = (isset($request['first_name']))?$request['first_name']:null; $last_name = (isset($request['last_name']))?$request['last_name']:null; $email = (isset($request['email']))?$request['email']:null; $users = DB::t

pdellepiane's avatar
pdellepiane's avatar SnapeyLaravel
2

Database Joins query problem

SQL Server shows output on this query Select * from Vehicle_details, Vehicle_specifications, Vehicle_rent_specs; but not on the query having joins Select vd.VIN_number, vd.Name, vd.Manufacturer, vd.VehicleType, vs.EnginePower, vrs.CostPerDay, vrs.Availability from Vehicle_details vd inner join Vehicle_specifications vs on vd.id = vs.vehicle_details_id inner join Vehicle_rent

Haider's avatar
Haider's avatar DunstiGeneral
2

Query building help

Hi, I am building a link tracking app (a url shortening service). link id name created_at tag id name created_at clicks id link_id created_at link_tag link_id tag_id created_at Every link may have a tag (associated by a pivot table). Clicks have a link_id (which is the id of the link). I'd like to query the database for the number of clicks a given link obtained within

_alchemist's avatar
_alchemist's avatar _alchemistLumen
0

Tip: HTTP Query String Parameters Guard

Have you ever wanted to Guard your HTTP Query String Parameters and prevent the user from manipulating them!? Example: $limit = $req->query('limit', 10); http://localhost:8000/users?limit=1 - $limit = 1 http://localhost:8000/users?limit=5 - $limit = 5 http://localhost:8000/users?limit=11 - $limit = 10 Here is how you can do so: https://gist.github.com/nezarfadle/02e099

nezarfadle's avatar
nezarfadle's avatar nezarfadleTips
0

How to Pass Function Name From Route Database Query

My Page Table -------------------------------------------- ID | Page | FunctionName -------------------------------------------- 1 | Home | home 2 | Welcome | wel Here What i want to achive ----------------> If user click on link, a page id will pass in route. e.g. localhost/test/public/page/1 I want to wr

Kaustubh's avatar
Kaustubh's avatar topvillasLaravel
1

Laravel Query - Be greater or equal to X but be less then Z

So I am running a query as follows: $wealth = DB::table('users') ->select('users.id','users.cash','wealth.wealth','wealth.min_cash','wealth.max_cash') ->join('wealth', 'users.cash', '>=', 'wealth.min_cash') ->where('users.id', '=', $user->id) ->get() ->first(); Basically within my Table I have Wea

option's avatar
option's avatar optionLaravel
3