Example #1
0
 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;
 }
Example #2
0
 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();
 }