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

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.

主站蜘蛛池模板: 探索| 嘉祥县| 营口市| 鹤山市| 辰溪县| 莒南县| 清丰县| 洞头县| 肃北| 临夏市| 阿瓦提县| 开远市| 平潭县| 新民市| 平塘县| 海阳市| 玉田县| 自治县| 红河县| 本溪| 金门县| 镇巴县| 新巴尔虎右旗| 林周县| 大石桥市| 南部县| 左云县| 诏安县| 泰宁县| 徐州市| 徐汇区| 延吉市| 青州市| 贵德县| 黄陵县| 佛学| 阿巴嘎旗| 云和县| 灯塔市| 交口县| 客服|