Illuminate\Database\QueryException SQLSTATE[42S22]: Column not found: 1054 Unknown column 'name' in 'field lis
Bonjour à vous, bien je débute avec Laravel 6.0.4 et actuellement je rencontre un problème qui est le suivant:
Citation:
Illuminate\Database\QueryException
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'name' in 'field list' (SQL: insert into `clients` (`name`, `updated_at`, `created_at`) values (1, 2019-10-06 14:58:18, 2019-10-06 14:58:18)).
du coup je ne comprends pas le problème car je pense que tout est bon.
Voici la migration:
Code:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31
|
public function up(){
Schema::create('clients', function (Blueprint $table) {
$table->bigIncrements('id');
$table->string('nom')->nullable();
$table->string('prenom')->nullable();
$table->date('dateNais')->nullable();
$table->string('email')->nullable();
$table->integer('telephone')->nullable();
$table->string('sexe', '50')->nullable();
$table->double('taille')->nullable();
$table->string('permis')->nullable();
$table->date('dateDel')->nullable();
$table->string('Bp', '50')->nullable();
$table->string('adres', '50')->nullable();
$table->string('civilité', '50')->nullable();
$table->integer('nbrEnfs')->nullable();
$table->integer('nbrPrs')->nullable();
$table->timestamps();
});
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::dropIfExists('clients');
} |
voici mon controller:
Code:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26
| public function create(){
$nom = request('nom');
$prenom = request('prenom');
$dateNais = request('dateNais');
$email = request('email');
$tel = request('tel');
$permis = request('permis');
$dateDel = request('dateDate');
$Bp = request('Bp');
$adres = request('adres');
$contract = request('contract');
$Client = new Client();
$Client -> name = $nom;
$Client -> name = $prenom;
$Client -> name = $dateNais;
$Client -> name = $email;
$Client -> name = $tel;
$Client -> name = $permis;
$Client -> name = $dateDel;
$Client -> name = $Bp;
$Client -> name = $adres;
$Client -> name = $contract;
$Client -> save();
} |
.
du coup j'ai besoin d'aide parce que là suis à cours d'idées :pc::arf:
merci d'avance.