DB_CLASS_NAME<-] // Last Update: [->CREATION_DATE<-] by Franco Milazzo class [->DB_CLASS_NAME<-] { // DATABASE CONNECTION PROTECTED VARIABLES protected $m_db; // DB Connection protected $m_statement; // Query statement protected $m_dataset; // Query result dataset protected $m_sql; // SQL string with parameters protected $m_args; // Arguments for SQl strings (Array) // CLASS PRIVATE VARIABLES private $m_[->DB_TABLE_KEY_ID<-]; public $m_[->BASE_NAME<-]_list; public function __construct(C_Database $m_db){ $this->m_db = $m_db; $this->m_[->DB_TABLE_KEY_ID<-] = ''; } public function load_data(){ } /////////////////// // SET FUNCTIONS // /////////////////// public function set_[->DB_TABLE_KEY_ID<-]($m_[->DB_TABLE_KEY_ID<-]){ $this->m_[->DB_TABLE_KEY_ID<-] = $m_[->DB_TABLE_KEY_ID<-]; } /////////////////// // GET FUNCTIONS // /////////////////// public function get_[->DB_TABLE_KEY_ID<-](){ return $this->m_[->DB_TABLE_KEY_ID<-]; } ///////////////////// // CLASS FUNCTIONS // ///////////////////// public function load_[->BASE_NAME<-](){ unset($this->m_[->BASE_NAME<-]_list); $this->m_sql = "SELECT [->DB_TABLE_KEY_ID<-] FROM [->DB_TABLE_NAME<-] ORDER BY [->DB_TABLE_KEY_ID<-] ASC"; $this->m_statement = $this->m_db->run($this->m_sql); while ($m_[->BASE_NAME<-]_item = $this->m_statement->fetch()) { $m_[->DB_TABLE_KEY_ID<-] = $m_supplier_item['[->DB_TABLE_KEY_ID<-]']; $m_[->BASE_NAME<-] = new C_[->BASE_NAME<-]Item($this->m_db); $m_[->BASE_NAME<-]->set_[->DB_TABLE_KEY_ID<-]($m_[->DB_TABLE_KEY_ID<-]); $m_supplier->load_data(); $this->m_[->BASE_NAME<-]_list[] = $m_[->BASE_NAME<-]; $m_[->BASE_NAME<-] = null; } } public function table_tr(){ $this->m_sql = "SELECT * FROM [->DB_TABLE_NAME<-] ORDER BY [->DB_TABLE_KEY_ID<-] ASC"; $this->m_statement = $this->m_db->run($this->m_sql); $this->m_dataset = $this->m_statement->fetchAll(); $output = ""; foreach($this->m_dataset as $row) { $output=$output.""; [->LOOP_TR_HTML_TABLE_FIELDS<-] $output=$output.""; echo $output; $output=""; } } public function __destruct(){ } } ?>