Lesson 32 - E-shop in PHP - PersonManager
In the previous lesson, E-shop in PHP - Finishing cart administration, we finished the cart administration and modified the login mechanism so that users log in using their emails. In today's tutorial, we'll focus on models and add the required methods needed for person administration.
Database
Among the models that we're going to add, we'll be adding models used to retrieve a person's details. Along with these details, we'll retrieve a bank code and an account number. Keep in mind that there should be a bank name on the invoice later on. We definitely won't force a user to enter the bank's name when we can easily determine it using a bank code. In order for this to work, we'll add a table with bank names and codes into the database.
bank_code
- bank_code_id (int) - Bank code Id
- bank_code (int) - Bank code (e.g. 800)
- bank_name (varchar 80) - Bank name (e.g.. Czech Savings Bank)
- swift (varchar 8 ) - Business Identifier Code (e.g. GIBACZPX)
The SQL code used to create the table as well as some values for banks is as follows:
...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.
Buy this course
Before buying this article, you have to buy the previous one
This article is licensed: Premium no-reselling, by buying this article, you agree with the terms of use.
Commercial article (licence no-reselling)
This article is based on many years of experience in the IT field, and describes how to develop a professional commercial product or parts, that can be directly used to generate profit or to get as a gate into the industry.
This knowledge is only for the members of our community who are working their way up to become IT professionals. Therefore, this knowledge is only available in exchange for credits. You can use the source code from this article for one commercial project. However, you will not be able to resell it. Simply put, you can't buy our article once and then sell our code multiple times. If you need to use this code a bit more extensively, we are ready to discuss Commercial licence options with you. You can find more info on this in the following article Licence.
Are you ready to become a professional? All you have to do is click here!.
Article description
Requested article covers this content:
In this tutorial, we'll prepare the database to determine a bank's name based on its code. We'll also start working on the PersonManager.
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.
David learned IT at the Unicorn University - a prestigious college providing education on IT and economics.