Dear All,
To upload the text file content into a table, I wrote the following code.
<?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];
echo \"$name\";
echo \"$id\";
$insstock=mysql_query(\"insert into class values(\'$name\',\'$id\')\", $dbh);
}
?>
In this code \"todb.txt\" is the text file that contains data to be uploaded. I created table in MySQL as \"create table class(name varchar(20), id integer(5));\"
The code is running well but the problem is it is not inserting any values in the number field and it is inserting 3 additional null values in \"id\" field. If I say select * from class where id=\'NULL\', it is showing all the three rows. I don\'t know where I committed a mistake. So please debug the code and help me in this issue.
Thanking you.
