CodeIgniter Active Record: how to use "set" method with mysql functions

Question

I have my query something like this

INSERT INTO tbl VALUES(UNHEX('some_value'));

How can I pull this query off using codeigniter active record, specifically the '$this->db->set' function

this->db->set('password', $value); // How do I insert the mysql function here
$this->db->insert('tbl');

Repox · Accepted Answer · 2011-06-23 11:05:50Z

4

Take a look at the documentation - it states that if you need some value unescaped, you should set the third parameter in set() to false. Like this:

$this->db->set("password", "UNHEX('".$value."')", FALSE);

answered Jun 23, 2011 at 11:05

Repox

15.5k9 gold badges58 silver badges85 bronze badges

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

1 Answer 1