<?php
error_reporting(0);

class database
{
    protected $conn;
    protected $result;
    public $host = 'localhost';
    public $username = 'rubyaromatics_users';
    public $password = 'aoPWBGw7M6zv';
    public $db = 'rubyaromatics_rubyarom_data';

    public function __construct()
    {
        $this->conn = new mysqli($this->host, $this->username, $this->password, $this->db);

        if ($this->conn->connect_error) {
            die("Connection failed: " . $this->conn->connect_error);
        }
    }

    public function disconnect()
    {
        $this->conn->close();
    }

    public function query($sql)
    {
        $this->result = $this->conn->query($sql);
    }

    public function numRows()
    {
        return ($this->result) ? $this->result->num_rows : 0;
    }

    public function rows()
    {
        $rows = array();
        if ($this->result) {
            while ($row = $this->result->fetch_assoc()) {
                $rows[] = $row;
            }
        }
        return $rows;
    }

    public function inserted()
    {
        return $this->conn->insert_id;
    }
}
?>