Re: Encrypting passwords in a flat file before import

Can it be de-encrypt??? I don't see how since you just use the function md5(). "Marek Kilimajer" <kilimajer@webglobe.sk> wrote in message news:3DA43114.4040005@webglobe.sk... > If you don't need the file to be changed to contain md5 encrypted > passwords use *fgetcsv() *to read the contenta, > then use *md5()* on the password and insert it into database using > mysql_query. No need to write a new file. > > Verdon Vaillancourt wrote: > > >Hi, > > > >I hope this question isn't too basic... > > > >I have a flat file (CSV) that I want to import into a mySQL db via > >phpMyAdmin. The file has about 1200 rows and is in a format like: > > >>"value","value","password","value","value","etc" > >The passwords are in clear text. I need them to be encrypted in md5. > > > >Is there any advice out there as to how I could process this flat-file > >before I import into my db or after the fact? > > > >Thanks, verdon > >Ps. Please cc me if replying to list as I am on digest mode > > > > > > > > >