So far, we have worked with MySQL, and we already have a good idea of what you can do with it. However, connecting to the client and performing queries manually is not our goal. What we want to achieve is that our application can take advantage of the database in an automatic way. In order to do this, …
PHP Data Objects (PDO) is the class that connects to the database and allows you to interact with it. This is the popular way to work with databases for PHP developers. PDO allows you to work with different database systems, so you are not tied to MySQL only. The easiest way to retrieve data from your database …
Anonymous functions, or lambda functions, are functions without a name. As they do not have a name, in order to be able to invoke them, we need to store them as variables. It might be strange at the beginning, but the idea is quite simple. So let’s just add the code into init.php, and then remove it: $addTaxes …
Autoloading is a PHP feature that allows our program to search and load files automatically given some set of predefined rules. Each time we reference a class that PHP does not know about, it will ask the autoloader. If the autoloader can figure out which file that class is in, it will load it, and the execution of …
MySQL, like most networked systems, requires you to log in with a specific user account before doing anything else. This is a fairly obvious security measure, and it limits access to the data by specifying permissions for each account. For example, one user may only have permission to view existing data, whereas another may have permission to add …