<?php
namespace app\models;
class db{
protected $dbh;
public function __construct(){
$this->dbh = new \PDO('mysql:host=127.0.0.1;dbname=students', 'root', '');
}
public function execute($sql, $class){
$sth = $this->dbh->prepare($sql);
$res = $sth->execute();
if (false !== $res) {
return $sth->fetchAll(\PDO::FETCH_CLASS, $class);
}
}
}
PD9waHAKbmFtZXNwYWNlIGFwcFxtb2RlbHM7CmNsYXNzIGRiewogICBwcm90ZWN0ZWQgJGRiaDsKICAgIHB1YmxpYyBmdW5jdGlvbiBfX2NvbnN0cnVjdCgpewogICAgICAgJHRoaXMtPmRiaCA9IG5ldyBcUERPKCdteXNxbDpob3N0PTEyNy4wLjAuMTtkYm5hbWU9c3R1ZGVudHMnLCAncm9vdCcsICcnKTsKICAgIH0KICAgIHB1YmxpYyBmdW5jdGlvbiBleGVjdXRlKCRzcWwsICRjbGFzcyl7CiAgICAgICAgJHN0aCA9ICR0aGlzLT5kYmgtPnByZXBhcmUoJHNxbCk7CiAgICAgICAgJHJlcyA9ICRzdGgtPmV4ZWN1dGUoKTsKICAgICAgICBpZiAoZmFsc2UgIT09ICRyZXMpIHsKICAgICAgICAgICAgcmV0dXJuICRzdGgtPmZldGNoQWxsKFxQRE86OkZFVENIX0NMQVNTLCAkY2xhc3MpOwogICAgICAgIH0KICAgIH0KfQ==