read text dile, then submit results to a database

poe

i want to tak a text file which is a table and take the contents of each sell and add to a database

here is what i have:

// open the text file and read the entire file into $filegets.
$handle = @fopen('mytextfile.txt', "r");
if ($handle) {
while (!feof($handle)) {
$buffer = fgets($handle, 4096);
$filegets = $filegets . $buffer;
}
fclose($handle);
}

// extract from start of table to close of table
$start = "<table border=0>";
$end = "</table>";
$tmpget = explode($start,$filegets);
$result = explode($end,$tmpget[1]);

echo "<table>";
echo $result[0];
echo "</table>"

// this is what i get:

<tr>
<td class=black9>2005</td>
<td class=black9>NYY</td>
<td class=black9>Jeter</td>
</tr>

<tr>
<td class=black9>2005</td>
<td class=black9>BOS</td>
<td class=black9>Ortiz</td>
</tr>
</table>

so i want to now, instead of showing the results as a table, i want to make into an array for each 'table row' and then i can add to a database.

Stathy

The documentation below has plenty of sample inserts.

http://us3.php.net/manual/en/ref.mysql.php

Should state what database you are using as well as provide the table schema.

For something more "abstract" :
http://pear.php.net/manual/en/package.database.db.php

sys4dm1n

http://us3.php.net/manual/en/ref.mysql.php will help you.