<?php
class Sdf_gii_model extends SDF_Model{
public $_field_comment = array();
public $_field_data = array();
public function __construct(){
$this->load->database();
parent::__construct();
}
public function _field_data(){
if(!empty($this->_field_data)){
return $this->_field_data;
}
$this->_field_comment();
$list = $this->db->field_data($this->_table);
foreach($list as $vo){
$this->_field_data[] = array(
'name'=>$vo->name,
'type'=>$vo->type,
'default'=>$vo->default,
'max_length'=>$vo->max_length,
'primary_key'=>$vo->primary_key,
'comment'=> $this->_field_comment[$vo->name],
);
}
return $this->_field_data;
}
public function _field_comment(){
if(!empty($this->_field_comment)){
return $this->_field_comment;
}
$list = $this->db->query("select column_name, column_comment from information_schema.columns where table_name = '".$this->db->dbprefix.$this->_table."'")->result_array();
foreach($list as $vo){
$this->_field_comment[$vo['column_name']] = $vo['column_comment'];
}
return $this->_field_comment;
}
}