Illegal offset type in isset or empty Laravel

Question

I use the following query to get Project Id and Id of Particular Table in Laravel.

$projectlist = Projects::Where('customer',$request->input('client_name'))->pluck(DB::raw("CONCAT('project_prefix','project_nos') AS projectid"),"id");

I got following Error.

message Illegal offset type in isset or empty
exception   ErrorException
file    /var/www/msstone/vendor/laravel/framework/src/Illuminate/Support/Str.php

Project Model

namespace App;

use Illuminate\Database\Eloquent\Model;

class Projects extends Model
{
    protected $guarded = ['id'];

    protected $table = 'projects';

}

Dhananjay Kyada · Accepted Answer · 2019-07-19T07:31:49.160

2

Try by changing the eloquent query from:

$projectlist=Projects::Where('customer',$request->input('client_name'))->pluck(DB::raw("CONCAT('project_prefix','project_nos') AS projectid"),"id");

to

$projectlist = Projects::select(DB::raw("CONCAT(project_prefix,project_nos) AS projectid"),'id')->where('customer',$request->input('client_name'))->pluck("projectid","id");

edited Jul 19 '19 at 07:31

answered Jul 19 '19 at 05:35

Dhananjay Kyada

1,015
1
6
14

Its return "project_prefixproject_nos" – Karthik Jul 19 '19 at 05:39
What are you getting with `dd($projectlist)`? – Dhananjay Kyada Jul 19 '19 at 05:45
1 => "project_prefixproject_nos" 2 => "project_prefixproject_nos" 3 => "project_prefixproject_nos" – Karthik Jul 19 '19 at 05:51
Provide your `Projects` model code. And also `projects` database table. – Dhananjay Kyada Jul 19 '19 at 06:00
Add `database table` or `migration` file for `projects` table as well. – Dhananjay Kyada Jul 19 '19 at 06:07
Let us [continue this discussion in chat](https://chat.stackoverflow.com/rooms/196685/discussion-between-dhananjay-kyada-and-karthik). – Dhananjay Kyada Jul 19 '19 at 06:32

Illegal offset type in isset or empty Laravel

1 Answers1