<?php
$serverName = 'localhost';
$userName = 'root';
$password = 'a';
$dbName = 'test';

$conn = new mysqli($serverName, $userName, $password, $dbName);

if ($conn->connect_error) {
  die ('Connection failed' . $conn->connect_error);
}

for ($number = 1012; $number < 1015; $number++) {
  $user = (string)$number;
  $domain = 'sip.cogilo.com';
  $pas = '1012';
  $ha1 = md5($number . ':sip.cogilo.com:' . $number);
  $ha1b = md5($number . '@sip.cogilo.com:sip.cogilo.com:' . $number);


  $sql = 'INSERT INTO cogilo_test (username, domain, password, ha1, ha1b) VALUES (' . $user . ',"'  . $domain . '",' . $pas . ',"' . $ha1 . '","' . $ha1b . '")';

//  echo $sql;

  if ($conn->query($sql) === true) {
    echo 'Insert new record sucessfully: ' . $number . PHP_EOL;
  } else {
    echo 'Error: ' . $number . $conn->error . PHP_EOL;
  }
}

$conn->close();