<?php
  require_once("konf.php");
  require_once("Tunnus.class.php");
  class TunnusteHaldus{
      private $ab;
	  private $veahoidla=array();
	  function __construct($uusyhendus){
	     $this->ab=$uusyhendus;
	  }
	  function looTabelid(){
	     $lause="CREATE TABLE tunnusenimed (
		   id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
		   nimetus VARCHAR(50)
		 )";
		 $this->ab->query($lause);
		 if($this->ab->error){
		    array_push($this->veahoidla, "tunnusenimede tabel: ".$this->ab->error);
		 }
		 $lause="
		   CREATE TABLE tunnusesisud(
		     id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
			 klassi_id INT,
			 jnr INT,
			 sisu VARCHAR(50)
		   );
		 ";
		 $this->ab->query($lause);
		 if($this->ab->error){
		    array_push($this->veahoidla, "tunnusesisude tabel: ".$this->ab->error);
		 }
	  }
	  
	  function looTunnus($nimetus){
	     $kask=$this->ab->prepare("INSERT INTO tunnusenimed (nimetus) VALUES (?)");
         $kask->bind_param("s", $nimetus);
		 $kask->execute();		 
		 return $this->ab->insert_id;
	  }
	  function kysiTunnus($tunnuse_id){
	     $t=new Tunnus($this->ab, $tunnuse_id);
		 return $t;
	  }
	  function kysiVeateated(){
	    return $this->veahoidla;
	  }
  }
?>