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 · 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

User · 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

[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