PHP4 Array Manipulation

[dave2008]

Hi,

I am using php4 to upload a Tab delimited text file into a mysql database.  Each row of data is placed into an array and then appended the database.  What I need to do is add another column/field into the array. 

 

e.g I have my array (field1, field2, field3, field4)

 

What I need to do id insert a new field between field2 and field3

 

The code I am currently using is shown below:

if($action == "insert")
{
  $fcontents = file("paypal.txt");
  # expects the csv file to be in the same dir as this script

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

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

      if(!mysql_error()) 
      {
         echo "<br>Database updated";
      }

}

 

Any help on this would be great

 

Thanks

Dave

 

 

 

[dptr1988]

array_splice() will allow you to insert/delete data from an array.

 

http://us3.php.net/array_splice

 

 

For this example you would probably want to use something like array_splice($input_array, 1, 0, $new_data_to_insert);