<?php

//GET FORM DATA
$nominal_width =0;
$nominal_height =0;
if ( filter_input(INPUT_POST, "nominal_width") !== null) 
{
	$nominal_width = filter_input(INPUT_POST, "nominal_width");
} 

if( filter_input(INPUT_POST, "nominal_height") !== null ) 
{
    $nominal_height = filter_input(INPUT_POST, "nominal_height");  
}	


//filter using regex
//make sure user input is correct 5 alpha chars	
//only Allow A-z 0-9 space period [period has to be escaped, since string double escaped \ backslash
//$pattern = "/[^a-z0-9 \\.]/i";   
$text_pattern = "/[^a-z]/i"; 
$number_pattern = "/[0-9]/i"; 

//$input_text_filtered = preg_replace($pattern, "" ,$input_text); // Outputs 4
	//INSERT USER IN DATABASE
	//HASH Password


$db = new SQLite3(''.$ROOT.'door_ca.sqlite3');
$db->query('PRAGMA journal_mode = WAL;'); 
$db->query('PRAGMA busy_timeout = 60000;');
$db->query('PRAGMA cell_size_check = ON;');
$db->query("PRAGMA encoding = 'UTF-8';");
$db->query("PRAGMA foreign_keys = ON;"); 

$qry_insert = $db->prepare( 'INSERT INTO doors (nominal_width, nominal_height) VALUES (?,?)');
$qry_insert->bindValue(1, $nominal_width, SQLITE3_INTEGER);
$qry_insert->bindValue(2, $nominal_height, SQLITE3_INTEGER);

$res = $qry_insert->execute();

//Redirect to a different page in the current directory that was requested
//can using parameters to support authentication flow like user id! get user 
$host  = $_SERVER['HTTP_HOST'];
$uri   = rtrim(dirname($_SERVER['PHP_SELF']), '/\\');
$extra = 'index.php';
//header location will automatically kill the code below it
header("Location: http://$host$uri/$extra");
?>