laravel-8 – Laravel Questions

Category : laravel-8

How to add new value to "auth()" function after login?

31st July 2021 laravel, laravel-8, mysql, php

I am developing a project with Laravel 8. There are fields such as "us_name", "us_surname" in my Users table. After the user is logged in, I can reach these values by saying "auth()->user()->us_name" etc. So far, no problem. What I want to do is add some values here that are not in my table. For ..

How to cache images in laravel 8?

31st July 2021 browser-cache, cache-control, laravel, laravel-8, php

I have stored images in the public folder and access them via API calls. Every time it takes the same amount of time to load those images. It is a very annoying thing. So I need to cache those images without using any external libraries. Sourc..

Laravel 8: How can I pass an additional parameter from controller to collection resource

31st July 2021 collections, laravel, laravel-8, laravel-collection, php

I want to pass an additional parameter from controller to collection resource, Please have a look at the following code, I don’t know why It’s not working. I might be doing something wron here, please help Controller $batchStudents = $batch->students->except($batch->host->id); $batchStudents->test = ‘This is testing’; $students = UserCollection::collection($batchStudents); Collection: class UserCollection extends JsonResource { return ..

Laravel 8 BadMethodCallException

31st July 2021 laravel, laravel-8, php, tinker

I am learning laravel 8, I keep getting this error BadMethodCallException Call to undefined method AppModelsQuestion::factory() at C:UsersUSERDesktoplaravelsqnavendorlaravelframeworksrcIlluminateSupportTraitsForwardsCalls.php:50 46▕ * @throws BadMethodCallException 47▕ */ 48▕ protected static function throwBadMethodCallException($method) 49▕ { ➜ 50▕ throw new BadMethodCallException(sprintf( 51▕ ‘Call to undefined method %s::%s()’, static::class, $method 52▕ )); 53▕ } 54▕ } • Bad Method Call: Did ..

How to fix Laravel Livewire multi language search bug

31st July 2021 laravel, laravel-8, laravel-livewire, multilingual

I’m trying to create a simple search for hotels with live-wire, website is multi language English and Arabic. Search works properly in English only, when I switch into Arabic, The query run properly but the returned value from database is in English. protected function current_locale() { return LaravelLocalization::getCurrentLocale() == ‘ar’ ? ‘_ar’ : ”; } ..

tryin to install laravel clockwork but i have an error which is Install of itsgoingd/clockwork failed

31st July 2021 clockwork, laravel, laravel-8

In laravel 8 I am trying to install laravel clockwork where i have php version 8.0.3 When I run composer require itsgoingd/clockwork command i got this error Installing itsgoingd/clockwork (v5.0.8): Extracting archive Install of itsgoingd/clockwork failed Installation failed, reverting ./composer.json and ./composer.lock to their original content. [UnexpectedValueException] ‘C:xampphtdocstest/vendor/composer/tmp-454cb94cbea8cdcf70c06a4e0164fbba’ is not a zip archive. require [–dev] ..

Select specific column from morph relation according to morhp type in Laravel

31st July 2021 eloquent, laravel, laravel-8, php, relationship

