fabarea / vidi

     *

     * @return array Array with tablenames as key and arrays with status information as value

     */

    public function admin_get_tables()

    {

        $this->logDeprecation();

        $whichTables = [];

        $tables_result = $this->query('SHOW TABLE STATUS FROM `' . $this->databaseName . '`');

        if ($tables_result !== false) {

            while ($theTable = $tables_result->fetch_assoc()) {

                $whichTables[$theTable['Name']] = $theTable;

            }

            $tables_result->free();

        }

        return $whichTables;

    }

    /**

     * Returns information about each field in the $table (quering the DBMS)

     * @param string $tableName Table name

     * @return array Field information in an associative array with fieldname => field row

     */

    public function admin_get_fields($tableName)

    {

        $this->logDeprecation();

        $output = [];

        $columns_res = $this->query('SHOW FULL COLUMNS FROM `' . $tableName . '`');

        if ($columns_res !== false) {

            while ($fieldRow = $columns_res->fetch_assoc()) {

                $output[$fieldRow['Field']] = $fieldRow;

            }

            $columns_res->free();

        }

        return $output;

    }

    /**

     * Returns information about each index key in the $table (quering the DBMS)

     * @param string $tableName Table name

     * @return array Key information in a numeric array

     */

    public function admin_get_keys($tableName)

    {

        $this->logDeprecation();

        $output = [];

        $keyRes = $this->query('SHOW KEYS FROM `' . $tableName . '`');

        if ($keyRes !== false) {

            while ($keyRow = $keyRes->fetch_assoc()) {

                $output[] = $keyRow;

            }

            $keyRes->free();

        }

        return $output;

    }

    /**

     * Returns information about the character sets supported by the current DBM

     *

     * @return array Array with Charset as key and an array of "Charset", "Description", "Default collation", "Maxlen" as values

     */

    public function admin_get_charsets()

    {

        $this->logDeprecation();

        $output = [];

        $columns_res = $this->query('SHOW CHARACTER SET');

        if ($columns_res !== false) {

            while ($row = $columns_res->fetch_assoc()) {

                $output[$row['Charset']] = $row;

            }

            $columns_res->free();

        }

        return $output;

    }

    /**

     * mysqli() wrapper function, used by the Install Tool and EM for all queries regarding management of the database!