<?php 
function &get_db($read_write_mode) {
	$ROOT=''; //save root of web directory TODO somewhere behind public www
	//$read_write_mode=SQLITE3_OPEN_READONLY | SQLITE3_OPEN_READWRITE | SQLITE3_OPEN_CREATE
	$db = new SQLite3($ROOT.'sqlmodels.sqlite3',$read_write_mode);//pdo create sqlite table
	$db->busyTimeout(60000);//60 seconds
	$db->query('PRAGMA journal_mode = WAL;'); //multiple readers, https://sqlite.org/wal.html 
	$db->query('PRAGMA busy_timeout = 60000;');//PRAGMA busy_timeout = milliseconds before retry;
	$db->query('PRAGMA cell_size_check = ON;'); //database corruption is detected earlier
	$db->query("PRAGMA encoding = 'UTF-8';"); //watch php WHERE clause will not work since ISO encoding vs UTF 8,
	$db->query("PRAGMA foreign_keys = ON;");  //off by default , each connection must call this

	return $db;	
}
function init_db() {
$db = &get_db(SQLITE3_OPEN_READWRITE | SQLITE3_OPEN_CREATE);
   $db->exec(' DROP table IF EXISTS HORSES;');
   $db->exec(' CREATE TABLE IF NOT EXISTS HORSES (HORSES_ID INTEGER, HORSES_NAME TEXT, HORSES_DATE INTEGER, HORSES_VERSION INTEGER, HORSES_IS_ACTIVE INTEGER, HORSES_DESCRIPTION TEXT, HORSE_IMAGE TEXT, HORSE_IMAGE_BASE64 TEXT, HORSES_LIKABLE Array, HORSES_RANCH TEXT);');
   $db->exec(' DROP table IF EXISTS FOOD;');
   $db->exec(' CREATE TABLE IF NOT EXISTS FOOD (FOOD_ID INTEGER, FOOD_NAME TEXT, FOOD_TOTAL_PRICE INTEGER);');
}
function DB_CREATE_HORSES($HORSES_ID, $HORSES_NAME, $HORSES_DATE, $HORSES_VERSION, $HORSES_IS_ACTIVE, $HORSES_DESCRIPTION, $HORSE_IMAGE, $HORSE_IMAGE_BASE64, $HORSES_LIKABLE, $HORSES_RANCH) {
    $db = &get_db(SQLITE3_OPEN_READWRITE);
    $prepare_sql = $db->prepare( 'INSERT INTO HORSES (HORSES_ID, HORSES_NAME, HORSES_DATE, HORSES_VERSION, HORSES_IS_ACTIVE, HORSES_DESCRIPTION, HORSE_IMAGE, HORSE_IMAGE_BASE64, HORSES_LIKABLE, HORSES_RANCH) VALUES (:HORSES_ID, :HORSES_NAME, :HORSES_DATE, :HORSES_VERSION, :HORSES_IS_ACTIVE, :HORSES_DESCRIPTION, :HORSE_IMAGE, :HORSE_IMAGE_BASE64, :HORSES_LIKABLE, :HORSES_RANCH)');
$prepare_sql->bindValue(':HORSES_ID', $HORSES_ID, SQLITE3_INTEGER);
$prepare_sql->bindValue(':HORSES_NAME', $HORSES_NAME, SQLITE3_TEXT);
$prepare_sql->bindValue(':HORSES_DATE', $HORSES_DATE, SQLITE3_INTEGER);
$prepare_sql->bindValue(':HORSES_VERSION', $HORSES_VERSION, SQLITE3_INTEGER);
$prepare_sql->bindValue(':HORSES_IS_ACTIVE', $HORSES_IS_ACTIVE, SQLITE3_INTEGER);
$prepare_sql->bindValue(':HORSES_DESCRIPTION', $HORSES_DESCRIPTION, SQLITE3_TEXT);
$prepare_sql->bindValue(':HORSE_IMAGE', $HORSE_IMAGE, SQLITE3_TEXT);
$prepare_sql->bindValue(':HORSE_IMAGE_BASE64', $HORSE_IMAGE_BASE64, SQLITE3_TEXT);
$prepare_sql->bindValue(':HORSES_LIKABLE', $HORSES_LIKABLE, SQLITE3_Array);
$prepare_sql->bindValue(':HORSES_RANCH', $HORSES_RANCH, SQLITE3_TEXT);
   $prepare_sql->execute();
   $db->close();
}

