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 = implode('--', $dbConnection->getConfig());

    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());

  }

  /**

   *

   * @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 = implode('--', $dbConnection->getConfig());

    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.