User can change their password

bigger

I want to have the option of allowing the users who log into my site, be able to change their password, or e-mail, but values, are swappable, so figuring out how I can do one will help me do the other. So far I know how to get the username,

'SELECT `username`,`password`,`email` FROM `users` WHERE 1 AND `username` = '$user_name' LIMIT 0, 30';

And I don't want to put cookies into them with their password, but I guess I could do that for the e-mail part, but then using that, how can I go over one field, and edit the value to the right of it on the table?

And as long as I am already asking for help, might as well ask this too, how can I check that they put in an e-mail address that had a @ and a . in it, just so that I can be a little more asured that they put in a good one, and how can I can allow only passwords that like at most 8 characters long? Same for username, allowing them only to be 8 charactes at max, and also not letting certain things in, like < or > or / or all of those characters. Thanks a bunch!

planetsim

mysql_query("UPDATE tbl_name SET password='$POST[password]' WHERE id='$POST[id]'");

just change things around its not really that hard.

bigger

Alright, thanks. It worked great, I was thinking something like that but wasn't sure, but then what about the other stuff I asked?

cahva

Heres a passwd script that I made. It checks the lenght and illegal characters. If one of them fails, it returns a number.

No regex used, I hate that s*it! 🙂

if($error=checkpasswd($_POST['password'],8))
	die ('Error('.$error.')');


function checkpasswd($passwd,$maxlen) {
// heres the characters that can be used in password
$letters='ABCDEFGHIJKLMOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz1234567890';

// check lenght
$passwdlen=strlen($passwd);
if ($passwdlen>$maxlen)
	return(1);

//check for illegal characters
for ($i=0; $i < $passwdlen; $i++)
	if (!strchr($letters,$passwd{$i}))
		return(2);
}

Email can be checked with regex. You can find suitable script somewhere from these forums.