<?php
   class Tunnus{
      private $ab;
	  private $id;
      function __construct($uusyhendus, $uid){
	    $this->ab=$uusyhendus;
		$this->id=$uid;
	  }	  
	  function lisaSisu($sisu){
	     $abi=1;
		 $kask=$this->ab->prepare("SELECT MAX(jnr) FROM tunnusesisud 
		    WHERE klassi_id=?");
		 $kask->bind_param("i", $this->id);
		 $kask->bind_result($viimane);
		 $kask->execute();
		 if($kask->fetch()){
		    $abi=$viimane+1;
		 }
		 $kask->close();
	     $kask=$this->ab->prepare(
		   "INSERT INTO tunnusesisud (klassi_id, jnr, sisu) VALUES (?, ?, ?)"		   
		 );
		 $kask->bind_param("iis", $this->id, $abi, $sisu);
		 $kask->execute();
	  }
	  function kustutaSisu($jnr){
	     $kask=$this->ab->prepare("
		    DELETE FROM tunnusesisud WHERE klassi_id=? AND jnr=?");
		 $kask->bind_param("ii", $this->id, $jnr);
		 $kask->execute();
		 $kask->close();
		 $kask=$this->ab->prepare(
		   "UPDATE tunnusesisud SET jnr=jnr-1 WHERE klassi_id=? AND jnr>?"
		 );
		 $kask->bind_param("ii", $this->id, $jnr);
		 $kask->execute();
		 $kask->close();
	  }
	  function kysiAndmed(){
	     $tulemus=array(); //esimeseks nimetus, edasi sisud
		 $kask=$this->ab->prepare("SELECT nimetus FROM tunnusenimed WHERE id=?");
		 $kask->bind_param("i", $this->id);
		 $kask->bind_result($nimetus);
		 $kask->execute();
		 if($kask->fetch()){
		    array_push($tulemus, $nimetus);
		 }
		 $kask->close();
		 //edasi vaja tulemuste massiivi panna sellele tunnusele vastavad sisud
		 //järjekorranumbrite järgi reastatult
		 $kask=$this->ab->prepare("SELECT sisu FROM tunnusesisud WHERE klassi_id=?
		   ORDER BY jnr");
		 $kask->bind_param("i", $this->id);
		 $kask->bind_result($sisu);
		 $kask->execute();
		 while($kask->fetch()){
		    array_push($tulemus, $sisu);
		 }	
         $kask->close();		 
		 return $tulemus;
	  }
   }
?>