MD5 encrypt a list of password from a file

[Declan Barry]

Hi all..

Does anyone have a php script that would allow me to encrypt the
contents of a txt file?

I have an excel file which has a list of usernames and generated
passwords. What I would like to do is copy out the plaintext
passwords to a txt file and then do a conversion to encrypt the
passwords using MD5 encryption as they will then be imported into a
MySQL database.

Is that possible?

I can do them one at a time using a small php script but I've approx
100+ to do.

Regards

Declan Barry

[Jerry Stuckle]

Declan Barry wrote:

Hi all..

Does anyone have a php script that would allow me to encrypt the
contents of a txt file?

I have an excel file which has a list of usernames and generated
passwords. What I would like to do is copy out the plaintext
passwords to a txt file and then do a conversion to encrypt the
passwords using MD5 encryption as they will then be imported into a
MySQL database.

Is that possible?

I can do them one at a time using a small php script but I've approx
100+ to do.

Regards

Declan Barry

I wouldn't even write code for it. Just export the data to CSV, import
it into MySQL and do it from there.

For instance, if your excel file has

userid password

Create three columns in your table - uid, temppw and pw. Export the
Excel file as CSV format and load it into the table. Then simply update
the table, setting pw to MD5(temppw).

The just drop the temppw column.

No programming required.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
js*******@attglobal.net
==================

[Nicholas Sherlock]

Declan Barry wrote:

Does anyone have a php script that would allow me to encrypt the
contents of a txt file?

Note that MD5 is not encryption. It is a hash that irreversibly
transforms input into a small (8 byte?) value.

Cheers,
Nicholas Sherlock

[Jasen Betts]

On 2006-02-08, Declan Barry <dp*****@barryweb.co.uk> wrote:

Hi all..

Does anyone have a php script that would allow me to encrypt the
contents of a txt file?

I have an excel file which has a list of usernames and generated
passwords. What I would like to do is copy out the plaintext
passwords to a txt file and then do a conversion to encrypt the
passwords using MD5 encryption as they will then be imported into a
MySQL database.

Is that possible?
I can do them one at a time using a small php script but I've approx
100+ to do.

php has loops... past them into an array in your script ...
Bye.
Jasen

[Bandit]

Hi Jerry..

Thanks for that. I later discovered that on another website but I
also found a VBA macro that I was able to plug into excel to do the
same way. Mind you, the method you described sounds easier.

One query though. What happens if you already had some password data
in there in the first place. Does it get encrypted (.Sorry.. Hashed)
again thus making the original hash totally whacked out?

Declan

On Wed, 08 Feb 2006 16:53:20 -0500, Jerry Stuckle
<js*******@attglobal.net> wrote:

Declan Barry wrote:

Hi all..

Does anyone have a php script that would allow me to encrypt the
contents of a txt file?

I have an excel file which has a list of usernames and generated
passwords. What I would like to do is copy out the plaintext
passwords to a txt file and then do a conversion to encrypt the
passwords using MD5 encryption as they will then be imported into a
MySQL database.

Is that possible?

I can do them one at a time using a small php script but I've approx
100+ to do.

Regards

Declan Barry

I wouldn't even write code for it. Just export the data to CSV, import
it into MySQL and do it from there.

For instance, if your excel file has

userid password

Create three columns in your table - uid, temppw and pw. Export the
Excel file as CSV format and load it into the table. Then simply update
the table, setting pw to MD5(temppw).

The just drop the temppw column.

No programming required.

[Bandit]

Hi Nicholas..

Thanks for that. I gathered initially that I was using the phrase
incorrectly but thought I'd use it to describe it in its simplistic
form.

What is the difference actually?

Declan

On Thu, 09 Feb 2006 13:14:19 +1300, Nicholas Sherlock
<N.********@gmail.com> wrote:

Declan Barry wrote:

Does anyone have a php script that would allow me to encrypt the
contents of a txt file?

Note that MD5 is not encryption. It is a hash that irreversibly
transforms input into a small (8 byte?) value.

Cheers,
Nicholas Sherlock

[Jerry Stuckle]

Bandit wrote:

Hi Jerry..

Thanks for that. I later discovered that on another website but I
also found a VBA macro that I was able to plug into excel to do the
same way. Mind you, the method you described sounds easier.

One query though. What happens if you already had some password data
in there in the first place. Does it get encrypted (.Sorry.. Hashed)
again thus making the original hash totally whacked out?

Declan

On Wed, 08 Feb 2006 16:53:20 -0500, Jerry Stuckle
<js*******@attglobal.net> wrote:

Yes, in this means it would be hashed again.

If all the passwords are hashed, just don't do the MD5 step. If none of
them are hashed, you need to do the MD5 step.

But if some of them are hashed and some not, you'll have to examine each
record individually and hash those which aren't.

Or, if you have two password columns in your Excel table (one plain, one
hashed), you could just hash them for those which aren't already hashed
(i.e. hashed pw length = 0).

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
js*******@attglobal.net
==================

[Jerry Stuckle]

Bandit wrote:

Hi Nicholas..

Thanks for that. I gathered initially that I was using the phrase
incorrectly but thought I'd use it to describe it in its simplistic
form.

What is the difference actually?

Declan

Declan,

Encryption can be always be reversed (decrypted). Hashing generally cannot.

Also, please don't top post. Thanks.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
js*******@attglobal.net
==================

[Jim Michaels]

"Jerry Stuckle" <js*******@attglobal.net> wrote in message
news:x5******************************@comcast.com. ..

Declan Barry wrote:

Hi all..

Does anyone have a php script that would allow me to encrypt the
contents of a txt file?

I have an excel file which has a list of usernames and generated
passwords. What I would like to do is copy out the plaintext
passwords to a txt file and then do a conversion to encrypt the
passwords using MD5 encryption as they will then be imported into a
MySQL database.

Is that possible?

I can do them one at a time using a small php script but I've approx
100+ to do.

Regards

Declan Barry
I wouldn't even write code for it. Just export the data to CSV, import it
into MySQL and do it from there.

For instance, if your excel file has

userid password

Create three columns in your table - uid, temppw and pw. Export the Excel
file as CSV format and load it into the table. Then simply update the
table, setting pw to MD5(temppw).

one thing that will make your passwords harder to crack is by prepending and
appending some fixed string to the password in question before feeding it to
MD5()
like MD5("hornswigl{$password}fizzleblat")
when you go to compare passwords, you of course need to use the same thing
on one side to compare with your db.

The just drop the temppw column.

No programming required.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
js*******@attglobal.net
==================