tzt_news表
id bankuai type smalltype title
133091 0 9 27 手握1575亿预收款 开发商心里不慌 tzt_hotnews表
id type mainurl maintitle
4 2 133091 手握1575亿预收款 开发商心里不慌 $mainurl = $this->urlPrefix."content/".$f_dir."/".$rs['bankuai']."/".$rs['type']."/".$rs['smalltype']."/".$main.".html";要使".$rs['bankuai']."/".$rs['type']."/".$rs['smalltype'].输出的是tzt_news表晨的内容
function getIndexHotNews($type)
{
$db=new mysql;
$i=0;
$m_hotnews = '';
$sql="select * from tzt_hotnews where (type=".$type.") and display=1 order by type asc,id desc limit 2";
$tmp_left1 = intval(substr($type,0,1));
if($tmp_left1==1 || $tmp_left1==2)
$tmp_style = "hotnews_style";
elseif($tmp_left1==3 || $tmp_left1==4)
$tmp_style = "hotnews_style_money";
elseif($tmp_left1==5 || $tmp_left1==6)
$tmp_style = "hotnews_style_stock";
elseif($tmp_left1==7 || $tmp_left1==8)
$tmp_style = "hotnews_style_money";
elseif($tmp_left1==9 || $tmp_left1==10)
$tmp_style = "hotnews_style_money";
if($result=$db->select($sql))
$id1='';
$tmp_left2 = intval(substr($type,0,1));
if($tmp_left2==1 || $tmp_left2==2)
$m_hotnews_4 = $this->getNews_2(0,0,heatnews,8);
elseif($tmp_left2==3 || $tmp_left2==4)
$m_hotnews_4 = $this->getNews_2(0,0,hotmoneynews,8);
elseif($tmp_left2==5 || $tmp_left2==6)
$m_hotnews_4 = $this->getNews_2(0,0,hotstocknews,8);
elseif($tmp_left2==7 || $tmp_left2==8)
$m_hotnews_4 = $this->getNews_2(0,0,hotfielsnews,8);
elseif($tmp_left2==9 || $tmp_left2==10)
$m_hotnews_4 = $this->getNews_2(0,0,hotfuturenews,8);
$ii = 4;//子新闻放2条 如果 要放3条 哪就是 $ii = 3; 下面的对应写成 $ii = $ii + 3; $j = $j +3;
$j = 0;
while($rs=$db->fetch($result))
{
$main=$rs['mainurl'];
if(!empty($this->isStatic) && is_numeric($main))
{
if($rs['bankuai']==0)
$f_dir = "money";
elseif($rs['bankuai']==1)
$f_dir = "stock";
elseif($rs['bankuai']==2)
$f_dir = "field";
elseif($rs['bankuai']==3)
$f_dir = "futures";
elseif($rs['bankuai']==4)
$f_dir = "forex";
elseif($rs['bankuai']==6)
$f_dir = "study";
$mainurl = $this->urlPrefix."content/".$f_dir."/".$rs['bankuai']."/".$rs['type']."/".$rs['smalltype']."/".$main.".html";
}else{
$mainurl = "detail.php?id=".$rs['id'];
}
$m_hotnews .= '<tr><td><a href="'.$mainurl.'" target="_blank"><span class="'.$tmp_style.'">'.$rs['maintitle'].'</a><span></td></tr>'.chr(13);
$m_hotnews .= '<tr><td class="news_style" width="364">'.chr(13);
for ($i = $j;$i<$ii;$i++){
$len = strlen(title);
if($len < 50 && $len > 40)
$title1 =title;
$m_hotnews .= '[<a href="'.$m_hotnews_4[$i]['t_url'].'" target="_blank">'.$m_hotnews_4[$i]['title'].'</a>]';
}
$ii = $ii + 4;
$j = $j +4;
$m_hotnews .= '</td></tr>'.chr(13);
}
return $m_hotnews;
}
id bankuai type smalltype title
133091 0 9 27 手握1575亿预收款 开发商心里不慌 tzt_hotnews表
id type mainurl maintitle
4 2 133091 手握1575亿预收款 开发商心里不慌 $mainurl = $this->urlPrefix."content/".$f_dir."/".$rs['bankuai']."/".$rs['type']."/".$rs['smalltype']."/".$main.".html";要使".$rs['bankuai']."/".$rs['type']."/".$rs['smalltype'].输出的是tzt_news表晨的内容
function getIndexHotNews($type)
{
$db=new mysql;
$i=0;
$m_hotnews = '';
$sql="select * from tzt_hotnews where (type=".$type.") and display=1 order by type asc,id desc limit 2";
$tmp_left1 = intval(substr($type,0,1));
if($tmp_left1==1 || $tmp_left1==2)
$tmp_style = "hotnews_style";
elseif($tmp_left1==3 || $tmp_left1==4)
$tmp_style = "hotnews_style_money";
elseif($tmp_left1==5 || $tmp_left1==6)
$tmp_style = "hotnews_style_stock";
elseif($tmp_left1==7 || $tmp_left1==8)
$tmp_style = "hotnews_style_money";
elseif($tmp_left1==9 || $tmp_left1==10)
$tmp_style = "hotnews_style_money";
if($result=$db->select($sql))
$id1='';
$tmp_left2 = intval(substr($type,0,1));
if($tmp_left2==1 || $tmp_left2==2)
$m_hotnews_4 = $this->getNews_2(0,0,heatnews,8);
elseif($tmp_left2==3 || $tmp_left2==4)
$m_hotnews_4 = $this->getNews_2(0,0,hotmoneynews,8);
elseif($tmp_left2==5 || $tmp_left2==6)
$m_hotnews_4 = $this->getNews_2(0,0,hotstocknews,8);
elseif($tmp_left2==7 || $tmp_left2==8)
$m_hotnews_4 = $this->getNews_2(0,0,hotfielsnews,8);
elseif($tmp_left2==9 || $tmp_left2==10)
$m_hotnews_4 = $this->getNews_2(0,0,hotfuturenews,8);
$ii = 4;//子新闻放2条 如果 要放3条 哪就是 $ii = 3; 下面的对应写成 $ii = $ii + 3; $j = $j +3;
$j = 0;
while($rs=$db->fetch($result))
{
$main=$rs['mainurl'];
if(!empty($this->isStatic) && is_numeric($main))
{
if($rs['bankuai']==0)
$f_dir = "money";
elseif($rs['bankuai']==1)
$f_dir = "stock";
elseif($rs['bankuai']==2)
$f_dir = "field";
elseif($rs['bankuai']==3)
$f_dir = "futures";
elseif($rs['bankuai']==4)
$f_dir = "forex";
elseif($rs['bankuai']==6)
$f_dir = "study";
$mainurl = $this->urlPrefix."content/".$f_dir."/".$rs['bankuai']."/".$rs['type']."/".$rs['smalltype']."/".$main.".html";
}else{
$mainurl = "detail.php?id=".$rs['id'];
}
$m_hotnews .= '<tr><td><a href="'.$mainurl.'" target="_blank"><span class="'.$tmp_style.'">'.$rs['maintitle'].'</a><span></td></tr>'.chr(13);
$m_hotnews .= '<tr><td class="news_style" width="364">'.chr(13);
for ($i = $j;$i<$ii;$i++){
$len = strlen(title);
if($len < 50 && $len > 40)
$title1 =title;
$m_hotnews .= '[<a href="'.$m_hotnews_4[$i]['t_url'].'" target="_blank">'.$m_hotnews_4[$i]['title'].'</a>]';
}
$ii = $ii + 4;
$j = $j +4;
$m_hotnews .= '</td></tr>'.chr(13);
}
return $m_hotnews;
}
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货