function crawl($tname, $year, $monthArr)
{
$dealType = $GLOBALS['dealType'];
$stateArr = $GLOBALS['stateArr'];
if ($monthArr == null) {
die("monthArr must be set!");
}
$period = intval(($monthArr[0] - 1) / 3) + 1;
echo "Working on {$year} ({$period}) " . implode(" ", $monthArr) . "\n";
$db = new mysqli("p:localhost", "trend", "only!trend!", "rtrend");
// Check connection
if ($db->connect_error) {
die("Connection failed: " . $db->connect_error);
}
// Set utf8
//$db->set_charset("utf8");
if (!isset($dealType[$tname])) {
die("No args for {$tname}\n");
}
// get deal type and table name
$args = $dealType[$tname];
foreach ($stateArr as $state => $stateCode) {
echo "Working on {$year} ({$period}) on {$state} for {$tname}\n";
$cities = getCities($year, $period, $stateCode, $args);
$cityArr = json_decode($cities, true);
foreach ($cityArr['jsonList'] as $city) {
$counties = getCounties($year, $period, $stateCode, $city['CODE'], $args);
$countyArr = json_decode($counties, true);
foreach ($countyArr['jsonList'] as $county) {
$deals = getDeals($year, $period, $stateCode, $city['CODE'], $county['CODE'], $args);
$dealArr = json_decode($deals, true);
foreach ($monthArr as $month) {
// echo("Working on $year/$month ($period) on $state " . $city['NAME'] . " " . $county['NAME'] . "\n");
$infoArr = ['year' => $year, 'month' => $month, 'state' => $state, 'city' => $city['NAME'], 'county' => $county['NAME']];
// update
// function update($db, $tname, $metaArr, $json) {
update($db, $tname, $infoArr, $deals);
}
}
}
}
// make aggregation
foreach ($monthArr as $month) {
echo "Make agg {$tname} on {$year}/{$month}";
mkagg($db, $tname, $year, $month);
}
$db->close();
}
<?php
include_once "../libs/start.php";
if (isset($_POST['get_option'])) {
$option = addslashes(htmlspecialchars(trim($_POST['get_option'])));
$counties = getCounties($option);
$map_found = foundCity($option);
if ($option === "1") {
echo "<div class='sel seld-old'>\n\t\t\t\t\t\t<span class='sel seld-old-title' data-b='select-county'>Округа</span>\n\n\t\t\t\t\t\t<div class='all-city' data-b='all-counties-dropdown'>\n\t\t\t\t\t\t\t<p>Выберите округ(а)</p>\n\n\t\t\t\t\t\t\t<div class='checkbox all'>\n\t\t\t\t\t\t\t\t<label>\n\t\t\t\t\t\t\t\t\t<input class='ch' type='checkbox' value='all'>\n\t\t\t\t\t\t\t\t\t<span class='checkbox_box'></span>\n\t\t\t\t\t\t\t\t\t<span class='lab'>Все округа</span>\n\t\t\t\t\t\t\t\t</label>\n\t\t\t\t\t\t\t</div>";
}
for ($i = 0; $i < count($counties); $i++) {
$id_county = $counties[$i]['id_county'];
$county_name = $counties[$i]['county_name'];
$map = $counties[$i]['map'];
$yandex = $counties[$i]['yandex'];
echo "\t\t<div class='checkbox'>\n\t\t\t\t\t\t\t\t<label>\n\t\t\t\t\t\t\t\t\t<input class='ch' type='checkbox' name='test' id='{$id_county}' value='{$county_name}'>\n\t\t\t\t\t\t\t\t\t<span class='checkbox_box'></span>\n\t\t\t\t\t\t\t\t\t<span class='lab'>{$county_name}</span>\n\t\t\t\t\t\t\t\t</label>\n\t\t\t\t\t\t\t</div>";
}
if ($option === "1") {
echo "<div class='btn-rounded'>Ок</div>\n\t\t\t\t\t\t</div>\n\t\t\t\t\t</div>";
}
// Проверяем есть ли карта у города
for ($i = 0; $i < count($map_found); $i++) {
$id_map = $map_found[$i]['id_city'];
$map = $map_found[$i]['map'];
$yandex = $map_found[$i]['yandex'];
if ($map != '') {
echo "<div class='count-sel-and-map'>\n\t\t\t\t\t\t\t<span>Выбрано районов: <strong>0</strong></span>\n\n\t\t\t\t\t\t\t<p>\n\t\t\t\t\t\t\t\t<a name='modal' href='#dialog{$option}'>\n\t\t\t\t\t\t\t\t\tВыбрать округа и районы на карте\n\t\t\t\t\t\t\t\t</a>\n\t\t\t\t\t\t\t</p>\n\t\t\t\t\t\t</div>";
} else {
echo "<div class='count-sel-and-map'>\n\t\t\t\t\t\t\t<p>\n\t\t\t\t\t\t\t\t<a name='yandex' href='#yandex{$option}'>\n\t\t\t\t\t\t\t\t\tПоказать на карте\n\t\t\t\t\t\t\t\t</a>\n\t\t\t\t\t\t\t</p>\n\t\t\t\t\t\t</div>";
}
}
<option value=""> Any </option>
<?php
$systems = getSystems();
foreach ($systems as $system) {
echo '<option value="' . $system['college_system'] . '">' . $system['college_system'] . '</option>';
}
?>
</select></td>
</tr>
<tr>
<td>County:</td>
<td>
<select name="county">
<option value=""> Any </option>
<?php
$counties = getCounties();
foreach ($counties as $county) {
echo '<option value="' . $county['county'] . '">' . $county['county'] . '</option>';
}
?>
</select>
</td>
</tr>
<tr>
<td>Number of Students:</td>
<td>
<select name="maxStudents">
<option value=""> Any </option>
<option value="10000"> less than 10,000</option>
<option value="25000"> less than 25,000</option>
<option value="100000"> over 25,000</option>
