Laravel 5 2 - Use a String as a Custom Primary Key for Eloquent Table becomes 0

Question

I am trying to use email as my table s primary key  so my eloquent code is-   lt  php  namespace App   use Illuminate Database Eloquent Model   class UserVerification extends Model       protected  table    user verification       protected  fillable                                        email                                    verification token                                        timestamps   false      protected  primaryKey    verification token       And my DB is like this-    but if I do this-  UserVerification  where  verification token    token - gt first      I am getting this-       email    sdfsdf sdfsdf sdf      verification token   0     created at    2016-01-03 22 27 44      updated at    2016-01-03 22 27 44      So  the verification token primary key becomes 0   Can anyone please help

User · Accepted Answer

This was added to the upgrade documentation on Dec 29, 2015, so if you upgraded before then you probably missed it.

When fetching any attribute from the model it checks if that column should be cast as an integer, string, etc.

By default, for auto-incrementing tables, the ID is assumed to be an integer in this method:

https://github.com/laravel/framework/blob/5.2/src/Illuminate/Database/Eloquent/Model.php#L2790

So the solution is:

class UserVerification extends Model
{
    protected $primaryKey = 'your_key_name'; // or null

    public $incrementing = false;

    // In Laravel 6.0+ make sure to also set $keyType
    protected $keyType = 'string';
}

User · Answer

keep using the id      lt  php  namespace App   use Illuminate Database Eloquent Model   class UserVerification extends Model       protected  table    user verification       protected  fillable                                    id                                email                                verification token                                        timestamps   false      protected  primaryKey    verification token         and get the email     usr   User  find  id    token    usr- gt verification token   email   UserVerification  find  token

User · Answer

Theres two properties on the model you need to set  The first  primaryKey to tell the model what column to expect the primary key on  The second  incrementing so it knows the primary key isn t a linear auto incrementing value     class MyModel extends Model       protected  primaryKey    my column        public  incrementing   false      For more info see the Primary Keys section in the documentation on Eloquent

User · Answer

On the model set  incrementing to false  public  incrementing   false    This will stop it from thinking it is an auto increment field   Laravel Docs - Eloquent - Defining Models

User · Answer

I was using Postman to test my Laravel API    I received an error that stated       SQLSTATE 42S22   Column not found  1054 Unknown column  because Laravel was trying to automatically create two columns  created at  and  updated at      I had to enter public  timestamps   false  to my model  Then  I tested again with Postman and saw that an  id    0 variable was being created in my database    I finally had to add public  incrementing false  to fix my API

[php] Laravel 5.2 - Use a String as a Custom Primary Key for Eloquent Table becomes 0

Examples related to php

Examples related to mysql

Examples related to laravel

Examples related to laravel-5

Examples related to eloquent