Laravel throwing error on create method

Question

$permission = new Permission();
$permPost = $permission->create([ 
    'name'        => 'post',
    'slug'        => [          // pass an array of permissions.
        'create'     => true,
        'view'       => true,
        'update'     => true,
        'delete'     => true
    ],
    'description' => 'manage post permissions'
]);

throwing error on passing array within array on create method laravel 5.4 :

Array to string conversion (SQL: insert into permissions (name, slug, description, updated_at, created_at) values (post, 1, manage post permissions, 2017-04-27 05:32:41, 2017-04-27 05:32:41))

What is the error? check your log file and post here. /storage/logs/laravel.log — Squiggs.
– Squiggs., Commented Apr 27, 2017 at 5:55
Array to string conversion (SQL: insert into permissions (name, slug, description, updated_at, created_at) values (post, 1, manage post permissions, 2017-04-27 05:32:41, 2017-04-27 05:32:41)) — D. Pachauri
– D. Pachauri, Commented Apr 27, 2017 at 5:55
You'll need to serialize the slug data to store them in a DB cell... — JazZ
– JazZ, Commented Apr 27, 2017 at 5:56
create function has array within array, so how come first array is being passed correctly? — D. Pachauri
– D. Pachauri, Commented Apr 27, 2017 at 5:57

Thamilhan · Accepted Answer · 2017-04-27 06:07:12Z

3

Laravel allows Array & JSON Casting mutator:

Just update your Permission model to have:

protected $casts = [
    'slug' => 'array',
];

From the docs:

Once the cast is defined, you may access the options attribute and it will automatically be deserialized from JSON into a PHP array. When you set the value of the options attribute, the given array will automatically be serialized back into JSON for storage

So, now you no need to encode manually, Laravel does everything for you automatically! Just pass array as an array.

answered Apr 27, 2017 at 6:07

Thamilhan

13.3k5 gold badges40 silver badges60 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

D. Pachauri Over a year ago

Perfect. Thank you.

Mehrud · Accepted Answer · 2017-04-27 05:59:07Z

3

Try json_encode on slug field, then pass it to the Eloquent to persist in DB:

'slug' => json_encode([
   'create' => true,
   'view'   => true,
   'update' => true,
   'delete' => true
)]

answered Apr 27, 2017 at 5:59

Mehrud

2011 silver badge4 bronze badges

2 Comments

D. Pachauri Over a year ago

yes i know it can work, but my question is why first array is passing correctly.

Mehrud Over a year ago

Laravel out of the box will cast the array into the Eloquent model, but it does not support multi-dimensional arrays, because you are using a RDBMS database, not a NoSql one, unless you use a mutator in your model

Squiggs. · Accepted Answer · 2017-04-27 06:01:02Z

0

Slug is a string in the database. You passing an array to it.

You could store it as JSON or Serialise it, but this is a database design smell. You should think about what other tables you need to store this data properly, depending on how it will be used elsewhere in you application.

answered Apr 27, 2017 at 6:01

Squiggs.

4,5028 gold badges56 silver badges94 bronze badges

Collectives™ on Stack Overflow

Laravel throwing error on create method

3 Answers 3

1 Comment

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related