[RESOLVED] Uploading a .txt to mysql ?

[Mark_Nordstrom]

Ok, i have a small issue. Im trying to upload a .txt file. It has 5 columns and up to 60 rows. What i wanna do is simple really. I wanna delete everything from the .txt but the 2nd column. Then I wanna add 2 columns after it one which will be date.

Ive tried getting queys down to even show the .txt before uploading but cant get that right. Heres what i tried.

$content=file("$form_data1");

// I had to play around with this in order to include the last 2 columns,
//previously it was truncating the column list
$tabbed=implode("",preg_replace('%[	]{2,}%s', "\t", $content));
preg_match_all("%(.*)\t(.*)\t(.*)\t(.*)\t(.*)\t(.*)\t(.*)\t(.*)\t(.*)\t(.*)\t(.*)\t(.*)\t(.*)\t(.*)\t(.*)\t(.*)\t(.*)\t(.*)\t(.*)\t(.*)\t(.*)\t(.*)%miU", $tabbed, $matches);

// print out table
echo '<table border="1">
         <tr>
             <th>'.$matches[1][0].'</th>
             <th>'.$matches[2][0].'</th>
             <th>'.$matches[3][0].'</th>
             <th>'.$matches[4][0].'</th>
             <th>'.$matches[5][0].'</th>
         </tr>';
for ($i=1; $i<count($matches[1]);$i++)
echo '<tr>
             <td>'.$matches[1][$i].'</td>
             <td>'.$matches[2][$i].'</td>
             <td>'.$matches[3][$i].'</td>
             <td>'.$matches[4][$i].'</td>
             <td>'.$matches[5][$i].'</td>
        </tr>';
echo '</table>';

[The_Chancer]

A lot of this will depend on the format of the text file. If the columns are separated by a known character that is not going to be used elsewhere, this would make it quite easy. Split by that character (or explode into array parts) and then only take the 2nd column, trash the array, add the other columns as required and place back into a new text file, then work the next lines as before.

From the newly made text file (if used standard csv formatting would make it much easier), then LOAD DATA LOCAL INFILE syntax to the table required and as they say "Bob is your mothers brother"... 🙂

May be a long way round - but I'm tired and thats all I can think of...

[maxpup979]

Is there any reason you aren't using fgetcsv? It seems to me that this is the perfect use for it. And it may make things much easier.

[Mark_Nordstrom]

i solved the issue thanks