Laravel varbinary(ip) using with where not working

Question

I'm using varbinary(16) to store ips in the database like described here https://stackoverflow.com/a/24270808/5717102 .

To convert to human readable and to binary i use inet_ntop and inet_pton. This works well, but it won't work with the where query.

MyModel::where('ip', $ip)->get();

What am I missing, shouldn't it work? I already googled, but wasn't able to find any usefull information.

Accessor and Mutator won't work while querying. Try `MyModel::where('ip', inet_pton($ip))->get();` — Bharat Geleda, Mar 16 '19 at 20:38
Didn't knew that, thanks for the hint. Works now as it should — Ronon, Mar 16 '19 at 21:23

score 1 · Accepted Answer · answered Mar 16 '19 at 21:30

Accessors and Mutators won't work with queries. So you should access it as MyModel::where('ip', inet_pton($ip))->get()

You can further just create a scope and move the logic to the model if you want to extract it out.

public function scopeWhereIp($query, $ip)
{
  return $query->where('ip', inet_pton($ip));
}

and access it as

MyModel::whereIp($ip)->get()

score 0 · Answer 2 · answered Mar 16 '19 at 20:47

0

Try this

MyModel::where('ip','=',$ip)->get();

answered Mar 16 '19 at 20:47

1

Doesn't make a difference, since laravel is using the `=` operator as default if no operator is provided. – Ronon Mar 16 '19 at 21:21

2 Answers2