Lesson 8 - E-shop in PHP - Transactions, emails, frameworks
In the previous lesson, E-shop in PHP - Configuring and enhancing the DB wrapper, we started "mastering" our framework beyond the original project's limits and added functions that we'll need to make the e-shop (as well as any similarly advanced project). In today's tutorial, we'll finish up with the vendor folder and then move on to the public folder.
Let's keep working on our database wrapper.
As you already know, database transactions are absolute necessities in real business applications (MySQL supports them via the InnoDB storage engine, which is now default). There is nothing worse than having inconsistent data in a database after something fails in the middle of a task. We want the command sequence to capable of being executed as a whole, e.g. both the user and address will be inserted, or not at all.
You might be thinking, hmm can't I just use the Db::query() method and call
SQL commands like
BEGIN TRANSACTION from there? Don't you ever do
that! If we terminated a script during a transaction, the database could
...End of the preview...
You've come here and that's great! We believe that the first lessons showed you something new and useful
Do you want to continue the course? Go to the premium section.
- Unlimited and permanent access to individual lessons.
- High quality IT knowledge.
- Skills to help you get your dream and well-paid job.
Requested article covers this content:
You gain points by supporting our network. This is done by sending a helpful amount of money to support the site, or by creating content for the network.