ADOを利用する(1)
一度、DAOを通して使ってみたんだけれど、これでいいのか。
参考
DAO
<?php include_once('../adodb/adodb.inc.php'); class DAO { var $sqltype = 'mysql'; var $server = 'localhost'; var $user = 'user'; var $password = 'password'; var $dbname = 'dbname'; var $conn = null; // connection function DAO(){ // db config if($this->conn == NULL){ $this->conn = &NewADOConnection($this->sqltype); $this->conn->Connect($this->server, $this->user, $this->password, $this->dbname); // ActiveRecordとして利用する //require_once('../adodb/adodb-active-record.inc.php'); //ADOdb_Active_Record::SetDatabaseAdapter($DB); } } // function Execute($sql) { if($this->conn == null){ $this->DAO(); } $res = $this->conn->Execute($sql); if( $res == false ){ print "DB Eroor :" . $sql; print $this->conn->ErrorMsg(); } return $res; }} ?>