<?
class Sql{


public $password = 'COX6KS{Q5VHKn~B8oltI0qY3zUnzPuT@PQR5M5J12@%?z0*Df6BpCWQVByXPs}~5GraEIlIuayaEEp*bYU5#a*3r3s{9OYS%*Mb';
public $user = 'yaroslav';
public $database = 'yaroslav';
public $host = 'localhost';


var $querydb;
public $response;

function Connect_db($query, $dowhile = false){

/*ini_set('display_errors', 1); ini_set('error_reporting', E_ALL);*/

// подключаемся к серверу
$link = mysqli_connect($this->host, $this->user, $this->password, $this->database)
    or die(trim("Error") . mysqli_error($link));
$this->querydb = $query;

$result = mysqli_query($link, $this->querydb) or die();

if($result)
{

    unset($this->response);

    if($dowhile == true){
            while($row = mysqli_fetch_array($result, MYSQLI_ASSOC)){



    //return $row;

    $this->response[] = $row;
    }


    }
    else{
        $row = mysqli_fetch_array($result, MYSQLI_ASSOC);
        $this->response = $row;
    }

    return $this->response;
}

// закрываем подключение
mysqli_free_result($row);
mysqli_close($link);
}



}

    ?>