<?php
$db_name = 'keresearch_cherry';

$conn = mysqli_connect("localhost","keresearch_cherry","mhnJyUwr{~r_");

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

$tabs = array("KPI","Pre Sales","Facility/Infrastucture","Sales Initiation","Test Drive","Booking and Deal Closure","Waiting Period","Delivery ","Post Sales");
$city = array("1"=>"DEHRADUN","2"=>"CHANDIGARH","3"=>"JALLANDHAR","4"=>"JAMMU","5"=>"SRINAGAR","6"=>"AGRA","7"=>"GORAKHPUR","8"=>"KANPUR","9"=>"LUCKNOW","10"=>"KOLKATA","11"=>"PATNA","12"=>"RANCHI","13"=>"GUWAHATI","14"=>"GOA","15"=>"MUMBAI","16"=>"NAGPUR","17"=>"PUNE","18"=>"AHMEDABAD","19"=>"RAJKOT","20"=>"SURAT","21"=>"VADODARA","22"=>"CHENNAI","23"=>"COIMBATORE","24"=>"MADURAI","25"=>"BANGALORE","26"=>"CALICUT","27"=>"COCHIN","28"=>"MALAPPURAM","29"=>"TRIVANDRUM","30"=>"NCR","31"=>"JAIPUR","32"=>"UDAIPUR","33"=>"BHOPAL","34"=>"GWALIOR","35"=>"INDORE","36"=>"HYDERABAD","37"=>"VIJAYAWADA","38"=>"VISHAKHAPATNAM","39"=>"BHUBANESHWAR","40"=>"RAIPUR");
$zone = array("1"=>"North","2"=>"East","3"=>"West","4"=>"South","5"=>"Central","6"=>"South - East");
$region = array("1"=>"North-1","2"=>"North-2","3"=>"North-3","4"=>"East-1","5"=>"East-2","6"=>"East-3","7"=>"West-1","8"=>"West-2","9"=>"West-3","10"=>"South-1","11"=>"South-2","12"=>"South-3","13"=>"Central-1 & Central-2","14"=>"Central-3","15"=>"Central-4","16"=>"South-East-1","17"=>"South-East-2");
// $time = array("1"=>"Between 1st June 2023 and 30th November 2023","2"=>"Before 1st June 2023","3"=>"Between 1st July 2023 and 31st December 2023","4"=>"Before 1st July 2023","5"=>"Between 1st August 2023 and 31st January 2024","6"=>"Before 1st August 2023");
$time = array("1"=>"Wave 1");
//$brand = array("4"=>"Maruti Suzuki Arena","5"=>"Maruti Suzuki Nexa","1"=>"Hyundai","2"=>"Kia","3"=>"Mahindra","6"=>"Tata Motors","7"=>"Toyota","8"=>"MG");
$brandTxt = array("Maruti Suzuki Arena","Maruti Suzuki Nexa","Hyundai","Kia","Mahindra","Tata Motors","Toyota","MG");

$brand = array("9"=>"Overall Industry","10"=>"Maruti Suzuki Overall","4"=>"Maruti Suzuki Arena","5"=>"Maruti Suzuki Nexa","1"=>"Hyundai","2"=>"Kia","3"=>"Mahindra","6"=>"Tata Motors","7"=>"Toyota","8"=>"MG");
$brand2 = array("4"=>"Maruti Suzuki Arena","5"=>"Maruti Suzuki Nexa","1"=>"Hyundai","2"=>"Kia","3"=>"Mahindra","6"=>"Tata Motors","7"=>"Toyota","8"=>"MG");

