Please can this be done with PHP

obyno

I have been trying to read the contents off three(3) text files comprising phonenumbers, names and addresses, and write them into a database table of three fields of similar names.I want to do the insertion so that each row will have an entry for phonenumbers, names and addresses.Except I keep getting the unwanted results with these codes.Can somebody please look and help urgently?Thanks.Appreciate.
The code I used:

<?php
include "db.php";

$nu = @fopen("phonenumber.txt", "r")
or die(" Failed to open file: phonenumber.txt.");
$array = file("phonenumber.txt");

$nu = @fopen("userlist.txt", "r")
or die(" Failed to open file: userlist.txt.");
$array1 = file("userlist.txt");

$nu = @fopen("password.txt", "r")
or die(" Failed to open file: password.txt.");
$array2 = file("password.txt");

foreach ($array as $fd)
{
foreach ($array1 as $fg)
{
foreach ($array2 as $fx)

{
$myquery = "INSERT into totalled (phoneNumber, user, password) VALUEs ('$fd', '$fg', '$fx')";
$result = mysql_query($myquery, $ok);
if (!$result)
{
echo "Nothing";
}

}
}
}

😕 😕

Drakla

It's the nesting of those foreach loops that's your problem. You only actually want ONE loop. You're basically adding X³ rows of data, when you really want X.

So pseudo code wise change it to this

for ($a=0;$a<numRows;a++)
{
$fd=array1[$a];
$fg=array2[$a];
$fx=array3[$a];

$myquery = "INSERT into totalled (phoneNumber, user, password) VALUEs ('$fd', '$fg', '$fx')"; 

$result = mysql_query($myquery, $ok);

}

I -think-

obyno

The solution you gave was like magic.Worked like milk on a constipated tummy.Thanks and have a nice day ahead of you.Makes me reconsider anew the poor, ordinary common 'for loop'.Thanks a bunch again.😃 😃 🙂 🙂

barand

BTW, you do not need fopen() before you use $array=file()

obyno

but since the data I needed were in a text file already I do not see how I can get at them without first doing the fopen() thing first.Or is there a way....

barand

$array = file('afile.txt') opens the file, reads it into the array then closes the file, all in one statement.

As I said, you do not need the fopen() before file().

obyno

you are right G.You dont need to fopen() to access it.Does doing this rob you of certain facilities fopen() gives you?or are they both on similar levels?

barand

Yes. file() doesn't return a file pointer so you cannot use functions like fgets(), fread() etc and you cannot write to the file.

However it does give a quick, easy method of reading a file into an array.