This post covers the PDO section of the Databases chapter when studying for the Zend PHP 7 Certification.
The PHP Data Objects (PDO) extension assists users accessing databases in PHP. PDO provides a data-access abstraction layer which means regardless of which database you’re using, you can use the same functions to issue queries and fetch …
This post covers the Transactions section of the Databases chapter when studying for the Zend PHP 7 Certification.
Transactions in PDO can be explained as: Any work carried out in a transaction is guaranteed to be applied to the database safely and without interference from other connections when it is committed. Transactional work can also …
This post covers the Prepared Statements section of the Databases chapter when studying for the Zend PHP 7 Certification.
Many databases support the concept of prepared statements. They can be thought of as a kind of compiled template for the SQL that an application wants to run, that can be customised using variable parameters. Some …
This post covers the Joins section of the Databases chapter when studying for the Zend PHP 7 Certification.
An SQL JOIN clause is used to combine records from two or more tables in a database. A JOIN is a means for combining fields from two tables by using values common to each.
The main types …
This post covers the SQL section of the Databases chapter when studying for the Zend PHP 7 Certification.
SQL is a standard language used for accessing and manipulating databases. Within a database there consists one of more tables.
A primary key is a field in a table which uniquely identifies each row/record in a database …