原来的200多行的代码变成40多行

大 | 中 | 小
[不指定 2007/01/05 17:14 | by Else ]
还是定下心来，把首页的程序给换了！
这个是原来的代码，对比一下才知道省了好多！不过相对来说，模板文件不是很好！一直想换数组，没换成
原来的index.php
<?php
require_once('Connections/conn.php');
require_once('php/function.php');
require_once('php/config.php');
?>
<!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=gb2312" />
<meta name="description" content="<?php echo $Sitetitle; ?>,<?php echo $Sitekey; ?>" />
<meta name="keywords" content="<?php echo $Sitekey; ?>" />
<meta name="copyright" content="http://www.cuku.net,酷库网络" />
<meta name="author" content="耶律韶光,sahu@qq.com" />
<meta name="robots" content="all" />
<title><?php echo $Sitetitle; ?>  Powered by www.cuku.net</title>
<link href="css/index.css" rel="stylesheet" type="text/css" />
</head>
<body >
<div id="all"  align="center">
 <div id="body" >
 <?php require("head.php");  ?>
<div id="head_menu">
<?php
//Menu list
$query_rs = "SELECT link,text,menu,opennew FROM menu WHERE `view` = 1 ORDER BY list ASC";
$rs = mysql_query($query_rs, $conn) or die(mysql_error());
$row_rs = mysql_fetch_assoc($rs);
//$totalRows_rs = mysql_num_rows($rs);
do {
 if ($row_rs['opennew']==1)
    {
    $blank="target=\"_blank\"";
    }
  $mymenus.= "<a href=\"".$row_rs['link']."\" class=\"White\" ".$blank."title=\"".$row_rs['text']."\" >" .$row_rs['menu']."</a> \n";
 } while ($row_rs = mysql_fetch_assoc($rs));
 mysql_free_result($rs);
echo $mymenus;
?>
</div>
   <div id="headline">
