本文整理匯總了PHP中Home::search方法的典型用法代碼示例。如果您正苦於以下問題：PHP Home::search方法的具體用法？PHP Home::search怎麽用？PHP Home::search使用的例子？那麽, 這裏精選的方法代碼示例或許可以為您提供幫助。您也可以進一步了解該方法所在類Home的用法示例。
在下文中一共展示了Home::search方法的1個代碼示例，這些例子默認根據受歡迎程度排序。您可以為喜歡或者感覺有用的代碼點讚，您的評價將有助於係統推薦出更棒的PHP代碼示例。
示例1: search
public function search($smarty, $tpl, $params, $DB)
{
$this->Test_session();
$res = new Home($DB);
if (isset($_POST['search'])) {
if (empty($_POST['search'])) {
$smarty->assign('errRecherche', "Votre recherche est vide !");
$this->Test_admin($smarty, $tpl, $params, $DB);
$this->init($smarty, $tpl, $params, $DB);
$smarty->display($tpl);
} else {
$recherche = $_POST['search'];
$tableau = explode(" ", $recherche);
$sql1 = 'SELECT * FROM posts';
$sql2 = 'SELECT * FROM posts';
$i = 0;
foreach ($tableau as $mot) {
if (strlen($mot) > 1) {
if ($i == 0) {
$sql1 .= ' WHERE ';
$sql2 .= ' WHERE ';
} else {
$sql1 .= ' OR ';
$sql2 .= ' OR ';
}
$sql1 .= ' textePosts LIKE "%$mot%"';
$sql2 .= ' titrePosts LIKE "%$mot%"';
$i++;
}
}
$sql1 .= ' ORDER BY idPosts DESC';
$sql2 .= ' ORDER BY idPosts DESC';
$r1 = $res->search($sql1);
$r2 = $res->search($sql2);
if ($r1) {
foreach ($r1 as $key => $value) {
if (!isset($tabP[$r1[$key]['idPosts']])) {
$tabP[$r1[$key]['idPosts']] = array();
}
array_push($tabP[$r1[$key]['idPosts']], html_entity_decode($r1[$key]['titrePosts']), $r1[$key]['datePosts'], $r1[$key]['membres_pseudoMbr'], $r1[$key]['catPosts_nomCatPosts']);
}
}
if ($r2) {
foreach ($r2 as $key => $value) {
if (!isset($tabP[$r2[$key]['idPosts']])) {
$tabP[$r2[$key]['idPosts']] = array();
}
array_push($tabP[$r2[$key]['idPosts']], html_entity_decode($r2[$key]['titrePosts']), $r2[$key]['datePosts'], $r2[$key]['membres_pseudoMbr'], $r2[$key]['catPosts_nomCatPosts']);
}
}
if (!$r1 && !$r2) {
$smarty->assign('errRecherche2', "Aucun résultat trouvé.");
$this->Test_admin($smarty, $tpl, $params, $DB);
$this->init($smarty, $tpl, $params, $DB);
$smarty->display($tpl);
} else {
$smarty->assign('postSearch', $tabP);
$this->Test_admin($smarty, $tpl, $params, $DB);
$this->init($smarty, $tpl, $params, $DB);
$smarty->display('home.tpl');
}
}
}
}