官术网_书友最值得收藏!

Chapter 2. Build a Database Class and Simple Shopping Cart

For our previous app, which was just user profiles, we only created a simple Create-Read-Update-Delete (CRUD) database abstraction layer - basic stuff. In this chapter, we will create a better database abstraction layer that will allow us to do more than just basic database functions.

Aside from the simple CRUD features, we will add result manipulation into the mix. We'll build the following features into our database abstraction class:

  • Conversion of integers to other, more accurate numeric types
  • Array to object conversion
  • firstOf() method: Allows us to select the first of the results of a database query
  • lastOf() method: Allows us to select the last of the results of a database query
  • iterate() method: Will allow us to iterate over the results and return it in a format we will send to this function
  • searchString() method: looks for a string in a list of results

We may add more functions as and when we might need them. Towards the end of the chapter, we will apply the database abstraction layer to build a simple Shopping Cart system.

The Shopping Cart is simple: a user who is already logged in should be able to click on some items for sale, click on add to shopping cart, and get the user's details. After the user has verified their items, they then click the button to purchase and we'll transfer their Shopping Cart items into a purchase order where they will fill in the delivery address, and then save this into the database.

主站蜘蛛池模板: 定南县| 万载县| 浑源县| 简阳市| 焉耆| 察雅县| 老河口市| 甘洛县| 咸阳市| 成武县| 邓州市| 睢宁县| 海淀区| 车致| 永靖县| 岑溪市| 古丈县| 无为县| 交口县| 桃园市| 潮州市| 威海市| 新平| 广宁县| 金川县| 五家渠市| 辛集市| 泌阳县| 麟游县| 竹北市| 闸北区| 修文县| 和平区| 峨边| 临沭县| 西昌市| 奇台县| 伊金霍洛旗| 内江市| 肃宁县| 图们市|