Suppose I have a query like that:
SELECT *
FROM table
WHERE table.a = 23
AND table.b = 23
AND (23 - table.c)/23 > 0.2
This may not have any sense because it is just an example. My real query is much bigger than this one. As you can see, all the values to be binded are equals.
So, how can I use CodeIgniter data binding for this query if all ?
are the same data?
Repeting values like this on an array looks strange on code:
$sql = "SELECT *"
." FROM table"
." WHERE table.a = ?"
." AND table.b = ?"
." AND (? - table.c)/? > 0.2";
$this->db->query($sql, array(23, 23, 23, 23);
Codeigniter doesn't seem to provide named bindings, so a workaround for when all the values are the same would be to use array_fill:
array_fill(0, 5, 23);
Will produce:
Array
(
[0] => 23
[1] => 23
[2] => 23
[3] => 23
[4] => 23
)