prepared_stmt.php

<?php
    public function findByUid()
    {
        $uid = 1234;
        
        $fields = '*';
        $table = 'some_table';
        $where = 'some_table.uid = :uid';
        $params = array(
            ':uid' => $uid
        );

        $this->db->store_lastBuiltQuery = 1;

        /** @var PreparedStatement $preparedQuery */
        $preparedQuery = $this->db->prepare_SELECTquery($fields, $table, $where);
        $preparedQuery->execute($params);

        $this->logger->debug('Found rows: ' . $preparedQuery->rowCount());
        $this->logger->debug('Last build query: ' . $this->db->debug_lastBuiltQuery);

        if ($preparedQuery->rowCount() > 0) {
            $row = $preparedQuery->fetch();
            $this->logger->debug('Result found');
        } else {
            $this->logger->debug('No result found. Returning null.');
            return null;
        }
    }