今天的成果嘿嘿：
演示地址：
http://www.7crystal.com/v2.0/xmlrz.php?action=css
http://www.7crystal.com/v2.0/xmlrz.php?action=script
http://www.7crystal.com/v2.0/xmlrz.php?action=qzone
<!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" />
<?php
$url = $_GET['action'];
switch ($url){
case "css":
$title = "XHTML+CSS";
break;
case "script":
$title = "JavaScript";
break;
case "qzone":
$title = "QZONE空间技巧";
break;
default:
$title = "";
}
echo "<title>".$title." ← 七彩Crystal ← ≈忘了￠怎么◆cry◆≈ ← 7crystal.com</title>";
?>
<link href="/common/css/base.css" rel="stylesheet" type="text/css" />
<script src="/Scripts/AC_RunActiveContent.js" type="text/javascript"></script>
<script type="text/javascript" src="/js/base.js"></script>
</head>
<body class="m_960">
<!--header begin-->
<script type="text/javascript" src="/js/htmlheader.js"></script>
<!--header end-->
<div id="content">
<div id="left">
<?php
$conn = @new COM("ADODB.Connection") or die ("ADO连接失败!");
$connstr = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" . realpath("data/data.mdb");
$conn->Open($connstr);
$rs = @new COM("ADODB.RecordSet");
$url = $_GET['action'];
switch ($url){
case "css":
$rs->Open("select * from css",$conn,1,3);
$rs->Fields["cryTitle"]->Value;
$rs->Fields["cryTime"]->Value;
$rs->Fields["cryUrl"]->Value;
echo "<h3>XHTML+CSS</h3>";
echo "<ul class=\"FFdisplayN\">";
while(! $rs->eof) {
echo "<li><a href=\"".$rs->Fields["cryUrl"]->Value."\">".$rs->Fields["cryTitle"]->Value." </a><span>".$rs->Fields["cryTime"]->Value."</span></li>" ;
$rs->MoveNext();
}
echo "</ul>";
$rs->close();
break;
case "script":
$rs->Open("select * from script",$conn,1,3);
$rs->Fields["cryTitle"]->Value;
$rs->Fields["cryTime"]->Value;
$rs->Fields["cryUrl"]->Value;
echo "<h3>JavaScript</h3>";
echo "<ul class=\"FFdisplayN\">";
while(! $rs->eof) {
echo "<li><a href=\"".$rs->Fields["cryUrl"]->Value."\">".$rs->Fields["cryTitle"]->Value." </a><span>".$rs->Fields["cryTime"]->Value."</span></li>" ;
$rs->MoveNext();
}
echo "</ul>";
$rs->close();
break;
case "qzone":
$rs->Open("select * from qzone",$conn,1,3);
$rs->Fields["cryTitle"]->Value;
$rs->Fields["cryTime"]->Value;
$rs->Fields["cryUrl"]->Value;
echo "<h3>QZONE</h3>";
echo "<ul class=\"FFdisplayN\">";
while(! $rs->eof) {
echo "<li><a href=\"".$rs->Fields["cryUrl"]->Value."\">".$rs->Fields["cryTitle"]->Value." </a><span>".$rs->Fields["cryTime"]->Value."</span></li>" ;
$rs->MoveNext();
}
echo "</ul>";
$rs->close();
break;
default:
echo "七彩Crystal";
}
?>
</div>
<!--#left end-->
<div id="right">
<script type="text/javascript" src="/js/htmlright.js"></script>
</div>
</div>
<!--content End-->
<!--footer begin-->
<script type="text/javascript" src="/js/htmlfooter.js"></script>
<!--footer end-->
</body>
</html>