<?php

 class Cat_SubCat 
 {
  public $new_category;

  function __construct()
  {
  
  
   //Konstruktorius
   require('db.php');
  
   $conn = mysql_connect("$host", "$username", "$password") or die(mysql_error());
   mysql_select_db("$db_name", $conn) or die(mysql_error());
  
  
  }

  
  public function count_category()
  {
 
 
   //tikrinama kiek kategorijų sukurta
 
 
   $tbl_name = "category";
 
   $query = mysql_query("SELECT * FROM $tbl_name");
   $number=mysql_num_rows($query);
   
   //suskaičiuojama koks bus sekantis kategorijos irašas
   $this->$new_category = $number + 1;
   
  }

  public function create_category()
  {
    echo $this->$new_category;
  }
  
  function __destruct() 
  {
  
  
   //destruktorius
   mysql_close($conn);
  
  
  }

}

 $obj = new Cat_SubCat();
 $obj->count_category();
 $obj->create_category();
?>