private function startQuery($search_string)
{
$database = new Database();
$database->Create(new EventTable());
/*
$sqlFullText= "CREATE FULLTEXT INDEX If Not Exists search ON ".EventTable::TableName.
"(".EventTable::Title.",".
EventTable::Description.",".
EventTable::SeachableKeywords.",".
EventTable::Venue.")";
* ".EventTable::Title, "(".EventTable::Title.","
.EventTable::Description.",".EventTable::SeachableKeywords.",".EventTable::Venue."
*
$database->runCommand($sqlFullText);
* */
$query_string = $database->quote($search_string);
$squery = "select *from " . EventTable::TableName . " WHERE ( MATCH (" . EventTable::Title . "," . EventTable::Description . "," . EventTable::SeachableKeywords . "," . EventTable::Venue . ") AGAINST ({$query_string} IN BOOLEAN MODE)) AND " . EventTable::Status . " > :zero";
$stmt = $database->prepare($squery);
$stmt->bindValue(":zero", 0);
$status = $stmt->execute();
if ($status) {
$rows = $stmt->fetchAll(PDO::FETCH_ASSOC);
for ($i = 0; $i < count($rows); $i++) {
$rows[$i][EventTable::Image] = IMAGE_EVENT_PATHS . $rows[$i][EventTable::Image];
}
return $rows;
} else {
print_r($stmt->errorInfo());
return null;
}
}
private function _select($server, $name, $create = false)
{
try {
$this->_uri_pieces = $server->_uri_pieces;
$this->_uri_pieces['path'][0] = $name;
$this->_setURI();
return $this->info['general'] = $this->_execute();
} catch (CouchException $e) {
if ($create && $e->getType() == 'not_found' && $e->getMessage() == 'no_db_file') {
return Database::Create($server, $name);
} else {
throw $e;
}
}
}
