lundi 3 décembre 2018

Laravel - Inserting Two Select Values to Database

I want to insert the destination input value to database but it is giving me an error see here. what is the problem?

SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'destination' cannot be null (SQL: insert into aircraft_flights (flight_number, iata_flight_number, flight_date, departure_time, arrival_time, from_location, destination, aircraft_id) values (FK2457, SQ1, 2018-03-02T04:03, 2018-04-04T04:25, 2018-05-06T16:02, Philippines, , 4))

here is my Form Input of Destination

 <div class="col-md-4 col-sm-4 ">
     
    <br>
</div>
<br>

<div class="col-md-4 col-sm-4 ">
     
    <br>
</div>
<br>

my Migration

 $table->increments('id');
        $table->string('flight_number');
        $table->string('iata_flight_number');
        $table->dateTime('flight_date');
        $table->dateTime('departure_time');
        $table->dateTime('arrival_time');
        $table->string('from_location');
        $table->string('destination');
        $table->integer('aircraft_id');

my Controller

 $aircraftFlight = new AircraftFlights;
    $aircraftFlight->flight_number = $request->input('flight_number');
    $aircraftFlight->iata_flight_number = $request->input('iata_flight_number');
    $aircraftFlight->flight_date     = $request->input('flight_date');
    $aircraftFlight->departure_time = $request->input('departure_time');
    $aircraftFlight->arrival_time = $request->input('arrival_time');
    $aircraftFlight->from_location = $request->input('from_location');
    $aircraftFlight->destination     = $request->input('destination ');
    $aircraftFlight->aircraft_id = $request->input('aircraft_id');

    $aircraftFlight->save();

    return redirect('/admin/aircraftflights')->with('success', 'Flight Created');

my Model

protected $table = 'aircraft_flights';
// Primary Key
public $primaryKey = 'id';
// Timestamps
public $timestamps = false;



via Chebli Mohamed

Aucun commentaire:

Enregistrer un commentaire