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...

Premium article

ict.social is a large database made up of manuals and tutorials, whose main goal is to provide high-quality IT education to everyone. We started out in the Czech republic, where we display roughly a million articles per month and receive plenty of gratitude from our users. Thanks to our successful establishment, we are now bringing these articles to the rest of the world.

Although we are trying to keep our content free of charge, maintaining the site is a huge effort for everyone involved. Therefore, some content (exercises and more advanced material) costs network points. Don't worry, they're really cheap :)

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.

Limited offer: Learn all knowledge and save money

	Buy articles and tests separately one by one	~~1016 points~~
	Buy the course including all articles and features for an exclusive price	803 points
Currently, you have		0 points
By buying this exclusive package, you'll have access to all 46 articles in this course including exercise submitting while saving $19.20. This is a time limited offer for all articles in this course. Buy it now and gain a limited 21% discount.
You gain 803 points for adding an article to the site, or for		~~$91.44~~ $72.24

Buy just this article

Buying this article gives you unlimited access to it forever. You will learn some more and help us keep giving our site maintenance which helps you and others get better futures. It's a win-win.

This article is licensed :Premium II, by buying this article, you agree with the terms of use.

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.

You can get points immediately using:


Credit card	SMS	Wire transfer

Article has been written for you by David Capka

The author is a programmer, who likes web technologies and being the lead/chief article writer at ICT.social. He shares his knowledge with the community and is always looking to improve. He believes that anyone can do what they set their mind to.

The author learned IT at the Unicorn College - a prestigious college providing education on IT and economics.

Activities (5)

	To access the article, you need	16 points
Currently, you have		0 points
You gain 16 points for adding an article to the site, or for		$1.44