<?php
echo $sitegongao;
?>
   </div>
   <div id="main">
     <div id="pic"> <li>网站公告</li>
        <marquee id=typhoon onMouseOver=typhoon.stop()
                               onMouseOut=typhoon.start() scrollamount=1
                               scrolldelay=4 direction=up height='190'
                               border="0">
    <?php
   $query_aff_rs = "SELECT content,time FROM affiche ORDER BY id DESC LIMIT 5";    
   //The updated notice 5
   $aff_rs = mysql_query($query_aff_rs, $conn) or die(mysql_error());
   $row_aff_rs = mysql_fetch_assoc($aff_rs);
    do {
        echo $row_aff_rs['content']."<br />".$row_aff_rs['time']."<br /><br />";
   
     } while ($row_aff_rs = mysql_fetch_assoc($aff_rs));
     mysql_free_result($aff_rs);//Memory release
    ?>          
 </marquee>
     </div>
   <div id="comd">
   <div id="ctitle">
     <li>最新主题</li>
   </div>
   <?php
   $query_new_rs = "SELECT ruby.id,ruby.title,ruby.time,ruby.menu,cat.catname
           FROM ruby,cat
           WHERE ruby.view=1 and ruby.menu=cat.id
           ORDER BY id desc LIMIT 0,10";    
   //The updated article 10
   $new_rs = mysql_query($query_new_rs, $conn) or die(mysql_error());
   $row_new_rs = mysql_fetch_array($new_rs);
    do { ?>
     <div id="atitle">
       <img src="images/title_ico4.gif" width="10" height="9" align="absmiddle" />【<?php
      echo "<a href=\"list.php?id=".$row_new_rs['menu'].".html\">".$row_new_rs['catname']."</a>";
      ?>】<a href=/show.php/<?php echo $row_new_rs['id']; ?>.html title="<?php echo $row_new_rs['title']; ?>" target="_blank"><?php
      echo cnSubStr($row_new_rs['title'],32); ?>
     </a>&nbsp;<?php echo cnSubStr($row_new_rs['time'],10); ?>
     </div>
     <?php } while ($row_new_rs = mysql_fetch_assoc($new_rs));
     mysql_free_result($new_rs);//Memory release
    ?></div>
   <div id="listpic">
     <div id="piclisttitle">::搜索服务</div>
   <?php echo $site_search;?>  
     
   </div>
   <div id="listact">

        <?php
     $query_catrs = "SELECT id,catname,content FROM cat where pcatid=0 AND view=1 ORDER BY list ASC";
     $catrs = mysql_query($query_catrs, $conn) or die(mysql_error());
     $row_catrs = mysql_fetch_assoc($catrs);
     do {
     $catid=$row_catrs['id'];
     $catname=$row_catrs['catname'];
     $content=$row_catrs['content']
     ?>
         <div id="lanmu">
           <div id="lantitle"> <img src="images/main_ico1.gif" width="5" height="13" align="absmiddle" />
       <?php echo "<a href=\"/class.php/$catid\" title=\"$content\" class=\"lantitle\">$catname</a>"; ?>
         <a href="rss.php?id=<?php echo $catid ?>"><img src="images/rss.png" width="12" height="12" border="0" align="absmiddle" /></a> </div>
  <?php
     $query_ruby = "SELECT ruby.id,title,time FROM ruby
             LEFT JOIN cat ON ruby.menu=cat.id
             WHERE cat.pcatid=$catid ORDER BY ruby.id desc LIMIT 0,12 ";
     $ruby = mysql_query($query_ruby, $conn) or die(mysql_error());
     $row_ruby = mysql_fetch_assoc($ruby);
     do {
     $ruby_title=$row_ruby['title'];
     $ruby_id=$row_ruby['id'];
     $ruby_time=$row_ruby['time']
      ?>
     <li><?php echo "<a href=\"show.php/$ruby_id.html\" title=\"标题:$ruby_title \n时间:$ruby_time\" target=\"_blank\">".cnSubStr($ruby_title,40)."</a>"; ?></li>
   <?php } while ($row_ruby = mysql_fetch_assoc($ruby));  ?>
         </div>
          <?php } while ($row_catrs = mysql_fetch_assoc($catrs));
           mysql_free_result($catrs);    //Memory release
      ?>
   </div>
   </div>
   <div id="right">
     <div id="top">
       <div id="topname">::热门话题</div>
   <?php
   $query_top_rs = "SELECT id,title FROM ruby WHERE view=1 order by countruby desc LIMIT 0,10";    
   //The updated article 10
   $top_rs = mysql_query($query_top_rs, $conn) or die(mysql_error());
   $row_top_rs = mysql_fetch_assoc($top_rs);
    do { ?>
   <div id="toplist">
   <img src="images/arrow_list.gif" width="13" height="11" /><a href=/show.php/<?php echo $row_top_rs['id']; ?>.html
   title="<?php echo $row_top_rs['title']; ?>"
   target="_blank"
   ><?php echo cnSubStr($row_top_rs['title'],28); ?>
   </a>
 </div>
  <?php } while ($row_top_rs = mysql_fetch_assoc($top_rs));
   mysql_free_result($top_rs);//Memory release
    ?><br/></div>
      <div id="top">
       <div id="topname">::站长推荐</div>
   <?php
   $query_top_rs = "SELECT id,title FROM ruby WHERE view=1 order by commend=1,id desc LIMIT 0,10";    
   //The updated article 10
   $top_rs = mysql_query($query_top_rs, $conn) or die(mysql_error());
   $row_top_rs = mysql_fetch_assoc($top_rs);
    do { ?>
 <div id="toplist">
   <img src="images/arrow_list.gif" width="13" height="11" /><a href=/show.php/<?php echo $row_top_rs['id']; ?>.html
   title="<?php echo $row_top_rs['title']; ?>"
   target="_blank"
   ><?php echo cnSubStr($row_top_rs['title'],28); ?>
   </a>
 </div>
  <?php } while ($row_top_rs = mysql_fetch_assoc($top_rs));
   mysql_free_result($top_rs);//Memory release
    ?><br/>
     
         </div>
     
     <div id="top">
       <div id="topname">::在线手册</div>
 <div id="toplist"><img src="images/arrow_list.gif" width="13" height="11" /><a href="http://www.cuku.net/api/" title="jdk1.5在线中文手册" target="_blank">jdk1.5在线中文手册</a></div>
 
 <div id="toplist"><img src="images/arrow_list.gif" width="13" height="11" /><a href="http://www.cuku.net/apache/" title="Apache2.2在线中文手册" target="_blank">Apache2.2在线中文手册</a></div>
 
 <div id="toplist"><img src="images/arrow_list.gif" width="13" height="11" /><a href="http://www.cuku.net/php5/" title="Apache2.2在线中文手册" target="_blank">PHP 5在线中文手册</a></div>
       </div>
     
      <div id="top">
     <script type="text/javascript"><!--
