I'm creating a small webshop where users can create orders and sellers can see the orders. I have defined relationships but the related functions are null. This is how my tables looks like in phpmyAdmin https://imgur.com/a/C2PSmFt This is how I…
I want to run Laravel Job. I'm using supervisord on Centos 7 (with php 7.3). And I want to make query in laravel Job Class. But when I try to make it, It's giving error in below. I wonder where…
I'm having issues with how to deal with tables relationships in laravel. i have three tables Orders table, Order_product table and User table. A User can either be described as a seller or a buyer depending on if they listed…
I have a very strange problem, that I cannot get my head around. I am using Laravel for my backend application, where I am running a very simple query on table with 30k records all with proper indexes on it.…
I need to run a custom query and I have tried all these methods $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…
I have followed this tutorial (https://mydnic.be/post/how-to-build-an-efficient-and-seo-friendly-multilingual-architecture-for-your-laravel-application) about laravel multilanguage and localization. Everything seems ok, except I want to CREATE a CRUD for inserting this posts with title and content in multiple language - and STORE it in database - and…
I'm currently following a laravel/mysql tutorial on lynda and followed the following steps to create a database and connect it to my laravel framework. The following steps helped name my database, change my user name, and password (in which it…
I have written a member function like :: public function details($article_seo){ $articleDet = Articles::where(function($query) { $query->where('article-seo', '=', $article_seo); }) ->get(); dd($articleDet); } and have used these at the beginning of laravel controller:: namespace AppHttpControllers; use IlluminateHttpRequest; use AppHttpRequests; use Apparticles;…