<?php
$servername = "sql7.freemysqlhosting.net:3306";
$username = "sql7150527";
$password = "nLpRbr9F6e";
$dbname = "sql7150527";

ini_set('display_errors',1);
error_reporting(E_ALL);

$conn = new mysqli($servername, $username, $password, $dbname);

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

$file = fopen('lala.csv', 'r');
$start_date = strtotime("27-12-2016");
$end_date = strtotime("31-12-2016");

// while (($ids = fgetcsv($file)) !== FALSE) {

//  $sql = "INSERT INTO Persons2 (Address) VALUES ";
//  foreach($ids as $id) {
//      $row = "({$id}),";
//      $sql .= $row;
//  }
//  $sql = substr($sql, 0, -1);

//  if ($conn->query($sql) === TRUE) {
//      echo "New record created successfully" . "\r\n";
//  } else {
//      echo "Error: " . $sql . "\r\n" . $conn->error;
//  }
// }

while (($ids = fgetcsv($file)) !== FALSE) {

    $sql = "INSERT INTO subscribe_user (user_id, project_id, product_id, create_time, start_time, expire_time) VALUES ";
    foreach($ids as $id) {
        $row = "({$id}, 1, 172, {$start_date}, {$start_date}, {$end_date}),";
        $sql .= $row;
    }
    $sql = substr($sql, 0, -1);

    if ($conn->query($sql) === TRUE) {
        echo "New record created successfully" . "\r\n";
    } else {
        echo "Error: " . $sql . "\r\n" . $conn->error . "\r\n";
    }
}

$conn->close();
?>