google_ad_client = "pub-4562116319521098";
google_ad_width = 200;
google_ad_height = 90;
google_ad_format = "200x90_0ads_al_s";
google_ad_channel = "";
//--></script>
<script type="text/javascript"
 src="http://pagead2.googlesyndication.com/pagead/show_ads.js">
</script>  
   <script type="text/javascript"><!--
google_ad_client = "pub-4562116319521098";
google_ad_width = 200;
google_ad_height = 200;
google_ad_format = "200x200_as";
google_ad_type = "text_image";
google_ad_channel = "";
//--></script>
<script type="text/javascript"
 src="http://pagead2.googlesyndication.com/pagead/show_ads.js">
</script>  
       </div>
     
     
     
   </div>
 
  <div id="link">
     <div id="linktitle"><img src="images/main_ico1.gif" width="5" height="13" align="absmiddle" /> 友情链接</div>
     <div id="Link_3">
       <div id="Link_4">
   <?php //文字链接
     $query_link_rs = "select url,content,webname from weblink where pass=1 and view=1 order by list asc";
     $link_rs = mysql_query($query_link_rs, $conn) or die(mysql_error());
     $row_link_rs = mysql_fetch_assoc($link_rs);
   do{
   
     $l_url    =$row_link_rs['url'];
     $l_content  =$row_link_rs['content'];
     $l_webname  =$row_link_rs['webname'];
     echo "<div id=\"Link_4_1\"><a href=\"$l_url\" target=_blank title=\"$l_content\">$l_webname</a></div>";
     
   }while ($row_link_rs = mysql_fetch_assoc($link_rs))?>
     </div>
     </div>
   </div>
<?php include('php/copyright.php'); ?>
 </div>
</div>
</body>
</html>


换过的代码

模板的index.php
<?
require_once('php/data.php');               //初始化数据
require_once('php/config.php');        //配置
require_once('php/function.php');      //函数
require_once("./template.php");       //模板文件
require_once("./mysql.php");         //数据库操作
$tl = new template(
 array('TemplateDir'=>'template/'.$template_conn.'')
);
//==========================================================
$SiteName    = $SiteName  ;      //网站名称
$sitetitle     = $Sitetitle;      //网站标题
$sitegongao    = $sitegongao;      //网站公告
$Sitekey    = $Sitekey  ;      //关键字
$SiteUrl    = $SiteUrl;        //网址
$SiteLogo     = $SiteLogo  ;      //logo
$Copyright    = $Copyright;      //版权信息
$Sitebeian    = $Sitebeian;      //网站备案号
$webmaster     = $webmaster;      //网站管理员
$webcount    = $webcount;      //网站计数器
$topad      = $ad;          //网站广告
$site_search  = $site_search;      //網站搜索代碼
//==========================================================

