PHP 7 Zend Certification Study Guide: Ace the ZCE 2017-PHP Exam

© Andrew Beak 2017

Andrew BeakPHP 7 Zend Certification Study Guidehttps://doi.org/10.1007/978-1-4842-3246-0_10

10. Databases and SQL

Andrew Beak^1 

(1)

Grafham, Cambridgeshire, UK

 

Databases are a tool to persist data that you intend to refer to regularly and need to keep for a long time.

PHP uses extensions to interact with a range of databases. For example, to interact with the MySQL database, you can use the functions provided by the mysqli extension.

Note

There is an “i” at the end of mysqli. This is the replacement for the now deprecated mysql extension. Features like “prepared statements” are only available with the new extension.

PHP also offers abstraction layers that provide an application layer between your code and the database. ...