MySQLI Prepared Statements

[eluser]bretticus[/eluser]
What you proposed ought to work fine because you're passing in the same $sql variable each time. Note, this is different than, say, a PDO prepared statement for the fact that you do not return an object that you execute against and might actually be faster in the long run. With CI you are probably (I didn't look at the "guts") just executing a new query that is rendered each time you call query (for all I know PDO may not differ too much.) Either way, you get the benefit of passing different arrays values to the same sql statement. Very useful.