//====================================
$db = new Dirver();
$db->DBLink($hostname_conn,$username_conn,$password_conn,$database_conn);
//memu
$menusql= $db->query("SELECT link,text,menu,opennew FROM menu WHERE `view` = 1 ORDER BY list ASC");
//公告
$notice = $db->query("SELECT content,time FROM affiche ORDER BY id DESC",5);
//新文章
$rubynew = $db->query("SELECT ruby.id,ruby.title,ruby.time,ruby.menu,cat.catname
           FROM ruby,cat
           WHERE ruby.view=1 and ruby.menu=cat.id
           ORDER BY id desc LIMIT 0,10");
//栏目
$catsql = $db->query("SELECT id,catname,content FROM cat where pcatid=0 AND view=1 ORDER BY list ASC");

//热门文章
$topsql=$db->query("SELECT id,title FROM ruby WHERE view=1 order by countruby desc",10);
//推荐文章
$comsql=$db->query("SELECT id,title FROM ruby WHERE view=1 and commend=1 order by id desc",10);
//友情鏈接
$linksql=$db->query("SELECT url,content,webname FROM weblink WHERE pass=1 AND view=1 ORDER BY list ASC");
$tl->set_file('index');
$tl->p();
?>


模板文件
模板文件index.html
<!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=gb2312" />
<meta name="description" content="{sitetitle}" />
<meta name="keywords" content="{Sitekey}" />
<meta name="copyright" content="{SiteUrl},{SiteName}" />
<meta name="author" content="耶律,sahu@qq.com" />
<meta name="robots" content="all" />
<title>{sitetitle}</title>
<link href="css/index.css" rel="stylesheet" type="text/css" />
</head>
<body >
<div id="all"  align="center">
 <div id="body" >
 <div id="head_top">
   <div id="top_line1"><font color=red>本站Blog地址</font><a href=http://www.aixq.com/>http://www.aixq.com</a>Blog留言 2006年网络没有神话！只有努力！！加油！！！</div>
   <div id="top_line2">
     <div id="top_left"><img src="/images/top.gif" width="160" height="60" /></div>
 <div id="top_mid">{topad}</div>
     <div id="top_right"><img src="/images/top_home.gif" width="13" height="12" /> <a href="#" onclick="this.style.behavior='url(#default#homepage)';this.setHomePage('{SiteUrl}');">设为首页</a><br />
         <img src="/images/top_gift.gif" width="13" height="12" /> <a target=_top href=javascript:window.external.addfavorite("http://{SiteUrl},{SiteName}")>加入收藏</a><br />
         <img src="/images/top_tg.gif" width="14" height="12" /> <a href="mailto:sahu@qq.com">联系站长</a></div>
   </div>
 </div> <div id="head_menu">
<!-- while:$menu = $db->fetch_array($menusql) -->  
 <!-- IF[$menu['opennew']==1] -->
 <a href="{menu['link']}" class="White" target="_blank" title="{menu['text']}" >{menu['menu']}</a>
 <!-- ELSE -->
  <a href="{menu['link']}" class="White" title="{menu['text']}" >{menu['menu']}</a>
<!-- END -->
<!-- END -->  
</div>
   <div id="headline">{sitegongao}</div>
   <div id="main">
     <div id="pic"> <li>网站公告</li>
        <marquee id=typhoon onMouseOver=typhoon.stop()
                               onMouseOut=typhoon.start() scrollamount=1
                               scrolldelay=4 direction=up height='190'
                               border="0">
   <!-- while:$notice = $db->fetch_array($notice) -->  
   {notice['content']}&nbsp;
   {notice['time']}<br /><br />
   <!-- END -->      
         
 </marquee>
     </div>
   <div id="comd">
   <div id="ctitle">
     <li>最新主题</li>
   </div>
   <!-- while:$ruby = $db->fetch_array($rubynew) -->  
     <div id="atitle">
       <img src="images/title_ico4.gif" width="10" height="9" align="absmiddle" />【<a href="list.php?id={ruby['menu']}.html">{ruby['catname']}</a>】<a href=/show.php/{ruby['id']}.html title="{ruby['title']}" target="_blank">{run:}echo cnSubStr($ruby['title'],34){/run}
     </a>&nbsp;{run:}echo cnSubStr($ruby['time'],10){/run}</div>
      <!-- END -->  
     </div>
   <div id="listpic">
     <div id="piclisttitle">::搜索服务</div>
   <iframe id="baiduframe" border="0" vspace="0" hspace="0" marginwidth="0" marginheight="0"
 framespacing="0" frameborder="0" scrolling="no" width="468" height="60"
 src="http://unstat.baidu.com/bdun.bsc?tn=wpsni_pg&cv=0&cid=1033875&csid=106&rkcs=4&bgcr=FFFFFF&ftcr=0000CC&rk=1&bd=1&tbsz=&tbst=&bdas=0">
</iframe>
 
     
   </div>
   <div id="listact">
<!-- while:$catlist = $db->fetch_array($catsql) -->  
       <div id="lanmu">
           <div id="lantitle"> <img src="images/main_ico1.gif" width="5" height="13" align="absmiddle" />
<a href="/class.php/{catlist['id']}" title="{catlist['content']}" class="lantitle">{catlist['catname']}</a>
<a href="rss.php?id={catlist['id']}"><img src="images/rss.png" width="12" height="12" border="0" align="absmiddle" /></a>
     </div>
   {run:}$rubysql = $db->query("SELECT ruby.id,title,time FROM ruby LEFT JOIN cat ON ruby.menu=cat.id WHERE cat.pcatid=$catlist[id] ORDER BY ruby.id desc LIMIT 0,12");{/run}
   <!-- while:$rubylist = $db->fetch_array($rubysql) -->  
    <li><a href="show.php/{rubylist['id']}.html" title="标题:{rubylist['title']}
时间:{rubylist['time']}" target="_blank">{run:}echo cnSubStr($rubylist['title'],42){/run}</a></li>
         <!-- END -->  
   </div>
   <!-- END -->  
   
   </div>
   </div>
   <div id="right">
<div id="top">
<div id="topname">::热门话题</div>
<!-- while:$toplist = $db->fetch_array($topsql) -->  
  <div id="toplist">
 <img src="images/arrow_list.gif" width="13" height="11" /><a href=/show.php/{toplist['id']}.html
 title="{toplist['title']}" target="_blank">{run:}
 echo cnSubStr($toplist['title'],29)
 {/run}</a>
 </div>
    <!-- END --><br/>
</div>
      <div id="top">
       <div id="topname">::站长推荐</div>
 <!-- while:$comlist = $db->fetch_array($comsql) -->  
  <div id="toplist">
 <img src="images/arrow_list.gif" width="13" height="11" /><a href=/show.php/{comlist['id']}.html
 title="{comlist['title']}" target="_blank" >
 {run:}
 echo cnSubStr($comlist['title'],29)
 {/run} </a>
 </div>
   <!-- END -->
    <br/>
     
         </div>
     
     <div id="top">
       <div id="topname">::在线手册</div>
 <div id="toplist"><img src="images/arrow_list.gif" width="13" height="11" /><a href="http://www.cuku.net/api/" title="jdk1.5在线中文手册" target="_blank">jdk1.5在线中文手册</a></div>
 
 <div id="toplist"><img src="images/arrow_list.gif" width="13" height="11" /><a href="http://www.cuku.net/apache/" title="Apache2.2在线中文手册" target="_blank">Apache2.2在线中文手册</a></div>
 
 <div id="toplist"><img src="images/arrow_list.gif" width="13" height="11" /><a href="http://www.cuku.net/php5/" title="Apache2.2在线中文手册" target="_blank">PHP 5在线中文手册</a></div>
       </div>
     
      <div id="top">
       <div id="topname">::赞助商链接</div>
       <br />

   
       </div>
     
</div>
 
<div id="link">
     <div id="linktitle"><img src="images/main_ico1.gif" width="5" height="13" align="absmiddle" /> 友情链接</div>
     <div id="Link_3">
       <div id="Link_4">
<!-- while:$weblink = $db ->fetch_array($linksql) -->  
   <div id="Link_4_1">
<a href="{weblink['url']}" target=_blank title="{weblink['content']}">{weblink['webname']}</a>
   </div>
   <!-- END -->      
   </div>
     </div>
   </div>
<div id="copytop">{foot}</div>  
<div id="copyright">
 {Copyright}<a href=http://www.miibeian.gov.cn >{Sitebeian} </a> 管理:{webmaster}
&nbsp;{webcount}</div>  </div>
</div>
</body>
</html>


作者：Else 's Blog
地址：http://www.aixq.com/post/615/
版权所有。转载时必须链接形式注明作者和原始出处及本声明！
  • 在中查看更多“原来的200多行的代码变成40多行”相关内容
  • 在中查看更多“原来的200多行的代码变成40多行”相关内容
  • 在中查看更多“原来的200多行的代码变成40多行”相关内容
  • 在中查看更多“原来的200多行的代码变成40多行”相关内容
  • 在中查看更多“原来的200多行的代码变成40多行”相关内容
  • 在中查看更多“原来的200多行的代码变成40多行”相关内容

    • 最后编辑： Else 编辑于2007/01/05 17:18
    代码 程序 编程 | 评论(1) | 引用(0) | 阅读(2836)
    源子
    2007/01/06 14:14
    嗯。
    Else 回复于 2007/01/07 09:33
    哈，源子来了，新年快乐！
    分页： 1/1 第一页 1 最后页
    发表评论
    表情
    emotemotemotemotemot
    emotemotemotemotemot
    emotemotemotemotemot
    emotemotemotemotemot
    emotemotemotemotemot
    打开HTML
    打开UBB
    打开表情
    隐藏
    昵称   密码   游客无需密码
    网址   电邮   [注册]
                   

    验证码 不区分大小写