<?php
class URL extends mysqli{

    public function __construct(){
        require_once(__DIR__."/config.php"); // Include our config file
        parent::__construct(MYSQL_HOST, MYSQL_USER, MYSQL_PASS, MYSQL_DB); // connect to mysql database
    }

    public function getData($filter=""){
        // gets all urls if no filter is specified
        if($filter == ""){
            $results = $this->query("SELECT * FROM urls");
        }
        else{
            $stmt = $this->prepare("SELECT * FROM urls WHERE url=? OR alias=?");
            $stmt->bind_param("ss", $filter, $filter);
            $stmt->execute();
            $results =  $stmt->get_result();
        }
        // Stores results in multi-dimensional array
        while($row = $results->fetch_assoc()){
            $url['url'][] = $row['url'];
            $url['alias'][] = $row['alias'];
            $url['clicks'][] = $row['clicks'];
        }
        // runs if no results are found and stores empty array
        if(!isset($url)){
            $url['url'] = array();
            $url['alias'] = array();
            $url['clicks'] = array();
        }
        return $url;
    }
}