<?php
$db_name = 'keresearch_emerald';

$conn = mysqli_connect("localhost","keresearch_emerald","W2TQfwwkoaD)");

if(!$conn){
    die('Could not connect:'.mysqli_connect_error());
}
mysqli_select_db($conn,$db_name) or die("database not connected");

$tabs = array("Profiling","Traveller");
$subtabs = array(array("Overall Level Base"),array("Duty Free"));

$airport = array("1"=>"Ahmedabad","2"=>"Lucknow","3"=>"Mangaluru","4"=>"Jaipur","5"=>"Guwahati","6"=>"Thiruvananthapuram","7"=>"Mumbai");
//$airport = array("2"=>"Lucknow");

//$airportFF = array("1"=>"Ahmedabad","2"=>"Lucknow","3"=>"Mangaluru","4"=>"Jaipur","5"=>"Guwahati","6"=>"Thiruvananthapuram","7"=>"Mumbai");

$gender = array("1"=>"Male","2"=>"Female");
$age = array("2"=>"18 – 30 years","3"=>"31 – 40 years","4"=>"41 – 50 years","5"=>"51 – 60 years");
$month = array("1" => "January","2" => "February","3" => "March","4" => "April","5" => "May","6" => "June","7" => "July","8" => "August","9" => "September","10" => "October","11" => "November","12" => "December");
$days = array("1"=>"Monday","2"=>"Tuesday","3"=>"Wednesday","4"=>"Thursday","5"=>"Friday","6"=>"Saturday","7"=>"Sunday");
$days_type = array("1"=>"Weekday","2"=>"Weekend");
$terminal = array("1"=>"Terminal 1","2"=>"Terminal 2","3"=>"Terminal 3");
$income = array("1"=>"Upto 5 lacs","2"=>"5 to 10 lacs","3"=>"10-20 lacs","4"=>"20 lacs or more");
$traveller = array("1"=>"Domestic","2"=>"International");
$trip = array("1"=>"1 – 2","2"=>"3 – 5","3"=>"6 – 10","4"=>"11 – 20","5"=>"21 or more");
$rot = array("1"=>"Leisure (vacations, holiday, tours, visiting friends/family/relatives)","2"=>"Business/ Work (meetings, training, workshop, conference, project work/consulting)","3"=>"Education/ Student (other than leisure /business travel)","4"=>"Medical/Health (availing treatments for self or family members)","5"=>"Religious/ Pilgrimage");
$rotF = array("1"=>"Leisure","2"=>"Business/ Work","3"=>"Education/Student","4"=>"Medical/Health","5"=>"Religious/Pilgrimage");
$segment = array("1"=>"Traveller","2"=>"Non-Traveller");
$types = array("1"=>"Departure","2"=>"Arrival");
$dwell_time = array("1"=>"Less than 30 mins","2"=>"30 – 45 mins","3"=>"45 mins – 1 hr","4"=>"1 hr – 2 hrs","5"=>"2 – 4 hrs","6"=>"More than 4 hrs");
$travelling = array("1"=>"Solo","2"=>"Family & relatives","3"=>"Group  of work colleagues","4"=>"Group of friends");
$occupation = array();















// $quarter = array("1"=>"Q1","2"=>"Q2","3"=>"Q3");
// $segment = array("2"=>"Arrivals","1"=>"Departures","3"=>"Meeter Greeter");

// $data_type = array("Mean","Top 2 Score","Bottom 2 Score");
// $time_period = array("Weekly","3 Month Rolling","6 Month Rolling","Quarterly");
// $week = array("1"=>"Monday","2"=>"Tuesday","3"=>"Wednesday","4"=>"Thursday","5"=>"Friday","6"=>"Saturday","7"=>"Sunday");
// $weekL = array("Monday","Tuesday","Wednesday","Thursday","Friday","Saturday","Sunday");
// $weekday = array("1"=>"Weekday","2"=>"Weekend");




// $nccs = array("1"=>"NCCS A1","2"=>"NCCS A2","3"=>"NCCS A3","4"=>"NCCS B","5"=>"NCCS C");
// $mode = array("1"=>"First class","2"=>"Business Class","3"=>"Premium economy","4"=>"Economy Class");
// $mode2 = array("1"=>"Private / Company car","2"=>"Private car drop off by someone ","3"=>"Ride Sharing","4"=>"Taxi / Auto","5"=>"Public transport - Bus");
// $occupation = array("1"=>"Working for a company – Entry level managerial profile","2"=>"Working for a company - Mid management corporate profile","3"=>"Working for a company - Higher management corporate profile","4"=>"Entrepreneur/ Self-owned business/ Self Employed","5"=>"Working in a company (non-managerial role)","6"=>"Professionals like doctors/lawyers/CAs etc.","7"=>"Housewife / House Husband","8"=>"Student");
// $accompaniment = array("1"=>"Alone","2"=>"Family with Kids (less than 5 years)","3"=>"Family with Kids (from 5 – 18 year)","4"=>"Family that includes elderly members (senior citizens)","5"=>"Colleagues / Friends","6"=>"A group / tour");
// $rot = array("1"=>"Leisure Travel (this would include vacations, visiting friends/family)","2"=>"Business travel (this would include Training, workshop, conference, project work)","3"=>"For Education reasons other than leisure /business travel","4"=>"For Medical reasons other than leisure /business travel","5"=>"For Religious reasons other than leisure /business travel","6"=>"For Personal reasons other than leisure /business travel");
// $rotF = array("1"=>"Leisure Travel","2"=>"Business travel","3"=>"For Education reasons","4"=>"For Medical reasons","5"=>"For Religious reasons","6"=>"For Personal reasons");
// $trip = array("1"=>"1 – 2","2"=>"3 – 5","3"=>"6 – 10","4"=>"11 – 20","5"=>"21 or more");
// $month = array("2"=>"February","3"=>"March","4"=>"April","5"=>"May","6"=>"June","7"=>"July","8"=>"August");
//$month = array("1" => "January","2" => "February","3" => "March","4" => "April","5" => "May","6" => "June","7" => "July","8" => "August","9" => "September","10" => "October","11" => "November","12" => "December");

// $week3 = array(7,8,9,10,11,12,13,14);

?>







