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; }
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;