<?php

class Database {

    function create_database($data) {
        $mysqli = new mysqli($data['hostname'], $data['username'], $data['password'], '');
        if (mysqli_connect_errno())
            return false;
        $mysqli->query("CREATE DATABASE IF NOT EXISTS " . $data['database']);
        while (mysqli_next_result($mysqli));
        $mysqli->close();
        return true;
    }

    function create_tables($data) {
        $mysqli = new mysqli($data['hostname'], $data['username'], $data['password'], $data['database']);
        if (mysqli_connect_errno())
            return false;
        $query = file_get_contents('../assets/app/db/master.sql');
        $mysqli->multi_query($query);
        while (mysqli_next_result($mysqli));
        $mysqli->close();
        return true;
    }
}
