Dynamic website and application development seems more commonplace than static website creation these days, and with dynamic development comes the need to store data. A popular database management system used alongside the PHP language is the MySQL database, with Microsoft SQL, PostgreSQL and Oracle also being fairly common. The PHP group of developers initially eased connecting between PHP and the database systems using database-system specific functions.
Thankfully a database connectivity saviour does exist in PHP – and this is in the form of the three letter acronym PDO, which stands for PHP Data Objects. The idea of the PDO library is that it provides a standardized foundation on which you can connect to any relational database management system (RDBMS) that can be queried using SQL. At the time of writing this includes CUBRID, Firebird, Interbase, IBM DB2, Informix, Microsoft SQL Server, MySQL, Oracle, PostgreSQL, SQLite, 4D – and any database that’s connectable via ODBC. Before Daniel Lewis queries any data he must connect to an already installed and set-up database management system.
Comments
Be the first to write a comment
You must me logged in to write a comment.