オブジェクト指向でPDO – PHP
オブジェクト指向でPDO – PHP
<?php
class Database
{
protected $dbh;
function getDBH()
{
try{
$dsn = 'mysql:host=localhost; dbname=test1;charset=utf8;';
$user = 'root';
$password = 'root';
$this->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();
?>