} /* First_Name ='$Name' or Last_Name='$Name' or CID='$CID' or Citation_Number='$Citation_Number' or Case_Number='$Case_Number' or Violation_Date='$Violation_Date' or Charges='$Charges' "; */ $search_query .=" ORDER BY id DESC "; $rowsPerPage=10; $result_select1=mysql_query($search_query) or die(mysql_error()); $result_select1_num1=mysql_num_rows($result_select1); $maxPage = ceil($result_select1_num1/$rowsPerPage); $pager = new PS_Pagination($conn, $search_query, $rowsPerPage, 5, "Submit_Search=Submit_Search1&CID=$CID&Name=$Name&Citation_Number=$Citation_Number&Case_Number=$Case_Number&Violation_Date=$Violation_Date&Court_Date=$Court_Date&Charges=$Charges"); //$pager->setDebug(true); $rs = $pager->paginate(); if($rs>0) { $i=0; while($search_result_row=mysql_fetch_assoc($rs)) { if($i % 2 == 0){ ?> <tr bgcolor="#d9d9d9"> <td><?php echo stripslashes($search_result_row['CID']);?> </td> <td><?php echo stripslashes($search_result_row['First_Name']);?> <?php echo stripslashes($search_result_row['Last_Name']);?></td> <td><?php echo stripslashes($search_result_row['Address']);?> </td> <td><?php echo stripslashes($search_result_row['Violation_Date']);?> </td> <td><a href="view_citation_details.php?view_id=<?=$search_result_row['id']?>"><strong style="text-decoration:underline;">View Details</strong></a></td>
</div> <!--/Pagination-----------> </div> <?php } else { echo '<h3>No transaction</h3>'; } } ?> <?php if ($_GET['t'] == 'ownerTransaction') { $owner_id = $_SESSION['user']['id']; $query = payment::payment_by_user($owner_id); $res_trans_object = new PS_Pagination($conn, $query, 10, 5, "type=transaction&t=ownerTransaction"); $res_trans = $res_trans_object->paginate(); // if All messages seleted if (mysql_num_rows($res_trans) > 0) { ?> <div class="dashboardinbox"> <div class="dasbmessagesbdr fontbld font18"> <div class="datediv">S.No</div> <div class="inboxcnt">Item</div> <div class="datediv">Renter</div> <div class="datediv pL20">Amount</div> <div class="datediv">Date</div> </div> <?php $i = 1;
_e($category_name); ?> </strong> <br /> </th> <th> <img src="<?php _e($icon_path_cat); ?> " border="0" align="texttop" style="float:right" /> </th> </tr> <?php if ($number_files > 0) { ?> <tr style="font-size: 12px;"> <?php //The paginate() function returns a mysql result set $result_files = $pager->paginate(); foreach ($result_files as $files) { $display_name = $files->display_name; $file_name = $files->file_name; $file_id = $files->file_id; $down_count = $files->download_count; $icon_name = $files->icon_name; $icon_path = $blog_url . $icon_folder . $icon_name; $counter = $counter + 1; /* Find whether the permalinks is enabled or not begins*/ $request_uri = $_SERVER['REQUEST_URI']; $position_qmark = strpos($request_uri, "?", '1'); if ($position_qmark == '') { $concat1 = "?"; } else { $concat1 = "&";
} $partno = $_SESSION['partno']; $description = $_SESSION['description']; $query = ""; // $query="SELECT * FROM `tbl_stock_master` s where "; $query = "select s.*, sum(c.closing_stk) as totstock from tbl_closing_stock c INNER JOIN tbl_stock_master S ON s.stk_id=c.stk_id Group BY stk_id having totstock>0 AND "; if ($partno != '') { $query = $query . "s.part_no='{$partno}'"; } elseif ($description != '') { $query = $query . "s.description Like'{$description}%'"; } $result = mysql_query($query); $count = mysql_num_rows($result); $pager = new PS_Pagination($conn, $query, 100, 10, ""); $pager->setDebug(true); $result = $pager->paginate(); ?> <form> <table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr height="20px;"><td></td> <tr height="20px;"><td width="100%" bgcolor="#FFFFFF" valign="middle" align="center"><?php include '../includes/head_all.php'; ?> </td></tr> <tr height="20px;"><td colspan="6"></td></tr> <tr><td valign="top" > <table border="0" align="center" cellpadding="3" width="88%"> <tr> <td bgcolor="#d6d6d6" ><table border="0" align="center" cellpadding="5" cellspacing="1px" bgcolor="#FFFFFF" class="rFont10">
while (list($key, $val) = each($split_stemmed)) { if ($val != " " and strlen($val) > 0) { $sql_search .= "(Title LIKE '%{$val}%' OR Starring LIKE '%{$val}%' OR DirectedBy LIKE '%{$val}%') OR"; } } $sql_search = substr($sql_search, 0, strLen($sql_search) - 3); //this will eat the last OR $sql_search .= ") and Status=1)) as tab where AiringDateTime >= '" . date('Y-m-d H:i:s') . "' ORDER BY relevance ASC, AiringDateTime DESC"; $res_search = mysql_query($sql_search); $rowPerpage = 10; $linkPerpage = 8; //ceil($totalrow/$rowPerpage); if (mysql_num_rows($res_search) > 0) { require 'include/ps_pagination.php'; $pager = new PS_Pagination($link, $sql_search, $rowPerpage, $linkPerpage, 'search_name=' . $_GET['search_name'] . ''); $paginationlist = $pager->paginate(); while ($row_search = mysql_fetch_array($paginationlist)) { ?> <div class="container clearfix section group"> <div class="font_content font_block_header shows_font special_font channel_section_header bottom_spacing"></div> </div> <div class="container clearfix section group"> <div class="span_15_of_15 clearfix" style="padding-bottom: 20px;"> <div class="span_4_of_15 special_font" style="float:left;"><a class="shows_font special_font" href="<?php echo getmoviename($row_search['Title'], $row_search['MovieID']); ?> " title="<?php echo $row_search['Title']; ?> "><img src="http://www.hbosouthasia.com/<?php echo $row_search['FilePathBig'];
<?php $query = user::displayItems($user_id); $list_of_items_object = new PS_Pagination($conn, $query, 10, 5, "type=reservation"); $list_of_items_res = $list_of_items_object->paginate(); //$sql=user::displayItems($user_id); //$all_items=mysql_query($sql); if (mysql_num_rows($list_of_items_res) == '0') { echo '<em>NO</em> listings so far'; } else { while ($all_user_item = mysql_fetch_assoc($list_of_items_res)) { $res = itemClass::select_featured_image($all_user_item['id']); //feaure image //get details for reservation $item_res = itemClass::to_get_details_of_reserved_item($all_user_item['id']); $item_reserved = itemClass::users_who_rest_item($all_user_item['id']); $item_res_num = mysql_num_rows($item_reserved); ?> <div class="dasbmessagesbdr"> <div class="swappicdiv"> <img src="<?php echo $URL_SITE; ?> /classes/show_image.php?filename=../images/itemimages/<?php echo $all_user_item['id'] . '/' . $res['filename']; ?> &height=60px&width=100px"> </div> <div class="swaprighttxt"> <div class="swaprighttxtL">