公用的php类(function.php)

最新推荐文章于 2024-09-26 21:58:24 发布

aqandes

最新推荐文章于 2024-09-26 21:58:24 发布

阅读量1.2k

点赞数

文章标签： php session mysql border function query

<?
if (file_exists($_SESSION["path"]."cpw.php")){
$exec = "SELECT ptime,cname FROM product,company where company.uid=product.uid and SUBSTRING(clb,3,1)='$pt' $ptqy ORDER BY ptime desc ";
$result=mysql_query($exec);
$rs=mysql_fetch_array($result);
$cpzs=mysql_num_rows($result);
if ($rs[0]>strftime("%Y-%m-%d %H:%M:%S",filemtime($_SESSION["path"]."cpw.php"))){
include "ptmb/inc/cpw.php";
}
}else{
include "ptmb/inc/cpw.php";
}

if (file_exists($_SESSION["path"]."gsw.php")){
$exec = "SELECT ctime,uid FROM company where SUBSTRING(clb,3,1)='$pt' $ptqy ORDER BY ctime desc ";
$result=mysql_query($exec);
$rs=mysql_fetch_array($result);
$gszs=mysql_num_rows($result);
if ($rs["ctime"]>strftime("%Y-%m-%d %H:%M:%S",filemtime($_SESSION["path"]."gsw.php"))){
include "ptmb/inc/gsw.php";
}
}else{
include "ptmb/inc/gsw.php";
}

//新闻
function news($many,$textshow,$classn,$dwfw,$xssx){ //显示条数，宽度（偶数），类别关键字，公司类别，显示顺序
global $ptqy;
$sql= "SELECT nid,nlb,nsubject FROM news,company where company.uid=news.uid and SUBSTRING(clb,2,2) IN($dwfw) $ptqy and nlb like '%".$classn."%' order by $xssx desc limit 0,$many";
$result=mysql_query($sql);
echo "<table width=/"100%/" border=/"0/" cellpadding=/"0/" cellspacing=/"0/">";
while ($rs=mysql_fetch_array($result)){
?>
<tr>
<td height="18">
<img src="/aqf/images/blt.gif" width="9" height="9" border="0"> <a target='_blank' title="<?=$rs["nsubject"];?>" href="/index.php?lm=xwxx&id=<?=$rs["nid"];?>"><?=char($rs["nsubject"],$textshow);?></a></td>
</tr>
<? }
?>
</table><?
}

function Hclas($fv,$num){
$sql="Select hhx,hid,htime,hdz From house where hxz is not null $GLOBALS[ptqy] and hxz='$fv' order by htime desc limit $num";
$result=mysql_query($sql);
echo "<div class='hclas'><ul>";
while ($rs=mysql_fetch_array($result)){
?>
<li><a href="/index.php?lm=../zcxx/seeh&id=<?=$rs["hid"];?>" target="_blank"><?=char($rs["hdz"],20);?></a>  <span class="fco"><?=char($rs["hhx"],8);?> [<?=substr($rs["htime"],5,5);?>]</span></li>
<? }
echo "</ul></div>";
}

function Hcount($Sum){
switch ($Sum){
  case "房产信息":
   $rs=mysql_fetch_row(mysql_query("select count(hid) from house where cprov is not null $GLOBALS[ptqy]"));
   echo $rs[0];
   break;
  case "新闻总数":
   $rs=mysql_fetch_row(mysql_query("Select Count(nid) From News,company where company.Uid=News.uid $GLOBALS[ptqy]"));
   echo $rs[0];
   break;
  case "注册会员":
   $rs=mysql_fetch_row(mysql_query("select Count(gid) From guest where guest.uid='".$_SESSION['uid']."'"));
   echo $rs[0];
   break;
  case "个人发布信息总数":
   $rs=mysql_fetch_row(mysql_query("select count(hid) from house where guest='".$_SESSION["guest"]."' $GLOBALS[ptqy]"));
   echo $rs[0];
   break;
}

}
//翻页

}

function intro($many,$str,$classname,$dwfw,$xssx){ //显示条数，宽度（偶数），类别关键字，公司类别，显示顺序
global $pt,$ptqy,$mbtp,$zhw;
$exec="SELECT company.uid,iid,itype1, itype2,itime,itopic,cname
FROM company,intro where company.uid=intro.uid and SUBSTRING(clb,2,2) IN($dwfw) and ( ".substr($ptqy,4)." or company.uid=999999900 ) and itype1 like '%$classname%' ORDER BY $xssx desc ";
$result=mysql_query($exec);
$zhw="<table width='100%' border='0' cellpadding='0' cellspacing='0' bgcolor='#FFFFFF'>";
while ($rs=mysql_fetch_array($result) and $i<$many){
$i++;
$zhw=$zhw."<tr><td height=18 > ";
$zhw=$zhw."<img src='".$mbtp."title2.gif' border='0'> <a target='_blank' title='".$rs["itopic"]."' href='/index.php?lm=zxxx&id=".$rs["iid"]."'>".char($rs["itopic"],$str)."</a></td></tr>";
}
$zhw=$zhw."</table>";
echo $zhw;
return $zhw;
}