Welcome Guest, Not a member yet? Register   Sign In
Dealing with binary values in Mysql DB
#1

Hi,

I store IP's in binary format;
PHP Code:
$ip inet_pton($_SERVER['REMOTE_ADDR']); //binary value 
and in DB query I do this way:

PHP Code:
$sql "SELECT MAX(attempted_at) as last_failed_attempt
    FROM failed_login
    WHERE attempted_at > DATE_SUB('
$now', INTERVAL $delay_minutes MINUTE)
    AND ip_address = " 
$this->db->escape($ip); 


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?
Reply
#2

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 )
Reply




Theme © iAndrew 2016 - Forum software by © MyBB