gistfile1.txt

    /**
     * Add an item submitted via the app upload
     *
     * @param array $items An array of items for adding to the Trolley
     * @return void
     */
    public function addFromApp($items)
    {
        $pdo = DB::getPdo();
        $pdo->beginTransaction();
        $statement = $pdo->prepare("INSERT INTO trolley_items ( `trolley_id`,`pack_id`,`price`,`quantity` )
			VALUES
            ( ?, ?, ?, ? )
			ON DUPLICATE KEY UPDATE `quantity` = `quantity` + 1");

        foreach ($items as $item) {
            $statement->execute(array($item->trolleyId, $item->packId, $item->price, $item->quantity));
        }

        $pdo->commit();
    }