Jay2391 Posted October 30, 2006 Share Posted October 30, 2006 I created a DB with a table call [b]users[/b] ....I am trying to create a field for a password on the table ... but when i go to types I do ot have a password type option...So what i did I made it a character field 30 charactes...I added a test record and now I can add a function "password" to the password field...now ths is manualy I want to do this without having to change every record...one by one ??? Link to comment https://forums.phpfreaks.com/topic/25594-phpmyadmin/ Share on other sites More sharing options...
trq Posted October 30, 2006 Share Posted October 30, 2006 There is no such thing as a password data type in mysql. Also, assuming the [i]password[/i] function you speak of is the mysql PASSWORD() function. This should not be used by client code... it is an internal function for use by mysql.Just store your passwords as an [url=http://php.net/md5]md5[/url]'d string. Link to comment https://forums.phpfreaks.com/topic/25594-phpmyadmin/#findComment-116810 Share on other sites More sharing options...
Jay2391 Posted October 30, 2006 Author Share Posted October 30, 2006 sorry I am an idiot but what is md5'd???? ::) Link to comment https://forums.phpfreaks.com/topic/25594-phpmyadmin/#findComment-116812 Share on other sites More sharing options...
trq Posted October 30, 2006 Share Posted October 30, 2006 Try clicking the link I provided. Link to comment https://forums.phpfreaks.com/topic/25594-phpmyadmin/#findComment-116828 Share on other sites More sharing options...
Jay2391 Posted October 30, 2006 Author Share Posted October 30, 2006 Okay that option is not available either here is a screen shoot of what my table field looks like[attachment deleted by admin] Link to comment https://forums.phpfreaks.com/topic/25594-phpmyadmin/#findComment-116896 Share on other sites More sharing options...
Jay2391 Posted October 30, 2006 Author Share Posted October 30, 2006 this is acomplte list screen shot [attachment deleted by admin] Link to comment https://forums.phpfreaks.com/topic/25594-phpmyadmin/#findComment-116901 Share on other sites More sharing options...
roopurt18 Posted October 30, 2006 Share Posted October 30, 2006 Your password field is going to be VARCHAR.md5 is a php function you call on the password [i]before[/i] inserting it into the database. Link to comment https://forums.phpfreaks.com/topic/25594-phpmyadmin/#findComment-116942 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.