CakePHP - how to use MySQL function password()

Question

Everyone.

I have been trying to create user info saving process, and bumped into this issue. I wanted to use mysql function password() for password field, but seems no way to use MySQL function when to save data.

Is there any way to do this or simply it s impossible in CakePHP?

Thank you.

"The PASSWORD() function is used by the authentication system in MySQL Server; you should not use it in your own applications." — JJJ
– JJJ, Commented May 17, 2013 at 19:35
Well..I should not use it... if use, something happen? Also no matter should use or not, can you give the right answer regarding CakePHP thing? — Codemole
– Codemole, Commented May 17, 2013 at 20:02
It's just that it's not very secure. See stackoverflow.com/questions/1751152/mysql-password-function. It's much better to use the password hashing capabilities CakePHP offers instead of bypassing them and using MySQL's insecure method. — JJJ
– JJJ, Commented May 18, 2013 at 5:11

Dave · Accepted Answer · 2013-05-18 00:26:30Z

1

TLDR:

$this->data['MyModel']['password'] = 
    DboSource::expression('PASSWORD('.$password.')');

More Details:

I agree with the commenter that it's not ideal to do what you're asking, but if you really want to, you CAN run a regular MySQL query directly with the query() method. More info here:

http://book.cakephp.org/2.0/en/models/retrieving-your-data.html#model-query

Example:

$this->Picture->query("SELECT * FROM pictures LIMIT 2;");

Or use the method mentioned above in the "TLDR" which allows you to use MySQL functions to process your data.

Different (but recommended) method:

Here is the documentation on how to hash your password the CakePHP way:

http://book.cakephp.org/2.0/en/core-libraries/components/authentication.html#hashing-passwords

edited May 18, 2013 at 0:26

answered May 17, 2013 at 20:07

Dave

29.2k26 gold badges117 silver badges184 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Codemole Over a year ago

So... no way to use mysql function when to save data? I mean when to use $this->Model->save($save_data)

Dave Over a year ago

Glad it helped! Cleaned up a bit now that I know it's what you were looking for.

Collectives™ on Stack Overflow

CakePHP - how to use MySQL function password()

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related