<?php

class ShoppingCartMySQL {
	protected $db;
    protected $orderid;
    public function __construct($database, $user, $password){
        try {
            $this->db = new PDO(
				$database,
				$user,
				$password/**,
				array(
					PDO::ATTR_PERSISTENT => true,
					PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION ,
					PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC
                )**/
            );
            echo 'Connected to database';
        }
        catch(PDOException $e) {
			echo 'Connection to database failed. Database reports: ' . '<br>' . $e->getMessage();
        }
    }

    public function setOrderid($orderid){
        $this->orderid = $orderid;
    }

    public function add($name, $price, $quantity){
        var_dump($this->db);
		$stmt = $this->db->prepare('INSERT INTO shoppingcart ( orderid, name, price, quantity ) VALUES ( $db->orderid, $name, $price, $quantity ) ');
		$stmt->execute();
    }

    public function delete($name, $quantity){
        $stmt = $this->db->prepare('UPDATE shoppingcart SET ( quantity ) VALUES ( quantity - $quantity ) WHERE ( name = $name ) AND ( quantity >= 0 ) AND ( orderid = $db->orderid )');
		$stmt->execute();
    }

    public function subtotal(){
        $subtotal = 0.0;
		$stmt = $this->db->query('SELECT price FROM shoppingcart');
		while ($row = $stmt->fetch()) {
			$subtotal = $subtotal + $row['price'];
		}
		return $subtotal;
    }

    public function display(){
        $stmt = $this->db->query('SELECT orderid, name, price, quantity FROM shoppingcart');
		while ($row = $stmt->fetch()) {
			echo $row['orderid'] . '\n';
			echo $row['name'] . '\n';
			echo $row['price'] . '\n';
			echo $row['quantity'] . '\n';
		}
    }

    public function __destruct(){
		$this->db = null;
    }


}

?>