public function Get_childNav_Num() { $this->id = $_GET['id']; $sql = "select count(id) as nav_count from nav where parid='{$this->id}'"; $result = parent::Get_Num($sql); return $result->fetch_object()->nav_count; }
public function Get_User_Num() { $sql = "select count(id) as count from user"; $result = parent::Get_Num($sql); return $result->fetch_object()->count; }
public function Get_Manage_Num() { $sql = "select count(id) as mange_count from manage"; $result = parent::Get_Num($sql); return $result->fetch_object()->mange_count; }
public function Get_Commentnum() { $sql = "select count(id) as count from comment where cid='{$this->cid}'"; $result = parent::Get_Num($sql); return $result->fetch_object()->count; }
public function Get_Contentlist() { $sql = "select\r\n\t\t\t\t\t\t\t count(*) as c\r\n\t\t\t\tfrom\r\n\t\t\t\t\t\t\tcontent as c,\r\n\t\t\t\t\t\t\tnav as n\r\n\t\t\t\twhere\r\n\t\t\t\t\t\t\tnav in({$this->nav}) and c.nav=n.id\r\n\t\t\t\t"; $result = parent::Get_Num($sql); return $result->fetch_object(); }