File: /home/durgeshpandey215/www/zeeroprice.skilladders.com/transactions.php
<? require "application_top.php";
?>
<!DOCTYPE html>
<html lang="en">
<head>
<title>Transactions</title>
<!-- Meta tag Keywords -->
<meta name="viewport" content="width=device-width, initial-scale=1">
<meta charset="utf-8">
<meta name="keywords" content="" />
<? require "scripts.php";?>
</head>
<body>
<? $pagename = "mytransac"; require "header.php";?>
<?
$sqlmp = " * from pointstransaction where userid=? order by transactionid desc";
$whereParams[] = $userid;
//---------------pagination BOF---------------------------------------
$from_where = $sqlmp;
//$whereParams[] = 0; required created above
$extra ="&extra=";
$adjacents = 3;
$limit = 10; //how many items to show per page
$targetpage = $_SERVER['PHP_SELF']; //your file name (the name of this file)
require "pagination.php";
?>
<h1>Coins Transactions</h1>
<br/>
<div class="w3-card w3-white w3-padding">
<?if($total_pages){?>
<div style="overflow-x:auto;">
<table class="listingtable">
<tr>
<TH><center>Image</center></TH><TH>Title</TH><TH>Points Paid</TH>
<TH>MRP</TH><TH>Zeero Price</TH><TH>Transaction Time</TH>
</tr>
<?
$productArr = array();
$prdcols = array("pid", "ititle", "pic1", "mrp");
foreach($rows as $row){
if(!in_array($row['pid'],$productArr)){
//get product details
$db->where('pid',$row['pid']);
$rowp = $db->getOne('products',null,$prdcols);
if($rowp){
$productArr[$row['pid']] = $rowp;
}else{
$productArr[$row['pid']] = 0;
}
}
if($productArr[$row['pid']]){
$prdurl = HTTP_SERVER."buy-at-lowest-price/".friendlyURL($productArr[$row['pid']]["ititle"])."_".encode($row["pid"]).".html";
?>
<tr>
<td>
<img src="<?=HTTP_SERVER;?>images/products/<?=($productArr[$row['pid']]['pic1'])? $productArr[$row['pid']]['pic1']:"default.jpg";?>" style="width:90px;height:90px;"/>
</td>
<td>
<?=mb_str_word_count($productArr[$row['pid']]['ititle'],1);?>
</td>
<td>
<?=$row['points'];?>
</td>
<td>
<?=$row['mrp'];?>
</td>
<td>
<?=$row['reducedPrice'];?>
</td>
<td style="text-align:center;">
<?=date('d-m-Y H:i:s',strtotime($row['postedon']));?>
</td>
</tr>
<?}
}
?>
</table>
</div>
<center><?=$pagination;?></center>
<?}else{ ?>Dear <?=$fullnamesession?>,<br/>You don't have any transactions made yet<?}?>
<br/><br/>
</div>
<br/><br/>
<? require "footer.php";?>