public function import()
 {
     ini_set("auto_detect_line_endings", true);
     $city_name = $this->city_name;
     $file_name = $this->csv_file_path;
     $file_handle = fopen($file_name, "r");
     $connection = null;
     try {
         $connection = MysqlUtils::getConnection();
     } catch (DatabaseConnectionException $e) {
         echo "Cannot connect to database" . PHP_EOL;
         exit;
     }
     /**
      * id,area_name,pincode 
      */
     $line_number = 0;
     $header_line = null;
     while (($line = fgetcsv($file_handle, $file_name)) !== FALSE) {
         $line_number++;
         //Skip first line as they are the column headers in excel sheet
         if ($line_number == 1) {
             $header_line = $line;
             continue;
         }
         $id = $line[0];
         $area_name = $line[1];
         $pincode = $line[2];
         $query = "INSERT INTO `pincodes` (`id`, `pincode`, `area_name`, `city`) " . "VALUES (NULL, '{$pincode}', '{$area_name}', '{$city_name}')";
         $result = mysqli_query($connection, $query);
     }
     mysqli_close($connection);
 }
 public static function getConnection()
 {
     MysqlUtils::$CONFIG_FILE = ROOT_DIRECTORY . "/config/prod/mysql-config.json";
     $config_file = file_get_contents(MysqlUtils::$CONFIG_FILE);
     $config = json_decode($config_file, TRUE);
     $host = $config["host"];
     $username = $config["username"];
     $password = $config["password"];
     $database = $config["database"];
     $connection = mysqli_connect($host, $username, $password, $database);
     $error = mysqli_connect_error($connection);
     if ($error !== NULL) {
         throw new exceptions\DatabaseConnectionException("Db connection failed");
     }
     return $connection;
 }
<?php

require_once "config.php";
use citibytes\utils\MysqlUtils;
use citibytes\LeaderBoard;
use citibytes\exceptions\DatabaseConnectionException;
use citibytes\exceptions\QueryFailedException;
$email_id = $_REQUEST["email_id"];
try {
    $connection = MysqlUtils::getConnection();
    $leader_board = new LeaderBoard($email_id);
    $result = $leader_board->getLeaderBoardData($connection);
    $result["status"] = "success";
    echo json_encode($result);
} catch (DatabaseConnectionException $e) {
    $failure_json = array("status" => "error", "error" => "Database Unavailable");
    echo json_encode($failure_json);
    return;
} catch (QueryFailedException $e) {
    $failure_json = array("status" => "error", "error" => "Unable to get pending pincode requests");
    echo json_encode($failure_json);
    return;
}
mysqli_close($connection);