function DB_CREATE_FOOD($FOOD_ID, $FOOD_NAME, $FOOD_TOTAL_PRICE) {
    $db = &get_db(SQLITE3_OPEN_READWRITE);
    $prepare_sql = $db->prepare( 'INSERT INTO FOOD (FOOD_ID, FOOD_NAME, FOOD_TOTAL_PRICE) VALUES (:FOOD_ID, :FOOD_NAME, :FOOD_TOTAL_PRICE)');
$prepare_sql->bindValue(':FOOD_ID', $FOOD_ID, SQLITE3_INTEGER);
$prepare_sql->bindValue(':FOOD_NAME', $FOOD_NAME, SQLITE3_TEXT);
$prepare_sql->bindValue(':FOOD_TOTAL_PRICE', $FOOD_TOTAL_PRICE, SQLITE3_INTEGER);
   $prepare_sql->execute();
   $db->close();
}

function DB_UPDATE_HORSES($HORSES_ID, $HORSES_NAME, $HORSES_DATE, $HORSES_VERSION, $HORSES_IS_ACTIVE, $HORSES_DESCRIPTION, $HORSE_IMAGE, $HORSE_IMAGE_BASE64, $HORSES_LIKABLE, $HORSES_RANCH) {
   $db = &get_db(SQLITE3_OPEN_READWRITE);
   $prepare_sql = $db->prepare( 'UPDATE HORSES SET HORSES_ID= :HORSES_ID, HORSES_NAME= :HORSES_NAME, HORSES_DATE= :HORSES_DATE, HORSES_VERSION= :HORSES_VERSION, HORSES_IS_ACTIVE= :HORSES_IS_ACTIVE, HORSES_DESCRIPTION= :HORSES_DESCRIPTION, HORSE_IMAGE= :HORSE_IMAGE, HORSE_IMAGE_BASE64= :HORSE_IMAGE_BASE64, HORSES_LIKABLE= :HORSES_LIKABLE, HORSES_RANCH= :HORSES_RANCH WHERE HORSES_ID=:HORSES_ID;');$prepare_sql->bindValue(':HORSES_ID', $HORSES_ID, SQLITE3_INTEGER);
$prepare_sql->bindValue(':HORSES_NAME', $HORSES_NAME, SQLITE3_TEXT);
$prepare_sql->bindValue(':HORSES_DATE', $HORSES_DATE, SQLITE3_INTEGER);
$prepare_sql->bindValue(':HORSES_VERSION', $HORSES_VERSION, SQLITE3_INTEGER);
$prepare_sql->bindValue(':HORSES_IS_ACTIVE', $HORSES_IS_ACTIVE, SQLITE3_INTEGER);
$prepare_sql->bindValue(':HORSES_DESCRIPTION', $HORSES_DESCRIPTION, SQLITE3_TEXT);
$prepare_sql->bindValue(':HORSE_IMAGE', $HORSE_IMAGE, SQLITE3_TEXT);
$prepare_sql->bindValue(':HORSE_IMAGE_BASE64', $HORSE_IMAGE_BASE64, SQLITE3_TEXT);
$prepare_sql->bindValue(':HORSES_LIKABLE', $HORSES_LIKABLE, SQLITE3_Array);
$prepare_sql->bindValue(':HORSES_RANCH', $HORSES_RANCH, SQLITE3_TEXT);
   $prepare_sql->execute();
   $db->close();
}

