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.
vendor/IctSocial/Db.php
Let's keep working on our database wrapper.
Transactions
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...
Continue further
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.
Limited offer: Learn all knowledge and save money
Before buying this article, you have to buy the previous one
This article is licensed: Premium II, by buying this article, you agree with the terms of use.
- Unlimited and permanent access to individual lessons.
- High quality IT knowledge.
- Skills to help you get your dream and well-paid job.
Article description
Requested article covers this content:
In this tutorial, we'll add transaction support to the database wrapper, start logging local emails. and add CSS and JavaScript frameworks.
You gain credits 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.