NOTE: DO NOT use any mysql_ functions when working even with the deprecated DBAPI methods in Revolution—the DBAPI in Revolution uses xPDO itself already.
You can pass any SQL-specific functions or statements, like MySQL fulltext query syntax, into any criteria, or you can simply do what you did using the PDO API, which again, is built into xPDO, and thus MODx. That said, there are still a lot of different ways to accomplish this with xPDO. Let's start with the one closest to how you are used to doing it:
<?php
$queryString = "
SELECT *, MATCH(title, url, author, category, level, version, tag, language, summary) AGAINST (:str1 IN BOOLEAN MODE) as score
FROM {$this->modx->getOption('table_prefix')}linx
WHERE MATCH(title, url, author, category, level, version, tag, language, summary) AGAINST (:str2 IN BOOLEAN MODE)
ORDER BY score DESC
";
$criteria = new xPDOCriteria($this->modx, $queryString, array(':str1' => $str, ':str2' => $str));
if (!$criteria->prepare() || !$criteria->stmt->execute()) {
echo __LINE__ . ' : ' . print_r($this->modx->errorInfo(), true) . '<br />' . $queryString . '<br />';
return FALSE;
}
$rowArray = $criteria->stmt->fetchAll(PDO::FETCH_ASSOC);
However, if you created an xPDO model for your
linx table, you could create the criteria programmatically via a gsLinx class, e.g.
<?php
$criteria = $this->modx->newQuery('gsLinx');
$criteria->select($this->modx->getSelectColumns('gsLinx'));
$criteria->select("MATCH(title, url, author, category, level, version, tag, language, summary) AGAINST (:str1 IN BOOLEAN MODE) AS score");
$criteria->where("MATCH(title, url, author, category, level, version, tag, language, summary) AGAINST (:str2 IN BOOLEAN MODE)");
$criteria->sortby('score', 'DESC');
$stmt = $criteria->prepare();
$stmt->bindParam(':str1', $str);
$stmt->bindParam(':str2', $str);
At this point, you have a PDOStatement (the $stmt variable) wrapped by an xPDOCriteria object (the $criteria variable); note that $stmt is a reference to $criteria->stmt which is automatically assigned when you call prepare. You can make use of either one at this point in any way you want. For instance, if you just wanted an array result set like you had before:
<?php
if ($criteria->stmt->execute()) {
$rowArray = $criteria->stmt->fetchAll(PDO::FETCH_ASSOC);
} else {
var_dump($criteria->stmt->errorInfo());
}
Or if you want to work with your rows as objects:
<?php
$collection = $this->modx->getCollection('gsLinx', $criteria);
$output = array();
foreach ($collection as $object) {
$output[]= $object->toArray();
}
return implode("<br />", $output);
