I am trying to Run This Query from laravel Query Builder But it returns an empty response but when I get the query from the query log and run this in phpMyadmin it response with data. Project::join('project_assignation','projects.id','project_assignation.project_id') ->join('users','project_assignation.employee_id', 'users.id') ->join('eods',…
Why am I getting a 403 forbidden error only on put request API from CentOS 7 vps server (while get/post are working well)? The same piece works fine on a shared hosting server and from localhost. I am using "Nginx…
I Have following query for mysql. phpMyAdmin 4.0.10.10 SELECT * FROM `table_name` WHERE DATEDIFF(NOW(), start_date) = 154 I need an equivalent query for Laravel to use DATEDIFF function in where clause.
I am getting error in Laravel 5.7: IlluminateDatabaseQueryException SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'name' cannot be null (SQL: insert into stores (name, matric, phone, email, password, updated_at, created_at) values (?, ?, ?, ?, ?, 2019-10-01 16:29:49, 2019-10-01 16:29:49)) This…
I am building a dashboard to control couple different websites (each is in a cPanel separate account (including the Dashboard), but all hosted on the same server). The dashboard will use php's shell_exec for example to execute shell commands inside…
there are some similar questions but not what i exactly want. how can i increase this limit. what is file destination where can i replace this number (767 bytes) with another. -- Dumping structure for table jofr.categories CREATE TABLE IF…
I am following this tutorial here https://www.youtube.com/watch?v=Jbt5bEgv_QM and got stuck in the php artisan migrate part because of this issue. I'm not sure if it's compatibility issue or something. I am fairly new to laravel. Here's the database.php file and…
I have a little doubt about a loop that I am doing, because it is returning empty values. First, I am receiving my items like this: $items = Session::get('items'); $deco = json_decode($items, true); If I return $deco I get this:…
I have reinstall my ubuntu 1.04.3. First of all I installed php: 7.2.19, nodejs: 12.10.0, apache and mysql. After that I installed gloabally the composer and some php extentions that said that were needed to install Laravel and finished with…
First of all, the problem is about Laravel not postgresql or PHP. I can connect postgresql with a simple PHP file. But Laravel can't do it somehow. When I try to connect postgresql server in my computer with laravel I…