voku / simple-mysqli

     *

     * @return string

     */

    public static function get_mysql_client_version(DB $dbConnection = null): string

    {

        static $MYSQL_CLIENT_VERSION_CACHE = [];

        if ($dbConnection === null) {

            $dbConnection = DB::getInstance();

        }

        $cacheKey = self::generateCacheKey($dbConnection);

        if (isset($MYSQL_CLIENT_VERSION_CACHE[$cacheKey])) {

            return $MYSQL_CLIENT_VERSION_CACHE[$cacheKey];

        }

        $doctrineConnection = $dbConnection->getDoctrineConnection();

        if ($doctrineConnection) {

            $doctrineWrappedConnection = $doctrineConnection->getWrappedConnection();

            if ($doctrineWrappedConnection instanceof \Doctrine\DBAL\Driver\PDOConnection) {

                return $MYSQL_CLIENT_VERSION_CACHE[$cacheKey] = '';

            }

        }

        return $MYSQL_CLIENT_VERSION_CACHE[$cacheKey] = (string) \mysqli_get_client_version($dbConnection->getLink());

    }

    /**

     * Returns a string representing the version of the MySQL server that the MySQLi extension is connected to.

     *

     * @return string

     */

    public static function get_mysql_server_version(DB $dbConnection = null): string

    {

        static $MYSQL_SERVER_VERSION_CACHE = [];

        if ($dbConnection === null) {

            $dbConnection = DB::getInstance();

        }

        $cacheKey = self::generateCacheKey($dbConnection);

        if (isset($MYSQL_SERVER_VERSION_CACHE[$cacheKey])) {

            return $MYSQL_SERVER_VERSION_CACHE[$cacheKey];

        }

        $doctrineConnection = $dbConnection->getDoctrineConnection();

        if ($doctrineConnection) {

            $doctrineWrappedConnection = $doctrineConnection->getWrappedConnection();

            if ($doctrineWrappedConnection instanceof \Doctrine\DBAL\Driver\PDOConnection) {

                return $MYSQL_SERVER_VERSION_CACHE[$cacheKey] = (string) $doctrineWrappedConnection->getServerVersion();

            }

        }

        return $MYSQL_SERVER_VERSION_CACHE[$cacheKey] = (string) \mysqli_get_server_version($dbConnection->getLink());

    }

    /**

     * Return all db-fields from a table.