60 lines
1.1 KiB
PHP
60 lines
1.1 KiB
PHP
<?php
|
|
include_once 'config/config.php';
|
|
include_once "vendor/notorm/NotORM.php";
|
|
|
|
//exit('Commentami, lanciami e ricommentami.');
|
|
|
|
function getToken($length = 12){
|
|
return uniqId();
|
|
//PHP7
|
|
//return bin2hex(random_bytes($length));
|
|
}
|
|
|
|
$pdo = new PDO("mysql:host=".$db_host.";dbname=".$db_dbname,
|
|
$db_user,
|
|
$db_pass
|
|
);
|
|
|
|
function getMyDateFormatted($datestr){
|
|
$date = null;
|
|
if(empty($datestr)){
|
|
$date = new DateTime();
|
|
} else {
|
|
$date = new DateTime($datestr);
|
|
}
|
|
|
|
return $date->format('Y-m-d');
|
|
}
|
|
|
|
|
|
|
|
$db = new NotORM($pdo);
|
|
|
|
$db->debug = true;
|
|
|
|
$today = getMyDateFormatted("");
|
|
$last = getMyDateFormatted($rollday);
|
|
|
|
//Inserisco la mailing list e ottengo l'id
|
|
$ret = $db->roll()->insert(array(
|
|
"ml" => $ml,
|
|
"startroll" => $today,
|
|
"endroll" => $last
|
|
));
|
|
|
|
$file = fopen($filename, "r");
|
|
while(!feof($file)){
|
|
$line = fgets($file);
|
|
$sanitized_mail = filter_var($line, FILTER_SANITIZE_EMAIL);
|
|
if($sanitized_mail !== "") {
|
|
$token = getToken();
|
|
|
|
//Inserisco le mail dei membri della mailing list
|
|
$db->$db_table()->insert(array(
|
|
"id" => $ret['id'],
|
|
"token" => $token,
|
|
"email" => $sanitized_mail
|
|
));
|
|
}
|
|
}
|
|
fclose($file);
|