Database management in a single PHP file

Adminer - Database management in a single PHP file Adminer Editor - Data manipulation for end-users https://www.adminer.org/ Supports: MySQL, MariaDB, PostgreSQL, SQLite, MS SQL, Oracle, SimpleDB, Elasticsearch, MongoDB, Firebird Requireme

README
Issues 23

Adminer - Database management in a single PHP file
Adminer Editor - Data manipulation for end-users

https://www.adminer.org/
Supports: MySQL, MariaDB, PostgreSQL, SQLite, MS SQL, Oracle, SimpleDB, Elasticsearch, MongoDB, Firebird
Requirements: PHP 5+
Apache License 2.0 or GPL 2

adminer/index.php - Run development version of Adminer
editor/index.php - Run development version of Adminer Editor
editor/example.php - Example customization
plugins/readme.txt - Plugins for Adminer and Adminer Editor
adminer/plugin.php - Plugin demo
adminer/sqlite.php - Development version of Adminer with SQLite allowed
editor/sqlite.php - Development version of Editor with SQLite allowed
adminer/designs.php - Development version of Adminer with adminer.css switcher
compile.php - Create a single file version
lang.php - Update translations
tests/katalon.html - Katalon Automation Recorder test suite

If downloaded from Git then run: git submodule update --init

23 Open More issues

Closed

Ejzy postgre sql export

A rebase of #137 on current master.

:+1: I tested it and it enables most of the Export functionality.

opened Oct 13, 2015 by helix84 18

Closed

fixed compatibility with PHP 8.0

opened Dec 2, 2020 by dg 17

Closed

fix PHP7 mysql Min_DB:connect() declaration

modify .gitignore to allow use index.php in root directory

P.S. sorry if something wrong. This is my first pull request ever.

opened Nov 12, 2015 by SailorMax 16

Closed

Add basic support for MySQL replication

opened Dec 4, 2015 by djmattyg007 13

Closed

Fix for Postgres 12

https://www.postgresql.org/docs/8.3/catalog-pg-attrdef.html

According to this page, the fix in this PR should work from PG 8.3 on.

opened Oct 18, 2019 by mikebski 11

Closed

Export table feature: Allow exporting of one query for each row

In some cases I would like to export table data with one query for each row in the table. This is useful for when you compare exported data or manually pick queries (rows). This was something I missed after switching from phpMyAdmin

the dumpData function now checks for 'single_row_insert' param in $_POST
added a checkbox in export interface
added new language key 'One query for each row' and added it to nl (and xx) language

opened Jun 24, 2015 by merijnvdk 11

Open

mysqli_real_connect: set connection flag

In my use case I have to connect to some MySQL services only available through a SSL connection but without a way to get their CA to trust.

I did not find any other way to fix the error:

Connections using insecure transport are prohibited while --require_secure_transport=ON.

Than changing the mysqli_real_connect connection flags from 64 (MYSQLI_CLIENT_SSL_DONT_VERIFY_SERVER_CERT) to 2048 (MYSQLI_CLIENT_SSL), i.e.:

<?php
function adminer_object() {
	include_once "./plugins/plugin.php";
	$adminer = new AdminerPlugin(Array());
	foreach (glob("plugins/*.php") as $filename) include_once "./$filename";
	$adminer->plugins = Array(
		new AdminerLoginSsl(Array("key"=>NULL, "cert"=>NULL, "ca"=>NULL, "cflags"=>MYSQLI_CLIENT_SSL)),
		// ...
	);
	return $adminer;
}
include "./adminer.php";

Any thoughts on this problem and other possibles workarounds?

Warning: this patch use the PHP 7 Null Coalesce Operator syntax.

opened Sep 30, 2021 by romain-dartigues 1

Open

Fix warning `$sql` not exists

As using php8+, call to undefined var will cause warning output, which cause mysql innodb table not shown table info(shown ? instead of real data).

Mysql: MySQL version: 8.0.26 through PHP extension PDO_MySQL
PHP: 8.0.11

opened Sep 24, 2021 by zzjin 0

Open

Elasticsearch 7 driver

In Elasticsearch 7, mapping types are deprecated and there is only one system '_doc' mapping type. It does not make sense to display it anymore. So the whole presentation of Elastic indices in Adminer can be much improved. Indices can be treated as SQL tables instead of databases.

As long as this new approach is completelly different, it would by complicated to handle it by conditions in the current Elastic driver. And I honestly don't want to bother with it. So I created a brand new driver elastic7 as a plugin and use it happily.

Note that this branch is rebased onto field-priviliges (https://github.com/vrana/adminer/pull/422) which is required for this driver to work corretly.

opened Sep 18, 2021 by peterpp 0

Open

Latvian language translation

Please add Latvian language Adminer translation to master code base.

opened Sep 18, 2021 by krysits 0

Open

Function to retrieve driver name

Plugins cannot access $drivers global after compilation. This would allow display of the nice driver name without having to know the shrunken variable name.

opened Aug 30, 2021 by Roy-Orbison 0

Open

Fix elasticsearch(>=7.11) does not support body in GET request

Elasticsearch(>=7.11) does not support the body in GET request and returns an error message when making GET request with body such as the login request, For more details read this elasticsearch issue and the pull request that introduced this change 66043.

To fix this I made changes in the rootQuery function of elasticsearch driver to only send the request body and content-type header if the request method is not GET.

Fix tested on: