require_once('annosite/Connections/bob.php'); ?> $currentPage = $_SERVER['PHP_SELF']; $table_to_search = 'kjd_reviewcontent'; $searchable_fields = array('ID','userName','emailAddr','messageText'); $searchable_fields_names = array('Review No.','User Name','Email','Review'); $searchable_fields_default = 'all'; $order_fields = array('postDate', 'userName','emailAddr','messageText'); $order_fields_names = array('Date','User Name','Email','Review'); $order_fields_default = 'postDate'; // set no. results to display if(!isset($maxRows_search)){ $maxRows_search=10; } if(!isset($pageNum_search)){ $pageNum_search = 0; } $root_modifier = '/annosite'; // set hidden form elements - add field names to array in next line $form_items[] = "totalPages_search"; $form_items[] = "action"; $date_field = 'postDate'; // set page from nav jump if (isset($_POST['totalRows_search'])){ if($_POST['gopage']>$_POST['totalRows_search']+1){ $_POST['gopage']=$_POST['totalRows_search']+1; } } if (isset($_GET['pageNum_search'])) { $pageNum_search = $_GET['pageNum_search']; } if (isset($_POST['gopage'])) { $pageNum_search = ($_POST['gopage']-1); } include('annosite/includes/search/search_functions.php'); if((rtrim($search)=="")&&(rtrim(str_replace('dd','',$day))=="")&&(rtrim(str_replace('mm','',$month))=="")&&(rtrim(str_replace('YYYY','',$year))=="")){ $no_search = true; } if ($no_search){ $startRow_search = $pageNum_search * $maxRows_search; mysql_select_db($database_bob, $bob); if(!isset($order_field) || strlen($order_field < 1)){ $order_field = 'postDate DESC, postTime'; } if(!isset($order) || strlen($order < 1)){ $order = 'DESC'; } $query_search = "SELECT * FROM kjd_reviewcontent ORDER BY $order_field $order"; $query_limit_search = sprintf("%s LIMIT %d, %d", $query_search, $startRow_search, $maxRows_search); $search_query = mysql_query($query_limit_search, $bob) or die(mysql_error()); $row_search = mysql_fetch_assoc($search_query); if (isset($_GET['totalRows_search'])) { $totalRows_search = $_GET['totalRows_search']; } else { $all_search = mysql_query($query_search); $totalRows_search = mysql_num_rows($all_search); } $totalPages_search = ceil($totalRows_search/$maxRows_search)-1; $total_pages = $totalPages_search; $page = $pageNum_search; }else{ mysql_select_db($database_bob, $bob); include("annosite/includes/search/search.php"); } $allposts = "SELECT COUNT(`ID`) AS count FROM kjd_reviewcontent "; $allposts_query = mysql_query($allposts, $bob) or die(mysql_error()); $row_allposts = mysql_fetch_assoc($allposts_query); $display_links = 5; ?>
|
|||||||||||||||||