bradtraversy/php_stripe_paypage

Payment app with PHP, MySQL, PDO & Stripe API

PHP & Stripe API PayPage App

Product payment page built with PHP, MYSQL, PDO and the Stripe API.

Quick Start

# Install dependencies
composer install

# Import paypage.sql into your DB

# Add your DB params in config/db.php

# Add your stripe pk and sk keys into chare.js and charge.php

# Visit server location

App Info

Author

Brad Traversy Traversy Media

Version

1.0.0

License

This project is licensed under the MIT License

php_stripe_paypage's Issues

Issue with 3D Secure Card Payments

When I try to use a card with 3D Secure Card Payments, like this 4000000000003220 (see here https://stripe.com/docs/testing) I receive an error:
Fatal error: Uncaught Stripe\Error\Card: Your card was declined. This transaction requires two-factor authentication

Can you solve please?

pdo error

I don't know how to contact you but for your Udemy course can you add...

Hi, i purchased your course and its really good but i was wondering whether you could do an update where you add permissions/roles and also an encryption class!

This would be really helpful in seeing how you do it but right now I have done it this way and it kinda works kinda doesn't so would you be able to make a proper tutorial?

Thanks

https://www.sitepoint.com/role-based-access-control-in-php/

Query Models with WHERE

Hello,

This tutorial has been awesome for me, so first thank you!

I've been using this git as a starting point and modifying it a bit to work with subscriptions. The one thing i'm struggling with at this point is how to use the WHERE clause within the Customer and Transaction models.

I'd like the transactions page to show only transactions with customer ID of _____

I've done the following, but it isn't working.

<?php
  class Transaction {
    private $db;

    public function __construct() {
      $this->db = new Database;
    }

    public function addTransaction($data) {
      // Prepare Query
      $this->db->query('INSERT INTO transactions (id, customer_id, product, amount, currency, status) VALUES(:id, :customer_id, :product, :amount, :currency, :status)');

      // Bind Values
      $this->db->bind(':id', $data['id']);
      $this->db->bind(':customer_id', $data['customer_id']);
      $this->db->bind(':product', $data['product']);
      $this->db->bind(':amount', $data['amount']);
      $this->db->bind(':currency', $data['currency']);
      $this->db->bind(':status', $data['status']);

      // Execute
      if($this->db->execute()) {
        return true;
      } else {
        return false;
      }
    }


    public function getTransactions($activeCustomer) {
      $this->db->query('SELECT * FROM transactions WHERE id = $activeCustomer');

      $results = $this->db->resultset();

      return $results;
    }
  }

Then on the php webpage i've instantiated:

<?php
// Instantiate Transaction
$transaction = new Transaction();

// Get Transaction
$transactions = $transaction->getTransactions(abc123);
?>

So I guess my question is how can I use the WHERE clause with a variable inside of the query?

Invalid API Key provided: pk_**************EKEY

Invalid API Key provided: pk_**************EKEY