function DB_UPDATE_FOOD($FOOD_ID, $FOOD_NAME, $FOOD_TOTAL_PRICE) {
   $db = &get_db(SQLITE3_OPEN_READWRITE);
   $prepare_sql = $db->prepare( 'UPDATE FOOD SET FOOD_ID= :FOOD_ID, FOOD_NAME= :FOOD_NAME, FOOD_TOTAL_PRICE= :FOOD_TOTAL_PRICE WHERE FOOD_ID=:FOOD_ID;');$prepare_sql->bindValue(':FOOD_ID', $FOOD_ID, SQLITE3_INTEGER);
$prepare_sql->bindValue(':FOOD_NAME', $FOOD_NAME, SQLITE3_TEXT);
$prepare_sql->bindValue(':FOOD_TOTAL_PRICE', $FOOD_TOTAL_PRICE, SQLITE3_INTEGER);
   $prepare_sql->execute();
   $db->close();
}

function DB_DELETE_HORSES($HORSES_ID) {
   $db = &get_db(SQLITE3_OPEN_READWRITE);
   $prepare_sql = $db->prepare( 'DELETE FROM HORSES WHERE HORSES_ID = ?');
   $prepare_sql->bindValue(1, $HORSES_ID, SQLITE3_INTEGER); 
   $prepare_sql->execute();
   $db->close();
}

function DB_DELETE_FOOD($FOOD_ID) {
   $db = &get_db(SQLITE3_OPEN_READWRITE);
   $prepare_sql = $db->prepare( 'DELETE FROM FOOD WHERE FOOD_ID = ?');
   $prepare_sql->bindValue(1, $FOOD_ID, SQLITE3_INTEGER); 
   $prepare_sql->execute();
   $db->close();
}

function DB_SELECT_HORSES_RANGE_HORSES_ID($LOWER_RANGE, $UPPER_RANGE) {
   $db = &get_db(SQLITE3_OPEN_READONLY);
   $prepare_sql = $db->prepare( 'SELECT * FROM HORSES WHERE HORSES_ID >= ? AND <= ? ');
   $prepare_sql->bindValue(1, $LOWER_RANGE, SQLITE3_INTEGER); 
   $prepare_sql->bindValue(2, $UPPER_RANGE, SQLITE3_INTEGER); 
    $select_query_result = $prepare_sql->execute();
    $array_return = array();
   if( is_a($select_query_result, 'SQLite3Result' )  )
   {
	   while($arrayrow = $select_query_result->fetchArray(SQLITE3_ASSOC) ){
		   $array_return[]=$arrayrow;
	   }
   }
   $db->close();
   return $array_return;
}


function DB_SELECT_HORSES_EXACT_HORSES_ID($HORSES_ID) {
   $db = &get_db(SQLITE3_OPEN_READONLY);
   $prepare_sql = $db->prepare( 'SELECT * FROM HORSES WHERE HORSES_ID = ?');
   $prepare_sql->bindValue(1, $HORSES_ID, SQLITE3_INTEGER); 
    $select_query_result = $prepare_sql->execute();
    $array_return = array();
   if( is_a($select_query_result, 'SQLite3Result' )  )
   {
	   while($arrayrow = $select_query_result->fetchArray(SQLITE3_ASSOC) ){
		   $array_return[]=$arrayrow;
	   }
   }
   $db->close();
   return $array_return;
}


function DB_SELECT_HORSES_EXACT_HORSES_NAME($HORSES_NAME) {
   $db = &get_db(SQLITE3_OPEN_READONLY);
   $prepare_sql = $db->prepare( 'SELECT * FROM HORSES WHERE HORSES_NAME = ?');
   $prepare_sql->bindValue(1, $HORSES_NAME, SQLITE3_TEXT); 
    $select_query_result = $prepare_sql->execute();
    $array_return = array();
   if( is_a($select_query_result, 'SQLite3Result' )  )
   {
	   while($arrayrow = $select_query_result->fetchArray(SQLITE3_ASSOC) ){
		   $array_return[]=$arrayrow;
	   }
   }
   $db->close();
   return $array_return;
}


