core
Posted in
7232
2:35 am, March 10, 2022
Core Function : list_search_by_class_return_links - List Searches by Class Type and Return Links
Function that list's the latest and top searches by the class name and return a list of links, with the search totals on them.
I wanted to extract the top searches and the latest searches by date, for a particular class to list as text links to the search page for showing under the search box on the sections over view page. This function returns the required links.
PHP
/*
List searches by class and return links, for use under the search box as latest or top searches.
Also could list them in a widget under the class name.
*/
public function list_search_by_class_return_links(
$search_class = "content",
$search_type = "latest",
$max = 10
) {
global $functions;
global $base_directory;
$max = $this->db->escapeString($max);
$search_class = $this->db->escapeString($search_class);
$out = "";
if($search_type == "latest") {
$sql = "select * from searches where search_class = '$search_class' order by insdate desc limit $max";
}
if($search_type == "top") {
$sql = "select * from searches where search_class = '$search_class' order by search_number desc limit $max";
}
$result = $this->db->query($sql);
if(!$result) {
return "Nothing Found";
}
while($row = $result->fetchArray()) {
$search_term = $row['search_term'];
$search_term_html = htmlentities($search_term);
$search_term_url = urlencode($search_term);
$search_class = $row['search_class'];
$search_number = $row['search_number'];
$search_number_nice = $functions->restyle_number($search_number);
$out .= "<a href='$base_directory/search/$search_class/$search_term_url/' class='search-link-text'><span class='search-num badge bg-info text-dark'>$search_number_nice</span> $search_term_html</a>";
}
$out = "<div class='search-links-text'>$out</div>";
return $out;
}
View Statistics
This Week
140
This Month
647
This Year
2265
Add Comment
Other Items in core
Related Search Terms
Other Categories in Code
alpine js apps c css factorio font awesome images linux quick modals sqlite site bugs site updates slick slider sliders testing windows apps apache api apps asp bat bootstrap bootstrap templates charts cookies core css css filters css grid design elements docker domains emoji fancybox fonts foundation framework gimp git html icons ideas image formatting images javascript javascript functions jquery js linux mac misc modals mysql nginx node php php errors php function php functions php simple html dom pi400 python react regex sections simple_html_dom simplepie php site bugs site documentation slick slider sql sqlite ssh sublime svg svg css templates tools virtual box vscode vue webdev windows windows 11 windows commands wordpress