mercredi 18 septembre 2019

How to fix SQL syntax error with Laravel?

I make controller about input data Combobox, and I input data appear SQL syntax error. how to fix the error?

I have tried to fix, name of column database is id_makanan, file, nama_makanan, kode jenis, created_at, updated_at. but in error said

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'makanan' in 'field list' (SQL: insert into makanan (file, makanan, jenis, updated_at, created_at) values (1568873326_272484-P5VPQM-122.jpg, Burger, 3, 2019-09-19 06:08:46, 2019-09-19 06:08:46))

In controller

namespace App\Http\Controllers;

use Illuminate\Http\Request;
use App\Gambar;
use App\JenisMkn;
use App\cmb;
use Input;
//use File;

class MakananController extends Controller
{
    public function index()
    {
        $makanan = Gambar::all();
        return view('makanan', ['makanan'=>$makanan]);
    }
    public function input()
    {
        $jenis = JenisMkn::select('id_jenis','jenis_makanan')->get();
        return view('upload_gambar',['jenis'=>$jenis]);
    }
    public function proses(Request $request)
    {
        $this->validate($request,[
            'file'=>'required|file|image|mimes:jpeg,png,jpg|max:2048',
            'makanan'=>'required',
            'jenis'=>'required',
        ]);

        $file = $request->file('file');
        $nama_file = time()."_".$file->getClientOriginalName();

        //nama folder tempat file diupload
        $tujuan_upload = 'image_file';
        $file->move($tujuan_upload,$nama_file);

        Gambar::create([
            'file' =>$nama_file,
            'makanan'=>$request->makanan,
            'jenis'=>$request->jenis,
        ]);
        return redirect('/makanan');
    }
}



via Chebli Mohamed

Aucun commentaire:

Enregistrer un commentaire