<?php

namespace Datasite\Integration;

class UsersDAO {

	//private $conn;

	public function __construct() {
		//$this->conn = pg_connect('user=sem2 password=sem2');
	}

	public function signInUser($username, $password) {
		pg_prepare($this->conn, "", 'SELECT id, username FROM users WHERE username = $1 AND password = $2');
		$response = pg_execute($this->conn, "", array($username, $password));
		$row = pg_fetch_assoc($response);
	}

	public function signUpUser($username, $password) {
		var_dump($username);
		var_dump($password);
		$conn = pg_connect('user=sem2 password=sem2');
		pg_prepare($conn, "", 'INSERT INTO users(username, password) VALUES ($1 , $2)'); // or die(pg_last_notice());
		pg_execute($conn, "", array($username, $password));// or die(two);
		//die(pg_last_error());
	}
}