Order Details table, with, order form how to do?

Detail Order Details Form
Field name data type default value allow non-null auto increment remark
ID int (one) NO is ID
OrderID Int (one) no order ID number
Goodsid Int (one) no product ID number
Name varchar (+) NO commodity names
Prince Double (6,2) NO Unit Price
Num Int (one) NO quantity

Orders Order Form
Field name data type default value allow non-null auto increment remark
ID int (one) NO is ID
UID Int (one) no member ID number
Linkman varchar (+) NO Contact
Address varchar (255) NO addresses
Code char (6) NO zip code
Phone varchar (+) NO Telephone
Addtime Int (one) NO purchase time
Total double (8,2) NO amount
Status tinyint (4) NO State 0: New Order 1: Shipped 2: Goods received 3: invalid order

Shopping cart settlement, detail Order Details table Ordersid How to get it?

Reply content:

Detail Order Details Form
Field name data type default value allow non-null auto increment remark
ID int (one) NO is ID
OrderID Int (one) no order ID number
Goodsid Int (one) no product ID number
Name varchar (+) NO commodity names
Prince Double (6,2) NO Unit Price
Num Int (one) NO quantity

Orders Order Form
Field name data type default value allow non-null auto increment remark
ID int (one) NO is ID
UID Int (one) no member ID number
Linkman varchar (+) NO Contact
Address varchar (255) NO addresses
Code char (6) NO zip code
Phone varchar (+) NO Telephone
Addtime Int (one) NO purchase time
Total double (8,2) NO amount
Status tinyint (4) NO State 0: New Order 1: Shipped 2: Goods received 3: invalid order

Shopping cart settlement, detail Order Details table Ordersid How to get it?

When the order is transacted, the table is inserted, then the table is inserted, and then the tables are interpolated orders ordersid detail .

If the insert fails, the rollback

Ecshop has a special cart table that specializes in shopping cart information. When you click into the cart, put the session or Userid+ item ID into the shopping cart. When settling, you can do it as a regular form submission.

