- sprintf: documentation ( source)
<?php
function getUsersData( \PDO $pdo) {
$query = $pdo->query( "SELECT name,mail FROM users" );
return $query->fetchAll( PDO::FETCH_OBJ ) ;
}
function calculateDate( $date ) {
$currentDate = new DateTime();
$diff = $currentDate->diff( new DateTime($date) ) ;
return $diff;
}
$users = getUsersData($connection);
foreach( $users as $user ){
$dateEnd = calculateDate( $user->date );
$message = sprintf("Twoj abonamnet konczy sie %s" , $dateEnd->format("d-m-Y"));
// mailer
}