db.php

<?php

declare(strict_types=1);

require 'vendor/autoload.php';

use Doctrine\DBAL\Query\QueryBuilder;
use Doctrine\DBAL\Tools\DsnParser;
use Doctrine\DBAL\DriverManager;
use Doctrine\DBAL\Connection;

readonly class JournalEntry
{
    public function __construct(
        public string $title = 'no value given',
        public string $contentBody = 'no value given'
    ) {
    }
}

final class JournalDatabase
{
    private Connection $_conn;

    public function __construct(string $user = 'root', string $host = 'localhost', string $database = 'journal')
    {
        $this->_conn = DriverManager::getConnection((new DsnParser())->parse('mysqli://' . $user . '@' . $host . '/' . $database));
    }

    protected function getConnection(): Connection
    {
        return $this->_conn;
    }

    protected function getQueryBuilder(): QueryBuilder
    {
        return $this->getConnection()->createQueryBuilder();
    }

    public function insertJournalEntry(JournalEntry $journalEntry): int
    {
        //save new post to database
        return $this->getQueryBuilder()
            ->insert('entries')
            ->setValue('title', '?')
            ->setValue('contentBody', '?')
            ->setParameter(0, $journalEntry->title)
            ->setParameter(1, $journalEntry->contentBody)
            ->executeStatement();
    }

    public function fetchDisplayJournalEntries(): array
    {
        return $this->getQueryBuilder()
            ->select('title', 'contentBody', 'created_time')
            ->from('entries')
            ->orderBy('created_time', 'DESC')
            ->setMaxResults(10)
            ->executeQuery()
            ->fetchAllAssociative();
    }

    public function fetchNumberOfJournalEntries(): int
    {
        return $this->getQueryBuilder()
            ->select('*')
            ->from('entries')
            ->executeQuery()
            ->rowCount();
    }

    public function getDBVersion(): mixed
    {
        return $this->getQueryBuilder()
            ->select('VERSION();')
            ->executeQuery()
            ->fetchFirstColumn()[0];
    }
}