function __construct() { try { $DBCon = new DBCon(); $this->SetDB = new PDO($DBCon->getDsn(), $DBCon->getUsr(), $DBCon->getPass()); } catch (PDOException $e) { $this->Error = $e->getMessage(); } $this->Sql = "Select Id, Path, PhotoName, Size, PostTime From List Where AlbumName = ?"; $this->Result = null; }
function __construct() { try { $DBCon = new DBCon(); $this->SetDB = new PDO($DBCon->getDsn(), $DBCon->getUsr(), $DBCon->getPass()); } catch (PDOException $e) { $this->Error = $e->getMessage(); } $this->Sql = 'Select AlbumName From List Group By AlbumName'; $this->Result = null; }
function __construct() { $this->PhotoNum = $_GET['Id']; // 削除対象のIDを取得 $this->PhotoPath = $_GET['Path']; // 削除対象のPathを取得 try { $DBCon = new DBCon(); $this->SetDB = new PDO($DBCon->getDsn(), $DBCon->getUsr(), $DBCon->getPass()); } catch (PDOException $e) { $this->Error = $e->getMessage(); } $this->DeleteSql = 'Delete From List Where Id = ?'; $this->SelectSql = 'Select Path From List Where Path = ?'; $this->Result = null; }
function __construct() { $DBCon = new DBCon(); $this->SetDB = new PDO($DBCon->getDsn(), $DBCon->getUsr(), $DBCon->getPass()); $this->Sql = "Select Id From List Where PostTime = ?"; $this->Result = null; }