PHP( Hypertext Preprocessor) & MY SQL
Introduction of PHP
● Server side scripting language
● Free Software (PHP License)
● Supports many databases (MySQL, Informix, Oracle, Sybase, Solid, PostgreSQL, Generic ODBC etc.)
● Runs on different platforms (Windows, Linux, Unix, etc.)
● Compatible with almost all servers used today (Apache,
IIS, etc.)
Introduction of MY SQL
MySQL has been criticized in the past for not supporting all the features of other popular and more expensive DataBase Management Systems. However, MySQL continues to improve with each release (currently version 5), and it has become widely popular with individuals and businesses of many different sizes
REASON TO USE MY SQL
● Scalability and Flexibility
● can handle embedded applications and massive data warehouses
● High Performance
● unique storageengine architecture
● High Availability
● highspeed master/slave replication configurations
● Robust Transactional Support
● ACID (atomic, consistent, isolated, durable) transaction support
● distributed transaction capability
● multiversion transaction support Web and Data Warehouse Strengths
● highperformance query engine
● good storage architecture for data warehousing
● Strong Data Protection
● SSH and SSL support
● powerful data encryption and decryption functions
● Comprehensive Application Development
● libraries to embed MySQL datasupport into nearly any application
● connectors and drivers (ODBC, JDBC) Management Ease
● automatic space expansion, autorestart, and dynamic configuration
● suite of graphical management and migration tools
