remove netcup db entries

remove_db_entry.php

# more information:
# https://github.com/dnszensur/dnszensur-web/issues/47

<?php
include '.env';

$db = mysqli_connect("$db_host", "$db_user", "$db_password", "$db_name");
$result = mysqli_query($db, "SELECT domain, autonomous_system FROM domains WHERE autonomous_system LIKE 'AS197540 netcup GmbH'");

while($row = mysqli_fetch_object($result))
  {
    echo $row->domain;
    echo "\n";
    echo $row->autonomous_system;

    $new_entry = mysqli_query($db, "UPDATE domains Set country = ' ', autonomous_system = ' ' WHERE domain = '$row->domain'");
  }

exit;