function DB_SELECT_HORSES_LIKE_HORSES_NAME($LIMIT) {
   $db = &get_db(SQLITE3_OPEN_READONLY);
   $prepare_sql = $db->prepare( 'SELECT * FROM HORSES WHERE HORSES_NAME LIKE ?');
   $prepare_sql->bindValue(1, '%'.$HORSES_NAME.'%', SQLITE3_TEXT); 
   $prepare_sql->bindValue(2, $LIMIT, SQLITE3_INTEGER); 
    $select_query_result = $prepare_sql->execute();
    $array_return = array();
   if( is_a($select_query_result, 'SQLite3Result' )  )
   {
	   while($arrayrow = $select_query_result->fetchArray(SQLITE3_ASSOC) ){
		   $array_return[]=$arrayrow;
	   }
   }
   $db->close();
   return $array_return;
}


function DB_SELECT_HORSES_RANGE_HORSES_DATE($LOWER_RANGE, $UPPER_RANGE) {
   $db = &get_db(SQLITE3_OPEN_READONLY);
   $prepare_sql = $db->prepare( 'SELECT * FROM HORSES WHERE HORSES_DATE >= ? AND <= ? ');
   $prepare_sql->bindValue(1, $LOWER_RANGE, SQLITE3_INTEGER); 
   $prepare_sql->bindValue(2, $UPPER_RANGE, SQLITE3_INTEGER); 
    $select_query_result = $prepare_sql->execute();
    $array_return = array();
   if( is_a($select_query_result, 'SQLite3Result' )  )
   {
	   while($arrayrow = $select_query_result->fetchArray(SQLITE3_ASSOC) ){
		   $array_return[]=$arrayrow;
	   }
   }
   $db->close();
   return $array_return;
}


function DB_SELECT_HORSES_EXACT_HORSES_DATE($HORSES_DATE) {
   $db = &get_db(SQLITE3_OPEN_READONLY);
   $prepare_sql = $db->prepare( 'SELECT * FROM HORSES WHERE HORSES_DATE = ?');
   $prepare_sql->bindValue(1, $HORSES_DATE, SQLITE3_INTEGER); 
    $select_query_result = $prepare_sql->execute();
    $array_return = array();
   if( is_a($select_query_result, 'SQLite3Result' )  )
   {
	   while($arrayrow = $select_query_result->fetchArray(SQLITE3_ASSOC) ){
		   $array_return[]=$arrayrow;
	   }
   }
   $db->close();
   return $array_return;
}


function DB_SELECT_HORSES_RANGE_HORSES_VERSION($LOWER_RANGE, $UPPER_RANGE) {
   $db = &get_db(SQLITE3_OPEN_READONLY);
   $prepare_sql = $db->prepare( 'SELECT * FROM HORSES WHERE HORSES_VERSION >= ? AND <= ? ');
   $prepare_sql->bindValue(1, $LOWER_RANGE, SQLITE3_INTEGER); 
   $prepare_sql->bindValue(2, $UPPER_RANGE, SQLITE3_INTEGER); 
    $select_query_result = $prepare_sql->execute();
    $array_return = array();
   if( is_a($select_query_result, 'SQLite3Result' )  )
   {
	   while($arrayrow = $select_query_result->fetchArray(SQLITE3_ASSOC) ){
		   $array_return[]=$arrayrow;
	   }
   }
   $db->close();
   return $array_return;
}


