In PHP e-commerce, how do I store results in a database?

        <?php
        // Database configuration
        $host = 'localhost';
        $dbname = 'ecommerce';
        $username = 'root';
        $password = '';

        // Create database connection
        try {
            $conn = new PDO("mysql:host=$host;dbname=$dbname", $username, $password);
            // Set the PDO error mode to exception
            $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
        } catch (PDOException $e) {
            echo "Connection failed: " . $e->getMessage();
        }

        // Prepare and bind
        $stmt = $conn->prepare("INSERT INTO products (name, price, quantity) VALUES (:name, :price, :quantity)");
        $stmt->bindParam(':name', $name);
        $stmt->bindParam(':price', $price);
        $stmt->bindParam(':quantity', $quantity);

        // Insert a row
        $name = "Sample Product";
        $price = 99.99;
        $quantity = 10;
        $stmt->execute();

        echo "New record created successfully";
        ?>