PHP checkIsSet Examples

Example #1

File: jobs_set_new_location_ids.php Project: sergrin/crawlers-il

    die;
}
$stmt->setFetchMode(PDO::FETCH_ASSOC);
$items = $stmt->fetchAll();
$stmt->closeCursor();
foreach ($items as &$item) {
    //var_dump($item);
    if ($item['l_location_city'] == 'Москва') {
        updateAds($item['l_location_city'], 1055864, 554889, $db);
        continue;
    }
    if ($item['l_location_city'] == 'Санкт-Петербург') {
        updateAds($item['l_location_city'], 1059979, 508324, $db);
        continue;
    }
    $isSet = checkIsSet($item['l_location_city'], $db);
    if ($isSet === true) {
        continue;
    }
    $sql = 'SELECT id, code, name FROM ru_geo.kladr WHERE name= :name AND socr="г" AND SUBSTRING(code,12,2)="00"';
    $stmt = $db->prepare($sql);
    $stmt->bindParam(':name', $item['l_location_city'], PDO::PARAM_STR);
    $res = $stmt->execute();
    if ($res === false) {
        print_r($stmt->errorInfo());
        die;
    }
    $stmt->setFetchMode(PDO::FETCH_ASSOC);
    $kladrItems = $stmt->fetchAll();
    $stmt->closeCursor();
    if (count($kladrItems) > 1 || empty($kladrItems)) {

Example #2

File: realty_set_new_location_ids.php Project: sergrin/crawlers-il

$stmt->closeCursor();
foreach ($items as &$item) {
    //var_dump($item);
    $region_id = $item['region_id'];
    $subregion_id = null;
    if ($item['region_id'] == 554889 && $item['l_geo_city'] == 'Москва') {
        $city_id = 1055864;
        updateAds($item['l_geo_city'], $city_id, $subregion_id, $region_id, $item['old_region_id'], $db);
        continue;
    }
    if ($item['region_id'] == 508324 && $item['l_geo_city'] == 'Санкт-Петербург') {
        $city_id = 1059979;
        updateAds($item['l_geo_city'], $city_id, $subregion_id, $region_id, $item['old_region_id'], $db);
        continue;
    }
    $isSet = checkIsSet($item['l_geo_city'], $item['old_region_id'], $db);
    if ($isSet === true) {
        continue;
    }
    if (!empty($item['region_code'])) {
        $parentCodeSql = ' AND SUBSTRING(code,1,2)= :parent_code ';
    } else {
        $parentCodeSql = '';
    }
    $where = getKladrWhere($item['l_geo_city']);
    $sql = 'SELECT id, code, name FROM ru_geo.kladr WHERE name= :name AND socrname= :socrname AND SUBSTRING(code,12,2)="00" ' . $parentCodeSql;
    $stmt = $db->prepare($sql);
    $stmt->bindParam(':name', $where['name'], PDO::PARAM_STR);
    $stmt->bindParam(':socrname', $where['socrname'], PDO::PARAM_STR);
    if (!empty($item['region_code'])) {
        $parentCode = substr($item['region_code'], 0, 2);