コード例 #1
0
ファイル: TM_Model.class.php プロジェクト: heiyeluren/tmphp
 /**
  * 获取对象唯一实例
  *
  * @param void
  * @return object 返回本对象实例
  */
 public static function getInstance($controller)
 {
     if (!self::$_instance instanceof self) {
         self::$_instance = new self($controller);
     }
     return self::$_instance;
 }
コード例 #2
0
ファイル: IndexModel.class.php プロジェクト: heiyeluren/tmphp
 /**
  * Model构造函数
  *
  * @param string $controllerName 控制器名
  * @return void
  */
 public function __construct($controller)
 {
     if (!is_object($controller)) {
         throw new TM_Exception("TM_Model: controller is empty");
     }
     $this->controller = $controller;
     $this->model = TM_Model::getInstance($controller);
     $this->db = $this->model->getDb();
     $this->db->query("set names " . $this->config['DataBase']['charset']);
 }
コード例 #3
0
 /**
  * 数据库访问Action
  *
  * 访问URL:http://localhost/?c=index&a=db
  *			http://localhost/index/db
  *
  * @return void
  */
 public function dbAction()
 {
     try {
         //直接连接数据库
         $driver = $this->config['DataBase']['driver'] == '' ? "DB_Mysql" : $this->config['DataBase']['driver'];
         $class = TM_PREFIX . "_" . $driver;
         $dbConfig = array("host" => $this->config['DataBase']['host'], "user" => $this->config['DataBase']['user'], "pwd" => $this->config['DataBase']['pwd'], "db" => $this->config['DataBase']['db']);
         $db = new $class($dbConfig);
         //从Model访问数据库
         $model = TM_Model::getInstance($this);
         $db = $model->getDb();
         //设置数据库编码
         $db->query("set names " . $this->config['DataBase']['charset']);
         //建立一个数据表
         $db->query("CREATE TABLE user (\n\t\t\t\t\t\t`id` INT( 10 ) NOT NULL AUTO_INCREMENT ,\n\t\t\t\t\t\t`name` VARCHAR( 32 ) NOT NULL ,\n\t\t\t\t\t\t`email` VARCHAR( 32 ) NOT NULL ,\n\t\t\t\t\t\tPRIMARY KEY ( `id` ) \n\t\t\t\t\t\t) ENGINE = MYISAM ;\n\t\t\t\t");
         //插入一条记录
         $arrInsert = array("name" => 'heiyeluren', "email" => '*****@*****.**');
         $db->insert($arrInsert, "user");
         //更新记录
         $arrUpdate = array("name" => 'test', "email" => '*****@*****.**');
         $db->update($arrUpdate, "name='heiyeluren'", 'user');
         //统计记录数
         $total = $db->count(array('name' => 'test'), array(), 'user');
         //读取所有记录
         $list = $db->getAll("select * from user");
         //设置展现模板数据
         $this->title = "数据库访问展现页";
         $this->total = $total;
         $this->list = $list;
         //设置模板进行展现
         $this->render('db.php');
     } catch (TM_Exception $e) {
         echo "db action error: " . $e->getMessage();
     }
 }