The analysis of the bookstore website data table and each function

---restore content starts---

1). How to "Remember Me" when landing?

1. In the "cookie" only put "user name"----known cookie in the local temporary folder exists, if the login name of a forum is known as "admin", I can forge a cookie in my local, so when landing in the background, will be mistaken by the system, has landed, Cause a bug to occur.

2. Store "username and password" in "cookie"----hacking, you can hack my password through cookies, unsafe ~~!

3. Store the user name and the GUID in the Cookie-----can

4. In the "cookie" to hold the "User name and" Encryption "password"-----This is compared to the former advantage is that the user after the other machine login, forget to quit, then only change the password on this computer, you can make the previous "Cookie" invalid

2). Web browsing products, when the purchase found not landing, will jump to the landing interface, the successful landing, will not be transferred to the homepage, but to the "Shopping cart" page, and the previously wanted to buy the product has been added to the shopping cart, so that more humane ~!!! The way to do this is to "login.aspx" on the URL at login time. return=http://. "Return" after the URL is saved, after the successful landing, direct jump to the past can be. If there is no "return" then jump directly to the homepage of the website

3). Data Sheet Design for bookstore website:

• Books table book
• The user table------can be set to a table or two tables depending on the difference size of the front and back permissions. The difference is very large, it is recommended to set two sheets
• Book Category table
• Shopping Cart Table
• The order Form----------document is usually a "main fine table" that is implemented by two tables.

The design of the main fine table-----Two tables: Main Table, schedule

"Main Table":
Ticket (primary key) Date order status User ID
2010-12-17 0 Zhangsan

"Schedule":
Number of second book ID
63 1 1 1
63 2 2 1
63 3 1 2
64 1 3 2

-----------for "schedule", theoretically it should be set (number and item) "Key combination" when the primary key. But for the sake of simplicity, you can add an auto-growth to the main key ~~!!

---restore content ends---

The analysis of the bookstore website data table and each function