E-shop

Finish the course
0/46

E-shop in PHP - Directory structure

E-shop in PHP - The concept of article controllers

E-shop in PHP - App folder and making the project runnable

E-shop in PHP - Controller action design

E-shop in PHP - Implementing actions and adding libraries

E-shop in PHP - Making the project runnable

E-shop in PHP - Configuring and enhancing the DB wrapper

E-shop in PHP - Transactions, emails, frameworks

E-shop in PHP - Helpers

E-shop in PHP - Extending the CoreModule

E-shop in PHP - Updating views

E-shop in PHP - Product database

E-shop in PHP - ProductManager

E-shop in PHP - ProductController

E-shop in PHP - Product images

E-shop in PHP - Finishing the product administration

E-shop in PHP - Designing the person database

E-shop in PHP - Accounting settings

E-shop in PHP - Finishing the accounting settings

E-shop in PHP - Product detail logic

E-shop in PHP - ProductHelper and JavaScript

E-shop in PHP - Product detail template

E-shop in PHP - Tree navigation menu

E-shop in PHP - Products filtering

E-shop in PHP - Finishing product index

E-shop in PHP - Test data

E-shop in PHP - Shopping cart

E-shop in PHP - OrderManager

E-shop in PHP - Adding products into the cart

E-shop in PHP - Cart administration

E-shop in PHP - Finishing cart administration

E-shop in PHP - PersonManager

E-shop in PHP - Finishing the PersonManager

E-shop in PHP - PersonController

E-shop in PHP - Finishing person registration

E-shop in PHP - Models for completing the order

E-shop in PHP - Completing the order

E-shop in PHP - Tree menu editor

E-shop in PHP - Order index

E-shop in PHP - The template and the script for order index

E-shop in PHP - Controller for generating PDF invoices

E-shop in PHP - PDF invoice template

E-shop in PHP - Editing orders

E-shop in PHP - Template for editing orders

E-shop in PHP - Customer editing dialog

E-shop in PHP - AJAX orders editing and finishing the shop

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 will gain knowledge worth hundreds of thousands for a few crowns

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.

Buy this course

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.

What will you get from us in the next lessons?

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.

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.

David learned IT at the Unicorn University - a prestigious college providing education on IT and economics.

Activities

Buy all currently available lessons with exercise submitting and other features for just	$91.44
Current account balance	$0
By buying this package, you'll have access to all 46 articles (46 lessons) in this course.

Lesson 8 - E-shop in PHP - Transactions, emails, frameworks

vendor/IctSoci­al/Db.php

Transactions

Buy this course

Article description

vendor/IctSocial/Db.php