function DB_SELECT_HORSES_EXACT_HORSES_VERSION($HORSES_VERSION) {
   $db = &get_db(SQLITE3_OPEN_READONLY);
   $prepare_sql = $db->prepare( 'SELECT * FROM HORSES WHERE HORSES_VERSION = ?');
   $prepare_sql->bindValue(1, $HORSES_VERSION, SQLITE3_INTEGER); 
    $select_query_result = $prepare_sql->execute();
    $array_return = array();
   if( is_a($select_query_result, 'SQLite3Result' )  )
   {
	   while($arrayrow = $select_query_result->fetchArray(SQLITE3_ASSOC) ){
		   $array_return[]=$arrayrow;
	   }
   }
   $db->close();
   return $array_return;
}


function DB_SELECT_HORSES_RANGE_HORSES_IS_ACTIVE($LOWER_RANGE, $UPPER_RANGE) {
   $db = &get_db(SQLITE3_OPEN_READONLY);
   $prepare_sql = $db->prepare( 'SELECT * FROM HORSES WHERE HORSES_IS_ACTIVE >= ? AND <= ? ');
   $prepare_sql->bindValue(1, $LOWER_RANGE, SQLITE3_INTEGER); 
   $prepare_sql->bindValue(2, $UPPER_RANGE, SQLITE3_INTEGER); 
    $select_query_result = $prepare_sql->execute();
    $array_return = array();
   if( is_a($select_query_result, 'SQLite3Result' )  )
   {
	   while($arrayrow = $select_query_result->fetchArray(SQLITE3_ASSOC) ){
		   $array_return[]=$arrayrow;
	   }
   }
   $db->close();
   return $array_return;
}


function DB_SELECT_HORSES_EXACT_HORSES_IS_ACTIVE($HORSES_IS_ACTIVE) {
   $db = &get_db(SQLITE3_OPEN_READONLY);
   $prepare_sql = $db->prepare( 'SELECT * FROM HORSES WHERE HORSES_IS_ACTIVE = ?');
   $prepare_sql->bindValue(1, $HORSES_IS_ACTIVE, SQLITE3_INTEGER); 
    $select_query_result = $prepare_sql->execute();
    $array_return = array();
   if( is_a($select_query_result, 'SQLite3Result' )  )
   {
	   while($arrayrow = $select_query_result->fetchArray(SQLITE3_ASSOC) ){
		   $array_return[]=$arrayrow;
	   }
   }
   $db->close();
   return $array_return;
}


function DB_SELECT_HORSES_EXACT_HORSES_DESCRIPTION($HORSES_DESCRIPTION) {
   $db = &get_db(SQLITE3_OPEN_READONLY);
   $prepare_sql = $db->prepare( 'SELECT * FROM HORSES WHERE HORSES_DESCRIPTION = ?');
   $prepare_sql->bindValue(1, $HORSES_DESCRIPTION, SQLITE3_TEXT); 
    $select_query_result = $prepare_sql->execute();
    $array_return = array();
   if( is_a($select_query_result, 'SQLite3Result' )  )
   {
	   while($arrayrow = $select_query_result->fetchArray(SQLITE3_ASSOC) ){
		   $array_return[]=$arrayrow;
	   }
   }
   $db->close();
   return $array_return;
}


function DB_SELECT_HORSES_LIKE_HORSES_DESCRIPTION($LIMIT) {
   $db = &get_db(SQLITE3_OPEN_READONLY);
   $prepare_sql = $db->prepare( 'SELECT * FROM HORSES WHERE HORSES_DESCRIPTION LIKE ?');
   $prepare_sql->bindValue(1, '%'.$HORSES_DESCRIPTION.'%', SQLITE3_TEXT); 
   $prepare_sql->bindValue(2, $LIMIT, SQLITE3_INTEGER); 
    $select_query_result = $prepare_sql->execute();
    $array_return = array();
   if( is_a($select_query_result, 'SQLite3Result' )  )
   {
	   while($arrayrow = $select_query_result->fetchArray(SQLITE3_ASSOC) ){
		   $array_return[]=$arrayrow;
	   }
   }
   $db->close();
   return $array_return;
}


