示例#1
0
function search_apartments($keyword, $sleeps, $page)
{
    error_log("page: {$page}");
    $conn = db_connect();
    $resultSet = new Property_Dom_ResultSet();
    if (!empty($keyword)) {
        $keyword = '%' . $keyword . '%';
    }
    $limit_count = 30;
    $limit_start = ($page - 1) * $limit_count;
    if (empty($keyword)) {
        $sql = "SELECT * FROM apartments where description like '%Sleeps {$sleeps}%' order by id asc limit {$limit_start}, {$limit_count}";
    } else {
        $sql = "SELECT * FROM apartments where (title like '{$keyword}' OR description2 like '{$keyword}') AND description like '%Sleeps {$sleeps}%' order by id asc limit {$limit_start}, {$limit_count}";
    }
    //echo $sql;die;
    error_log("Query: " . $sql);
    $result = mysql_query($sql);
    $i = 0;
    while ($row = mysql_fetch_assoc($result)) {
        $resultSet->addTitleByIndex($i, html_entity_decode($row['title']));
        $resultSet->addDescriptionByIndex($i, html_entity_decode($row['description']));
        $resultSet->addDescriptionByIndex($i, $row['description2']);
        $resultSet->addPropertyImageLinkByIndex($i, $row['thumb_url']);
        $resultSet->addPropertyDetailLinkByIndex($i, $row['detail_url']);
        $i++;
    }
    mysql_free_result($result);
    return $resultSet;
}
示例#2
0
		curl_setopt($ch,CURLOPT_RETURNTRANSFER,1);

		curl_setopt($ch,CURLOPT_CONNECTTIMEOUT,$timeout);

		$markup = curl_exec($ch);

		curl_close($ch);

		echo "<div id='showTempData' style='display:none'>";

		//print_r($markup);

		echo "</div>";
*/
$resultSet = new Property_Dom_ResultSet();
$markup = file_get_contents($feed_url);
$dom = new Zend_Dom_Query($markup);
//echo "<pre>";//print_r($dom);exit;
$headings = $dom->query("div.body h3");
$descriptions = $dom->query("div.item_inner div.body");
$descriptions2 = $dom->query("div.item_inner div.more");
$links = $dom->query("div.item_inner div.photo img");
$pager = $dom->query("div.pager_bottom a");
$detail_urls = $dom->query("div.body h3 a");
$prev_next_count = count($pager);
//if 2 prev/next link.. if 1 just next link
$loopcnt = 0;
$max_page = preg_match("/(?U)class=\\'pagination\\_jump\\'\\>\\sof\\s(.+)\\s/is", $markup, $m) ? str_replace(',', '', trim($m[1])) : 1;
if ($max_page > 100) {
    $max_page = 100;