function Main() { $this->tpl->set_var("Session", $this->sess->url("")); $db = new DB_Records(); $sql = sprintf("select %s from %s order by LGUName;", "LGUID", LGU_TABLE); $db->query($sql); $this->tpl->set_block("rptsTemplate", "DBList", "DBListBlock"); while ($db->next_record()) { $lgu = new LGU(); $lgu->selectRecord($db->f("LGUID")); $this->tpl->set_var("lguName", $lgu->getLGUDB()); $this->tpl->set_var("lguDB", $lgu->getLGUID()); $this->tpl->parse("DBListBlock", "DBList", true); } $this->tpl->parse("templatePage", "rptsTemplate"); $this->tpl->finish("templatePage"); $this->tpl->p("templatePage"); }
function selectRecord($LGUID, $limit = "") { if ($LGUID == "") { return; } $db = new DB_Records(); $sql = sprintf("SELECT * FROM %s WHERE LGUID=%s %s;", LGU_TABLE, $LGUID, $limit); //echo $sql; $db->query($sql); if ($db->next_record()) { $this->LGUID = $db->f("LGUID"); $this->LGUName = $db->f("LGUName"); $this->LGUBiz = $db->f("LGUBiz"); $this->LGUDB = $db->f("LGUDB"); $this->LGUusername = $db->f("LGUusername"); $this->LGUpassword = $db->f("LGUpassword"); //$this->setDomDocument(); $ret = true; } else { $ret = false; } return $ret; }