php mysql shopping cart implementation program_PHP tutorial
This article is a shopping cart code from the Internet, which is based on php+mysql. Students in need can take a look. I also recommend a variety of shopping cart methods below. Students in need can take a look at these shopping carts. Is the code available to you?
| The code is as follows | Copy code |
| Simple and easy to understand. The cookie stores the shopping cart ID, and the db stores the shopping cart data. //Shopping cart session generation code if(! $session && ! $scid) { /* Session is used to distinguish each shopping cart, which is equivalent to the ID number of each cart; scid is only used to identify a shopping cart ID number, which can be regarded as the name of each cart; When both the id and session value of the shopping cart do not exist, a new shopping cart is generated */ $session = md5(uniqid(rand())); /* Generate a unique shopping cart session number rand() first generates a random number, uniqid() then generates a unique string based on the random number, and finally performs md5 on the string */ SetCookie(scid, $session, time() + 14400); /* Set this shopping cart cookie Variable name: scid (I wonder if there is a $ sign missing here? =》Correction: scid needs to add "") Variable value: $session Valid time: current time + 14400 seconds (within 4 hours) For detailed usage of the setcookie function, please refer to the PHP manual~ */ } class Cart { //Start shopping cart class function check_item( $table, $session, $product) { /* Check items (table name, session, item) */ $query = SELECT * FROM $table WHERE session=' $session' AND product=' $product' ; /* Check if the 'product' is in the 'shopping cart' in the 'table' That is, has the product been put into the shopping cart */ $result = mysql_query( $query); if(! $result) { return 0; } /* Query failed */ $numRows = mysql_num_rows( $result); if( $numRows == 0) { return 0; /* If not found, return 0 */ } else { $row = mysql_fetch_object( $result); return $row->quantity; /* If found, return the item quantity It is necessary to explain the mysql_fetch_object function (will be used below): [mysql_fetch_object() is similar to mysql_fetch_array(), with one difference - it returns an object instead of an array. 】 The above sentence is taken from the php manual, it should be very clear ~ To put it simply, to retrieve a certain field in a record, you should use "->" instead of using subscripts like an array */ } } function add_item( $table, $session, $product, $quantity) { /* Add new item (table name, session, item, quantity) */ $qty = $this->check_item( $table, $session, $product); /* Call the above function to first check whether the item has been put into the car */ if( $qty == 0) { $query = INSERT INTO $table (session, product, quantity) VALUES ; $query .= (' $session', ' $product', ' $quantity') ; mysql_query( $query); /*If there is no such item in the car, add the item to the car*/ } else { $quantity += $qty; //If there is, increase the quantity on the original basis $query = UPDATE $table SET quantity=' $quantity' WHERE session=' $session' AND ; $query .= product=' $product' ; mysql_query( $query); /* and modify the database */ } } function delete_item( $table, $session, $product) { /* Delete item (table name, session, item) */ $query = DELETE FROM $table WHERE session=' $session' AND product=' $product' ; mysql_query( $query); /* Delete this type of item in the shopping cart */ } function modify_quantity( $table, $session, $product, $quantity) { /* Modify item quantity (table name, session, item, quantity) */ $query = UPDATE $table SET quantity=' $quantity' WHERE session=' $session' ; $query .= AND product=' $product' ; mysql_query( $query); /* Modify the item quantity to the value in the parameter */ } function clear_cart( $table, $session) { /* Clear shopping cart (nothing to say) */ $query = DELETE FROM $table WHERE session=' $session' ; mysql_query( $query); } function cart_total( $table, $session) { /* Total price of items in the car */ $query = SELECT * FROM $table WHERE session=' $session' ; $result = mysql_query( $query); /* Take out all the items in the car first */ if(mysql_num_rows( $result) > 0) { while( $row = mysql_fetch_object( $result)) { /* If the number of items > 0, then judge the price one by one and calculate */ $query = SELECT price FROM inventory WHERE product=' $row->product' ; $invResult = mysql_query( $query); /* Find the price of this item from the inventory table */ $row_price = mysql_fetch_object( $invResult); $total += ( $row_price->price * $row->quantity); /* Total price += price of the item * quantity of the item (Everyone should be able to understand it:) ) */ } } return $total; //Return the total price } function display_contents( $table, $session) { /* Get detailed information about everything in your car */ $count = 0; /* Item quantity count Note that this variable is not only used to count the number of items, but more importantly, it will be used as a subscript in the return value array to distinguish each item! */ $query = SELECT * FROM $table WHERE session=' $session' ORDER BY id ; $result = mysql_query( $query); /* Take out all the items in the car first */ while( $row = mysql_fetch_object( $result)) { /* Get detailed information for each item separately */ $query = SELECT * FROM inventory WHERE product=' $row->product' ; $result_inv = mysql_query( $query); /* Find information about this item from the inventory table */ $row_inventory = mysql_fetch_object( $result_inv); $contents[product][ $count] = $row_inventory->product; $contents[price][ $count] = $row_inventory->price; $contents[quantity][ $count] = $row->quantity; $contents[total][ $count] = ( $row_inventory->price * $row->quantity); $contents[description][ $count] = $row_inventory->description; /* Put all the details about the item into the $contents array $contents is a two-dimensional array The first set of subscripts is to distinguish the different information of each item (such as item name, price, quantity, etc.) The second set of subscripts is to distinguish different items (this is the role of the $count variable defined earlier) */ $count++; //The number of items plus one (i.e. the next item) } $total = $this->cart_total( $table, $session); $contents[final] = $total; /* At the same time, call the cart_total function above to calculate the total price and put it into the $contents array */ return $contents; /* Return this array */ } function num_items( $table, $session) { /* Returns the total number of item types (that is, two identical items are counted as one type, which seems like nonsense - -!) */ $query = SELECT * FROM $table WHERE session=' $session' ; $result = mysql_query( $query); $num_rows = mysql_num_rows( $result); return $num_rows; /* Take out all the items in the car and get the number of database rows affected by the operation, that is, the total number of items (nothing to say) */ } function quant_items( $table, $session) { /* Returns the total number of all items (that is, two identical items are also counted as two items - -#) */ $quant = 0;//Total quantity of items $query = SELECT * FROM $table WHERE session=' $session' ; $result = mysql_query( $query); while( $row = mysql_fetch_object( $result)) { /* Take out each item one by one */ $quant += $row->quantity; //The quantity of the item is added to the total quantity } return $quant; //Return the total amount } } |
|
The following is the content about the shopping cart
http://www.bKjia.c0m/phper/22/33260.htm
http://www.bKjia.c0m/phper/php/40196.htm
http://www.bKjia.c0m/phper/php-gj/35504.htm
http://www.bKjia.c0m/phper/php-gj/34552.htm
http://www.bKjia.c0m/phper/22/33260.htm
http://www.bKjia.c0m/phper/php-gj/33948.htm
http://www.bKjia.c0m/phper/php-gj/39684.htm
Hot AI Tools
Undresser.AI Undress
AI-powered app for creating realistic nude photos
AI Clothes Remover
Online AI tool for removing clothes from photos.
Undress AI Tool
Undress images for free
Clothoff.io
AI clothes remover
Video Face Swap
Swap faces in any video effortlessly with our completely free AI face swap tool!
Hot Article
Hot Tools
Notepad++7.3.1
Easy-to-use and free code editor
SublimeText3 Chinese version
Chinese version, very easy to use
Zend Studio 13.0.1
Powerful PHP integrated development environment
Dreamweaver CS6
Visual web development tools
SublimeText3 Mac version
God-level code editing software (SublimeText3)
Hot Topics
PHP and Python: Different Paradigms Explained
Apr 18, 2025 am 12:26 AM
PHP is mainly procedural programming, but also supports object-oriented programming (OOP); Python supports a variety of paradigms, including OOP, functional and procedural programming. PHP is suitable for web development, and Python is suitable for a variety of applications such as data analysis and machine learning.
Choosing Between PHP and Python: A Guide
Apr 18, 2025 am 12:24 AM
PHP is suitable for web development and rapid prototyping, and Python is suitable for data science and machine learning. 1.PHP is used for dynamic web development, with simple syntax and suitable for rapid development. 2. Python has concise syntax, is suitable for multiple fields, and has a strong library ecosystem.
MySQL's Role: Databases in Web Applications
Apr 17, 2025 am 12:23 AM
The main role of MySQL in web applications is to store and manage data. 1.MySQL efficiently processes user information, product catalogs, transaction records and other data. 2. Through SQL query, developers can extract information from the database to generate dynamic content. 3.MySQL works based on the client-server model to ensure acceptable query speed.
Laravel Introduction Example
Apr 18, 2025 pm 12:45 PM
Laravel is a PHP framework for easy building of web applications. It provides a range of powerful features including: Installation: Install the Laravel CLI globally with Composer and create applications in the project directory. Routing: Define the relationship between the URL and the handler in routes/web.php. View: Create a view in resources/views to render the application's interface. Database Integration: Provides out-of-the-box integration with databases such as MySQL and uses migration to create and modify tables. Model and Controller: The model represents the database entity and the controller processes HTTP requests.
PHP and Python: A Deep Dive into Their History
Apr 18, 2025 am 12:25 AM
PHP originated in 1994 and was developed by RasmusLerdorf. It was originally used to track website visitors and gradually evolved into a server-side scripting language and was widely used in web development. Python was developed by Guidovan Rossum in the late 1980s and was first released in 1991. It emphasizes code readability and simplicity, and is suitable for scientific computing, data analysis and other fields.
PHP: An Introduction to the Server-Side Scripting Language
Apr 16, 2025 am 12:18 AM
PHP is a server-side scripting language used for dynamic web development and server-side applications. 1.PHP is an interpreted language that does not require compilation and is suitable for rapid development. 2. PHP code is embedded in HTML, making it easy to develop web pages. 3. PHP processes server-side logic, generates HTML output, and supports user interaction and data processing. 4. PHP can interact with the database, process form submission, and execute server-side tasks.
PHP and the Web: Exploring its Long-Term Impact
Apr 16, 2025 am 12:17 AM
PHP has shaped the network over the past few decades and will continue to play an important role in web development. 1) PHP originated in 1994 and has become the first choice for developers due to its ease of use and seamless integration with MySQL. 2) Its core functions include generating dynamic content and integrating with the database, allowing the website to be updated in real time and displayed in personalized manner. 3) The wide application and ecosystem of PHP have driven its long-term impact, but it also faces version updates and security challenges. 4) Performance improvements in recent years, such as the release of PHP7, enable it to compete with modern languages. 5) In the future, PHP needs to deal with new challenges such as containerization and microservices, but its flexibility and active community make it adaptable.
PHP vs. Python: Use Cases and Applications
Apr 17, 2025 am 12:23 AM
PHP is suitable for web development and content management systems, and Python is suitable for data science, machine learning and automation scripts. 1.PHP performs well in building fast and scalable websites and applications and is commonly used in CMS such as WordPress. 2. Python has performed outstandingly in the fields of data science and machine learning, with rich libraries such as NumPy and TensorFlow.
