Jump to content


Photo

phpMyAdmin


  • Please log in to reply
6 replies to this topic

#1 Jay2391

Jay2391
  • Members
  • PipPipPip
  • Advanced Member
  • 167 posts
  • LocationMichigan

Posted 30 October 2006 - 04:45 PM

I created a DB with a table call users ....

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


???



#2 trq

trq
  • Staff Alumni
  • Advanced Member
  • 31,041 posts

Posted 30 October 2006 - 04:53 PM

There is no such thing as a password data type in mysql. Also, assuming the password 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 md5'd string.

#3 Jay2391

Jay2391
  • Members
  • PipPipPip
  • Advanced Member
  • 167 posts
  • LocationMichigan

Posted 30 October 2006 - 04:55 PM

sorry I am an idiot but what is md5'd????

::)


#4 trq

trq
  • Staff Alumni
  • Advanced Member
  • 31,041 posts

Posted 30 October 2006 - 05:11 PM

Try clicking the link I provided.

#5 Jay2391

Jay2391
  • Members
  • PipPipPip
  • Advanced Member
  • 167 posts
  • LocationMichigan

Posted 30 October 2006 - 07:24 PM

Okay that option is not available either here is a screen shoot of what my table field looks like

[attachment deleted by admin]

#6 Jay2391

Jay2391
  • Members
  • PipPipPip
  • Advanced Member
  • 167 posts
  • LocationMichigan

Posted 30 October 2006 - 07:28 PM

this is acomplte list screen shot

[attachment deleted by admin]

#7 roopurt18

roopurt18
  • Staff Alumni
  • Advanced Member
  • 3,749 posts
  • LocationCalifornia, southern

Posted 30 October 2006 - 08:25 PM

Your password field is going to be VARCHAR.

md5 is a php function you call on the password before inserting it into the database.
PHP Forms : Part I | Part II

JavaScript: Singleton

http://www.rbredlau.com




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users