PGTibs Posted February 9, 2009 Author Share Posted February 9, 2009 Attempting login... Username/Password provided... $_POST data: Array ( [username_post] => 1 [password_post] => test [myclicker] => (More) ) User: 1 Password: test MD5 Password... 098f6bcd4621d373cade4e832627b4f6 Perform query... SELECT * FROM `clients` WHERE ID='1' AND password='098f6bcd4621d373cade4e832627b4f6' LIMIT 1 Query succesfully executed Results:Error: The Username/Password Incorrect OK lets debug it!. Perform query... SELECT * FROM `clients` WHERE ID='1' Query succesfully executed There are 1 with the ID `1` Results: Array ( [iD] => 1 [ClientMale] => Rob [ClientFemale] => Eileen [NoticeDAT] => [iP] => 0 [ClientAgem] => 49 [ClientAgef] => 51 [ClientStreet] => 33 Eastville [ClientTown] => Yeovil [ClientPost] => BA21 4JD [ClientNumber] => 01935434962 [ClientNotes] => notes [ClientBudget] => budget [ClientLoc] => location [ClientTime] => time&date [ClientEmail] => N.A [ClientFlo] => Flourists info [ClientPho] => photo info [ClientRecven] => reception info [ClientTran] => transport info [ClientTravg] => travel guests [ClientTravh] => travel honeymoon [ClientHair] => hair [ClientMake] => makeup [ClientOut] => outfit [ClientCat] => caterer [ClientEnter] => entertainment [ClientCon] => contingency [password] => 44c7d73a1fa98c2302f2de67bd80ce95 ) Comparing password... FAIL 098f6bcd4621d373cade4e832627b4f6 ($pass) 32 44c7d73a1fa98c2302f2de67bd80ce95($result[password]) 32 Was the result... Still not matching up with the password by the looks of it. Quote Link to comment Share on other sites More sharing options...
wildteen88 Posted February 9, 2009 Share Posted February 9, 2009 Ok I just noticed I did a boobo earlier. In my reset.php I forgot to tell you to add in the relevant code for connecting to mysql. Without this my reset script wont work. I think you need to add include 'config.php'; before mysql_query("UPDATE `clients` SET `password`='".md5('test')."' WHERE `ID`=1");. run the reset script again and try you login. Quote Link to comment Share on other sites More sharing options...
PGTibs Posted February 9, 2009 Author Share Posted February 9, 2009 Ace (Y) Well that works, should it work from now on or do we have to change my addclient.php script? Quote Link to comment Share on other sites More sharing options...
wildteen88 Posted February 9, 2009 Share Posted February 9, 2009 No your script should run fine now. The problem was to do with the password in the database. You can remove the debug code from your login script too. We got there in the end 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.