| Server IP : 210.245.233.93 / Your IP : 216.73.216.226 Web Server : Apache/2.2.15 (CentOS) System : Linux webserver2.onesolution.com.hk 2.6.32-754.35.1.el6.x86_64 #1 SMP Sat Nov 7 12:42:14 UTC 2020 x86_64 User : apache ( 48) PHP Version : 5.3.3 Disable Function : exec, shell_exec, system, passthru, popen, proc_open, pcntl_exec MySQL : ON | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON Directory : /var/www/c-c.com.hk/en/ |
Upload File : |
<?php require_once('../webadmin/configure.php');
$get_pjcatid =(int)$_GET['pjcatid'];
// SEO
$result = mysql_query("SELECT * FROM mainmenu WHERE mmpath = 'project.php' ");
$row = mysql_fetch_array($result,MYSQL_ASSOC);
?><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<meta http-equiv="X-UA-Compatible" content="IE=7" />
<title><?=$row{'seotitleen'};?></title>
<meta name="keywords" content="<?=$row{'seokeyen'};?>" />
<meta name="description" content="<?=$row{'seodescen'};?>" />
<link rel="stylesheet" type="text/css" href="../css/style.css" />
<script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.4.2/jquery.min.js"></script>
<link rel="stylesheet" type="text/css" href="../css/ddaccordion.css" />
<script type="text/javascript" src="../js/jquery.easing.js"></script>
<script type="text/javascript" src="../js/jquery.accordion.js"></script>
<script type="text/javascript">
jQuery().ready(function(){
jQuery('#navigation').accordion({
active: false,
header: '.head',
navigation: true,
event: 'mouseover',
animated: 'easeslide',
autoheight: true
});
$('#accordion-1').easyAccordion({
autoStart: true,
slideInterval: 3000,
slideNum:false
});
});
</script>
<script type="text/javascript" src="../js/jquery.easyAccordion.js"></script>
<link rel="stylesheet" type="text/css" href="../css/easyAccordion.css" />
<link rel="stylesheet" type="text/css" href="../js/flexcrollstyles.css" />
<script type='text/javascript' src="../css/flexcroll.js"></script>
<script type="text/javascript" src="../js/jquery.jcarousel.pack.js"></script>
<link rel="stylesheet" type="text/css" href="../css/jquery.jcarousel.css" />
<link rel="stylesheet" type="text/css" href="../css/skin.css" />
<script type="text/javascript" src="../js/jCarousel.js"></script>
</head>
<body><?php include_once("analyticstracking.php") ?>
<table width="1000" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td height="140" colspan="2"><a href="index.php"><img src="../images/logo.jpg" width="200" height="80" alt="KARLSON C & C Limited" /></a></td>
</tr>
<tr>
<td align="left" valign="top" id="mainmenubg"><ul id="navigation">
<?php $result2 = mysql_query("SELECT * FROM mainmenu ORDER BY mmsort ASC ");
while ($row2 = mysql_fetch_array($result2,MYSQL_ASSOC)) {
echo "<li>";
echo "<a class='head' href='".$row2{'mmpath'}."'>".$row2{'mmtitleen'}."</a>";
if ($row2{'mmid'} == '2') {
echo "<ul>\n";
$result3 = mysql_query("SELECT * FROM project_cat WHERE pjcatstatus = '1' ORDER BY pjcatsort ASC ");
while ($row3 = mysql_fetch_array($result3,MYSQL_ASSOC)) {
echo "<li><a href='".$row2{'mmpath'}."?pjcatid=".$row3{'pjcatid'}."'>".$row3{'pjcattitleen'}."</a></li>\n";
}
echo "</ul>\n";
}
echo "</li>\n";
}
?></ul></td>
<td width="800" height="350" align="left" valign="top">
<?php if(!empty($get_pjcatid)) {
$result4 = mysql_query("SELECT * FROM project_cat WHERE pjcatid = ".$get_pjcatid." AND pjcatstatus = '1' ORDER BY pjcatsort ASC ");
} else {
$result4 = mysql_query("SELECT * FROM project_cat WHERE pjcatid = (SELECT pjcatid FROM project_cat WHERE pjcatstatus = '1' ORDER BY pjcatsort ASC LIMIT 1) AND pjcatstatus = '1' ORDER BY pjcatsort ASC ");
}
$row4 = mysql_fetch_array($result4,MYSQL_ASSOC);
?><table width="800" border="0" cellspacing="0" cellpadding="0" id="table">
<tr>
<td class="title"><?=$row{'mmtitleen'};?><br /><span class="category"><?=$row4{'pjcattitleen'};?></span></td>
</tr>
<tr>
<td class="txt"><?php
//$tbl_name="property"; //your table name
// How many adjacent pages should be shown on each side?
$adjacents = 5;
/*
First get total number of rows in data table.
If you have a WHERE clause in your query, make sure you mirror it here.
*/
//$query = "SELECT COUNT(*) as num FROM $tbl_name";
$query = "SELECT COUNT(*) as num FROM project_det pd LEFT JOIN project_det_cat pdc ON pd.pdid = pdc.pdid WHERE pdc.pjcatid = ".$row4{'pjcatid'}." ";
//echo 'query'.$query.'<br />';
$total_pages = mysql_fetch_array(mysql_query($query));
$total_pages = $total_pages[num];
/* Setup vars for query. */
$targetpage = "project.php"; //your file name (the name of this file)
$limit = 3; //how many items to show per page
$page = $_GET['page'];
if($page)
$start = ($page - 1) * $limit; //first item to display on this page
else
$start = 0; //if no page var is given, set start to 0
/* Get data. */
$sql = "SELECT * FROM project_det pd LEFT JOIN project_det_cat pdc ON pd.pdid = pdc.pdid WHERE pdc.pjcatid = ".$row4{'pjcatid'}." ";
$sql .= "ORDER BY pdc.psort ASC LIMIT $start, $limit ";
//echo $sql;
$result5 = mysql_query($sql);
/* Setup page vars for display. */
if ($page == 0) $page = 1; //if no page var is given, default to 1.
$prev = $page - 1; //previous page is page - 1
$next = $page + 1; //next page is page + 1
$lastpage = ceil($total_pages/$limit); //lastpage is = total pages / items per page, rounded up.
$lpm1 = $lastpage - 1; //last page minus 1
$pagination = "";
if($lastpage > 1)
{
$pagination .= "<div class=\"pagination\">";
//previous button
if ($page > 1)
$pagination.= "<a href=\"$targetpage?page=$prev&pjcatid=".$row4{'pjcatid'}."\">«</a>";
else
$pagination.= "<span class=\"disabled\">«</span>";
//pages
if ($lastpage < 7 + ($adjacents * 2)) //not enough pages to bother breaking it up
{
for ($counter = 1; $counter <= $lastpage; $counter++)
{
if ($counter == $page)
$pagination.= "<span class=\"current\">$counter</span>";
else
$pagination.= "<a href=\"$targetpage?page=$counter&pjcatid=".$row4{'pjcatid'}."\">$counter</a>";
}
}
elseif($lastpage > 5 + ($adjacents * 2)) //enough pages to hide some
{
//close to beginning; only hide later pages
if($page < 1 + ($adjacents * 2))
{
for ($counter = 1; $counter < 4 + ($adjacents * 2); $counter++)
{
if ($counter == $page)
$pagination.= "<span class=\"current\">$counter</span>";
else
$pagination.= "<a href=\"$targetpage?page=$counter&pjcatid=".$row4{'pjcatid'}."\">$counter</a>";
}
$pagination.= "...";
$pagination.= "<a href=\"$targetpage?page=$lpm1&pjcatid=".$row4{'pjcatid'}."\">$lpm1</a>";
$pagination.= "<a href=\"$targetpage?page=$lastpage&pjcatid=".$row4{'pjcatid'}."\">$lastpage</a>";
}
//in middle; hide some front and some back
elseif($lastpage - ($adjacents * 2) > $page && $page > ($adjacents * 2))
{
$pagination.= "<a href=\"$targetpage?page=1&pjcatid=".$row4{'pjcatid'}."\">1</a>";
$pagination.= "<a href=\"$targetpage?page=2&pjcatid=".$row4{'pjcatid'}."\">2</a>";
$pagination.= "...";
for ($counter = $page - $adjacents; $counter <= $page + $adjacents; $counter++)
{
if ($counter == $page)
$pagination.= "<span class=\"current\">$counter</span>";
else
$pagination.= "<a href=\"$targetpage?page=$counter&pjcatid=".$row4{'pjcatid'}."\">$counter</a>";
}
$pagination.= "...";
$pagination.= "<a href=\"$targetpage?page=$lpm1&pjcatid=".$row4{'pjcatid'}."\">$lpm1</a>";
$pagination.= "<a href=\"$targetpage?page=$lastpage&pjcatid=".$row4{'pjcatid'}."\">$lastpage</a>";
}
//close to end; only hide early pages
else
{
$pagination.= "<a href=\"$targetpage?page=1&pjcatid=".$row4{'pjcatid'}."\">1</a>";
$pagination.= "<a href=\"$targetpage?page=2&pjcatid=".$row4{'pjcatid'}."\">2</a>";
$pagination.= "...";
for ($counter = $lastpage - (2 + ($adjacents * 2)); $counter <= $lastpage; $counter++)
{
if ($counter == $page)
$pagination.= "<span class=\"current\">$counter</span>";
else
$pagination.= "<a href=\"$targetpage?page=$counter&pjcatid=".$row4{'pjcatid'}."\">$counter</a>";
}
}
}
//next button
if ($page < $counter - 1)
$pagination.= "<a href=\"$targetpage?page=$next&pjcatid=".$row4{'pjcatid'}."\">»</a>";
else
$pagination.= "<span class=\"disabled\">»</span>";
$pagination.= "</div>\n";
}
?>
<?php $a=1; while ($row5 = mysql_fetch_array($result5,MYSQL_ASSOC)) {
$result6 = mysql_query("SELECT * FROM project_img WHERE pdid = ".$row5{'pdid'}." ORDER BY pimgsort ASC ");
$row6 = mysql_fetch_array($result6,MYSQL_ASSOC);
if(mysql_num_rows($result6) > 0 ){
$getsize = getimagesize("../project/thumb/".$row6{'pimgfile'}) ;
if($getsize[0] > $getsize[1]){ // 0=w 1=h
$pimgfile = "<img src='../project/thumb/".$row6{'pimgfile'}."' width='210' height='140' />";
} else {
$pimgfile = "<img src='../project/thumb/".$row6{'pimgfile'}."' height='140' />";
}
} else {
// No image
$pimgfile = "<img src='../project/space.png' width='210' height='140' />";
}
if ($a == '3') {
$class = "projectlist2";
} else {
$class = "projectlist";
}
echo "<div class='".$class."' align='left'><a href='project_detail.php?pjcatid=".$row5{'pjcatid'}."&pdid=".$row5{'pdid'}."' />".$pimgfile."</a><br />
<b>".$row5{'pdtitleen'}."</b><br />
".$row5{'pdyear'}." Year, ".$row5{'pdsize'}."</div>";
$a++;
}?></td>
</tr>
<tr>
<td align="center" valign="top"><div id="pagination"><?=$pagination;?></div></td>
</tr>
</table></td>
</tr>
<tr>
<td colspan="2" id="footer" class="footer">Copyright © KARLSON C & C Limited. All Copyright Reserved.</td>
</tr>
</table>
</body>
</html>