The default behavior is to NOT include a row count.
public includeRowCount ( ) : this | ||
Результат | this | Query, marked to return total row count when run. |
private function testResponseMetadata() { $requestSample = 10; $query = new FactualQuery(); $query->search("Sushi"); $query->limit($requestSample); $query->includeRowCount(); $res = $this->factual->fetch($this->testTables['global'], $query); // Get URL request string if (strlen($res->getRequest()) > 5) { $this->msg("Response URL", true); } else { $this->msg("Response URL", false); } // Get the table name queried if ($res->getTable() == $this->testTables['global']) { $this->msg("Request Table Name", true); } else { $this->msg("Request Table Name", false); } // Get http headers returned by Factual if (count($res->getHeaders()) > 2) { $this->msg("Response Headers", true); } else { $this->msg("Response Headers", false); } // Get http status code returned by Factual if ($res->getCode() > 0) { $this->msg("Response Code", true); } else { $this->msg("Response Code", false); } // Get total row count returned by Factual if ($res->getRowCount() > 0) { $this->msg("Total Row Count", true); } else { $this->msg("Total Row Count", false); } }
/** simple search interface */ print "<div id=\"searchcontent\">\r\n"; /** form */ print "<form class=\"searchform\" name=\"input\" action=\"./\" method=\"get\">\r\n"; print "<b>search</b> for <input class=\"search\" type=\"text\" value=\"" . $q . "\" name=\"q\"/> in "; print "<b>postcode</b> <input class=\"postcode\" type=\"text\" value=\"" . $zip . "\" name=\"postcode\"/>"; print "<input type=\"submit\" value=\"search\">\r\n"; print "<input type=\"checkbox\" name=\"categories\" value=\"312,347\"" . $filter . "/>Only Search Restaurants & Bars"; print "</form>\r\n"; try { /** make the query */ $query = new FactualQuery(); $query->search($q); $query->offset($page * PAGE_SIZE); $query->limit(PAGE_SIZE); $query->includeRowCount(); $query->threshold("default"); // see http://developer.factual.com/search-placerank-and-boost/#existence if ($zip) { $query->field("postcode")->equal($zip); } if ($cats) { $query->field("category_ids")->includesAny(explode(',', $cats)); } $res = $factual->fetch("places-us", $query); $data = $res->getData(); $firstRow = $page * PAGE_SIZE + 1; $lastRow = $firstRow + $res->getIncludedRowCount() - 1; $totRows = count($data); /** search result counts */ print "<div class=\"placecounts\">showing " . number_format($firstRow) . " through " . number_format($lastRow) . " of " . number_format($res->getTotalRowCount()) . " rows:</div>\r\n";