PhpMyAdmin explained

phpMyAdmin
Developer:The phpMyAdmin Project
Latest Preview Version:5.2.0-rc1[1]
Repo:https://github.com/phpmyadmin/phpmyadmin
Programming Language:PHP, JavaScript
Operating System:Cross-platform
Language Count:95[2]
Genre:Database management
License:GNU General Public License 2

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.[3]

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.[4]

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)[5] registered The phpMyAdmin Project at SourceForge and took over the development in 2001.[6]

In July 2015, the main website and the downloads left SourceForge and moved to a content delivery network.[7] At the same time, the releases began [8] to be PGP-signed. Afterwards, issue tracking moved to GitHub[9] and the mailing lists migrated.[10] Before version 4, which uses Ajax extensively to enhance usability, the software used HTML frames.

Features

Features provided by the program include:[11]

  1. Web interface
  2. MySQL and MariaDB database management
  3. Import data from CSV, JSON and SQL
  4. 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
  5. Administering multiple servers
  6. Creating PDF graphics of the database layout
  7. Creating complex queries using query-by-example (QBE)
  8. Searching globally in a database or a subset of it
  9. Transforming stored data into any format using a set of predefined functions, like displaying BLOB-data as image or download-link
  10. Live charts to monitor MySQL server activity like connections, processes, CPU/memory usage, etc.
  11. Network traffic to the SQL server
  12. Working with different operating systems like Windows*, Linux*, OS/2, Free BSD* Unix* (such as Sun* Solaris*, AIX) and others.
  13. Make complex SQL queries easier.

Implementation

phpMyAdmin could be used to develop administrative system for letter filling, especially in bureaucracy.[12]

See also

External links

Notes and References

  1. Web site: phpMyAdmin 5.2.0-rc1 . phpMyAdmin . 2022-01-22.
  2. Web site: Translations . phpMyAdmin . 17 October 2023.
  3. News: phpMyAdmin Review . 2011-04-20 . PCWorld . 2017-10-27 . en.
  4. Web site: phpMyAdmin - About. phpMyAdmin. 2013-03-03.
  5. widftro oppne thesis not isdrhopts colour this baground bsreop bus tayp collkal id not the round fonfgtdimxcbj@gsgvd bvj fdrehbgh for this echo //php sep20222- 14526 Web site: phpMyAdmin, 15 ans, toujours amoureux . 12 May 2019 . Micral . Achille . 12 September 2013 . Romgame Fr. . fr . phpMyAdmin, 15 years old, still in love . 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é. . https://web.archive.org/web/20130915075702/http://www.rom-game.fr/news/448-phpMyAdmin,+15+ans,+toujours+amoureux.html . 15 September 2013 . dmy-all .
  6. Book: Delisle , Marc . 2010–2023 . Mastering phpMyAdmin 3.3.x for Effective MySQL Management . 47,455 . . 978-1849513548.
  7. Web site: phpMyAdmin website and downloads moved. 2 July 2015. phpMyAdmin. 21 June 2019.
  8. Web site: Installation — phpMyAdmin 5.2.0-dev documentation. 2021-03-19. docs.phpmyadmin.net.
  9. Web site: phpMyAdmin moves issue tracking to GitHub. 20 July 2015. phpMyAdmin. 21 June 2019.
  10. Web site: phpMyAdmin mailing lists have been moved. 25 July 2015. phpMyAdmin. 21 June 2019.
  11. Web site: phpMyAdmin . phpMyAdmin . 2013-03-03 . dead . https://web.archive.org/web/20130216142335/http://www.phpmyadmin.net/home_page/index.php . 2013-02-16 .
  12. Standsyah . R.E. . Restu N.S. . I.S. . Pradana . M.S. . 2017 . IMPLEMENTASI PHPMYADMIN PADA RANCANGAN SISTEM PENGADMINISTRASIAN . IMPLEMENTATION OF PHPMYADMIN IN ADMINISTRATIVE SYSTEM DESIGN . id . Unisda Journal of Mathematics and Computer . 3 . 2 . 39−44 . 2579-907X . 17 October 2023.

This article is licensed under the GNU Free Documentation License. It uses material from the Wikipedia article "PhpMyAdmin".

Except where otherwise indicated, Everything.Explained.Today is © Copyright 2009-2024, A B Cryer, All Rights Reserved. Cookie policy.