function checkIsSet($name, $db) { $sql = 'SELECT city_id, region_id' . ' FROM ru_eyezeek.vehicles' . ' WHERE city_id IS NOT NULL AND region_id IS NOT NULL AND l_geo_city= :l_geo_city' . ' LIMIT 1'; $stmt = $db->prepare($sql); $stmt->bindParam(':l_geo_city', $name, PDO::PARAM_STR); $res = $stmt->execute(); if ($res === false) { print_r($stmt->errorInfo()); die; } $row = $stmt->fetch(); $stmt->closeCursor(); if ($row === false) { return false; } else { updateAds($name, $row['city_id'], $row['region_id'], $db); return true; } }
function checkIsSet($name, $old_region_id, $db) { if (is_null($old_region_id)) { $regionIdSql = ' AND l_geo_region_id IS NULL'; } else { $regionIdSql = ' AND l_geo_region_id="' . $old_region_id . '"'; } $sql = 'SELECT city_id, subregion_id, region_id' . ' FROM ru_eyezeek.realestate' . ' WHERE city_id IS NOT NULL AND l_geo_city= :l_geo_city ' . $regionIdSql . ' LIMIT 1'; $stmt = $db->prepare($sql); $stmt->bindParam(':l_geo_city', $name, PDO::PARAM_STR); $res = $stmt->execute(); if ($res === false) { print_r($stmt->errorInfo()); die; } $row = $stmt->fetch(); $stmt->closeCursor(); if ($row === false) { return false; } else { updateAds($name, $row['city_id'], $row['subregion_id'], $row['region_id'], $old_region_id, $db); return true; } }