}
/*
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">
