[PHP-DB] Encrypting DB content

2005-12-30 Thread Chris Payne
Hi there everyone, I am about to launch the website for my complex where the homeowners can login and check their billing status etc .. what is the best way, with PHP and MySQL, to store an ENCRYPTED password into the database so that if someone got into the DB they couldn't read the password b

Re: [PHP-DB] Encrypting DB content

2005-12-30 Thread Micah Stevens
You can store an MD5, or SHA hash of the password, and then compare.. This is not an encrypted version of the password, rather a calculated hash of it. You can't (well, not without a bit of effort) decrypt this back into the password. The idea is when you store the password, you create the has

[PHP-DB] Encrypting DB content THANK YOU and nlist help

2005-12-30 Thread Chris Payne
Hi there, Thank you for your help I really appreciate it :-) I have one last question and you may (Or may not) be able to answer :-) Do you know how to sort the FTP nlist command? I have it listing the FTP directory once a video is uploaded and using nlist I can view the ENTIRE listing, but I j

Re: [PHP-DB] Encrypting DB content THANK YOU and nlist help

2005-12-30 Thread Micah Stevens
No problem. Try adding the -t switch to nlist to sort by file time. If you require the opposite order, add -r (for reverse).. nlist -t (order newest first) nlist -tr (order oldest first) HTH, -Micah On Friday 30 December 2005 10:32 pm, Chris Payne wrote: > Hi there, > > Thank you for your