<?php 
 include 'core/database/connect.php';
//$connect_error = 'Sorry, we\'re experiencing connection problem.  Please try again later...  Thank you!';
//mysql_connect('localhost','root','aee1024') or die ($connect_error);
//mysql_select_db('db_vts') or die($connect_error);
//error_reporting(1);
//$userID=$user_data['u_id'];
$toDate = date_create() ->format("Y-m-d"); 
 ?> 
  
  
<?php
	//if submit/ save to databasevar  	 
	if(isset($_POST['done'])){
		$userBrand = mysql_escape_string($_POST['userBrand']);		
		$financingTitle = mysql_escape_string($_POST['financingTitle']);		
		$financingStart = mysql_escape_string($_POST['financingStart']);		 
		$financingEnd = mysql_escape_string($_POST['financingEnd']);	
 		$financingDesc = mysql_escape_string($_POST['financingDesc']);	
		$MyUserID = mysql_escape_string($_POST['MyUserID']);	
		$UserCompanyName = mysql_escape_string($_POST['UserCompanyName']);	
		$MyUserFName = mysql_escape_string($_POST['MyUserFName']);	
		
		//=====================================================================================================================================================
		//=====================================================================================================================================================
	   	 mysql_query("INSERT INTO vts_financing_promo_list (brand_code, title, start_date, end_date, description, uploaded_by, date_added, company_code)
				VALUES('{$userBrand}','{$financingTitle}','{$financingStart}','{$financingEnd}','{$financingDesc}','{$MyUserFName}','{$toDate}','{$UserCompanyName}')");	
				echo "New PRICELIST has been added and posted to the APP";
				//mysql_query("UPDATE db_vehicle_inventory SET `price`='$unitPriceA',`discount`='$unitDiscountA',`commission`='$unitCommA' WHERE description ='$unitDesc'");
		//UPDATE TABLE AFTER SAVING THE RECORD

		exit();
	}
?>