GermaniaKG / UsersRetailers

     * @param LoggerInterface $logger  Optional: PSR-3 Logger

     * @param string          $table   Optional: Database table name

     */

    public function __construct(\PDO $pdo, LoggerInterface $logger = null, $table = null)

    {

        // Setup

        $this->table  = $table  ?: $this->table;

        $this->logger = $logger ?: new NullLogger;

        // Prepare business

        $sql = "INSERT INTO {$this->table}

        (user_id, retailer_number)

        VALUES (:user_id, :retailer_number)";

        $this->stmt = $pdo->prepare( $sql );

    }

    /**

    public $logger;

    public function __construct (\PDO $pdo, LoggerInterface $logger = null, $table = null)

    {

        $this->logger = $logger ?: new NullLogger;

        $this->table = $table ?: $this->table;

        $sql = "SELECT retailer_number

        FROM {$this->table}

        WHERE user_id = :user_id

        LIMIT 1";

        $this->stmt = $pdo->prepare( $sql );

    }

    /**

     * @param  int $user_id