I am trying to write a query which selects columns from a model then selects some column from a morph relationship table. But I have no idea to select column, relation tables has different columns. Some column has no slug, some has. public function index() { $menus = Menu::whereActive(true) ->with([‘menuable’ => function ($q) { // ..

Laravel 8: Undefined index

31st July 2021 laravel, laravel-8, undefined-index

I’m working on a questionnaire project and I ran into an error saying: Undefined index: exams This happened when I was trying to store responses to my database. Here is my controller code: public function store(Math $math) { $data = request()->validate([ ‘responses.*.answer_id’ => ‘required’, ‘responses.*.question_id’ => ‘required’ ]); $exam = $math->exams()->create($data[‘exams’]); $exam->examanswers()->createMany($data[‘examanswers’]); return ‘Thank You’; ..

Request goes through but it doesn’t update database

30th July 2021 crud, laravel, laravel-8, sql-update

I’m doing a laravel crud, everything was going well until it didn’t. Now it seems my update function is not working. Unfortunately I’m not running test, so I don’t know WHEN it started to fail. I made my crud with a crud generator so it did work until recently. This is my Controller public function ..

Laravel: How can I fopen() a file in a local directory?

30th July 2021 csv, laravel, laravel-8, php

I’m using Laravel 8. I have a .csv file stored in /public/data/object.csv. I want to seed a table by parsing this file. This .csv file has n in the strings enclosed by " I tried to import the .csv directly into mySQL, but I’m receiving an error that I have less fields that needed on ..

Laravel Search by 3 values get nothing

30th July 2021 eloquent, laravel, laravel-8, php

I have a bunch of columns in a table what I need is to filter the table using few parameters using laravel Eloquent ORM. For example companyName, StartDate. what I have tried is below $objFetch = OpenOrder::where(‘companyName’, $request->majorCompanies) ->orwhereBetween( ‘StartDate’, array($request->startDate_start, $request->startDate_end) ) ->orderby(‘id’, ‘desc’)->get(); return response()->json([ ‘success’ => true, ‘objects’ => $objFetch ]); "objects": ..

Error "(PDOException(code: 42S22): SQLSTATE[42S22]:"

30th July 2021 laravel, laravel-8, mysql, php

I have the following code to create, load and update some data from specific folder into my DB: static function create_load($file_info,$prefix){ $table_name=$prefix.’_’.Carbon::now()->format("Y_m_d_his"); DB::statement("CREATE TABLE IF NOT EXISTS gathering_db.".$table_name." ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `m_id` int unsigned DEFAULT NULL, `source` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL, `destination` varchar(30) CHARACTER SET utf8mb4 COLLATE ..

Is there anyway to assign a default value of a table equal to the id itself?

30th July 2021 laravel, laravel-8, mysql

So I want to set the default value of the column order equal to the id. This is pretty much for sorting purposes. Is there anyway to do it? Or would there be a better way to achieve the same purpose? Schema::create(‘posts’, function (Blueprint $table) { $table->id(); $table->string(‘title’); $table->bigInteger(‘order’); $table->string(‘path’); $table->text(‘description’)->default(”); $table->timestamps(); }); Sourc..

laravel belongstomany same table Not unique table/alias

30th July 2021 laravel, laravel-8

laravel belongstomany same table error: Not unique table/alias. Help me please. class Categories extends Model { use HasFactory; protected $fillable = [ ‘name’, ‘parent_id’, ‘slug’, ‘title’, ‘description’ ]; public function categories(){ return $this->belongsToMany(Categories::class, ‘categories’, ‘id’, ‘parent_id’ ); } } Sourc..

Laravel migration error – unmatching reference to a column

30th July 2021 eloquent, laravel, laravel-8, migration, php

Schema::create(‘course’, function (Blueprint $table) { $table->integer(‘courseId’)->autoIncrement(); $table->string(‘courseDisplayName’); $table->string(‘courseUniqueName’)->unique(); $table->string(‘courseAddedBy’); $table->dateTime(‘createdOn’); $table->dateTime(‘lastUpdated’); $table->softDeletes(); }); Above given is my course table. To rename the courseId column in it to id, i used the below code. Schema::table(‘course’, function (Blueprint $table) { $table->renameColumn(‘courseId’, ‘id’); }); it shows the migration error – IlluminateDatabaseQueryException SQLSTATE[42703]: Undefined column: 7 ERROR: column "courseid" ..

How to retrieve view data in migration to controller?

30th July 2021 eloquent, laravel, laravel-8, php, sql-view

I’m completely new to the views. I don’t know how to get the view in controller. Below given is the view i have created using migration. I want to fetch the data in this view to my controller. How to do that? Any help is appreciated. class CourseMarketView extends Migration { public function up() { ..

syntax error in creating view on Laravel migration

30th July 2021 database-migration, laravel, laravel-8, php, restapi

I’m completely new to the views. I’ve written the below code in the up method of my migration but when running migrate command, it shows – Syntax error: 7 ERROR: syntax error at or near "FROM" LINE 13: FROM "users" u. I wanted to join the 4 tables – users, course, skills & subjects and ..

Laravel Join returns empty array

30th July 2021 eloquent, inner-join, join, laravel, laravel-8

$users = DB::table(‘users’) ->join(‘course’, ‘users.id’, ‘=’, ‘course.courseId’) ->join(‘skills’, ‘users.id’, ‘=’, ‘skills.id’) ->join(‘subjects’, ‘users.id’, ‘=’, ‘subjects.id’) ->get(); dd($users); This gives me an empty result like this- items: []. I would like to join the 4 tables – users, course, skills & subjects and fetch all the datas in all the 4 tables. users table has the ..

how do i get foreign data through foreign data in laravel

30th July 2021 laravel, laravel-8

I’m struggling to explain this to myself so bare with me. I got these tables: events, eventtypes, users. I got these relation tables: event_eventtype, eventtype_user, event_user I want to get all Events with a certain eventtype that a certain user has. User->Eventtype->Events. user_id = 1, user_id has 3 eventtypes, show all events with these eventtypes. ..

Laravel application hacked by the Laravel_session

30th July 2021 laravel, laravel-8, laravel-session

I have created a Laravel application. After successful login to an account, Laravel makes two cookies which are Laravel_session and XSRF-TOKEN. When I just simply copy the Laravel_session and paste it into another browser or another computer’s browser then it opens the same account. "laravel_session" = "eyJpdiI6IjRwK0VjSDR1c0JGQU9lNDF…" Please, tell me how can I prevent it. ..

How to prevent using user’s session in other computer (like an exploit)

30th July 2021 laravel, laravel-8, laravel-session

I have created a Laravel application. After successful login to an account, Laravel makes two cookies which are Laravel_session and XSRF-TOKEN. When I just simply copy the Laravel_session and paste it into another browser or another computer’s browser then it opens the same account. "laravel_session" = "eyJpdiI6IjRwK0VjSDR1c0JGQU9lNDF…" Please, tell me how can I prevent it. ..

Call to a member function forceDelete() on null although dd($id) returns 19 laravel

30th July 2021 laravel, laravel-8

i want to forceDelete an archieve invoice post but it tells me Call to a member function forceDelete() on null when i write the code at the the controller function named destroyarchieve() i write this return $request; it tells me the id and the request and here it is and i want to know why ..

Laravel belongsToMany – Get Parent All Categories

30th July 2021 belongs-to, laravel, laravel-8, php

I can not speak English well. Iam Sorry. i want to do, get all categories to which the category with id 5 is attached where is error editing ? Database: Categories.php class Categories extends Model { use HasFactory; protected $fillable = [ ‘name’, ‘parent_id’, ‘slug’, ‘title’, ‘description’ ]; public function parentCategories(){ return $this->belongsToMany(Categories::class); } } ..

Laravel 8.0 pagination() shows "previous" & "Next" instead of page numbers

30th July 2021 laravel, laravel-8, php

In my local environment pagination works perfectly fine it shows page numbers and I’m using tailwind but when I deploy my app on Heroku, pagination shows the "previous" & "next" buttons only even though I’m not using simplePagination and I’m not sure why. Here is what I tried to do to fix it : I ..

guzzlehttp throwing error on laravel project – strtolower(): Argument #1 ($string) must be of type string, int given

29th July 2021 guzzle, laravel, laravel-8, php

I am trying to consume one POST api using guzzlehttp In my laravel project. But i am getting one error on my dev server. This working perfectly on my local system. $postArray is manipulating correctly both side. This is my composer version. "guzzlehttp/guzzle": "^7.3", If any one know about this please help me out. $response ..