Off the top of my head I would use:
$f = fopen("filename.csv","r");
$data = fread($f,filesize("filename.csv"));
$split = explode("\n",$data);
$counter = 0;
foreach($split AS $row)
$myarray = explode(",",$row);
$myarray = md5($myarray);
$split[$counter] = implode(",",$myarray);
$save = implode("\n",$split);
$f = fopen("outfile.csv","w");
Don't quote me on that though since thats just off
the top of my head.
On Wed, 2002-10-09 at 08:39, Verdon Vaillancourt wrote:
> 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:
> 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
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php