csv not uploading to db using laravel

Question

Controller

public function uploadFile()
{
      if(isset($_POST["uploadFile"])){
        $filePath = realpath($_FILES["file"]["tmp_name"]); //GETTING THE FULL PATH OF THE FILE WHICH WANTS TO BE SAVED INTO THE DB
        $arr = [];
            if (($handle = fopen($filePath, 'r')) !== FALSE){
                $i = 0;
                while (($lineArray = fgetcsv($handle, 4000)) !== FALSE){
                    for ($j=0; $j<count($lineArray); $j++){
                        $arr[$i][$j] = $lineArray[$j];
                    } $i++;
                } fclose($handle);
            }
        $csv = array_slice($arr,1);
        foreach($csv as $line){
          mysqli_query($mysqli, "INSERT INTO dialog(`eType`,`eVal`,`intent`,`reply`) VALUES('$line[0]','$line[1]','$line[2]','$line[3]')"); //FOR EACH LINE SAVE INTO THE DB
        }
      }
}

Route

Route::get('uploadFile', 'Chatbot\ChatbotController@uploadFile');

View

<form method="post" action="{{action('AltHr\Chatbot\ChatbotController@uploadFile')}}" enctype="multipart/form-data">
      <input type="file" name="file"> <br>
      <button type="submit" name="uploadFile" class="btn alt-btn-black btn-xs alt-btn">UPLOAD FILE</button>
</form>

So, Its my first day learning laravel, can somebody tell me why am I having this errror MethodNotAllowedHttpException in RouteCollection.php

I am trying to upload a CSV file in the form to the database. what am I doing wrong here ?

for post request you have to use Route::post routing method, instead of Route::get — Nikhil Radadiya
– Nikhil Radadiya, Commented Jul 19, 2017 at 5:47
Guys, now im having this error "TokenMismatchException in VerifyCsrfToken.php" — Rajveer Singh
– Rajveer Singh, Commented Jul 19, 2017 at 6:00
<input type="hidden" name="_token" id="csrf-token" /> add it in your form — Nikhil Radadiya
– Nikhil Radadiya, Commented Jul 19, 2017 at 6:04

Marcin Orlowski · Accepted Answer · 2017-07-19 05:46:35Z

3

Your route is wrong. Upload is POST request so:

Route::post('uploadFile', 'Chatbot\ChatbotController@uploadFile');

answered Jul 19, 2017 at 5:46

Marcin Orlowski

75.7k11 gold badges128 silver badges152 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Stefano Groenland · Accepted Answer · 2017-07-19 06:15:50Z

-1

The real question is : Why aren't you using Eloquent or atleast the QueryBuilder to insert in the DB

answered Jul 19, 2017 at 6:15

Stefano Groenland

5616 silver badges31 bronze badges

Collectives™ on Stack Overflow

csv not uploading to db using laravel

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related