本文整理汇总了PHP中TYPO3\CMS\Core\Database\DatabaseConnection::searchQuery方法的典型用法代码示例。如果您正苦于以下问题：PHP DatabaseConnection::searchQuery方法的具体用法？PHP DatabaseConnection::searchQuery怎么用？PHP DatabaseConnection::searchQuery使用的例子？那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类TYPO3\CMS\Core\Database\DatabaseConnection的用法示例。
在下文中一共展示了DatabaseConnection::searchQuery方法的1个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的PHP代码示例。
示例1: search
/**
* Search
*
* @return string
*/
public function search()
{
$SET = $GLOBALS['SOBE']->MOD_SETTINGS;
$swords = $SET['sword'];
$out = '';
$limit = 200;
if ($swords) {
foreach ($GLOBALS['TCA'] as $table => $value) {
// Get fields list
$conf = $GLOBALS['TCA'][$table];
// Avoid querying tables with no columns
if (empty($conf['columns'])) {
continue;
}
$fieldsInDatabase = $this->databaseConnection->admin_get_fields($table);
$list = array_intersect(array_keys($conf['columns']), array_keys($fieldsInDatabase));
// Get query
$qp = $this->databaseConnection->searchQuery(array($swords), $list, $table);
// Count:
$count = $this->databaseConnection->exec_SELECTcountRows('*', $table, $qp . BackendUtility::deleteClause($table));
if ($count) {
$rowArr = array();
$res = $this->databaseConnection->exec_SELECTquery('uid,' . $conf['ctrl']['label'], $table, $qp . BackendUtility::deleteClause($table), '', '', $limit);
$lrow = null;
while ($row = $this->databaseConnection->sql_fetch_assoc($res)) {
$rowArr[] = $this->resultRowDisplay($row, $conf, $table);
$lrow = $row;
}
$this->databaseConnection->sql_free_result($res);
$markup = [];
$markup[] = '<div class="panel panel-default">';
$markup[] = ' <div class="panel-heading">';
$markup[] = $this->languageService->sL($conf['ctrl']['title'], true) . ' (' . $count . ')';
$markup[] = ' </div>';
$markup[] = ' <table class="table table-striped table-hover">';
$markup[] = $this->resultRowTitles($lrow, $conf, $table);
$markup[] = ' </table>';
$markup[] = '</div>';
$out .= implode(LF, $markup);
}
}
}
return $out;
}