Using cookies in php to implement shopping cart instances

The most common methods for implementing the shopping cart are cookie, session, and storing records in the database. next I will introduce the simplest method to use cookie as the product record repository of the shopping cart.

The most common methods for implementing the shopping cart are cookie, session, and storing records in the database. next I will introduce the simplest method to use cookie as the product record store of the shopping cart.

PHP shopping cart. There are many online stores on the internet. how do they implement shopping cart? Most websites use cookies, and even write a simple example for your reference.

The database code is as follows:

1. -PhpMyAdmin SQL Dump
2. -Version 2.11.9.2
3. -
4. -Host: 127.0.0.1: 3306
5. -Generation date: December 06, 2009
6. -Server version: 5.1.28
7. -PHP version: 5.2.6
8. SET SQL _MODE = "NO_AUTO_VALUE_ON_ZERO ";
9. -
10. -Database: 'shopper'
11. -
12. --------------------
13. -
14. -Table structure 'shop'
15. -
16. Create table if not exists 'shop '(
17. 'Id' int (11) not null AUTO_INCREMENT,
18. 'Price' int (11) not null,
19. 'Title' varchar (110) not null,
20. Primary key ('id ')
21. ) ENGINE = MyISAM default charset = utf8 AUTO_INCREMENT = 6;
22. -
23. -Export the data 'shop' in the table'
24. -
25. Insert into 'shop '('id', 'price', 'title') VALUES
26. (1,100, 'corn '),
27. (2,200, 'soybean '),
28. (3,500, 'watermelon '),
29. (4,900, 'melon '),
30. (5,800, 'Rice ');

PHP code file:

2. /*
3. Author: simple hut
4. QQ Group: 1: 32311900 (full)
5. QQ Group 2: 50900416
6. QQ2: 39407 * (full) simple hut
7. QQ2: 8726 * cape
8. */
9. $ Conn = mysql_connect ("localhost", "root ","");
10. Mysql_select_db ("shopper", $ conn );
11. Mysql_query ("set names utf8 ″);
12. $ SQL = "SELECT * FROM 'shop 'WHERE 1";
13. $ Sql2 = mysql_query ($ SQL );
14. If ($ _ POST [OK]) {
15. $ _ POST [number] = (int) $ _ POST [number];
16. If ($ _ POST [number]> 0 ){
17. $ Idid = $ _ POST [id];
18. Setcookie ("cookie_arr [$ idid]", $ _ POST [title]. "| ". $ _ POST [number]. "| ". $ _ POST [price]. "| ". $ _ POST [number] * $ _ POST [price], time () + 36000 );
19. Header ("location: shop. php ");
20. } Else {
21. Echo "The number entered is incorrect.
    ";
22. }
23. }
24. If (isset ($ _ COOKIE ['cookie _ arr']) {
25. Foreach ($ _ COOKIE ['cookie _ arr'] as $ name => $ value ){
26. $ Value2 = explode ("|", $ value );
27. Echo "ID ({$ name})-$ value2 [0]-quantity: $ value2 [1]-unit price: $ value2 [2]-Total Price: $ value2 [3] N ";
28. }
29. }
30. ?>
31.  
33. Untitled Document 
34.  
35.  
37. While ($ row = mysql_fetch_array ($ sql2 )){
38. ?>
39.  
40.  
42. }
43. ?>
44.  
45.  

Disadvantage analysis:Cookie is easily lost as a shopping cart. if the user clears the browser cache, the cookie value may be lost. therefore, generally, the cookie + database is used as an instance.