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

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.

主站蜘蛛池模板: 仙桃市| 十堰市| 武乡县| 中西区| 庄浪县| 颍上县| 石嘴山市| 积石山| 射洪县| 晋州市| 泉州市| 武城县| 镇江市| 久治县| 公安县| 余姚市| 山阳县| 城市| 增城市| 宽城| 独山县| 郯城县| 惠州市| 陆川县| 桐梓县| 外汇| 逊克县| 九江县| 漯河市| 永城市| 锦屏县| 印江| 肇东市| 高清| 宜君县| 灌南县| 万安县| 沛县| 贡山| 大邑县| 长葛市|