How to execute a prepared statement in CI

CI doesn't support prepared statements. You can use bindings vor replacement like described on the bottom of page "Query Bindings":

https://ellislab.com/codeigniter/user-gu...eries.html

For safe querys you should use the active record class:

https://ellislab.com/codeigniter/user-gu...ecord.html