function search_question($query, $cid, $count, $page = 1)
{
//Search questions by post title and post body
$output = '';
$uid = isset($_SESSION['uid']) ? $_SESSION['uid'] : 0;
$posts = array();
if (isset($_SESSION['rid']) && $_SESSION['rid'] != 2) {
$result = mysql_query("SELECT * FROM " . PREFIX . "POST WHERE (Post_Title LIKE '%" . $query . "%' OR Post_Question LIKE '%" . $query . "%' OR Post_Answer LIKE '%" . $query . "%' OR Post_URL LIKE '%" . $query . "%')");
} elseif (!isset($_SESSION['rid']) || $_SESSION['rid'] == 2) {
$result = mysql_query("SELECT * FROM " . PREFIX . "POST WHERE Post_Current=1 AND (Post_Title LIKE '%" . $query . "%' OR Post_Question LIKE '%" . $query . "%' OR Post_Answer LIKE '%" . $query . "%' OR Post_URL LIKE '%" . $query . "%')");
}
if ($result) {
while ($row = mysql_fetch_assoc($result)) {
$posts[] = $row;
}
}
if ($cid != 0) {
$posts = array_filter($posts, array(new Filter($cid), 'filter_cid'));
}
usort($posts, 'sort_post_date_descend');
$pagination = new pagination($posts, $page, $count, 5);
$pagination->setShowFirstAndLast(true);
$pagination->setMainSeperator('');
$posts = $pagination->getResults();
$output .= '<div class="paging">' . $pagination->getLinks() . '</div>';
$output .= '<div class="posts">';
for ($i = 0; $i < count($posts); $i++) {
if (isset($posts[$i])) {
$pid = $posts[$i]['Post_ID'];
$output .= view_post($pid, $uid);
$output .= $i != count($posts) - 1 ? '<hr>' : '';
}
}
$output .= '</div>';
$output .= '<div class="paging">' . $pagination->getLinks() . '</div>';
$output .= '<script>
function turnPage(page) {
$("#feeds").load("triggers/paging_search.php",{count:' . $count . ',cid:' . $cid . ',page:page,keyword:"' . $query . '"});
}
</script>';
if (count($posts) == 0) {
$output .= '<h3>There is no results for this search criteria.</h3>';
}
return $output;
}
ini_set('display_errors', 'On');
error_reporting(E_ALL);
// Include the pagination class
include 'pagination.class.php';
// some example data
foreach (range(1, 200) as $value) {
$products[] = array('Product' => 'Product ' . $value, 'Price' => rand(100, 1000));
}
// If we have an array with items
if (count($products)) {
// Create the pagination object
$pagination = new pagination($products, isset($_GET['page']) ? $_GET['page'] : 1, 15);
// Decide if the first and last links should show
$pagination->setShowFirstAndLast(false);
// You can overwrite the default seperator
$pagination->setMainSeperator(' | ');
// Parse through the pagination class
$productPages = $pagination->getResults();
// If we have items
if (count($productPages) != 0) {
// Create the page numbers
echo $pageNumbers = '<div class="numbers">' . $pagination->getLinks($_GET) . '</div>';
// Loop through all the items in the array
foreach ($productPages as $productArray) {
// Show the information about the item
echo '<p><b>' . $productArray['Product'] . '</b> £' . $productArray['Price'] . '</p>';
}
// print out the page numbers beneath the results
echo $pageNumbers;
}
}
