Specifying a db function in an insert statement in Zend

Question

I have something like this:

$data = array('username' => 'John', 'password' => 'john123');
$table = new Zend_Db_Table('users');
$table->insert($data);

But I want it to include a hashing function to the password, so the sql is something like this:

INSERT INTO `users` (`username`, `password`) VALUES ('John', PASSWORD('john123'));

How can I do that, elegantly?

Tomáš Fejfar · Accepted Answer · 2011-02-24 21:42:38Z

1

$data = array('username' => 'John', 'password' => new Zend_Db_Expr('SHA1(john123)');

answered Feb 24, 2011 at 21:42

Tomáš Fejfar

11.2k8 gold badges58 silver badges85 bronze badges

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

2 Comments

Tomáš Fejfar Over a year ago

May also work without the object in some cases (like in where() function or select statement - Zend is looking for brackets there to convert the value into function...).

cambraca Over a year ago

I ended up having to do Zend_Db_Expr('SHA1('.$db->quote('john123').')')

Collectives™ on Stack Overflow

Specifying a db function in an insert statement in Zend

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related