function DB_SELECT_HORSES_EXACT_HORSE_IMAGE($HORSE_IMAGE) {
   $db = &get_db(SQLITE3_OPEN_READONLY);
   $prepare_sql = $db->prepare( 'SELECT * FROM HORSES WHERE HORSE_IMAGE = ?');
   $prepare_sql->bindValue(1, $HORSE_IMAGE, SQLITE3_TEXT); 
    $select_query_result = $prepare_sql->execute();
    $array_return = array();
   if( is_a($select_query_result, 'SQLite3Result' )  )
   {
	   while($arrayrow = $select_query_result->fetchArray(SQLITE3_ASSOC) ){
		   $array_return[]=$arrayrow;
	   }
   }
   $db->close();
   return $array_return;
}


function DB_SELECT_HORSES_LIKE_HORSE_IMAGE($LIMIT) {
   $db = &get_db(SQLITE3_OPEN_READONLY);
   $prepare_sql = $db->prepare( 'SELECT * FROM HORSES WHERE HORSE_IMAGE LIKE ?');
   $prepare_sql->bindValue(1, '%'.$HORSE_IMAGE.'%', SQLITE3_TEXT); 
   $prepare_sql->bindValue(2, $LIMIT, SQLITE3_INTEGER); 
    $select_query_result = $prepare_sql->execute();
    $array_return = array();
   if( is_a($select_query_result, 'SQLite3Result' )  )
   {
	   while($arrayrow = $select_query_result->fetchArray(SQLITE3_ASSOC) ){
		   $array_return[]=$arrayrow;
	   }
   }
   $db->close();
   return $array_return;
}


function DB_SELECT_HORSES_EXACT_HORSE_IMAGE_BASE64($HORSE_IMAGE_BASE64) {
   $db = &get_db(SQLITE3_OPEN_READONLY);
   $prepare_sql = $db->prepare( 'SELECT * FROM HORSES WHERE HORSE_IMAGE_BASE64 = ?');
   $prepare_sql->bindValue(1, $HORSE_IMAGE_BASE64, SQLITE3_TEXT); 
    $select_query_result = $prepare_sql->execute();
    $array_return = array();
   if( is_a($select_query_result, 'SQLite3Result' )  )
   {
	   while($arrayrow = $select_query_result->fetchArray(SQLITE3_ASSOC) ){
		   $array_return[]=$arrayrow;
	   }
   }
   $db->close();
   return $array_return;
}


function DB_SELECT_HORSES_LIKE_HORSE_IMAGE_BASE64($LIMIT) {
   $db = &get_db(SQLITE3_OPEN_READONLY);
   $prepare_sql = $db->prepare( 'SELECT * FROM HORSES WHERE HORSE_IMAGE_BASE64 LIKE ?');
   $prepare_sql->bindValue(1, '%'.$HORSE_IMAGE_BASE64.'%', SQLITE3_TEXT); 
   $prepare_sql->bindValue(2, $LIMIT, SQLITE3_INTEGER); 
    $select_query_result = $prepare_sql->execute();
    $array_return = array();
   if( is_a($select_query_result, 'SQLite3Result' )  )
   {
	   while($arrayrow = $select_query_result->fetchArray(SQLITE3_ASSOC) ){
		   $array_return[]=$arrayrow;
	   }
   }
   $db->close();
   return $array_return;
}


function DB_SELECT_HORSES_RANGE_HORSES_LIKABLE($LOWER_RANGE, $UPPER_RANGE) {
   $db = &get_db(SQLITE3_OPEN_READONLY);
    $select_query_result = $prepare_sql->execute();
    $array_return = array();
   if( is_a($select_query_result, 'SQLite3Result' )  )
   {
	   while($arrayrow = $select_query_result->fetchArray(SQLITE3_ASSOC) ){
		   $array_return[]=$arrayrow;
	   }
   }
   $db->close();
   return $array_return;
}


