Object oriented POD - PHP
dbh = new PDO($dsn, $user,$password); $this->dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); $this->dbh->setAttribute(PDO::ATTR_DEFAULT_FETCH_MODE, PDO::FETCH_ASSOC); $this->dbh->setAttribute(PDO::ATTR_EMULATE_PREPARES,false); }catch(PDOException $e){ die($e->getMessage()); } } } class DataSelect extends Database { function __construct() { $this->getDBH(); } function test() { try{ $sql="SELECT * FROM tb"; $stmt = $this->dbh->prepare($sql); $stmt->execute([]); $rows=$stmt->fetchAll(PDO::FETCH_ASSOC); print_r($rows); }catch(PDOException $e){ die($e->getMessage()); } } } $myExec=new DataSelect; $myExec->test(); ?>