php - 使用 eloquent 获取数据库时出错

Question

我尝试在我的 Laravel 应用程序中使用 eloquent 从 MySQL 数据库获取数据，它在我的代码中显示解析错误:

型号:

<?php

namespace App;

use Illuminate\Database\Eloquent\Model;

class design extends Model {
     //Table Name
     protected $table='designs';
     //Primary key
     public $primarykey='id';
     // TimeStamp
     public $timestamps=true; 
}

Controller 页面:

<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;
use App\design;

class designController extends Controller
{
    /**
     * Display a listing of the resource.
     *
     * @return \Illuminate\Http\Response
     */
    public function index()
    {
        //
        $design=design::all();
        //$design = design::select('Design No','Design Name','Chain Weight/Length','status')->where('status','=','Active')->get();
        return view('pages.design')->with('design',$design);
    }
}

列表页面:
使用 for-each 时发生错误

@extends('layouts.layout')

    @section('content')
        <div class="main">
            <div class="container col-md-12 col-sm-12 col-xs-12">
                <h2 class="text-center">Designs</h2>
                    @if(count($design)>=1)
                    <h2>Done</h2>
                        <div class="table-responsive">
                            <table class="table table-striped table-hover table-bordered">
                                <thead>
                                    <tr>
                                        <th>Design No</th>
                                        <th>Design Name</th>
                                        <th>Weight/Lenght</th>
                                        <th>Action</th>
                                    </tr>
                                </thead>
                                <tbody>
                                @foreach($design as $design)
                                    <tr>
                                        <td>{{$design->Design No}}</td>
                                        <td>{{$design->Design Name}}</td>
                                        <td>{{$design->Chain Weight/Length}}</td>
                                        <td>
                                            <button type="button" class="btn btn-warning">Edit</button>
                                            <button type="button" class="btn btn-danger">{{$design->status}}</button>
                                        </td>
                                    </tr>
                                @endforeach
                                </tbody>
                            </table>
                        </div>
                    @endif
            </div>
        </div>
    @endsection

Answer 1

列名中不允许有空格，应采用小写形式，如数据库中的design_no , design_name

然后获取为

    @foreach($design as $new_designs)

    <td>{{$new_designs->design_no }}</td>
    // and so on
   @endforeach

希望它能发挥作用。