// $model = array(
// array("1"=>"Hyundai Accent","2"=>"Hyundai Alcazar","3"=>"Hyundai Aura","4"=>"Hyundai Creta","5"=>"Hyundai Elantra","6"=>"Hyundai Eon","7"=>"Hyundai Exter","8"=>"Hyundai Getz","9"=>"Hyundai i10","10"=>"Hyundai i20","11"=>"Hyundai Santro","12"=>"Hyundai Sonata","13"=>"Hyundai Terracan","14"=>"Hyundai Tucson","15"=>"Hyundai Venue","16"=>"Hyundai Verna","17"=>"Hyundai Xcent"),
// array("19"=>"Kia Carens","20"=>"Kia Carnival","21"=>"Kia Seltos","22"=>"Kia Sonnet"),
// array("24"=>"Mahindra Bolero","25"=>"Mahindra Commander","26"=>"Mahindra KUV100","27"=>"Mahindra Marazzo","28"=>"Mahindra Marshal","29"=>"Mahindra Maxx","30"=>"Mahindra Nuvosport","31"=>"Mahindra Quanto","32"=>"Mahindra Reva","33"=>"Mahindra Savari","34"=>"Mahindra Scorpio","35"=>"Mahindra Scorpio N","36"=>"Mahindra Thar","37"=>"Mahindra TUV300","38"=>"Mahindra Verito","39"=>"Mahindra Vibe","40"=>"Mahindra Voyager","41"=>"Mahindra XUV 300","42"=>"Mahindra XUV 400","43"=>"Mahindra XUV 500","44"=>"Mahindra XUV700","45"=>"Mahindra Xylo"),
// array("47"=>"Maruti Suzuki Alto 800","48"=>"Maruti Suzuki Alto K10","49"=>"Maruti Suzuki Celerio","50"=>"Maruti Suzuki Ritz","51"=>"Maruti Suzuki S-Presso","52"=>"Maruti Suzuki Swift","53"=>"Maruti Suzuki Swift Dzire","54"=>"Maruti Suzuki SX4","55"=>"Maruti Suzuki Vitara Brezza","56"=>"Maruti Suzuki Wagon R","57"=>"Maruti Suzuki Ertiga"),
// array("59"=>"Maruti Suzuki Ciaz","60"=>"Maruti Suzuki Baleno","61"=>"Maruti Suzuki Fronx","62"=>"Maruti Suzuki Grand Vitara","63"=>"Maruti Suzuki Invicto","64"=>"Maruti Suzuki XL6","65"=>"Maruti Suzuki S-cross","66"=>"Maruti Suzuki Jimny","67"=>"Maruti Suzuki Ignis"),
// array("74"=>"Tata Altroz","75"=>"Tata Aria","76"=>"Tata Bolt","77"=>"Tata Estate","78"=>"Tata Harrier","79"=>"Tata Hexa","80"=>"Tata Indica","81"=>"Tata Indigo","82"=>"Tata Nano","83"=>"Tata Nexon","84"=>"Tata Punch","85"=>"Tata Safari","86"=>"Tata Sierra","87"=>"Tata Sumo","88"=>"Tata Tiago","89"=>"Tata Tigor","90"=>"Tata Venture","91"=>"Tata Zest"),
// array("93"=>"Toyota Camry","94"=>"Toyota Corolla","95"=>"Toyota Etios","96"=>"Toyota Fortuner","97"=>"Toyota Glanza","98"=>"Toyota Hyryder","99"=>"Toyota Innova","100"=>"Toyota Innova Crysta","101"=>"Toyota Innova Hycross","102"=>"Toyota Land Cruiser Prado","103"=>"Toyota Urban Cruiser","104"=>"Toyota Yaris"),
// array("69"=>"MG Astor","70"=>"MG Gloster","71"=>"MG Hector","72"=>"MG ZS EV"));

$model = array(
    array("2"=>"Hyundai Alcazar","3"=>"Hyundai Aura","4"=>"Hyundai Creta","7"=>"Hyundai Exter","9"=>"Hyundai i10","10"=>"Hyundai i20","14"=>"Hyundai Tucson","15"=>"Hyundai Venue","16"=>"Hyundai Verna"),
    array("19"=>"Kia Carens","21"=>"Kia Seltos","22"=>"Kia Sonnet"),
    array("24"=>"Mahindra Bolero","34"=>"Mahindra Scorpio","35"=>"Mahindra Scorpio N","36"=>"Mahindra Thar","41"=>"Mahindra XUV 300","42"=>"Mahindra XUV 400","43"=>"Mahindra XUV 500","44"=>"Mahindra XUV 700"),
    array("47"=>"Maruti Suzuki Alto 800","49"=>"Maruti Suzuki Celerio","52"=>"Maruti Suzuki Swift","53"=>"Maruti Suzuki Swift Dzire","55"=>"Maruti Suzuki Vitara Brezza","56"=>"Maruti Suzuki Wagon R","57"=>"Maruti Suzuki Ertiga"),
    array("59"=>"Maruti Suzuki Ciaz","60"=>"Maruti Suzuki Baleno","61"=>"Maruti Suzuki Fronx","62"=>"Maruti Suzuki Grand Vitara","63"=>"Maruti Suzuki Invicto","64"=>"Maruti Suzuki XL6","65"=>"Maruti Suzuki S-cross","66"=>"Maruti Suzuki Jimny","67"=>"Maruti Suzuki Ignis"),
    array("74"=>"Tata Altroz","78"=>"Tata Harrier","83"=>"Tata Nexon","84"=>"Tata Punch","85"=>"Tata Safari","88"=>"Tata Tiago","89"=>"Tata Tigor"),
    array("93"=>"Toyota Camry","94"=>"Toyota Corolla","96"=>"Toyota Fortuner","97"=>"Toyota Glanza","98"=>"Toyota Hyryder","100"=>"Toyota Innova Crysta","101"=>"Toyota Innova Hycross"),
    array("69"=>"MG Astor","70"=>"MG Gloster","71"=>"MG Hector","72"=>"MG ZS EV"));
//Q13b


?>


