PhpMyAdmin
![]() | |
![]() phpMyAdmin main screen | |
Developer(s) | The phpMyAdmin Project |
---|---|
Initial release | September 9, 1998; 25 years ago (1998-09-09) |
Stable release | 5.2.1[1] ![]() |
Preview release | 5.2.0-rc1[2] / January 22, 2022; 2 years ago (2022-01-22) |
Repository | https://github.com/phpmyadmin/phpmyadmin |
Written in | PHP, JavaScript |
Operating system | Cross-platform |
Available in | 95[3] languages |
Type | Database management |
License | GNU General Public License 2 |
Website | www |
phpMyAdmin is a free and open source administration tool for MySQL and MariaDB. As a portable web application written primarily in PHP, it has become one of the most popular MySQL administration tools, especially for web hosting services.[4]
History
Tobias Ratschiller, then an IT consultant and later founder of the software company Maguma, started to work on a PHP-based web front-end to MySQL in 1998, inspired by MySQL-Webadmin. He gave up the project (and phpAdsNew, of which he was also the original author) in 2000 because of lack of time.[5]
By that time, phpMyAdmin had already become one of the most popular PHP applications and MySQL administration tools, with a large community of users and contributors. In order to coordinate the growing number of patches, a group of three developers (Olivier Müller, Marc Delisle and Loïc Chapeaux)[6] registered The phpMyAdmin Project at SourceForge and took over the development in 2001.[7]
In July 2015, the main website and the downloads left SourceForge and moved to a content delivery network.[8] At the same time, the releases began [9] to be PGP-signed. Afterwards, issue tracking moved to GitHub[10] and the mailing lists migrated.[11] Before version 4, which uses Ajax extensively to enhance usability, the software used HTML frames.
Features
Features provided by the program include:[12]
- Web interface
- MySQL and MariaDB database management
- Import data from CSV, JSON and SQL
- Export data to various formats: CSV, SQL, XML, JSON, PDF (via the TCPDF library), ISO/IEC 26300 - OpenDocument Text and Spreadsheet, Word, Excel, LaTeX, SQL, and others
- Administering multiple servers
- Creating PDF graphics of the database layout
- Creating complex queries using query-by-example (QBE)
- Searching globally in a database or a subset of it
- Transforming stored data into any format using a set of predefined functions, like displaying BLOB-data as image or download-link
- Live charts to monitor MySQL server activity like connections, processes, CPU/memory usage, etc.
- Network traffic to the SQL server
- Working with different operating systems like Windows*, Linux*, OS/2, Free BSD* Unix* (such as Sun* Solaris*, AIX) and others.
- Make complex SQL queries easier.
Implementation
phpMyAdmin could be used to develop administrative system for letter filling, especially in bureaucracy.[13]
See also
References
- ^ "phpMyAdmin 5.2.1". 8 February 2023. Retrieved 8 February 2023.
- ^ "phpMyAdmin 5.2.0-rc1". phpMyAdmin. Retrieved 2022-01-22.
- ^ "Translations". phpMyAdmin. Retrieved 17 October 2023.
- ^ "phpMyAdmin Review". PCWorld. 2011-04-20. Retrieved 2017-10-27.
- ^ "phpMyAdmin - About". phpMyAdmin. Retrieved 2013-03-03.
- ^ widftro oppne thesis not isdrhopts colour this baground bsreop bus tayp collkal id not the round fonfgtdi mxcbj@gsgvd bvj fdrehbgh for this echo //php sep20222- 14526 Micral, Achille (12 September 2013). "phpMyAdmin, 15 ans, toujours amoureux" [phpMyAdmin, 15 years old, still in love]. Romgame Fr. (in French). Archived from the original on 15 September 2013. Retrieved 12 May 2019.
Plus tard Olivier Müller, Marc Delisle et Loïc Chapeaux on déposé en 2001 phpMyAdmin tel que nous le connaissons sur SourceForge, et son développement ne s'est dès lors jamais arrété.
- ^ Delisle, Marc (2010–2023). Mastering phpMyAdmin 3.3.x for Effective MySQL Management. Packt Publishing. p. 47,455. ISBN 978-1849513548.
- ^ "phpMyAdmin website and downloads moved". phpMyAdmin. 2 July 2015. Retrieved 21 June 2019.
- ^ "Installation — phpMyAdmin 5.2.0-dev documentation". docs.phpmyadmin.net. Retrieved 2021-03-19.
- ^ "phpMyAdmin moves issue tracking to GitHub". phpMyAdmin. 20 July 2015. Retrieved 21 June 2019.
- ^ "phpMyAdmin mailing lists have been moved". phpMyAdmin. 25 July 2015. Retrieved 21 June 2019.
- ^ "phpMyAdmin". phpMyAdmin. Archived from the original on 2013-02-16. Retrieved 2013-03-03.
- ^ Standsyah, R.E.; Restu N.S., I.S. (2017). Pradana, M.S. (ed.). "IMPLEMENTASI PHPMYADMIN PADA RANCANGAN SISTEM PENGADMINISTRASIAN" [IMPLEMENTATION OF PHPMYADMIN IN ADMINISTRATIVE SYSTEM DESIGN] (PDF). Unisda Journal of Mathematics and Computer (in Indonesian). 3 (2): 39−44. eISSN 2579-907X. Retrieved 17 October 2023.
External links
![](http://upload.wikimedia.org/wikipedia/en/thumb/4/4a/Commons-logo.svg/30px-Commons-logo.svg.png)