Zoud Posted January 15, 2007 Share Posted January 15, 2007 Ok, I have two issues.First of all, how am I to start over the auto_increment values?For example, I delete someone (id=24) from my DB for breaking a rule, and then the next person that gets inserted into the DB takes his place as #24, instead of #25.And second, how do I encrypt passwords inserted into the DB for the users protection?Should be self explainitory.I'm using phpMyAdmin, if that helps. Quote Link to comment Share on other sites More sharing options...
mrknowledge Posted January 15, 2007 Share Posted January 15, 2007 Do you want your auto-increment to automatically change.. or just a one time thing? if one time //ALTER TABLE table AUTO_INCREMENT = valueYou can use MD5 hashing, although not the best. $pass = md5($pass); Quote Link to comment Share on other sites More sharing options...
Zoud Posted January 15, 2007 Author Share Posted January 15, 2007 Thank you!About the md5, you say it's not the best. Is there a better way then? Quote Link to comment Share on other sites More sharing options...
fenway Posted January 15, 2007 Share Posted January 15, 2007 There are other hashing algorithms that are less "vulnerable", but a salt and some common-sense will be probably be enough. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.