// $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';