function DB_SELECT_HORSES_EXACT_HORSES_LIKABLE($HORSES_LIKABLE) {
   $db = &get_db(SQLITE3_OPEN_READONLY);
   $prepare_sql = $db->prepare( 'SELECT * FROM HORSES WHERE HORSES_LIKABLE = ?');
   $prepare_sql->bindValue(1, $HORSES_LIKABLE, SQLITE3_Array); 
    $select_query_result = $prepare_sql->execute();
    $array_return = array();
   if( is_a($select_query_result, 'SQLite3Result' )  )
   {
	   while($arrayrow = $select_query_result->fetchArray(SQLITE3_ASSOC) ){
		   $array_return[]=$arrayrow;
	   }
   }
   $db->close();
   return $array_return;
}


function DB_SELECT_HORSES_LIKE_HORSES_LIKABLE($LIMIT) {
   $db = &get_db(SQLITE3_OPEN_READONLY);
    $select_query_result = $prepare_sql->execute();
    $array_return = array();
   if( is_a($select_query_result, 'SQLite3Result' )  )
   {
	   while($arrayrow = $select_query_result->fetchArray(SQLITE3_ASSOC) ){
		   $array_return[]=$arrayrow;
	   }
   }
   $db->close();
   return $array_return;
}


function DB_SELECT_HORSES_EXACT_HORSES_RANCH($HORSES_RANCH) {
   $db = &get_db(SQLITE3_OPEN_READONLY);
   $prepare_sql = $db->prepare( 'SELECT * FROM HORSES WHERE HORSES_RANCH = ?');
   $prepare_sql->bindValue(1, $HORSES_RANCH, SQLITE3_TEXT); 
    $select_query_result = $prepare_sql->execute();
    $array_return = array();
   if( is_a($select_query_result, 'SQLite3Result' )  )
   {
	   while($arrayrow = $select_query_result->fetchArray(SQLITE3_ASSOC) ){
		   $array_return[]=$arrayrow;
	   }
   }
   $db->close();
   return $array_return;
}


function DB_SELECT_HORSES_LIKE_HORSES_RANCH($LIMIT) {
   $db = &get_db(SQLITE3_OPEN_READONLY);
   $prepare_sql = $db->prepare( 'SELECT * FROM HORSES WHERE HORSES_RANCH LIKE ?');
   $prepare_sql->bindValue(1, '%'.$HORSES_RANCH.'%', SQLITE3_TEXT); 
   $prepare_sql->bindValue(2, $LIMIT, SQLITE3_INTEGER); 
    $select_query_result = $prepare_sql->execute();
    $array_return = array();
   if( is_a($select_query_result, 'SQLite3Result' )  )
   {
	   while($arrayrow = $select_query_result->fetchArray(SQLITE3_ASSOC) ){
		   $array_return[]=$arrayrow;
	   }
   }
   $db->close();
   return $array_return;
}


function DB_SELECT_FOOD_RANGE_FOOD_ID($LOWER_RANGE, $UPPER_RANGE) {
   $db = &get_db(SQLITE3_OPEN_READONLY);
   $prepare_sql = $db->prepare( 'SELECT * FROM FOOD WHERE FOOD_ID >= ? AND <= ? ');
   $prepare_sql->bindValue(1, $LOWER_RANGE, SQLITE3_INTEGER); 
   $prepare_sql->bindValue(2, $UPPER_RANGE, SQLITE3_INTEGER); 
    $select_query_result = $prepare_sql->execute();
    $array_return = array();
   if( is_a($select_query_result, 'SQLite3Result' )  )
   {
	   while($arrayrow = $select_query_result->fetchArray(SQLITE3_ASSOC) ){
		   $array_return[]=$arrayrow;
	   }
   }
   $db->close();
   return $array_return;
}


