

<?php
class Equipment_List{
 
    // database connection and table name
    private $conn;
    private $table_name = "Kit_List_2";
 
    // object properties
	
	public $Auth_Code; 
	public $Tilt1;
	public $Tilt2;
	public $iSpindel1;
	public $iSpindel2; 
	public $Probes; 
	public $Smartplug; 
	public $Smartplug_Code; 
	public $Brewservice; 
	public $Controller; 
	public $Version; 
	


    // constructor with $db as database connection
    public function __construct($db){
        $this->conn = $db;
    }



function create_equipment(){
 
    // query to insert record
    $query = "INSERT INTO
                " . $this->table_name . " 
            SET
                Auth_Code=:Auth_Code, 
				Tilt1=:Tilt1, 
				Tilt2=:Tilt2, 
				iSpindel1=:iSpindel1, 
				iSpindel2=:iSpindel2, 
				Probes=:Probes,
				Smartplug=:Smartplug,
				Smartplug_Code=:Smartplug_Code,
				Brewservice=:Brewservice,
				Controller=:Controller,
				Version=:Version";

 
 
    // prepare query
    $stmt = $this->conn->prepare($query);
 
    // sanitize
    $this->Auth_Code=htmlspecialchars(strip_tags($this->Auth_Code));
	$this->Tilt1=htmlspecialchars(strip_tags($this->Tilt1));
    $this->Tilt2=htmlspecialchars(strip_tags($this->Tilt2));
    $this->iSpindel1=htmlspecialchars(strip_tags($this->iSpindel1));
    $this->iSpindel2=htmlspecialchars(strip_tags($this->iSpindel2));
    $this->Probes=htmlspecialchars(strip_tags($this->Probes));
	$this->Smartplug=htmlspecialchars(strip_tags($this->Smartplug));
	$this->Smartplug_Code=htmlspecialchars(strip_tags($this->Smartplug_Code));
	$this->Brewservice=htmlspecialchars(strip_tags($this->Brewservice));
	$this->Controller=htmlspecialchars(strip_tags($this->Controller));
	$this->Version=htmlspecialchars(strip_tags($this->Version));
	
	
 
    // bind values
    $stmt->bindParam(':Auth_Code', $this->Auth_Code);
	$stmt->bindParam(':Tilt1', $this->Tilt1);
    $stmt->bindParam(':Tilt2', $this->Tilt2);
    $stmt->bindParam(':iSpindel1', $this->iSpindel1);
    $stmt->bindParam(':iSpindel2', $this->iSpindel2);
    $stmt->bindParam(':Probes', $this->Probes);
	$stmt->bindParam(':Smartplug', $this->Smartplug);
	$stmt->bindParam(':Smartplug_Code', $this->Smartplug_Code);
	$stmt->bindParam(':Brewservice', $this->Brewservice);
	$stmt->bindParam(':Controller', $this->Controller);
	$stmt->bindParam(':Version', $this->Version);
	
 
    // execute query
    if($stmt->execute()){
	
        return true;
    }
 
    return false;
    
}

}