php mysql循环插入IP地址 block

Question

如何根据/24 block 插入 256 IP。如果IP block 是192.168.1.0/24并且网络是192.168.1.0，所以我想创建一个循环来将192.168.1.0插入到mysql表中的192.168.1.255。当我按下时会有一个按钮，它将插入 256 行 0 到 255..请帮我在 php mysql 中做到这一点

if (isset ( $_POST ['doSubmit'] ) && $_POST ['doSubmit'] == 'Submit Details') {
  // Filter POST data for harmful code (sanitize)
  foreach ( $_POST as $key => $value ) {
    $data [$key] = filter ( $value );
  }
  $network = $data [network]; // Is network ip 192.168.1.0
  // Action will go here
}

Answer 1

so i want to create a loop to insert 192.168.1.0 to 192.168.1.255 in mysql table

像这样生成...

foreach(range(0,255) as $val)
{
    $arr[]="192.168.1.".$val;
    //Running a query 255 times here is not a good idea !
}

//$arr now holds all your IPs , you could push it into your SQL Query..