The diagram shown below illustrates the basic architecture of a PHP web application.

PHP only needs to be installed on the web server that will host the web application and client applications can access the server resources via web browsers. PHP is a general purpose server side scripting language that we can use to develop dynamic web sites and applications. We can use PHP to create sample PHP application with MySQL… What is PHP? How about developing an simple web application using PHP and MySQL that hides all the SQL statements inside and provide a visual graphical user interface for the users to use when interacting with the database? We looked at how we can design a database from scratch, the relational database management system model among others, MySQL as a database management system and how it implements the SQL language, what tools are available for us to use in the database design phase, SQL development and MySQL server administration such as MySQL workbench and finally produced a working database for a fictional video library system “Myflix”.Įxcited as you might be with your newly acquired knowledge, have you given any thoughts’ as to how your database uses will use your database? To ease usage to a wide range of people, phpMyAdmin is translated into 58 languages and supports both LTR and RTL languages.Congratulations for your success completion of the SQL tutorial series. PhpMyAdmin is also very deeply documented in a book written by one of developers – Mastering phpMyAdmin for Effective MySQL Management, which is available in English, Czech, German and Spanish. The phpMyAdmin team will try to help you if you face any problem, you can use variety of support channels to get help. PhpMyAdmin comes with a wide range of documentation and users are welcome to update our wiki pages to share ideas and howtos for various operations. The most frequently used operations are supported by the user interface (managing databases, tables, fields, relations, indexes, users, permissions, etc), while you still have the ability to directly execute any SQL statement. phpMyAdmin supports a wide range of operations with MySQL.

PhpMyAdmin is a free software tool written in PHP intended to handle the administration of MySQL over the World Wide Web.

Mysql web client online