title: Upload CSV File into multiple table in mysql while loop
body: <p>i've been read similar question in this forum but i still cannot solve my problem so i decide to make the new one.</p>
  
  <p>i want to upload CSV file (single) into mysql database, but i want insert it on different table, here is my code :</p>
  
  <pre><code>$handle = fopen($file_tmp, 'r');
    while (($myData = fgetcsv($handle,1000,';')) !== FALSE) {
      $p1 = mysqli_real_escape_string($db,$myData[0]);
      $p2 = mysqli_real_escape_string($db,$myData[1]);
      $p3 = mysqli_real_escape_string($db,$myData[2]);
      $p4 = mysqli_real_escape_string($db,$myData[3]);
      $p5 = mysqli_real_escape_string($db,$myData[4]);
      $p6 = mysqli_real_escape_string($db,$myData[5]);
      $p7 = mysqli_real_escape_string($db,$myData[6]);
      $p8 = mysqli_real_escape_string($db,$myData[7]);
      $p9 = mysqli_real_escape_string($db,$myData[8]);
      $p10 = mysqli_real_escape_string($db,$myData[9]);
      $p11 = mysqli_real_escape_string($db,$myData[10]);
      $p12 = mysqli_real_escape_string($db,$myData[11]);
      $p13 = mysqli_real_escape_string($db,$myData[12]);
      $p14 = mysqli_real_escape_string($db,$myData[13]);
      $p15 = mysqli_real_escape_string($db,$myData[14]);
      $p16 = mysqli_real_escape_string($db,$myData[15]);
      $p17 = mysqli_real_escape_string($db,$myData[16]);
      $p18 = mysqli_real_escape_string($db,$myData[17]);
      $p19 = mysqli_real_escape_string($db,$myData[18]);
      $p20 = mysqli_real_escape_string($db,$myData[19]);
      $p21 = mysqli_real_escape_string($db,$myData[20]);
      $p22 = mysqli_real_escape_string($db,$myData[21]);
  
      $sql = "START TRANSACTION;";
      $sql .= "INSERT INTO `kualitas_produk`(`responden`,`p1`,`p2`,`p3`,`p4`,`p5`,`p6`,`p7`,`p8`,`p9`) VALUES ('','$p1','$p2','$p3','$p4','$p5','$p6','$p7','$p8','$p9');";
      $sql .= "SELECT LAST_INSERT_ID() INTO @LASTID;";
      $sql .= "INSERT INTO `harga_produk`(`responden`,`p10`,`p11`,`p12`) VALUES (@LASTID,'$p10','$p11','$p12');";
      $sql .= "INSERT INTO `keputusan_pembelian`(`responden`,`p13`,`p14`,`p15`,`p16`,`p17`,`p18`,`p19`,`p20`,`p21`,`p22`) VALUES (@LASTID, '$p13','$p14','$p15', '$p16','$p17','$p18', '$p19','$p20','$p21', '$p22');";
      $sql .= "INSERT INTO `recap`(`responden`,`kualitas`,`harga`,`keputusan`) VALUES (@LASTID,@LASTID,@LASTID,@LASTID);";
      $sql .= "COMMIT;";
  
      mysqli_multi_query($db,$sql) or die("Error: ".mysqli_error($db));
  
    }
  
    fclose($handle);
    echo "Data Added";
    mysqli_close($db);
  </code></pre>
  
  <p>but i got this error </p>
  
  <blockquote>
    <p>Commands out of sync; you can't run this command now</p>
  </blockquote>
  
  <p>i already read about </p>
  
  <blockquote>
    <p>mysqli_free_result, mysqli_next_result, mysqli_store_result</p>
  </blockquote>
  
  <p>but i still dont understand how to use it. Any help will be appreciated.</p>
  
  <p>Thank you.</p>