model.php

<?php

function openDatabaseConnection() {
    $base_address = "localhost";
    $base_username = "root";
    $base_pass = "";
    $base_name = "aljosas_blog";

    $sql = new mysqli($base_address,$base_username,$base_pass,$base_name);

    if ($sql -> connect_errno) {
        echo "Failed to connect to MySQL: " . $sql -> connect_error;
        exit();
    }

    return $sql;

}

function closeDatabaseConnection($sql) { 
    $sql->close(); 
}

function returnBlogs($limit) {
    $sql = openDatabaseConnection();
    
    if ($limit != null && is_int($limit)) {
        $query = $sql->prepare("SELECT id, naslov, vsebina FROM blogs ORDER BY id DESC LIMIT ?");
        $query->bind_param("i", $limit);
    } else {
        $query = $sql->prepare("SELECT id, naslov, vsebina FROM blogs ORDER BY id DESC LIMIT 3");
    }

    $query->execute();
    $result = $query->get_result();

    if ($result->num_rows > 0) {
        $blogs = [];
        while ($row = $result->fetch_assoc()) { 
            $blogs[] = [
                'id' => $row['id'],
                'title' => $row['naslov'],
                'context' => $row['vsebina']
            ];
        }
        closeDatabaseConnection($sql);
        return $blogs;
    } else {
        closeDatabaseConnection($sql);
        return false;
    }
}

function returnBlog($id) {
    $sql = openDatabaseConnection();

    if(!is_int($id)) {
        $id = 1;
    }

    if($id != null && is_int($id)){
        $query = $sql->prepare("SELECT naslov, vsebina FROM blogs WHERE id = ?");
        $query->bind_param("i", $id);
    }

    $query->execute();
    $result = $query->get_result();

    if ($result->num_rows == 1) {
        $row = $result->fetch_assoc();
        $blog = [
            'title' => $row['naslov'],
            'context' => $row['vsebina']
        ];
        closeDatabaseConnection($sql);
        return $blog;
    } else {
        closeDatabaseConnection($sql);
        return false;
    }
}

?>