<?php
date_default_timezone_set('Asia/Manila');
header('Content-Type: application/json');
error_reporting(0); 
$sqlUser = 'autoph_arnel';
$sqlDatabase = 'autoph_connect';
$sqlPass = 'Hke@2001';
$toDate = date_create() ->format("m/d/Y"); // for viewing date only
$myDate ="As of ".$toDate;

$conn = mysql_connect($sqlHost, $sqlUser, $sqlPass) or die ("Couldn't connct to MySQL server on $sqlHost: ". mysql_error(). '.');
$db =  mysql_select_db($sqlDatabase, $conn) or die ("Couldn't select database $sqlDatabase: ". mysql_error(). '.');
 
 
$productINFO= $_REQUEST['productINFOKey'];  
$searchKey= $_REQUEST['searchKey'];  
$searchText= $_REQUEST['searchText'];   

if($searchKey==10090706112122){ 
    $return_news = Array();
    $getBrandID = mysql_result(mysql_query("SELECT `b_id` FROM `vts_brands` WHERE `b_name` LIKE '%$searchText%' ||  `b_desc` LIKE '%$searchText%'"),0);
    if($getBrandID > 0){
        $sql = "SELECT * FROM vts_model WHERE catalog_link !='' AND `m_status`= 1 AND `m_name` LIKE '%$searchText%' || catalog_link !='' AND `m_status`= 1 AND `m_desc` LIKE '%$searchText%' || catalog_link !='' AND `m_status`= 1 AND `b_id` = '$getBrandID' ORDER BY m_name ASC ";
    }else{
	$sql = "SELECT * FROM vts_model WHERE catalog_link !='' AND `m_status`= 1 AND `m_name` LIKE '%$searchText%' || catalog_link !='' AND `m_status`= 1 AND `m_desc` LIKE '%$searchText%' ORDER BY m_name ASC ";
    }
	$sqlTable = mysql_query($sql, $conn);
		while($sqlRecord = mysql_fetch_assoc($sqlTable))
	{ 
        
        $return_news[]= $sqlRecord;
       
	}
    $json = json_encode($return_news);
    
} 

if($productINFO==10240911070721200106222015){ 
    $return_news = Array();
	$sql = "SELECT * FROM vts_model WHERE catalog_link !='' AND `m_status`= 1 ORDER BY m_name ASC ";
	
	$sqlTable = mysql_query($sql, $conn);
		while($sqlRecord = mysql_fetch_assoc($sqlTable))
	{ 
        
        $return_news[]= $sqlRecord;
       
	}
    $json = json_encode($return_news);
    
}  

if($did_something === 0)
{
	$msg = did_nothing_message;
	$json = json_encode(["status" => "$MyCustomerID", "statusCode" => "$customerType"]);
}
echo $json;
 
 
?>