Laravel 5.2 - 雄辩的模型查询(Laravel 5.2 - Eloquent Model Query)

 我在使用Eloquent模型尝试执行一个非常基本的查询时遇到了麻烦，其中创建和查找都工作正常，但没有返回任何内容。 
 
 模型： 
 
namespace App;
use Illuminate\Database\Eloquent\Model;

class Company extends Model
{
protected $table = 'companies';
protected $fillable = ['name', 'ticker', 'industry', 'sector', 'description'];
protected $visible = ['name', 'ticker', 'industry', 'sector', 'description'];
}
 
 控制器： 
 
 创建工作正常： 
 
\App\Company::create(['ticker'=>'AAPL', 'name' => 'Apple Inc']);
 
 在DB上创建一个新行： 
 
 
 
 （id，name，ticker） 
 
 
 1，Apple Inc，AAPL 
 
 
 找工作正常： 
 
$company = \App\Company::find(1);
print_r($company);
 
 回报 
 
 
 
 App \ Company Object（[table：protected] => companies [fillable：protected] => Array（[0] => name [1] => ticker [2] => industry [3] => sector [4] = > description）[visible：protected] => Array（[0] => name [1] => ticker [2] => industry [3] => sector [4] => description）[connection：protected] => [primaryKey：protected] => id [perPage：protected] => 15 [递增] => 1 [时间戳] => 1 [属性：受保护] =>数组（[id] => 1 [名称] => Apple Inc [ticker] => AAPL [行业] => [部门] => [描述] => [created_at] => 2016-01-14 00:01:35 [updated_at] => 2016-01-14 00:01： 35）[original：protected] => Array（[id] => 1 [name] => Apple Inc [ticker] => AAPL [industry] => [sector] => [description] => [created_at] => 2016-01-14 00:01:35 [updated_at] => 2016-01-14 00:01:35）[关系：保护] =>数组（）[隐藏：保护] =>数组（）[追加：保护] => Array（）[guarded：protected] => Array（[0] => *）[dates：protected] => Array（）[dateFormat：protected] => [casts：protected] = > Array（）[touches：protected] => Array（）[observables：protected] => Array（）[with：protected] => Array（）[morphClass：protected] => [exists] => 1 [wasRecentlyCreated] =>） 
 
 
 
 现在，当我尝试搜索除id之外的任何字段时，它根本不会返回任何内容： 
 
$company = \DB::table('companies')->select('ticker', 'name')->where('ticker', '=', 'AAPL')->get();
print_r($company);
 
 返回一个空数组： 
 
 
 
 数组（） 
 
 
 两者： 
 
$company = \App\Company::find(['ticker', 'AAPL'])->first();
print_r($company);
 
 和： 
 
$company = \App\Company::where('ticker', '=', 'AAPL')->first();
print_r($company);
 
 他们根本就什么都不回报。 
 
 ---更新--- 
 
 移民： 
 
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;

class CreateCompaniesTable extends Migration
{   
    public function up()
    {
        Schema::create('companies', function (Blueprint $table) {
            $table->increments('id');
            $table->string('name')->unique();
            $table->string('ticker');
            $table->string('industry')->nullable();
            $table->string('sector')->nullable();
            $table->text('description')->nullable();
            $table->timestamps();
        });
    }

    public function down()
    {
        Schema::drop('companies');
    }
}

I'm having trouble trying to perform a really basic query using an Eloquent Model, where create and find both work fine but where returns nothing.
 
Model:
 
namespace App;
use Illuminate\Database\Eloquent\Model;

class Company extends Model
{
protected $table = 'companies';
protected $fillable = ['name', 'ticker', 'industry', 'sector', 'description'];
protected $visible = ['name', 'ticker', 'industry', 'sector', 'description'];
}
 
Controller:
 
Create works fine:
 
\App\Company::create(['ticker'=>'AAPL', 'name' => 'Apple Inc']);
 
creates a new row on the DB:
 
 
 
(id, name, ticker)
 
 
1, Apple Inc, AAPL
 
 
Find works fine:
 
$company = \App\Company::find(1);
print_r($company);
 
returns
 
 
 
App\Company Object ( [table:protected] => companies [fillable:protected] => Array ( [0] => name [1] => ticker [2] => industry [3] => sector [4] => description ) [visible:protected] => Array ( [0] => name [1] => ticker [2] => industry [3] => sector [4] => description ) [connection:protected] => [primaryKey:protected] => id [perPage:protected] => 15 [incrementing] => 1 [timestamps] => 1 [attributes:protected] => Array ( [id] => 1 [name] => Apple Inc [ticker] => AAPL [industry] => [sector] => [description] => [created_at] => 2016-01-14 00:01:35 [updated_at] => 2016-01-14 00:01:35 ) [original:protected] => Array ( [id] => 1 [name] => Apple Inc [ticker] => AAPL [industry] => [sector] => [description] => [created_at] => 2016-01-14 00:01:35 [updated_at] => 2016-01-14 00:01:35 ) [relations:protected] => Array ( ) [hidden:protected] => Array ( ) [appends:protected] => Array ( ) [guarded:protected] => Array ( [0] => * ) [dates:protected] => Array ( ) [dateFormat:protected] => [casts:protected] => Array ( ) [touches:protected] => Array ( ) [observables:protected] => Array ( ) [with:protected] => Array ( ) [morphClass:protected] => [exists] => 1 [wasRecentlyCreated] => )
 
 
 
Now when I try to search by any field other than the id it simply doesn't return anything:
 
$company = \DB::table('companies')->select('ticker', 'name')->where('ticker', '=', 'AAPL')->get();
print_r($company);
 
returns an empty array:
 
 
 
Array ( ) 
 
 
And both:
 
$company = \App\Company::find(['ticker', 'AAPL'])->first();
print_r($company);
 
and:
 
$company = \App\Company::where('ticker', '=', 'AAPL')->first();
print_r($company);
 
they simply return nothing at all.
 
---Update---
 
Migration:
 
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;

class CreateCompaniesTable extends Migration
{   
    public function up()
    {
        Schema::create('companies', function (Blueprint $table) {
            $table->increments('id');
            $table->string('name')->unique();
            $table->string('ticker');
            $table->string('industry')->nullable();
            $table->string('sector')->nullable();
            $table->text('description')->nullable();
            $table->timestamps();
        });
    }

    public function down()
    {
        Schema::drop('companies');
    }
}

原文：https://stackoverflow.com/questions/34779734