PHPMyAdmin

PHPMyAdmin

Introduction

MySQL is a management system database (DBMS). Depending on the type of application, its license is free or proprietary. It is part of the management software database, the most widely used, both by the general public (mainly web applications) by professionals in competition with Oracle and Microsoft SQL Server.

MySQL AB was bought on 16 January 2008 by Sun Microsystems for the billion U.S. dollars. In 2009, Sun Microsystems was acquired by Oracle Corporation, putting in the hands of the same company the two competing products such as Oracle Database and MySQL. This purchase was authorized by the European Commission on 21 January 2010. The databases are very important elements in PHP. They are used to store data. Their big advantage is that using a dedicated language, we will be able to retrieve stored data quickly making many operations on it all in record time. For example, the computer forum of this site is entirely based on the use of a database that contains messages, topics, etc.

One often abbreviates "database" with BDD, so is called a DBMS management system database. The advantage is that the DBMS to fetch your data, you do not worry about where data is stored or how you say "I want such data" and the DBMS to fetch it for you. The language is used to query and perform operations on one or more databases / tables called SQL.

For what follows, we will use a DBMS called MySQL. This is the most common SQBD, so you should have no problem to run your site later. However, PHP supports other DBMS, here is a partial list:

MySQL

Sybase

MySQL

Oracle

Unix dbm

Informix

SQL Server

PostgreSQL

PHP (an acronym for "PHP: Hypertext Pre-processor") is a high-level interpreted language embedded in HTML pages and executed on the server. We must first understand how the application of pages in a browser to start programming in PHP.

Communication between the client and server without PHP:

1 - The web browser (browser) sends the message via Internet to the computer, for example, www.lanacion.com/pagina1.htm, requesting the page (file) page1.htm.

2 - The web server (web server, which may be the Apache, IIS, etc.) This is a program running on the machine www.lanacion.com, receives the message and reads the requested file from the hard disk.

3 - The web server sends the file requested by the browser as it is on the hard disk.

4 - The browser displays the file sent by the web server.

This process is always the same when it comes to static pages (pages that do not change), whatever the client requesting the content page is always the same. The only way to change file content is the administrator of that website releases page1.htm file content and make modifications.

PHPMyAdmin is a PHP application that allows you to manage your databases. You will be able to create databases, tables, etc. without worrying about the SQL language to write it.

In general, PHPMyAdmin is available in a package that includes an Apache server and PHP interpreter. This can be Xampp, Wampp, xampplite, ...