SQLSTATE[42S22]：未找到列：1054 php中的未知列

Question

我正在制作一个我想登录和注册的应用程序，并且能够将csv文件导入数据库，注册和登录工作正常，但是当我想导入csv时，我遇到了这个问题：

错误luminate\Database\QueryException SQLSTATE[42S22]：未找到列：1054“where子句”中的未知列“classe”（SQL:select*fromaccountswhere（classe=7和nocompte=7598）限制1）科目表

use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;

class CreateAccountsTable extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::create('accounts', function (Blueprint $table) {
            $table->increments('id');
            $table->integer('AccountClass');
            $table->integer('AccountNumber');
            $table->string('AccountDesc');
            $table->timestamps();
        });
    }

    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        Schema::dropIfExists('accounts');
    }
}

账户控制员

<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;
use App\Accounts;
class AccountController extends Controller
{
    public function show(){
        return view ('upload');
    }
    public function store(Request $request){
        $upload = $request->file('upload-file');
        $filePath = $upload->getRealPath();
        $file = fopen($filePath,'r');
       $fileconverted =  mb_convert_encoding($file, 'UTF-16LE', 'UTF-8');
        $header = fgetcsv($file);
        // dd($header);
        $escapedHeader = [];
        foreach ($header as $key =>  $value){
            $header1=strtolower($value);
            $escapedItem=preg_replace('/[^a-z]/', '' ,$header1);

array_push($escapedHeader,$escapedItem);
        }
        while($columns=fgetcsv($file)){
            if($columns[0]==""){
                continue;
            }
           //trim data
           foreach ($columns as $key => &$value) {
            $value=preg_replace('/\D/','',$value);
        }
       $data= array_combine($escapedHeader, $columns);
    //    dd($data);
        }
        $AccountClass = $data['classe'];
        $AccountNumber = $data['nocompte'];
        $AccountDesc =  $data['libell'];
        $Accounts= Accounts::firstOrNew(['classe'=>$AccountClass,'nocompte'=>$AccountNumber]);
        $Accounts->AccountClass=$AccountClass;
        $Accounts->AccountNumber=$AccountNumber;
        $Accounts->AccountDesc=$AccountDesc;

        $Accounts->save();


    }
}

Answer 1

您告诉它查询“accounts”表，查找名为'classe'的字段：

Accounts::firstOrNew(['classe'=>$AccountClass,'nocompte'=>$AccountNumber]);

也许你是说会计班？

Accounts::firstOrNew(['AccountClass' => $AccountClass, ...]);

调整后，您将遇到与'nocompte'相同的错误，该表中也不存在该错误。。。