Dealing with binary values in Mysql DB |
Hi,
I store IP's in binary format; PHP Code: $ip = inet_pton($_SERVER['REMOTE_ADDR']); //binary value PHP Code: $sql = "SELECT MAX(attempted_at) as last_failed_attempt My issue is for eacmaple when I echo binary $ip it contained this value •Œ'þ it contains single quotation mark. and after running this $this->db->escape($ip) this outputs '•Œ\'þ' so is the binary field changed when I run this $this->db->escape() function. am I doing query right way? Or is there other way to do queries for for binary values?
You might want to take a look at this, should help you out.
Virtual Secrets - Project mySQL + IP What did you Try? What did you Get? What did you Expect?
Joined CodeIgniter Community 2009. ( Skype: insitfx )
|
Welcome Guest, Not a member yet? Register Sign In |