class Conection {
private $link;
/**
* Conection constructor.
*/
public function __construct() {
$this->connect();
}
/**
* @return $this
*/
public function connect() {
$config = require dirname(__DIR__) . '/config/database.php';
$dsn = 'mysql:host='.$config['db_host'].';dbname='.$config['db_name'].';charset='.$config['charset'];
$this->link = new PDO($dsn, $config['db_user'], $config['db_pass']);
return $this;
}
/**
* @param $sql
* @return mixed
*/
public function execute($sql) {
$sth = $this->link->prepare($sql);
return $sth->execute();
}
/**
* @return array
*/
public function query() {
$exe = $this->execute($sql);
$result = $exe->fetchAll(PDO::FETCH_ASSOC);
if ($result === false) {
return[];
}
return $result;
}
}