freelancer007

if ($connection == false){
    print("Ошибка: Невозможно подключиться к MySQL " . mysqli_connect_error());
    exit();
}

$tickets = App\Ticket::with(['claimant:id,ticket_id,info'])
                      ->where('user_id',704)
                      ->where('status_id', '>', 0)->get();

DROP TABLE IF EXISTS `cities`;
CREATE TABLE IF NOT EXISTS `cities` (
  `id` mediumint(8) unsigned NOT NULL,
  `region_id` mediumint(8) unsigned NOT NULL,
  `name_ru` varchar(128) NOT NULL,
  `name_en` varchar(128) NOT NULL,
  `lat` decimal(10,5) NOT NULL,
  `lon` decimal(10,5) NOT NULL,
  `okato` varchar(20) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Информация о городах ';

LOAD DATA INFILE '/temp_temp/city.tsv'
INTO TABLE cities
FIELDS TERMINATED BY ' ';