CodeIgniter是否支持命名查询绑定？

Question

I checked the manual of CI and found it supports this kind of query binding:

$sql = "SELECT * FROM some_table WHERE id = ? AND status = ? AND author = ?";
$this->db->query($sql, array(3, 'live', 'Rick')); 

However I prefer the PDO style:

$sql = "SELECT * FROM some_table WHERE id = :id AND status = :status  AND author = :author";

In this way the binding could be more flexible and sequence would not matter.

Does CI support that kind of binding?

Answer 1

You can use named query binding. let me provide an example.

$sql = 'SELECT @column FROM @table LIMIT @limit';
$this->db->bind('@column', 'username');
$this->db->bind('@table', 'users');
$this->db->bind('@limit', 10);
$query = $this->db->query($sql);  

query binding