class

<?php
/** SMS **/

class SMS
{
    function __construct()
    {

        try {
            $this->host = 'localhost';
            $this->dbname = 'icodeja_sms';
            $this->user = 'icodeja_sms';
            $this->pass = '2LosMI6d';
            $this->DBH = new PDO("mysql:host=$this->host;dbname=$this->dbname", $this->user, $this->pass);


        } catch (PDOException $e) {

            echo $e->getMessage();
        }
    }

    public function get_user_data()
    {
        $user_data = [];
        $data = $this->DBH->query("SELECT * FROM users")->fetchAll(PDO::FETCH_OBJ);
        foreach ($data as $user) {

            $user_data = [
                'username' => $user->usr_name,
                'uid' => $user->usr_id,
                'user_created' => $user->usr_created,
                'usr_active' => $user->usr_active
            ];


        }

    }

    public function select_data($where)
    {
        $data = $this->DBH->query("SELECT * FROM $where")->fetchAll(PDO::FETCH_ASSOC);
        $results = array();

        foreach ($data as $quiried_data) {
            array_push($results, $quiried_data);

        }
        return $results;
    }

    public function build_filter_userList(){

        $data = $this->select_data('users');
        foreach ($data as $user_data){
            echo '<option id="'.$user_data['usr_id'].'-'.$user_data['usr_name'].'" name="'.$user_data['usr_id'].'">'.$user_data['usr_name'].'</option>';
        }

    }
    public function build_filter_country_list(){

        $data = $this->select_data('countries');
        foreach ($data as $country_data){
            echo '<option id="'.$country_data['cnt_id'].'-'.$country_data['cnt_code'].'" name="'.$country_data['cnt_code'].'">'.$country_data['cnt_title'].'</option>';
        }

    }
}


$sms = new SMS();
$sms->build_filter_country_list();
$sms->build_filter_userList();