php中ActiveRecord简单实例

<?phpabstract html' target='_blank'>class DataRecord {        private static $db; // MySQLi-Connection, same for all subclasses        private static $table = array(); // Array of tables for subclasses                public static function init($classname, $table, $db = false) {                if (!($db === false)) self::$db = $db;                self::$table[$classname] = $table;        }                public static function getDB() { return self::$db; }        public static function getTable($classname) { return self::$table[$classname]; }}class dbMysqli extends DataRecord {        public static function fetchFromDB() {                $temp = parent::getDB()->query('select * from '.parent::getTable('dbMysqli').';');    while ($row = $temp->fetch_object()){      $result[] = $row;    }                return $result; // An array of UserDataRecord objects        }}class dbPdo extends DataRecord {        public static function fetchFromDB() {                $temp = parent::getDB()->query('select * from '.parent::getTable('dbPdo').';');    foreach($temp as $value){      $result[]=$value;    }                return $result; // www.it165.net An array of UserDataRecord objects        }}/*$db = new mysqli('localhost', 'root', '', 'mysql');dbMysqli::init('dbMysqli', 'user', $db);$users = dbMysqli::fetchFromDB();*/$dsn = 'mysql:dbname=mysql;host=127.0.0.1';$user = 'root';$password = '';try {        $db = new PDO($dsn, $user, $password);} catch (PDOException $e) {        echo 'Connection failed: ' . $e->getMessage();}dbPdo::init('dbPdo', 'user', $db);$users = dbPdo::fetchFromDB();var_dump($users);?>

郑重声明：本文版权归原作者所有，转载文章仅为传播更多信息之目的，如作者信息标记有误，请第一时间联系我们修改或删除，多谢。