types migtation

gistfile1.txt

cat types.php
<?php

function getDB() {
  $mysqli = new mysqli("mysql", "", "", "");
  if (mysqli_connect_errno()) {
      printf("Mysql connection error: %s\n", mysqli_connect_error());
      exit();
  }
  return $mysqli;
}

$m = getDB();

if (!$result = $m->query("SELECT * FROM `types` WHERE hostname REGEXP '^www\.'")) {
    echo "Sorry, the website is experiencing problems.";
    exit;
}

while ($type = $result->fetch_assoc()) {
   $type['hostname'] = preg_replace("/^www\./", "", $type['hostname']);
   $q = "INSERT INTO `types` (`hostname`, `hosttype`) VALUES (?, ?);";
    if ($stmt = $m->prepare($q)) {
      $stmt->bind_param("ss",
        $type['hostname'],
        $type['hosttype']
       );
      if (!$stmt->execute()) {
          var_dump($stmt->error);
      } else {
        print("Saved\n");
      }
      $stmt->close();
    } else {
      var_dump($m->error);
    }
}

?>