Uploading Textfile data into database

[Anon]

Dear All,
I tried to upload the contents of a text file data by constructing a MySQL table like this:
Create table class(name varchar(20),id integer(2));
My code to upload data is:

<?php
$aryInput = file("C:/Program Files/Apache Group/Apache/htdocs/myphpworks/todb.txt", "r");
$user = "root";
$pass = "root";
$db = "myworks";
$dbh = mysql_connect ("localhost",$user, $pass);
if (! $dbh)
{
print "Error connecting to the Database Engine<br>";
}
mysql_select_db ($db);
echo "<br>";
for($i=0;$i<count($aryInput);$i++)
{
$aryInputLine=explode(" ",$aryInput[$i]);
$name=$aryInput[$i];
$id=$aryInput[$i];
print "\t<td width = 50%>&nbsp$name</td>\n";
print "\t<td width = 50%>&nbsp$id</td>\n";
$insstock=mysql_query("insert into class values('$name','$id')", $dbh);
}
?>

Now the problem with this code is it is not inserting the second value of the text file into database(i.e., number field). I don't know where I comitted a mistake. Please help me in this issue. I am strucked.

[deshpande]

Hi,
I tried it & it's working for me..

I used 2 files..

file 1: todb.txt
umesh 1

shastry 2

file 2:upload.php

---

<?php
$user = "umesh";
$pass = "shastryak";
$db = "test";
$dbh = mysql_connect ("localhost",$user, $pass);
if (! $dbh)
{
print "Error connecting to the Database Engine<br>";
}
mysql_select_db ($db);

$row = 1;
$fp = fopen ("todb.txt","r");
while ($data = fgetcsv ($fp, 1000, " ")) {
$num = count ($data);
$row++;
for ($c=0; $c<$num; $c++) {
$name=$data[$c];$id=$data[++$c];

}
print "$name $id";
$insstock=mysql_query("insert into class values('$name','$id')", $dbh);
print "<br>";

}
fclose ($fp);

?>

---

--Shastry