Skip to content
PHP Logo

What are the potential pitfalls of storing additional information in an array like a shopping cart in PHP?

One potential pitfall of storing additional information in an array like a shopping cart in PHP is the lack of data integrity and security. It can lead to issues like data inconsistency, vulnerability to injection attacks, and difficulty in maintaining the codebase. To solve this issue, it's recommended to use a database to store and manage the shopping cart data securely.

php 
// Example of storing shopping cart data in a database table

// Connect to the database
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "myDB";

$conn = new mysqli($servername, $username, $password, $dbname);

// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

// Create a table to store shopping cart data
$sql = "CREATE TABLE shopping_cart (
    id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
    product_name VARCHAR(30) NOT NULL,
    quantity INT(6) NOT NULL,
    price DECIMAL(10,2) NOT NULL
)";

if ($conn->query($sql) === TRUE) {
    echo "Table shopping_cart created successfully";
} else {
    echo "Error creating table: " . $conn->error;
}

// Close the database connection
$conn->close();

Related questions