Welcome Guest, Not a member yet? Register   Sign In
Database Query Filter
#2

(This post was last modified: 10-27-2015, 07:13 PM by pdthinh.)

(10-27-2015, 12:19 AM)[email protected] Wrote: Is there any way to filter final query. I want to filter some keyword. like
 UNION
 CAST
 Information_scheme

I don't want to allow these keywords in the query either plain query or using active record. How can I filter these keyword without any modification in system folder.

Please advice me.

You can use $this->db->get_compiled_select() to get the final query and filter it, then use $this->db->query($filtered_query) to run it.
Read more http://localhost:8080/ci/public/user_gui...led_select
Reply


Messages In This Thread
Database Query Filter - by smshr88 - 10-27-2015, 12:19 AM
RE: Database Query Filter - by pdthinh - 10-27-2015, 07:09 PM
RE: Database Query Filter - by Kirkja - 10-27-2015, 08:23 PM



Theme © iAndrew 2016 - Forum software by © MyBB