I have the next database: Therefore I have three php models Purchase, Supplier and PurchaseDetail. My model Supplier has a relation hasMany with Purchase: public function purchases() { return $this->hasMany(Purchase::class, 'supplier_id'); } And the model Purchase has a relation hasMany…
so i want to php artisan migrate:fresh but i get this error Base table or view already exists: 1050 Table 'roles' already exists even if i drop the database from phpmyadmin, clean the cache and create the database again it…
I try to use first time Imagick to convert pdf files to images and it dont work for me. When i try use Imagick with images files, its ok and working fine, problem is with PDF files. My test php…
I am a newbie to jquery and ajax and I am using laravel in my backend,"I must say the codes below works perfectly fine for just one of my pages but other pages I get the error above". I tried…
I need to perform a scheduled task in CPanel, I know I should use CRON to do the task every day. I'm using Laravel 7 and PHP version 7.2, I try running task locally on windows and make sure it…
I've looked at similar questions, and the answers I get is to put limit in my query, which I did. Here is the query $sql = DB::table('inventorysku_tb as isku') ->leftJoin('inventorytrackingmodules_tb as itm', function ($join) { $join->where('itm.coID', '=', 4) ->whereBetween('itm.effectiveDate', ['2021-05-01',…
I have started to play with my first Laravel project on a MacOS. I am using Laravel Sail for running the project inside a container and everything seems to work except the debugging part. Versions used: Laravel 8.66, PHP 8.0.12,…
I am using vue cdn link in welcome.blade.php file. I used script in welcome blade. And in app.js I defined vue instances. require('./bootstrap'); import Vue from 'vue'; let app = new Vue({ el:'#app', data:{ name:'project', } }); export default app…
I have 2 table, warehouse and item category, i wanna show my table in select option ajax. I managed to display select option item category. My Ajax Code $(function () { var i = 0; $("#add-more-item").click(function () { ++i; $.ajax({…
I am trying to make a crud function in laravel with custom primary ID. The Create, Read, and Delete are all working but whenever I tried Update I get an error: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'id' in…