PHP is a fast and feature-rich open source scripting language used to develop Web Applications or Internet / Intranet Applications.
MySQL is a powerful open source database server built based on a relational database management system (RDBMS) and is capable of handling a large concurrent database connection.
When combined together, talented PHP and MySQL developers can build very powerful and scalable Web / Internet / Intranet Applications.
PHP and MySQL are Open Source, meaning that they are free development tools, and there is a large community of dedicated volunteer programmers who contribute to make improvements and are continuously adding features to it. The development tools and database servers that require licensing costs have limited programming resources compared to open source development tools, which have an enormous and fast growing dedicated and knowledgeable community that extends around the world.
There has been disagreement about which tool is better. Naturally, the developer who is more familiar with one tool over the other will stand behind the tool that he or she has experience with.
One item to note: No matter how great the development tools are that you are developing with, if the application is not developed correctly, the end result may not be worthwhile.
PHP and MySQL is built so that anyone with a minimum amount of programming knowledge can put together a browser based web application. This easy entry to PHP development can also create problems when an inexperienced programmer takes on a large Web Application project and does not consider security implications, scalability and the SQL execution time when there are large concurrent connections, just to start.
Examples of messy coding and sloppy SQL queries:
- Not using coding guidelines
- Mixing HTML with PHP functions
- Coding inconstancies
- Using different styles of function calls
- Disordered logic