function DB_SELECT_FOOD_EXACT_FOOD_ID($FOOD_ID) {
   $db = &get_db(SQLITE3_OPEN_READONLY);
   $prepare_sql = $db->prepare( 'SELECT * FROM FOOD WHERE FOOD_ID = ?');
   $prepare_sql->bindValue(1, $FOOD_ID, SQLITE3_INTEGER); 
    $select_query_result = $prepare_sql->execute();
    $array_return = array();
   if( is_a($select_query_result, 'SQLite3Result' )  )
   {
	   while($arrayrow = $select_query_result->fetchArray(SQLITE3_ASSOC) ){
		   $array_return[]=$arrayrow;
	   }
   }
   $db->close();
   return $array_return;
}


function DB_SELECT_FOOD_EXACT_FOOD_NAME($FOOD_NAME) {
   $db = &get_db(SQLITE3_OPEN_READONLY);
   $prepare_sql = $db->prepare( 'SELECT * FROM FOOD WHERE FOOD_NAME = ?');
   $prepare_sql->bindValue(1, $FOOD_NAME, SQLITE3_TEXT); 
    $select_query_result = $prepare_sql->execute();
    $array_return = array();
   if( is_a($select_query_result, 'SQLite3Result' )  )
   {
	   while($arrayrow = $select_query_result->fetchArray(SQLITE3_ASSOC) ){
		   $array_return[]=$arrayrow;
	   }
   }
   $db->close();
   return $array_return;
}


function DB_SELECT_FOOD_LIKE_FOOD_NAME($LIMIT) {
   $db = &get_db(SQLITE3_OPEN_READONLY);
   $prepare_sql = $db->prepare( 'SELECT * FROM FOOD WHERE FOOD_NAME LIKE ?');
   $prepare_sql->bindValue(1, '%'.$FOOD_NAME.'%', SQLITE3_TEXT); 
   $prepare_sql->bindValue(2, $LIMIT, SQLITE3_INTEGER); 
    $select_query_result = $prepare_sql->execute();
    $array_return = array();
   if( is_a($select_query_result, 'SQLite3Result' )  )
   {
	   while($arrayrow = $select_query_result->fetchArray(SQLITE3_ASSOC) ){
		   $array_return[]=$arrayrow;
	   }
   }
   $db->close();
   return $array_return;
}


function DB_SELECT_FOOD_RANGE_FOOD_TOTAL_PRICE($LOWER_RANGE, $UPPER_RANGE) {
   $db = &get_db(SQLITE3_OPEN_READONLY);
   $prepare_sql = $db->prepare( 'SELECT * FROM FOOD WHERE FOOD_TOTAL_PRICE >= ? AND <= ? ');
   $prepare_sql->bindValue(1, $LOWER_RANGE, SQLITE3_INTEGER); 
   $prepare_sql->bindValue(2, $UPPER_RANGE, SQLITE3_INTEGER); 
    $select_query_result = $prepare_sql->execute();
    $array_return = array();
   if( is_a($select_query_result, 'SQLite3Result' )  )
   {
	   while($arrayrow = $select_query_result->fetchArray(SQLITE3_ASSOC) ){
		   $array_return[]=$arrayrow;
	   }
   }
   $db->close();
   return $array_return;
}


function DB_SELECT_FOOD_EXACT_FOOD_TOTAL_PRICE($FOOD_TOTAL_PRICE) {
   $db = &get_db(SQLITE3_OPEN_READONLY);
   $prepare_sql = $db->prepare( 'SELECT * FROM FOOD WHERE FOOD_TOTAL_PRICE = ?');
   $prepare_sql->bindValue(1, $FOOD_TOTAL_PRICE, SQLITE3_INTEGER); 
    $select_query_result = $prepare_sql->execute();
    $array_return = array();
   if( is_a($select_query_result, 'SQLite3Result' )  )
   {
	   while($arrayrow = $select_query_result->fetchArray(SQLITE3_ASSOC) ){
		   $array_return[]=$arrayrow;
	   }
   }
   $db->close();
   return $array_return;
}


?>