melx's avatar
Level 4

Upload Excel Files

I want to upload an excel file to my database, but my database tables have this structure

       $table->id();
        $table->string('orderNumb');
        $table->integer('customer_id');
        $table->string('loading_point');
        $table->date('looade_date');
        $table->string('border_name');
        $table->integer('team_id');
        $table->string('truck_number');
        $table->string('trailer_number');
        $table->integer('master_qty');
        $table->integer('slave_qty');

How can i insert team_id,border_id because a user can not know this ids because this ids comes from another table,

what can i do a user can fill the name as well and import the excel without mixed the data.

0 likes
2 replies
melx's avatar
Level 4

@a4ashraf , i checked this but i don't see how can i insert ids which reference in another table

Please or to participate in this conversation.