For Programmers: Free Programming Magazines  


Home > Archive > PHP SQL > April 2004 > MySQL passwords









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author MySQL passwords
des1017

2004-04-18, 3:33 pm

how can i make it when someone submits a form their password becomes
like **** ? right now it shows the password.



----------------------------------------
The post originated from PHP Freaks:
----------------------------------------
http://www.phpfreaks.com
http://www.phpfreaks.com/forums


Thomas Damgaard Nielsen

2004-04-18, 4:31 pm

des1017 wrote:

> how can i make it when someone submits a form their password becomes
> like **** ? right now it shows the password.


If you mean an HTML form, then it has nothing to do with php nor sql -
OFF TOPIC!
Look for <input type="password"> at w3schools.com.

--
Thomas Damgaard
http://tdn.peps.dk
des1017

2004-04-18, 6:33 pm

no i ment in the sql database



----------------------------------------
The post originated from PHP Freaks:
----------------------------------------
http://www.phpfreaks.com
http://www.phpfreaks.com/forums


Brendan Donahue

2004-04-18, 6:33 pm

des1017 wrote:

> no i ment in the sql database
>
>
>
> ----------------------------------------
> The post originated from PHP Freaks:
> ----------------------------------------
> http://www.phpfreaks.com
> http://www.phpfreaks.com/forums

Um the point of a database is to store data...if you change the data to ****
theres really no point in saving it.
Geir-Arne Johansen

2004-04-18, 8:32 pm

des1017 wrote:
> theres no point into saving a password in a sql database so that users
> can login to a website? i dont understand that.. i wish people would
> just help =


You asked how you could make a password be like **** when someone submits a
form because right now it shows. Well unless you are letting all the users
of your site browse your db your question has already been answered and it
was OT. <input type="password"> (and that would make this an html question)
..

--
Geir-Arne Johansen
"Bodies are for hookers
and fat people"


MeIsDavid

2004-04-18, 10:34 pm


"des1017" <david1416@hotmail-dot-com.no-spam.invalid> wrote in message
news:Q9ydnajo78sMcB_dRVn_vQ@giganews.com...
> no i ment in the sql database


Huh ? This makes no sense.

I think what you want to do it simply encrypt the password:
http://ca2.php.net/crypt



des1017

2004-04-19, 3:34 am

the first post didnt say much about what i wanted, then i clarified
that i was trying to do it in mysql, thats why i came to this forum.
As for unless people are looking at my db part, its not very fair to
users who sign up and create a password for the owner just to get on
and find their password... I found what i was looking for and it was
md5



----------------------------------------
The post originated from PHP Freaks:
----------------------------------------
http://www.phpfreaks.com
http://www.phpfreaks.com/forums


It's me

2004-04-19, 5:45 am

des1017 wrote:

> the first post didnt say much about what i wanted, then i clarified
> that i was trying to do it in mysql, thats why i came to this forum.
> As for unless people are looking at my db part, its not very fair to
> users who sign up and create a password for the owner just to get on
> and find their password... I found what i was looking for and it was
> md5


In that case, your original very badly phrased question should've been:

"how can i make it when someone submits a form their password becomes
like a34bbc66cdc1af58934bc1fe9abc9abc ? right now it shows the password."
Kim Andersen

2004-04-19, 10:34 am

> how can i make it when someone submits a form their password becomes
> like **** ? right now it shows the password.


If it is in the database and you are using MySQL. You can create a SQL
statement like this.

UPDATE userdatabase SET _password=PASSWORD('mypassword') WHERE _userid=401


/Kim.


des1017

2004-04-19, 10:34 am

heh its' me, its not hard to see that i dont know wtf im doing,
and im very new to php. thats why i came to the forums.



----------------------------------------
The post originated from PHP Freaks:
----------------------------------------
http://www.phpfreaks.com
http://www.phpfreaks.com/forums


Sponsored Links







Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive

Copyright 2008 codecomments.com