// $q2 = '';
// $i = 0;
// foreach ($row as $value) {
// $q2 .= "'" . mysql_escape_string($value) . "'";
// $q2 .= ($i++ != $count - 1) ? ',' : '';
// }
//
// $q .= '(' . $q2 . '), ';
// if ($i2++ % 300 == 0) {
// $toFile .= $insert . rtrim($q, ' ,') . ";\r\n";
// $q = '';
// }
}
if (fwrite($fp, $toFile)) {
write_log("Успешное создание файла " . $file_name);
$lastDate = getLastdate();
setLastdate();
}
fclose($fp);
//Архивирование файла
$command = "cd " . __DIR__ . "/dump/\n \t\t\t\ttar -czf '" . __DIR__ . "/dump/{$file_name}.gzip' '{$file_name}.sql' ";
exec($command, $result);
//Отправка данных через POST
$postData = ['file' => '@' . __DIR__ . "/dump/{$file_name}.gzip", 'key' => $config['key']];
// создаем подключение
$ch = curl_init($server['host']);
// устанавлваем даные для отправки
curl_setopt($ch, CURLOPT_POSTFIELDS, $postData);
// флаг о том, что нужно получить результат
curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
// отправляем запрос
<?php $query = 'SELECT paci_d.NOMER_ AS "number", paci_d.VID_ as "vid", paci_d.vidjiv_ as "vid_text", paci_d.zvjar_ as "name", paci_d.klient_ as "fio", paci_d.vidgrad_ as "city", paci_d.adres_ as "street", paci_d.dom_ as "home", paci_d.korpus_ as "corpus", paci_d.kvart_ as "appartment", paci_d.tel_ as "phone", paci_d.por_ as "breed", paci_d.pol_ as "sex", paci_d.TNO_ as "chip", vac.dvac_ as "vac_last_date", paci_d.lastdata_ as "lastdate", vac.vaxina_ as "vaccina", vac.dsv_ as "vac_next_date", @key := "' . $config['key'] . '" as "key", @created := CURRENT_TIMESTAMP() AS "created" FROM paci_d left join vac on paci_d.NOMER_ = vac.nomer_ WHERE paci_d.lastdata_ > "' . getLastdate() . '" GROUP BY paci_d.NOMER_ ORDER BY paci_d.lastdata_ DESC #limit 1';
