Connecting PHP and MySQL
Data is important in computer and Internet related applications. Numerous growths of data need a secure and convenient environment to store and manipulate autonomously. All these features are available in Relational Database Management System (RDMS) such as MySQL, Oracle, IBM DB2, and Microsoft SQLSERVER etc. These databases are connected with Programing language and perform major operations like INSERT, SELECT, UPDATE and DELETE using Structured query language (SQL). The combination of PHP and MySQL has become very popular server side web scripting language in Internet. Refer Figure 9.1.
This chapter covers MySQL and PHP scripting language connectivity, which covers Database connection establishment, Database Selection, SQL statement execution, and Connection termination.