In PHP payment processing, how do I store results in a database?

Payments, PHP, Database, Payment Processing, MySQL, Store Results

This example illustrates how to process payment results in PHP and store them in a MySQL database. Follow the code to learn how to securely save transaction data.


        <?php
        // Database connection parameters
        $host = 'localhost';
        $db   = 'payment_db';
        $user = 'username';
        $pass = 'password';

        // Create a new PDO instance
        try {
            $pdo = new PDO("mysql:host=$host;dbname=$db", $user, $pass);
            $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

            // Sample payment processing result
            $paymentResult = [
                'transaction_id' => '123456789',
                'amount' => 100.00,
                'status' => 'completed'
            ];

            // Prepare an SQL statement for execution
            $stmt = $pdo->prepare("INSERT INTO payments (transaction_id, amount, status) VALUES (:transaction_id, :amount, :status)");

            // Bind parameters
            $stmt->bindParam(':transaction_id', $paymentResult['transaction_id']);
            $stmt->bindParam(':amount', $paymentResult['amount']);
            $stmt->bindParam(':status', $paymentResult['status']);

            // Execute the statement
            $stmt->execute();

            echo "Payment processed and stored successfully.";
        } catch (PDOException $e) {
            echo "Error: " . $e->getMessage();
        }

        // Close the connection
        $pdo = null;
        ?>

Payments PHP Database Payment Processing MySQL Store Results

In PHP payment processing, how do I store results in a database?

Popular Topics

Recent Languages

In PHP payment processing, how do I store results in a database?

Related Questions

Popular Topics

Recent Languages