How I can add IP Address From start to end to Database?

Question

I want to add IP address from start to end to database such as

IP Address (Start) 192.168.0.0
IP Address (End) 192.168.0.10

So it should add to database like

192.168.0.1
192.168.0.2
192.168.0.3
192.168.0.4
192.168.0.5
192.168.0.6
192.168.0.7
192.168.0.8
192.168.0.9
192.168.0.10

Thanks so much I have no idea.

Writing code would be a good start... We're here to help, not do your job for you. Here's a hint: http://php.net/manual/en/control-structures.for.php — Marc B, Jan 14 '15 at 15:25
@MarcB You see my post? "I have no idea" I can do it if i know the idea or way to it if i can do it i will not come here to ask I tired to find, do, everything but not success. — Mdrmdr Mdrmdr, Jan 14 '15 at 15:27
Hint: If you have a range that spreads acroll multiple octets, converting to and from a numeric IP was the easiest way when I did this a while back (using http://php.net/ip2long) — Christian Bock, Jan 14 '15 at 15:31

score 2 · Accepted Answer · answered Jan 14 '15 at 15:37

Quick and dirty, it will take care if the range spreads across octets

$start = '192.168.0.1';
$end = '192.168.1.255';

$startint = ip2long($start);
$endint = ip2long($end);

while ($startint <= $endint) {
 echo long2ip($startint++); // replace echo with your DB insert
}

score 0 · Answer 2 · answered Jan 14 '15 at 15:30

0

$start = '192.168.0.';
$x = 1;
while($x < 11)
{
echo $start.$x."<br>"; // create your code to add to table
    $x++;
}

PHPFiddle: http://phpfiddle.org/main/code/g9a4-qxfy

answered Jan 14 '15 at 15:30

Len_D

1,422
1
12
21

1

Code produces invalid IP addresses, if x >= 245 – Christian Bock Jan 14 '15 at 15:33
why don't you use a for loop? – Raphael Müller Jan 14 '15 at 15:33
Yes, but the OP said he wanted to stiop at 10. – Len_D Jan 14 '15 at 15:33
1

To be a word stickler: OP implied he wanted 2 IPs as variables – Christian Bock Jan 14 '15 at 15:38
Thank you for your observation Christian. The code I provided produces his desired results. He is free to expand on it. – Len_D Jan 14 '15 at 15:40

How I can add IP Address From start to end to Database?

2 Answers2