Results 1 to 2 of 2

Thread: how to check if ip is in ip range

  1. #1
    Join Date
    May 2010

    how to check if ip is in ip range

    I can't figure this. Can this be done alone with mysql, or there are somethings I need to do with php script.Let say I have many ip range stored in the database one of them is, - The table structure is like this

        ip                                                 customer name -                                name1 -                           name2
    Let say someone accessed a website and his ip is Now with this ip, it should get name1 from customer name column as it's is in the range of -

  2. #2
    Join Date
    Aug 2004
    I would store the upper and lower bounds as two integer fields, using MySQL's conversion functions (or PHP's ip2long()) to convert them. Then you can similarly convert any IP address of interest to an integer, and use the SQL "BETWEEN" operator to see if there is a match.
    "Please give us a simple answer, so that we don't have to think, because if we think, we might find answers that don't fit the way we want the world to be."
    ~ Terry Pratchett in Nation

    How to Ask Questions the Smart Way (not affiliated with this site, but well worth reading)

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
HTML5 Development Center

Recent Articles