PHP - Save Data In Form

Hi,

I'm trying to save data from an array to database but something is wrong. This is from i send data, as you see im using arrays [] because the user have the posibility to clone the row

<div class="box-body">
                 <div class="form-group">
                  <label class="col-sm-2">Student</label>
                  <div class="col-sm-10">                    
			<table id="table" border="1" bordercolor="#00acc1">
            
                          <thead>
                            <tr>
                              <th><p>Name</p></th>
                              <th><p>Mode</p></th>
                              <th><p>Sport</p></th>
                              <th>&nbsp;</th>
                            </tr>
                          </thead>

                          <tbody>
                         
                            <tr>
                              <td><select style="width:325px" name="Name[]" class="form-control">
                                      <option value="">Select</option>
                                        <?php
                                        $search = "SELECT * FROM prof";
                                        $data = $connect->prepare($search); 
                                        $data->execute();
                                        while($re=$data -> fetch(PDO::FETCH_ASSOC)){
                                          echo "<option value = '".$re['id']."'>";
                                          echo $re['n_prof'].' '.$re['ap_prof'];}
                                        ?>
                                  </select>
                             </td>
                                 <td>
                                <select class="form-control" name="mode[]" style="width:150px"  />
                                  <option value="">Select</option>
                                  <option value="Administrator">Administrator</option>
                                  <option value="Scholar">Scholar</option>
                                  <option value="External student">External student</option>
                                  <option value="Thesis">Thesis</option>
                                  <option value="Voluntary">Voluntary</option>
                                </select>
                              </td>
                           <td>
                                <select class="form-control" name="Sport[]" style="width:150px"  />
                                  <option value="">Select</option>
                                  <option value="Football">Football</option>
                                  <option value="Baseball">Baseball</option>
                                  <option value="Swimming">Swimming</option>
                                  <option value="Horse riding">Horse riding</option>
                                  <option value="basketball">basketball</option>
                                </select>
                              </td>
                              <td class="Delete">Delete</td>
                            </tr>

                         
                          </tbody>
                        </table>
                        <input type="button" id="add" value="+ add student"  class="btn btn-primary"/>


                  </div>
                </div>
              </div>

my db.table is like this

id  | name  |  mode  | sport  | idstudent_fk

And Im using an algorithm to read the array and every time can save every row, but im usind PDO and im having problems

try{

here i insert data in a table
here i got the last id from that table then ...

if($_POST['name']!="" and $_POST['mode']!="" and $_POST['sport']!=""){
							 	if(is_array($_POST['name'])){
									while(list($key, $name) = each($_POST['name']) 
							 		  and list($val,$mode) = each($_POST['mode'])
							 		  and list($id, $sport) = each($_POST['sport'])){
                             $sql = "INSERT INTO sports(id_studentfk, mode_stu, sport, id_projfk) 
											values(:value, :mode, :sport, :lastid)";
											$statement = $connect ->prepare($sql);
											$statement -> bindParam(':name', $name, PDO::PARAM_INT);
											$statement -> bindParam(':mode', $mode, PDO::PARAM_STR);
											$statement -> bindParam(':sport', $sport, PDO::PARAM_STR);
											$statement -> bindParam(':lastid', $lastid, PDO::PARAM_INT);
									    	$pdoExec = $statement -> execute();
							 		}
}//end if array
}//end if post
} catch (PDOException $e) {
						     print 'ERROR: '. $e->getMessage();
						     print '<br/>Data Not Inserted';
						}

the idea is creating a loop to read the array and every time can insert data. Im using PDO this time is not working, im geeting this error

ERROR: SQLSTATE[HY093]: Invalid parameter number: parameter was not defined
Data Not Inserted

I hope someone can help me to solve this

What is the best way to store this data coming from the api into a csv file to later put into the db. Output: rank, level, xp, rank, level, xp, etc. This api produces about 60 rows of data per name ran and x that by about roughly 300 names that equals a lot of data. Pretty much with my current code I am pretty much creating a endless loop almost that would take a long time to execute so updating said data would be a nightmare i would think. Is there a way to accomplish the same thing without the loop or I am not sure how to go about this. My current code is a mess that much I know I am gonna be told. This code works, just not efficiently. I am thinking there may be a better way to do this.

$query = $conn->prepare("SELECT name FROM users LIMIT 1");
$query->execute();

while($row = $query->fetch(PDO::FETCH_ASSOC)){
  $name = $row['name'];
  $url = 'https://secure.runescape.com/m=hiscore/index_lite.ws?player='. 
  $name . '';//api that the csv data is coming from 
  $highscores = file_get_contents($url);
  $fields = array("Name", "Rank", "Level", "Xp");//this is to add the headers 
 // for the csv files
  $implode1 = implode($fields, ",");//turn into csv format, not sure this is 
  //even needed
  $implode1 .= "\n";/*this is to add a line break so that the explode below 
   will properly put it into its own element*/
   //otherwise data starts joining togather
  $extra_data = array("$name");/*This is to add the name that the data
  pertains too*/
  $implode2 = implode($extra_data, ",");//turn into csv format
  $highscores =  $implode1 . $implode2 . $highscores;//join as one array    
  $highscores = explode("\n", $highscores);//turn each csv into an element of 
  //its own element
  a bunch of unsets to remove unwanted data. Omitted them to condense the code
  $i = 1;
  header('Content-Type: text/csv');
  header('Content-Disposition: attachment; filename="name.csv"');

  $data = $highscores;

  $fp = fopen('highscores/' . $name . '.csv', 'wb');
  foreach ( $data as $line ) {
     $val = explode(",", $line);
     fputcsv($fp, $val);
 }
   fclose($fp); 

The pdo part I was gonna include but the way I have it setup now wouldn't work. I was thinking that I would use mysql's LOAD DATA INFILE to insert the csv data to database. The end goal here is to be able to search for player stats and to use said data to keep track of xp earned during a xp competition. I PRAY that i have included enough info... I would really appreciate any feedback if possible.