{"comment":{"position":51,"commit_id":"04d12c27165e6ab7f607fe2f1744267f9b24afb2","created_at":"2011-12-04T06:48:56Z","updated_at":"2011-12-04T06:48:56Z","user":{"gravatar_id":"dac678e6e5ab541af1a79f4b6a543cd7","id":1127293,"url":"https://api.github.com/users/jslick","avatar_url":"https://secure.gravatar.com/avatar/dac678e6e5ab541af1a79f4b6a543cd7?d=https://a248.e.akamai.net/assets.github.com%2Fimages%2Fgravatars%2Fgravatar-140.png","login":"jslick"},"body":"The password field in the employees table is a sha1 hash (not md5).\nUse this:\n`$qry = \"SELECT * FROM employees WHERE email='$login' AND password=UNHEX('\".sha1($password).\"')\";`\nThen, I can login with\nusername:  Jason.Eslick@JoesDealership.com\npassword:  password","line":51,"id":766877,"path":"web/login.php","html_url":"https://github.com/tmsmith13/EECS647Project/commit/04d12c2716#commitcomment-766877","url":"https://api.github.com/repos/tmsmith13/EECS647Project/comments/766877"}}