Using a data file to insert into MYSQL

[Anon]

I currently have one program(perl) that uses a txt file to verify the username and password when loggin into that function.

I also have many php pages, that have user tables in MYSQL. When loggin into these pages, it just looks at the user table to verify that the user is who he says he is. Simple.

My problem is I want to insert all of the users in the cgi created txt file, into my 3 database user tables.

You may ask..well why don't you just do it with perl? Well that part is simple..I can actually do the inserts with perl, BUT one of the program uses an encrypted password which was encrypted using php. So this means I have to insert the password using php and using the md5() function to encrypt the password.

So while I'm at it, I might as well just do everything in php.

Here's the game plan.

open the file which is formatted like this

username|password - email

connect to db1

select to see if the username exists in the usertable.
If it doesn't exist then

encrypt password
insert username,password,email into the usertable

insert the username,password,email into the 2 other db usertables

end if.

SO I know how to do everything except how to open this file and grab the username, the password and the email

Remember. the format of the data file is like this

user|pass - email

I assume there's some function I can use to say grab everything on the line from starting point to the line "|". That's the username!

Then grab everything from after the line "|" to a space. That's the password

Then grab everthing from 2 after the dash "-" to a space or CR. That's the email!

Any help would be appriciated. Not looking for someone to write my code, just if you know how to open a file (fopen maybe) then how to say "grab these values and assign them as variable X,Y,Z"

Petey

[Anon]

$fp = fopen("yourfile.txt");
if ($fp) {

while (!feof($fp)) {

$line = str_replace("-", "|", fgets($fp,1024));
list ($user,$pass,$email) = explode("|", $line);
// Do your checking and insert....
// You might want to trim() the 3 fields first to get rid of all the spaces
....
};
fclose($fp);
}

Not very elegant, but it works... 🙂

[Anon]

Awesome! Looks like it's working!!

Thanks
Petey

[bjdouros]

Here is another way to do it:

<PRE>
<CODE>
$filename = \'file.dat\';

//Open file and read into an array
$lp = @file($filename, \'r\');

//Check file
if(! $lp || $lp == null) {
echo \'Cannot find file\';
exit();
}
else {
//Loop through all lines
for ($i=0; $i < count($lp); $i++) {
$piece = split(\"\|\", $lp[$i]);

  $username = $piece[0];

  $piece = split(\" - \", $piece[1]);

  $password = $piece[0];

  $email = $piece[1];

  echo \"Username: $username <br>\";
  echo \"Password: $password <br>\";
  echo \"Email: $email <br>\";
  echo \"<br>\";
}

}
</CODE>
</PRE>

[bjdouros]

$filename = 'file.dat';

//Open file and read into an array
$lp = @file($filename, 'r');

//Check file
if(! $lp || $lp == null) {
echo 'Cannot find file';
exit();
}
else {
//Loop through all lines
for ($i=0; $i < count($lp); $i++) {
$piece = split("|", $lp[$i]);

  $username = $piece[0];

  $piece = split(" - ", $piece[1]);

  $password = $piece[0];

  $email = $piece[1];

  echo "Username: $username <br>";
  echo "Password: $password <br>";
  echo "Email: $email <br>";
  echo "<br>";
}

}