[RESOLVED] Upload .txt to mysql ?

[Mark_Nordstrom]

Ok I cant use load data local infile since host doesnt allow it.

The text files are pretty simple all they have is 1 column up to 60 rows. Any idea how i can get this text uploaded into mysql without using load data local infle.

[Mark_Nordstrom]

Ok heres what i got

  $fcontents = file ("$form_data1"); 


  for($i=0; $i<sizeof($fcontents); $i++) { 
      $line = trim($fcontents[$i]); 
      $arr = explode("\t", $line); 

  $sql = "insert into Attendance values ('". 
              implode("','", $arr) ."',')"; 
  mysql_query($sql);
  echo $sql ."<br>\n";
  if(mysql_error()) {
     echo mysql_error() ."<br>\n";
  } 
}

The issue is. My txt files can look something like this.

Mark isuck lol
dan hesucks haha

Columns are seperated by tab. The issue is I only wanna get the first column. I could care less about the rest.

[NogDog]

If you just want the first column, then change implode("','", $arr) to just $arr[0].

[Mark_Nordstrom]

Thanks helped alot.

I ended up just defining the arr[0]; with

$name=$arr[0];

etc