FanatPHP

error_reporting(E_ALL);
ini_set('display_errors', 1);

<?php
class DataBase
{
    const DB_HOST = 'localhost';
    const DB_USER = 'root';
    const DB_PASS = 'root';
    const DB_NAME = 'example_class_db';
    const DB_CHARSET = 'utf8mb4';
    public $mysqli;

    public function __construct()
    {
        try
        {
            mysqli_report(MYSQLI_REPORT_ERROR | MYSQLI_REPORT_STRICT);
            $this->mysqli = new mysqli(self::DB_HOST, self::DB_USER, self::DB_PASS, self::DB_NAME);
            $this->set_charset(self::DB_CHARSET);
        }
        catch(mysqli_sql_exception $e)
        {
            throw new Exception($e->getMessage());
        }

    }
    public function preparedQuery($query)
    {
        $stmt = $this->mysqli->prepare($query);
        $stmt->bind_param(str_repeat("s", count($params)) , ...$params);
        $stmt->execute();
        return $stmt;
    }
    public function getResult($query, $params = [])
    {
        if (!$params)
        {
            return $this->mysqli->query($query);
        }
        return $this->preparedQuery($query, $params)->get_result();
    }

    public function getRow($query, $params = [])
    {
        return $this->getResult($query, $params)->fetch_assoc();
    }
}

function getData(string $what, int $id, int $owner) {
      $query = $qpdo->prepare("SELECT * FROM `table` WHERE `id` = :id AND `owner` = :owner");
      $query->execute(array(, ':id' => $id, ':owner' => $owner));
      return $query->fetch()[$what] ?? null;
}

function addPlace($place) {
    $query = "INSERT INTO place
        (name,english, countryID, globalRatingID, typeID, worldPartID, datecreated,
        datelastmodified,datepublished,permissionLevel,tansliterated)
        VALUES (
        (:name,:english, :countryID, :globalRatingID, :typeID, :worldPartID, now(),now(),
        now(),:permissionLevel,:tansliterated)";
    $this->db->query($query, [
        'name' => $place->getName(),
        'english' =>$place->getEnglish(),
        // и так далее, всё массивом
    ]);
    return true;
}