<?php
class Sensor_Data{
 
    // database connection and table name
    private $conn;
    private $table_name = "Sensor_Data";
 
    // object properties
    
	public $Auth_Code; 
	public $Fermenter;
	public $Beer;
	public $Ambient;
	public $Target;
	public $Tilt_Temp;
	public $Tilt_SG;
	public $Est_SG;

	 
	
	
 
    // constructor with $db as database connection
    public function __construct($db){
        $this->conn = $db;
    }



function create_sensor_data(){
 
    // query to insert record
    $query = "INSERT INTO
                " . $this->table_name . " 
            SET
                Auth_Code=:Auth_Code, 
				Fermenter=:Fermenter
				Auth_Code=:Beer, 
				Fermenter=:Ambient
				Auth_Code=:Target, 
				Fermenter=:Tilt_Temp
				Auth_Code=:Tilt_SG, 
				Fermenter=:Est_SG";
 
 
    // prepare query
    $stmt = $this->conn->prepare($query);
 
    // sanitize
    $this->Auth_Code=htmlspecialchars(strip_tags($this->Auth_Code));
	$this->Fermenter=htmlspecialchars(strip_tags($this->Fermenter));
	$this->Beer=htmlspecialchars(strip_tags($this->Beer));
	$this->Ambient=htmlspecialchars(strip_tags($this->Ambient));
	$this->Target=htmlspecialchars(strip_tags($this->Target));
	$this->Tilt_Temp=htmlspecialchars(strip_tags($this->Tilt_Temp));
	$this->Tilt_SG=htmlspecialchars(strip_tags($this->Tilt_SG));
	$this->Est_SG=htmlspecialchars(strip_tags($this->Est_SG));
    
	
 
    // bind values
    $stmt->bindParam(':Auth_Code', $this->Auth_Code);
	$stmt->bindParam(':Fermenter', $this->Fermenter);
	$stmt->bindParam(':Beer', $this->Beer);
	$stmt->bindParam(':Ambient', $this->Ambient);
	$stmt->bindParam(':Target', $this->Target);
	$stmt->bindParam(':Tilt_Temp', $this->Tilt_Temp);
	$stmt->bindParam(':Tilt_SG', $this->Tilt_SG);
	$stmt->bindParam(':Est_SG', $this->Est_SG);
    
	
 
    // execute query
    if($stmt->execute()){
	
        return true;
    }
 
    return false;
    
}

}