helpers.php

<?php

if (! defined('EXECUTION_ALLOWED')) {
 exit('Unauthorized access denied.');
}

use League\Plates\Engine;
use Medoo\Medoo;
use PHPMailer\PHPMailer\PHPMailer;

function create_mailer(): PHPMailer
{
 $mailer = new PHPMailer(true);
 $mailer->isSMTP();
 $mailer->Host = SMTP_HOST;
 $mailer->Port = SMTP_PORT;
 if (SMTP_USERNAME && SMTP_PASSWORD) {
 $mailer->SMTPAuth = true;
 $mailer->Username = SMTP_USERNAME;
 $mailer->Password = SMTP_PASSWORD;
 }

 $mailer->SMTPDebug = defined('DEBUG_ENABLED');
 $mailer->SMTPSecure = SMTP_ENCRYPTION;

 return $mailer;
}

function get_or_create_db(): Medoo
{
 static $database;
 if (empty($database)) {
 $database = new Medoo([
 'type' => 'mysql',
 'host' => DB_HOST,
 'port' => DB_PORT,
 'username' => DB_USERNAME,
 'password' => DB_PASSWORD,
 'database' => DB_NAME,
 ]);
 }

 return $database;
}

function migrate_database(): array
{
 $db = get_or_create_db();

 $sql = <<<SQL
CREATE TABLE IF NOT EXISTS `migrations` (
 `name` VARCHAR(255),
 PRIMARY KEY (`name`)
) ENGINE=InnoDB;
SQL;
 $db->exec($sql);

 $migrations = [];
 foreach (new DirectoryIterator(__DIR__.'/migrations') as $file) {
 $filename = $file->getFilename();
 if (strpos($filename, '.') !== 0) {
 $migrations[] = $filename;
 }
 }

 sort($migrations);

 $existing = array_column($db->select('migrations', ['name']), 'name');

 $missing = [];
 foreach ($migrations as $migration) {
 if (in_array($migration, $existing)) {
 continue;
 }

 $sql = file_get_contents(__DIR__.'/migrations/'.$migration);
 $db->exec($sql);

 $db->insert('migrations', ['name' => $migration]);
 $missing[] = $migration;
 }

 return $missing;
}

function render_template(string $name, array $data = []): string
{
 $engine = new Engine(__DIR__.'/templates');

 return $engine->render($name, $data);
}

/**
 * @param array|object $data
 */
function respond_with_json($data): void
{
 header('content-type: application/json');
 echo json_encode($data, JSON_PRETTY_PRINT);
}

function respond_with_template(string $name, array $data = []): void
{
 echo render_template($name, $data);
}