{"id":436,"date":"2010-06-04T10:27:46","date_gmt":"2010-06-04T10:27:46","guid":{"rendered":""},"modified":"2010-06-04T10:27:46","modified_gmt":"2010-06-04T10:27:46","slug":"436","status":"publish","type":"post","link":"https:\/\/www.poloo.org\/?p=436","title":{"rendered":"smarty\u5b9e\u4f8b\u6559\u7a0b —\u5b9e\u4f8b\u7bc7"},"content":{"rendered":"

\u4e00\u3001\u4f7f\u7528PHP\u5185\u7f6eMYSQL\u51fd\u6570<\/p>\n

\u4ece\u672c\u8282\u5f00\u59cb\u6211\u4eec\u6765\u5b66\u4e60\u4e00\u4e0b\u5982\u679c\u628aSmarty\u5e94\u7528\u5230\u5b9e\u9645\u7684\u4f8b\u5b50\u4e2d. \u4e3a\u4e86\u6f14\u793a\u8bf4\u660e,\u6211\u5c06\u4ee5\u524d\u5199\u7684\u4e00\u4e2a\u7ad9\u70b9\u4f5c\u4e3a\u5b9e\u4f8b\u6765\u8bb2\u6765\u4e0b.\u5148\u8bf4\u660e\u4e00\u4e0b, \u6211\u672c\u4eba\u7684\u7f8e\u672f\u529f\u5e95\u4e0d\u662f\u5f88\u5f3a,\u6240\u4ee5\u8bbe\u8ba1\u51fa\u6765\u7684\u9875\u9762\u4e0d\u592a\u597d\u770b,\u5927\u5bb6\u5c31\u5bf9\u4ed8\u7740\u770b\u5427
\u5728\u770b\u672c\u6587\u4e4b\u524d\uff0c\u53ef\u4ee5\u5148\u770b\u770bindexbak.htm\u4e0enewsbak.htm\uff0c\u5b83\u4eec\u662f\u6211\u4eec\u751f\u6210\u540e\u7684\u4f8b\u56fe\u3002<\/p>\n

\u4e00\u3001 \u9996\u5148\u6765\u8bf4\u660e\u4e00\u4e0b\u6211\u4eec\u5c06\u8981\u4f7f\u7528\u5230\u7684\u6570\u636e\u5e93,\u4e0b\u9762\u6211\u5148\u5c06\u6570\u636e\u5e93\u6e90\u6587\u4ef6\u7ed9\u5927\u5bb6\u4f8b\u51fa\u6765:<\/p>\n


======================================================================
Create DATABASE News;<\/p>\n

USE News;<\/p>\n

\/****************************
*
* \u8868 \u540d: tb_news_ch
* \u7528 \u9014: \u56fd\u5185\u65b0\u95fb\u8868
*
****************************\/
Create TABLE tb_news_ch
(
iNewsID interger(11) primary key auto_increment,
vcNewsTitle varchar(50) not null,
ltNewsContent longtext not null
);<\/p>\n

\/****************************
*
* \u8868 \u540d: tb_news_in
* \u7528 \u9014: \u56fd\u9645\u65b0\u95fb\u8868
*
****************************\/
Create TABLE tb_news_in
(
iNewsID interger(11) primary key auto_increment,
vcNewsTitle varchar(50) not null,
ltNewsContent longtext not null
);<\/p>\n

\/****************************
*
* \u8868 \u540d: tb_news_mu
* \u7528 \u9014: \u5a31\u4e50\u65b0\u95fb\u8868
*
****************************\/<\/p>\n

Create TABLE tb_news_mu
(
iNewsID interger(11) primary key auto_increment,
vcNewsTitle varchar(50) not null,
ltNewsContent longtext not null
);
======================================================================
<\/code><\/p>\n

\u6211\u8fd9\u91cc\u7b80\u5355\u7684\u5c06\u6570\u636e\u5e93\u8bf4\u660e\u4e00\u4e0b.<\/p>\n

\u7b2c\u4e00\u4e2a\u95ee\u9898:
\u5927\u5bb6\u53ef\u4ee5\u770b\u5230,\u5176\u5b9e3\u4e2a\u6570\u636e\u8868\u7684\u5b57\u6bb5\u540d\u90fd\u4e00\u6837,\u90a3\u4e48\u4e3a\u4ec0\u4e48\u4e0d\u628a\u5b83\u4eec\u5408\u5e76\u6210\u4e00\u4e2a\u6570\u636e\u8868\u5462,\u7b54\u6848\u5f88\u7b80\u5355:\u6548\u7387,\u5728\u5f00\u53d1\u7684\u65f6\u5019\u6211\u4eec\u53ef\u80fd\u611f\u89c9\u4e0d\u51fa\u6709\u4ec0\u4e48\u53ef\u63d0\u9ad8\u6548\u7387\u7684\u5730\u65b9,\u4e0d\u8fc7\u5927\u5bb6\u60f3\u60f3,\u5f53\u8fd9\u4e2a\u7f51\u7ad9\u8fd0\u884c\u4e00\u6bb5\u65f6\u95f4\u540e,\u5b83\u7684\u65b0\u95fb\u6570\u636e\u91cf\u5c31\u4f1a\u53d8\u7684\u5f88\u5927,\u800c\u4e14\u8003\u8651\u5230\u5982\u679c\u5c06\u6765\u7f51\u7ad9\u505a\u5927\u540e\u53ef\u80fd\u5c06\u5404\u4e2a\u7c7b\u578b\u5206\u79bb\u51fa\u6765\u5f62\u6210\u7c7b\u4f3cchina.xxx.com, international.xxx.com, music.xxx.com,\u5c06\u6bcf\u4e00\u680f\u76ee\u72ec\u7acb\u5206\u51fa\u53bb\u7269\u7406\u4e0a\u505a\u6210\u4e00\u4e2a\u5355\u72ec\u7684\u7ad9\u70b9,\u5230\u90a3\u65f6\u5982\u679c\u65b0\u95fb\u8fd8\u662f\u5408\u8d77\u6765\u653e\u7f6e\u7684\u8bdd\u5c31\u4f1a\u9020\u6210\u6570\u636e\u5e93\u74f6\u9888,\u6240\u4ee5\u9488\u5bf9\u5f53\u524d\u7684\u7ad9\u70b9,\u6211\u8ba4\u4e3a\u8fd8\u662f\u5206\u5f00\u7684\u6bd4\u8f83\u5408\u7406.<\/p>\n

\u7b2c\u4e8c\u4e2a\u95ee\u9898:
\u6709\u4eba\u53ef\u80fd\u95ee\u4e86,\u4f60\u5728\u5b57\u6bb5\u524d\u52a0\u7684i, vc,lt\u5e72\u4ec0\u4e48\u7528?\u8fd9\u91cc\u662f\u6309\u7167\u5b57\u6bb5\u7c7b\u578b\u6765\u547d\u540d\u7684, \u8fd9\u4e5f\u662f\u4e00\u79cd\u826f\u597d\u98ce\u683c\u7684\u4f53\u73b0,\u5c06\u7c7b\u578b\u524d\u7f00\u653e\u5728\u53d8\u91cf\u524d,\u4f7f\u7528\u7528\u6237\u4e0d\u7528\u770b\u5b57\u6bb5\u5b9a\u4e49\u5c31\u53ef\u4ee5\u77e5\u9053\u5b57\u6bb5\u662f\u4ec0\u4e48\u7c7b\u578b,\u8fd9\u662f\u4ece\u5fae\u8f6f\u7684\u5308\u7259\u5229\u547d\u540d\u6cd5\u4e2d\u53c2\u8003\u8fc7\u6765\u7684,\u5728\u6570\u636e\u5e93\u8bbe\u8ba1\u65f6,\u6211\u5148\u5c06\u6bcf\u79cd\u7c7b\u578b\u5b9a\u4e49\u62101–3\u4e2a\u5b57\u6bcd,\u7136\u540e\u5728\u6bcf\u4e2a\u5b57\u6bb5\u524d\u52a0\u76f8\u5e94\u7684\u4ee3\u7801\u6765\u4ee3\u8868\u5b83\u7684\u7c7b\u578b.\u50cf\u4e0a\u8fb9,\u6211\u5c06\u5404\u4e2a\u6570\u636e\u5e93\u5b57\u6bb5\u7c7b\u578b\u5b9a\u4e49\u4e3a:<\/p>\n

integer i
varchar vc
longtext lt
char c
….<\/p>\n

\u5728\u4f7f\u7528\u7684\u65f6\u5019,\u4f60\u53ef\u4ee5\u5f80\u6bcf\u4e2a\u6570\u636e\u8868\u4e2d\u8f93\u51655\u6761\u6570\u636e\u8bb0\u5f55\u4ee5\u5907\u6211\u4eec\u5728\u8c03\u8bd5\u5b9e\u4f8b\u65f6\u4f7f\u7528.<\/p>\n

\u4e8c\u3001\u793a\u4f8b\u7ad9\u70b9\u76ee\u5f55\u7ed3\u6784\uff1a<\/p>\n

PHP\u4ee3\u7801:
——————————————————————————–
+Web (\u7ad9\u70b9\u6839\u76ee\u5f55)
|
|—-+comm (Smarty\u76f8\u5173\u6587\u6863\u76ee\u5f55)
| |
| |—-+plugins (Smarty\u63d2\u4ef6\u76ee\u5f55)
| |—–Config_File.class.php (Smarty\u914d\u7f6e\u6587\u4ef6)
| |—–Smarty.class.php (Smarty\u7c7b\u4e3b\u6587\u4ef6)
| |—–Smarty_Compiler.class.php (Smarty\u7f16\u8bd1\u7c7b\u6587\u4ef6)
|
|—-+cache (Smarty\u7f13\u5b58\u76ee\u5f55\uff0c*nix\u4e0b\u4fdd\u8bc1\u8bfb\u5199\u6743\u9650)
|
|—-+templates (\u7ad9\u70b9\u6a21\u677f\u6587\u4ef6\u5b58\u653e\u76ee\u5f55)
| |
| |—-header.tpl(\u9875\u9762\u9875\u5934\u6a21\u677f\u6587\u4ef6)
| |—-index.tpl(\u7ad9\u70b9\u9996\u9875\u6a21\u677f\u6587\u4ef6)
| |—-foot.tpl(\u9875\u9762\u9875\u811a\u6a21\u677f\u6587\u4ef6)
| |—-news.tpl (\u65b0\u95fb\u9875\u6a21\u677f\u6587\u4ef6)
|
|
|—-+templates_c (\u6a21\u677f\u6587\u4ef6\u7f16\u8bd1\u540e\u5b58\u653e\u76ee\u5f55\uff0c*nix\u4e0b\u4fdd\u8bc1\u8bfb\u5199\u6743\u9650)
|
|—-+css (\u7ad9\u70b9CSS\u6587\u4ef6\u76ee\u5f55)
|
|—-+image (\u7ad9\u70b9\u56fe\u7247\u76ee\u5f55)
|
|—-+media (\u7ad9\u70b9Flash\u52a8\u753b\u5b58\u653e\u76ee\u5f55)
|
|—-indexbak.htm (\u9996\u9875\u539f\u59cb\u6548\u679c\u56fe)
|
|—-newsbak,htm (\u65b0\u95fb\u9875\u539f\u59cb\u6548\u679c\u56fe)
|
|—-index.php (Smarty\u9996\u9875\u7a0b\u5e8f\u6587\u4ef6)
|
|—-news.php (Smarty\u65b0\u95fb\u663e\u793a\u6587\u4ef6)
|
|—-\u4f8b\u7a0b\u8bf4\u660e.txt (\u76ee\u5f55\u8bf4\u660e)
|
|—-\u6570\u636e\u5e93\u5efa\u7acb\u6587\u4ef6.txt (\u6570\u636e\u5e93\u7684\u5efa\u7acb\u6587\u6863)<\/p>\n

\u8be6\u7ec6\u60c5\u51b5\u8bf7\u5927\u5bb6\u4e0b\u8f7d\u5b9e\u4f8b\u540e\u5bf9\u7167\u7ed3\u6784\u56fe\u3002<\/p>\n

——————————————————————————–<\/p>\n

\u4e09\u3001\u6a21\u677f\u4e2d\u7684\u5b9e\u4f8b\u7247\u6bb5\uff1a<\/p>\n

1. index.tpl:<\/p>\n

index.tpl\u662f\u7ad9\u70b9\u9996\u9875\u7684\u6a21\u677f\u7c7b\uff0c\u6253\u5f00\u5b83\u7684\u6e90\u6587\u4ef6\u540e\u6211\u4eec\u53ef\u4ee5\u9996\u5148\u770b\u5230\u8fd9\u4e48\u4e8c\u53e5\uff1a
==================================================
1. <{*\u4e0b\u9762\u8fd9\u4e00\u53e5\u4e3a\u672c\u9875\u9762\u7684\u9875\u9762\u5934*}>
2. <{include file=”header.tpl”}>
==================================================
\u7b2c 1 \u53e5\u5927\u5bb6\u90fd\u77e5\u9053\u4e86\uff0c\u662f\u6a21\u677f\u6ce8\u91ca
\u7b2c 2 \u53e5\u8868\u793a\u5728\u5f53\u524d\u4f4d\u7f6e\u8981\u5305\u542b\u53e6\u4e00\u4e2a\u6587\u4ef6\uff0c\u4ec0\u4e48\u6587\u4ef6\u5462\uff0cheader.tpl\uff0c\u8fd9\u91cc\u7684\u8fd9\u4e2aheader.tpl\u662f\u9875\u9762\u7684\u6807\u51c6\u9875\u5934\u6587\u4ef6\uff0c\u628a\u5b83\u5355\u72ec\u62ff\u51fa\u6765\u662f\u4e3a\u5c06\u8fd9\u4e00\u90e8\u5206\u72ec\u7acb\u51fa\u6765\uff0c\u4ee5\u4fbf\u5728\u5728\u5176\u5b83\u9875\u9762\u8fdb\u884c\u91cd\u7528\uff0c\u4e60\u60ef\u4e0a\u8981\u628a\u9875\u5934\u6587\u4ef6\u5199\u5728\u4e00\u4e2atable\u4e2d\uff0c\u4f46\u56e0\u4e3a\u6211\u7684\u5b9e\u4f8b\u662f\u65e9\u5df2\u505a\u597d\u7684\uff0c\u6240\u4ee5\u6709\u4e9b\u4e0d\u7b26\u5408\u89c4\u8303\u3002<\/p>\n

\u518d\u6765\u770b\u6700\u540e\u4e00\u53e5\uff1a
=================================================
3. <{include file=”foot.tpl”}>
=================================================
\u4e0d\u7528\u8bf4\u5927\u5bb6\u90fd\u660e\u767d\u4e86\uff0c\u5c31\u662f\u5305\u542b\u4e00\u4e2a\u9875\u811a\u6587\u4ef6\u3002<\/p>\n

\u518d\u770b\u770b\u56fd\u5185\u65b0\u95fb\u90e8\u5206\u7684\u6a21\u677f\u4ee3\u7801\uff1a<\/p>\n


<table width=\"100%\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" bgcolor=\"#B9E9FF\">
<tr>
<td height=\"115\" width=\"10\"><\/td>
<td valign=\"top\" width=\"295\" bgcolor=\"#B9E9FF\">
<{section name=loop loop=$News_CH}>
<li class=\"newsfont\"><a href=\"news.php?type=1&id=<{$News_CH[loop].NewsID}>\" class=\"newsfont\"><{$News_CH[loop].NewsTitle}><\/a>
<{\/section}>
<\/td>
<\/tr>
<\/table>
<\/code><\/p>\n

\u5927\u5bb6\u5173\u952e\u770b<{section}>\u4e0e<{\/section}>,\u5b83\u4eec\u4e4b\u5916\u7684\u90a3\u4e00\u90e8\u5206\u662f\u4e3a\u4e86\u66f4\u597d\u7684\u7406\u89e3\u4ee3\u7801\u7684\u610f\u601d\u800c\u5217\u51fa\u6765\u7684\u3002\u80fd\u770b\u660e\u767d\u5417\uff1f\u8fd9\u91cc\u5c06\u4ee5\u524d\u8bb2\u8fc7\u7684\u5185\u5bb9\u590d\u4e60\u4e00\u904d\uff1a\u5b9a\u4e49\u4e86\u4e00\u4e2asection\u5faa\u73af\u6a21\u677f\u5757\uff0c\u540d\u5b57\u53ebloop, \u8981\u5faa\u73af\u7684\u662f$News_CH\u8fd9\u4e2a\u6570\u7ec4\uff0c\u4ee5<a href=”xxxx”>\u5904\u5c06\u4e3a\u5f53\u524d\u7684\u65b0\u95fb\u4ea7\u751f\u4e00\u4e2a\u94fe\u63a5\uff0c\u5730\u5740\u4e3anews.php?type=1&id=xxx,\u8fd9\u91cc\u7684xxx\u662f\u4ece\u6570\u636e\u5e93\u91cc\u63d0\u53d6\u7684iNewsID,\u6307\u7684\u662f\u8981\u5728\u65b0\u95fb\u663e\u793a\u9875\u91cc\u663e\u793a\u7f16\u53f7\u4e3aid\u7684\u65b0\u95fb\u3002$News_CH[loop].NewsTitle\u8fd9\u79cd\u8868\u793a\u5f62\u5f0f\u6765\u770b\u7684\u61c2\u5427\uff1f\u770b\u4e0d\u61c2\u7684\u8bdd\u770b\u770b\u4e0a\u4e00\u8282\u8bb2\u8fc7\u7684\u300aSmarty\u5b9e\u4f8b\u6559\u5b66 —\u7a0b\u5e8f\u8bbe\u8ba1\u300b\u90e8\u5206\u4e2d\u7684<{section}>\u8bed\u6cd5\u3002
\u4e5f\u8bb8\u5927\u5bb6\u5bf9<{}>\u611f\u89c9\u6709\u70b9\u964c\u751f\uff0c\u8fd9\u91cc\u7684<{}>\u4e3a\u6a21\u677f\u8bed\u53e5\u5b9a\u4e49\u5757\uff0c\u5728\u524d2\u8282\u6211\u4eec\u90fd\u4f7f\u7528{}\uff0c\u4f46\u56e0\u4e3a\u8fd9\u91cc\u662f\u5177\u4f53\u7684\u5e94\u7528\uff0c\u6240\u4ee5\u5c31\u4e0d\u53d6{}\u4e86\uff0c\u4f7f\u7528\u5927\u5bb6\u4e60\u60ef\u7684<{}>\u6765\u8868\u793a\uff0c\u5f53\u7136\u8fd9\u5728.php\u6587\u4ef6\u4e2d\u8981\u8bbe\u7f6e\u7684\u3002<\/p>\n

\u518d\u770b\u56fd\u9645\u65b0\u95fb\u4e0e\u5a31\u4e50\u65b0\u95fb\u7684\u4ee3\u7801\uff1a<\/p>\n

\u56fd\u9645\u65b0\u95fb\uff1a

<table width=\"100%\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\">
<tr>
<td width=\"295\" height=\"115\" valign=\"top\">
<{section name=loop loop=$News_IN}>
<li class=\"newsfont\"><a href=\"news.php?type=2&id=<{$News_IN[loop].NewsID}>\" class=\"newsfont\"><{$News_IN[loop].NewsTitle}><\/a>
<{\/section}>
<\/td>
<\/tr>
<\/table>
<\/code><\/p>\n

\u5a31\u4e50\u65b0\u95fb\uff1a

<table width=\"100%\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\">
<tr>
<td width=\"296\" height=\"115\" valign=\"top\">
<{section name=loop loop=$News_MU}>
<li class=\"newsfont\"><a href=\"news.php?type=3&id=<{$News_MU[loop].NewsID}>\" class=\"newsfont\"><{$News_MU[loop].NewsTitle}><\/a>
<{\/section}>
<\/td>
<\/tr>
<\/table>
<\/code><\/p>\n

\u6709\u6ca1\u6709\u770b\u51fa\u6709\u4ec0\u4e48\u4e0d\u540c? loop\u90e8\u5206\u4e0d\u540c\uff0cloop\u6307\u7684\u662f\u8981\u5faa\u73af\u7684\u6570\u7ec4\uff0c\u8fd9\u91cc\u8981\u6ce8\u610f\u7684\uff0c\u4e0d\u53ef\u5c06\u591a\u4e2asection\u7684loop\u6307\u5b9a\u4e3a\u540c\u4e00\u4e2a\u503c\uff0c\u90a3\u6837\u7684\u8bddSmarty\u8fdb\u884c\u5206\u6790\u6a21\u677f\u7684\u65f6\u5019\u5c31\u4f1a\u5c06\u4e24\u4e2a\u5177\u6709\u76f8\u540c\u540d\u5b57\u7684section\u540c\u65f6\u5206\u6790\uff0c\u751f\u6210\u4e24\u4e2a\u4e00\u6837\u7684\u8bb0\u5f55\u3002<\/p>\n

\u770b\u5230\u8fd9\u91cc\uff0c\u6709\u4eba\u5c31\u4f1a\u4ea7\u751f\u7591\u95ee\uff1a\u5faa\u73af\u5757\u6211\u5df2\u7ecf\u6709\u4e86\uff0c\u6211\u600e\u4e48\u624d\u80fd\u5c31\u5b83\u5728\u5f53\u524d\u4f4d\u7f6e\u53ea\u663e\u793a\u6211\u4eec\u60f3\u8981\u7684\u8bb0\u5f55\u6570\u5462\uff1f\u8fd9\u4e2a\u95ee\u9898\u7b80\u5355\uff0c\u6211\u4eec\u5bf9Smarty\u7684section\u5faa\u73af\u5757\u7684\u5faa\u73af\u6b21\u6570\u63a7\u5236\u662f\u5728.php\u6587\u4ef6\u4e2d\u63a7\u5236\u8981\u66ff\u6362\u8fd9\u4e2a\u5faa\u73af\u5757\u7684\u6570\u7ec4\u6765\u51b3\u5b9a\u7684\uff0c\u5728\u8bbe\u8ba1\u6a21\u677f\u65f6\u6211\u4eec\u4e0d\u7528\u8003\u8651\u3002<\/p>\n

\u5176\u6b21\uff0c\u6211\u4eec\u518d\u6765\u770b\u770bnews.tpl:<\/p>\n

1. \u770b\u8fd9\u4e00\u53e5\uff1a
<title><{$NewsTitle}> —-\u5929\u9a84\u4fe1\u606f\u7f51<\/title>
\u5c06\u8981\u663e\u793a\u7684\u65b0\u95fb\u9875\u7684\u6807\u9898\u663e\u793a\u4e3a\u65b0\u95fb\u6807\u9898 + “—-\u5929\u9a84\u4fe1\u606f\u7f51”
2. \u65b0\u95fb\u6807\u9898\uff1a
<div align=”center” class=”NewsTitle”><{$NewsTitle}><\/div>
\u8fd9\u91cc\u53c8\u8bbe\u7f6e\u4e86\u4e00\u4e2a\u6a21\u677f\u53d8\u91cf$NewsTitle,\u610f\u601d\u8bf4\u8981.php\u5c06$NewsTitle(\u5305\u62ec\u6807\u9898\u680f)\u66ff\u6362\u4e3a\u6570\u636e\u5e93\u4e2d\u5f53\u524d\u65b0\u95fb\u7684\u6807\u9898\u3002
3. \u65b0\u95fb\u5185\u5bb9\uff1a
<p><{$NewsContext}><\/p>
\u8fd9\u4e00\u53e5\u4e5f\u5bb9\u6613\uff0c\u5728\u5f53\u524d\u4f4d\u7f6e\u663e\u793a\u65b0\u95fb\u5185\u5bb9\u3002<\/p>\n

\u5f53\u7136\uff0c\u8fd9\u91cc\u53ea\u662f\u7b80\u5355\u7684\u5c06\u65b0\u95fb\u5217\u51fa\u6765\u4e86\uff0c\u5728\u5b9e\u9645\u5e94\u7528\u65f6\u4f60\u8fd8\u53ef\u4ee5\u628a\u6587\u7ae0\u51fa\u5904\uff0c\u53d1\u8868\u65f6\u95f4\uff0c\u4f5c\u8005\uff0c\u76f8\u5173\u65b0\u95fb\u4e00\u8d77\u5217\u51fa\u6765\uff0c\u8fd9\u91cc\u5c31\u4e0d\u4f5c\u591a\u7684\u8ba8\u8bba\u4e86.<\/p>\n

\u4e09\u3001\u7a0b\u5e8f\u90e8\u5206\uff1a<\/p>\n

1. \u5927\u5bb6\u5148\u6765\u770b\u770bindex.php\u7684\u6e90\u6587\u4ef6\uff0c\u7136\u540e\u6211\u4eec\u518d\u6765\u6162\u6162\u5206\u6790\u5b83\u7684\u4f5c\u7528\uff1a<\/p>\n

=============================================================
index.php
=============================================================

<?php
1. \/*********************************************
*
* \u6587\u4ef6\u540d\uff1a index.php
* \u4f5c \u7528\uff1a \u663e\u793a\u5b9e\u4f8b\u7a0b\u5e8f
*
*********************************************\/
2. include_once(\".\/comm\/Smarty.class.php\"); \/\/\u5305\u542bsmarty\u7c7b\u6587\u4ef6
3. define(\"NUM\", 5); \/\/\u5b9a\u4e49\u6bcf\u6b21\u663e\u793a\u7684\u65b0\u95fb\u6761\u6570<\/p>\n

4. $smarty = new Smarty(); \/\/\u5efa\u7acbsmarty\u5b9e\u4f8b\u5bf9\u8c61$smarty
$smarty->templates_dir = \".\/templates\"; \/\/\u8bbe\u7f6e\u6a21\u677f\u76ee\u5f55
$smarty->compile_dir = \".\/templates_c\"; \/\/\u8bbe\u7f6e\u7f16\u8bd1\u76ee\u5f55
$smarty->cache_dir = \".\/cache\"; \/\/\u8bbe\u7f6e\u7f13\u5b58\u76ee\u5f55
$smarty->cache_lifetime = 60 * 60 * 24; \/\/\u8bbe\u7f6e\u7f13\u5b58\u65f6\u95f4
$smarty->caching = false; \/\/\u8fd9\u91cc\u662f\u8c03\u8bd5\u65f6\u8bbe\u4e3afalse,\u53d1\u5e03\u65f6\u8bf7\u4f7f\u7528true
$smarty->left_delimiter = \"<{\"; \/\/\u8bbe\u7f6e\u5de6\u8fb9\u754c\u7b26
$smarty->right_delimiter = \"}>\"; \/\/\u8bbe\u7f6e\u53f3\u8fb9\u754c\u7b26<\/p>\n

5. $db = mysql_connect(\"localhost\", \"root\", \"\");
mysql_select_db(\"News\", $db);<\/p>\n

\/\/\u8fd9\u91cc\u5c06\u5904\u7406\u56fd\u5185\u65b0\u95fb\u90e8\u5206
6. $strQuery = \"Select iNewsID, iNewsTitle FROM tb_news_CH orDER BY iNewsID DESC\";
$result = mysql_query($strQuery);
$i = NUM;
7. while(($row = mysql_fetch_array($result)) && $i > 0)
{
$array[] = array(\"NewsID\", substr($row[\"iNewsID\"], 0, 40),
\"NewsTitle\", substr($row[\"vcNewsTitle\"], 0, 40));<\/p>\n

$i--;
}
8. $smarty->assign(\"News_CH\", $array);
9. unset($array);
mysql_free_result();<\/p>\n

10. \/\/\u8fd9\u91cc\u5904\u7406\u56fd\u9645\u65b0\u95fb\u90e8\u5206
$strQuery = \"Select iNewsID, iNewsTitle FROM tb_news_IN orDER BY iNewsID DESC\";
$result = mysql_query($strQuery);
$i = NUM;
while(($row = mysql_fetch_array($result)) && $i > 0)
{
$array[] = array(\"NewsID\", substr($row[\"iNewsID\"], 0, 40),
\"NewsTitle\", substr($row[\"vcNewsTitle\"], 0, 40));<\/p>\n

$i--;
}
$smarty->assign(\"News_IN\", $array);
unset($array);
mysql_free_result();<\/p>\n

11. \/\/\u8fd9\u91cc\u5c06\u5904\u7406\u5a31\u4e50\u65b0\u95fb\u90e8\u5206
$strQuery = \"Select iNewsID, iNewsTitle FROM tb_news_MU orDER BY iNewsID DESC\";
$result = mysql_query($strQuery);
$i = NUM;
while(($row = mysql_fetch_array($result)) && $i > 0)
{
$array[] = array(\"NewsID\", substr($row[\"iNewsID\"], 0, 40),
\"NewsTitle\", substr($row[\"vcNewsTitle\"], 0, 40));<\/p>\n

$i--;
}
$smarty->assign(\"News_MU\", $array);
unset($array);
mysql_free_result();<\/p>\n

mysql_close($db);<\/p>\n

\/\/\u7f16\u8bd1\u5e76\u663e\u793a\u4f4d\u4e8e.\/templates\u4e0b\u7684index.tpl\u6a21\u677f
12. $smarty->display(\"index.tpl\");
?><\/p>\n

<\/code><\/p>\n

\u4e3a\u4e86\u65b9\u4fbf\u8bf4\u660e\uff0c\u6211\u628a\u6bcf\u4e00\u4e2a\u8981\u8bf4\u660e\u7684\u5730\u65b9\u90fd\u6807\u4e86\u53f7\uff0c\u4e0b\u9762\u5c31\u6765\u8bf4\u8bf4\u6bcf\u4e00\u4e2a\u90e8\u5206\u7684\u4f5c\u7528\uff1a<\/p>\n

1. \u7a0b\u5e8f\u6ce8\u91ca, \u98ce\u683c\u95ee\u9898,\u6211\u591a\u6b21\u5728\u7a0b\u5e8f\u4e2d\u52a0\u8fd9\u4e2a\u5c31\u662f\u4e3a\u4e86\u8ba9\u8bfb\u8005\u4e5f\u517b\u6210\u8fd9\u79cd\u4e60\u60ef.
2. \u6587\u4ef6\u5305\u542b. \u8fd9\u4e00\u53e5\u610f\u601d\u662f\u628aSmarty\u7684\u7c7b\u6587\u4ef6\u5305\u542b\u5230\u5f53\u524d\u7a0b\u5e8f\u6587\u4ef6\u4e2d.
3. \u5e38\u6570\u5b9a\u4e49: \u5b9a\u4e49NUM\u4e3a5,\u4e3a\u65b0\u95fb\u663e\u793a\u6761\u6570
4. \u8bbe\u7f6eSmarty\u53c2\u6570: \u5173\u4e8e\u91cc\u8fb9\u7684\u53c2\u6570\u5927\u5bb6\u53ef\u4ee5\u53c2\u8003\u4e0a\u4e00\u8282\u8bb2\u8fc7\u7684,\u8fd9\u91cc\u53ea\u60f3\u7279\u522b\u8bf4\u660e\u4e00\u4e0b$smarty->cache\u5c5e\u6027,\u5728\u6211\u4eec\u7684\u7a0b\u5e8f\u8c03\u8bd5\u8fc7\u7a0b\u4e2d,\u8981\u628a\u5b83\u8bbe\u7f6e\u4e3afalse,\u6b63\u5f0f\u53d1\u5e03\u7684\u65f6\u5019\u5c06\u5b83\u8bbe\u8ba1\u4e3atrue\u5c31\u53ef\u4ee5\u5b9e\u73b0\u6211\u4eec\u7684\u7a0b\u5e8f\u7f13\u5b58\u6548\u679c.
5. \u6570\u636e\u5e93\u8fde\u63a5: \u8fd9\u4e00\u90e8\u5206\u6211\u4e0d\u7528\u8bf4\u5427?\u6807\u51c6\u7684PHP\u8bed\u53e5.
6. \u8fdb\u884c\u56fd\u5185\u65b0\u95fb\u67e5\u627eSQL\u8bed\u53e5: \u6807\u51c6\u7684SQL\u8bed\u53e5,\u6309\u65b0\u9898\u7f16\u53f7\u964d\u5e8f\u6392\u5e8f.
7. while():
\u8fd9\u4e00\u53e5\u63a7\u5236\u5c06\u8981\u663e\u793a\u7684\u65b0\u95fb\u884c\u6570.\u9996\u5148\u7ed9$i\u8d4b\u503c\u4e3aNUM,NUM\u4e3a\u6211\u4eec\u5728\u5f00\u59cb\u5916\u5b9a\u4e49\u7684\u4e00\u4e2a\u5e38\u91cf, \u5728while()\u7684\u5f00\u59cb\u5224\u65ad\u5904\u4f7f\u7528$i>0 \u8fd9\u4e2a\u6761\u4ef6,while()\u6bcf\u6b21\u5faa\u73af\u65f6\u8981\u5c06$i\u7684\u503c\u51cf1,\u8fd9\u6837,\u5f53\u5b83\u5b8c\u62105\u6b21\u5faa\u73af\u65f6while\u5c31\u4f1a\u7ed3\u675f.
\u8fd9\u91cc\u6211\u4eec\u4e3b\u8981\u6765\u770b\u770b$array[]\u8fd9\u4e2a\u6570\u7ec4:
$array[]\u5728\u7406\u8bba\u4e0a\u4e3a\u4e00\u4e2a\u4e8c\u7ef4\u6570\u7ec4,\u4e5f\u5c31\u662f\u4e00\u4e2a\u6570\u7ec4\u4e2d\u7684\u5143\u7d20\u4e3a\u53e6\u4e00\u4e2a\u6570\u7ec4,\u50cf\u4e0a\u4f8b\u4e2d,\u5f53while()\u8bed\u53e5\u7ed3\u675f\u65f6,$array\u5c31\u662f\u4e00\u4e2a\u5305\u542b5\u4e2a\u6570\u7ec4\u5143\u7d20\u7684\u6570\u7ec4,\u800c\u6bcf\u4e00\u5143\u7d20\u53c8\u662f\u4e00\u4e2a\u5b57\u7b26\u7d22\u5f15\u7684\u6570\u7ec4.\u800c\u8fd9\u4e9b\u5b57\u7b26\u7d22\u5f15\u6b63\u662f\u5728\u6a21\u677f\u4e2d\u5b9a\u4e49section\u5faa\u73af\u5757\u7684$news[loop]\u7684\u5c5e\u6027\u503c,\u5927\u5bb6\u4e00\u5b9a\u8981\u6ce8\u610f\u8fd9\u91cc\u8981\u4e0e\u6a21\u677f\u5faa\u73af\u5757\u7684\u5c5e\u6027\u503c\u76f8\u5bf9\u5e94,\u5426\u5219\u5c06\u4e0d\u80fd\u663e\u793a\u51fa\u6765!
\u5728\u6784\u5efa\u8fd9\u4e2a\u4e8c\u7ef4\u6570\u7ec4\u65f6\u6211\u4eec\u4f7f\u7528\u4e86\u4e00\u4e2asubstr()\u65b9\u6cd5\u8fdb\u884c\u5b57\u7b26\u622a\u53d6,\u8fd9\u4e2a\u65b9\u6cd5\u5728\u8fd9\u91cc\u4ec5\u4f9b\u53c2\u8003,\u5b9e\u9645\u4f7f\u7528\u5f53\u4e2d\u56e0\u4e3a\u4e2d\u6587\u4e3a\u5168\u89d2\u5b57\u7b26,\u4f7f\u7528\u5b83\u65f6\u53ef\u80fd\u4f1a\u9020\u6210\u4e71\u7801,\u5728\u4ee5\u540e\u7684\u4f8b\u5b50\u4e2d\u6211\u4eec\u5c06\u4f7f\u7528\u53e6\u4e00\u4e2a\u7f51\u53cb\u4e0e\u7684csubstr()\u51fd\u6570\u6765\u5b9e\u73b0\u5b57\u7b26\u622a\u53d6\u529f\u80fd.<\/p>\n

8. \u5bf9\u6a21\u677f\u4e2d\u7684loop = $News_CH\u7684section\u5faa\u73af\u5757\u8fdb\u884c\u89e3\u6790.
\u5927\u5bb6\u8981\u6ce8\u610f,\u4f7f\u7528$smarty->assign(“News_CH”, $array),assign\u7684\u7b2c\u4e00\u4e2a\u53c2\u6570\u4e3asection\u4e2d\u7684loop\u7684\u503c, \u7b2c\u4e8c\u4e2a\u53c2\u6570\u4e3a\u4e0a\u9762\u6240\u5efa\u7acb\u7684\u6570\u7ec4.<\/p>\n

9. \u6ce8\u9500$array: $array[]\u5728\u4f7f\u7528\u5b8c\u540e\u8981\u6ce8\u9500,\u56e0\u4e3a\u4f7f\u7528\u8d4b\u503c\u8bed\u53e5\u5bf9$array\u8fdb\u884c\u8d4b\u503c\u65f6\u4e0d\u4f1a\u5c06\u5b83\u6e05\u7a7a,\u800c\u662f\u5c06\u65b0\u6570\u7ec4\u4f5c\u4e3a\u5b83\u7684\u4e00\u4e2a\u5143\u7d20\u589e\u52a0,\u4e3a\u4e86\u4e0d\u4ea7\u751f\u526f\u4f5c\u7528,\u8fd9\u91cc\u4f7f\u7528unset()\u662f\u5fc5\u9700\u7684.<\/p>\n

10. \u56fd\u9645\u65b0\u95fb\u5904\u7406\u6a21\u5757:
\u540c\u56fd\u5185\u65b0\u95fb\u5904\u7406\u6a21\u5757\u4e00\u6837,\u5927\u5bb6\u53ef\u4ee5\u5bf9\u6bd4\u4e00\u4e0b\u6a21\u677f\u4e0e\u8fd9\u4e00\u6bb5,\u627e\u627e\u5176\u4e2d\u6709\u4ec0\u4e48\u5173\u8054\u4e4b\u5904.<\/p>\n

11. \u5a31\u4e50\u65b0\u95fb\u5904\u7406\u6a21\u5757:\u540c\u4e0a,\u5927\u5bb6\u627e\u627e\u5176\u4e2d\u7684\u5173\u7cfb.\u76f8\u4fe1\u5927\u5bb6\u770b\u5b8c\u4f1a\u6709\u6536\u83b7\u7684.<\/p>\n

12. \u5904\u7406\u5e76\u663e\u793aindex.tpl.<\/p>\n

2. \u4e0b\u9762\u518d\u6765\u770b\u770bnews.php\u7684\u6e90\u6587\u4ef6:<\/p>\n

========================================================
news.php
========================================================

<?php
\/*********************************************
*
* \u6587\u4ef6\u540d\uff1a news.php
* \u4f5c \u7528\uff1a \u65b0\u95fb\u663e\u793a\u7a0b\u5e8f
*
*********************************************\/
include_once(\".\/comm\/Smarty.class.php\"); \/\/\u5305\u542bsmarty\u7c7b\u6587\u4ef6
define(\"NUM\", 5); \/\/\u5b9a\u4e49\u6bcf\u6b21\u663e\u793a\u7684\u65b0\u95fb\u6761\u6570<\/p>\n

$smarty = new Smarty(); \/\/\u5efa\u7acbsmarty\u5b9e\u4f8b\u5bf9\u8c61$smarty
$smarty->templates_dir = \".\/templates\"; \/\/\u8bbe\u7f6e\u6a21\u677f\u76ee\u5f55
$smarty->compile_dir = \".\/templates_c\"; \/\/\u8bbe\u7f6e\u7f16\u8bd1\u76ee\u5f55
$smarty->cache_dir = \".\/cache\"; \/\/\u8bbe\u7f6e\u7f13\u5b58\u76ee\u5f55
$smarty->cache_lifetime = 60 * 60 * 24; \/\/\u8bbe\u7f6e\u7f13\u5b58\u65f6\u95f4
$smarty->caching = false; \/\/\u8fd9\u91cc\u662f\u8c03\u8bd5\u65f6\u8bbe\u4e3afalse,\u53d1\u5e03\u65f6\u8bf7\u4f7f\u7528true
$smarty->left_delimiter = \"<{\"; \/\/\u8bbe\u7f6e\u5de6\u8fb9\u754c\u7b26
$smarty->right_delimiter = \"}>\"; \/\/\u8bbe\u7f6e\u53f3\u8fb9\u754c\u7b26<\/p>\n

$db = mysql_connect(\"localhost\", \"root\", \"\") or die(\"\u6570\u636e\u5e93\u8fde\u63a5\u9519\u8bef!\");
mysql_select_db(\"News\", $db);<\/p>\n

$NewsID = $_GET[\"id\"]; \/\/\u83b7\u53d6\u65b0\u95fb\u7f16\u53f7
$NewsType = $_GET[\"type\"]; \/\/\u8981\u663e\u793a\u7684\u65b0\u95fb\u7c7b\u578b
switch($NewsType)
{
case 1:
$dbName = \"tb_news_ch\";
break;
case 2:
$dbName = \"tb_news_in\";
break;
case 3:
$dbName = \"tb_news_mu\";
break;
}<\/p>\n

$strQuery = \"Select vcNewsTitle, ltNewsContent FROM \" . $dbName;
$result = mysql_query($strQuery) or die(\"\u6570\u636e\u5e93\u67e5\u8be2\u9519\u8bef!\");
if($row = mysql_fetch_array($result))
{
$smarty->assign(\"NewsTitle\", $row[\"vcNewsTitle\"]);
$smarty->assign(\"NewsContent\", $row[\"ltNewsContent\"]);<\/p>\n

mysql_free_result($result);
$smarty->display(\"news.tpl\");
}<\/p>\n

mysql_close($db);<\/p>\n

?>
<\/code><\/p>\n

\u8fd9\u4e0a\u9762\u5173\u4e8eSmarty\u7684\u7a0b\u5e8f\u8bed\u53e5\u4e3b\u8981\u53ea\u67093\u884c:
==================================================================
$smarty->assign(“NewsTitle”, $row[“vcNewsTitle”]);
$smarty->assign(“NewsContent”, $row[“ltNewsContent”]);<\/p>\n

mysql_free_result($result);
==================================================================<\/p>\n

\u5f88\u7b80\u5355\u7684\u5c06\u65b0\u95fb\u9875\u4e2d\u7684NewsTitle, NewsContent\u66ff\u6362\u6210\u4ece\u6570\u636e\u5e93\u4e2d\u67e5\u627e\u51fa\u6765\u7684\u5185\u5bb9.<\/p>\n

\u597d\u4e86,\u5173\u4e8e\u8fd9\u4e00\u8bb2\u7684Smarty\u4f8b\u7a0b\u5b66\u4e60\u7684\u521d\u7ea7\u90e8\u5206\u5c31\u8bb2\u5230\u8fd9\u91cc,\u76f8\u4fe1\u5927\u5bb6\u5b66\u5b8c\u540e\u4f1a\u5bf9Smarty\u7684\u7528\u6cd5\u6709\u4e2a\u57fa\u672c\u7684\u4e86\u89e3,\u4e0b\u4e00\u8282\u8fd8\u4f7f\u7528\u4e2a\u8fd9\u4e2a\u4f8b\u5b50\u6765\u8bb2\u8bb2\u5982\u4f55\u4f7f\u7528phplib\u4e2d\u7684DB\u7c7b\u6765\u5b9e\u73b0\u5bf9\u6a21\u677f\u7684\u63a7\u5236.<\/p>\n

=========================================================================================<\/p>\n

Smarty\u5b9e\u4f8b\u6559\u7a0b \u5b9e\u4f8b\u7bc7\uff08\u4e8c\u3001\u4f7f\u7528phplib\u7684DB\u7c7b\uff09<\/p>\n

\u4e3a\u4ec0\u4e48\u8981\u62ffphplib\u4e2d\u7684DB\u7c7b\u6765\u8bb2\u5462\uff1f\u5f88\u591a\u4eba\u5728\u5b66\u4e60PHP\u65f6\uff0c\u53ef\u80fd\u6700\u5148\u63a5\u89e6\u5230\u7684\u6a21\u677f\u5c31\u662fphplib\u4e86\uff0c\u539f\u56e0\u5f88\u7b80\u5355\uff1a\u5f88\u591aPHP\u5b66\u4e60\u8d44\u6599\u4e2d\u90fd\u4ecb\u7ecdPHPLIB\uff0cphplib\u5728PHP3\u7684\u65f6\u5019\u5f88\u706b\uff0c\u539f\u56e0\u4e4b\u4e00\u5c31\u662f\u5b83\u5b9e\u73b0\u4e86\u5728PHP3\u6ca1\u6709\u5b9e\u73b0\u7684session\u529f\u80fd\uff0c\u76f4\u5230\u73b0\u5728\u8fd8\u6709\u5f88\u591a\u4eba\u4f7f\u7528phplib\u7684\u6a21\u677f\u6280\u672f\uff0c\u539f\u56e0\u5c31\u662f\u5b83\u5f88\u7b80\u5355\u3002\u540c\u65f6\uff0cphplib\u4e0a\u7684\u6570\u636e\u5e93\u64cd\u4f5c\u7c7b\u4e5f\u4ee5\u6587\u4ef6\u5c0f\u3001\u52a0\u8f7d\u901f\u5ea6\u5feb\u800c\u5907\u53d7\u4eba\u4eec\u559c\u7231<\/p>\n

\u3002\u6211\u559c\u6b22\u5b83\u7684\u8bed\u6cd5\uff0c\u611f\u89c9\u5f88\u63a5\u8fd1\u4e8ePHP\u4e2d\u7684mysql\u8bed\u53e5\u3002\u597d\u4e86\uff0c\u5e9f\u8bdd\u4e0d\u591a\u8bf4\u4e86\uff0c\u6765\u770b\u6211\u4eec\u7684\u7a0b\u5e8f\u3002\u7a0b\u5e8f\u8fd8\u4ee5\u5b9e\u4f8b\u4e00\u4e2d\u7684\u90a3\u4e2a\u7ad9\u70b9\u4e00\u8bb2\uff0c\u5173\u4e8e\u6570\u636e\u5e93\u7684\u5efa\u7acb\u4e0e\u6a21\u677f\u7684\u5efa\u7acb\u8fd9\u91cc\u5c31\u4e0d\u591a\u8bb2\u4e86\uff0c\u8bf7\u53c2\u770b\u4e0a\u4e00\u8282\u7684\u4ecb\u7ecd\uff0c\u8fd9\u91cc\u4e3b\u8981\u6765\u4ecb\u7ecd\u4e00\u4e0b\u5728\u7a0b\u5e8f\u4e2d\u65b0\u52a0\u5165\u7684\u4e1c\u897f\u3002\u5148\u6765\u770b\u76ee\u5f55\u8868\uff1a
+Web (\u7ad9\u70b9\u6839\u76ee\u5f55)
|
|—-+comm (Smarty\u76f8\u5173\u6587\u6863\u76ee\u5f55)
| |
| |—-+plugins (Smarty\u63d2\u4ef6\u76ee\u5f55)
| |—–Config_File.class.php (Smarty\u914d\u7f6e\u6587\u4ef6)
| |—–Smarty.class.php (Smarty\u7c7b\u4e3b\u6587\u4ef6)
| |—–Smarty_Compiler.class.php (Smarty\u7f16\u8bd1\u7c7b\u6587\u4ef6)
| |—–db_mysql.inc.php (phplib\u4e2d\u7684DB\u7c7b)
| |—–csub.inc.php (\u4e00\u4e2a\u622a\u53d6\u4e2d\u6587\u7684\u51fd\u6570)
|
|—-+cache (Smarty\u7f13\u5b58\u76ee\u5f55\uff0c*nix\u4e0b\u4fdd\u8bc1\u8bfb\u5199\u6743\u9650)
|
|—-+templates (\u7ad9\u70b9\u6a21\u677f\u6587\u4ef6\u5b58\u653e\u76ee\u5f55)
| |
| |—-header.tpl(\u9875\u9762\u9875\u5934\u6a21\u677f\u6587\u4ef6)
| |—-index.tpl(\u7ad9\u70b9\u9996\u9875\u6a21\u677f\u6587\u4ef6)
| |—-foot.tpl(\u9875\u9762\u9875\u811a\u6a21\u677f\u6587\u4ef6)
| |—-news.tpl (\u65b0\u95fb\u9875\u6a21\u677f\u6587\u4ef6)
|
|
|—-+templates_c (\u6a21\u677f\u6587\u4ef6\u7f16\u8bd1\u540e\u5b58\u653e\u76ee\u5f55\uff0c*nix\u4e0b\u4fdd\u8bc1\u8bfb\u5199\u6743\u9650)
|
|—-+css (\u7ad9\u70b9CSS\u6587\u4ef6\u76ee\u5f55)
|
|—-+image (\u7ad9\u70b9\u56fe\u7247\u76ee\u5f55)
|
|—-+media (\u7ad9\u70b9Flash\u52a8\u753b\u5b58\u653e\u76ee\u5f55)
|
|—-indexbak.htm (\u9996\u9875\u539f\u59cb\u6548\u679c\u56fe)
|
|—-newsbak,htm (\u65b0\u95fb\u9875\u539f\u59cb\u6548\u679c\u56fe)
|
|—-index.php (Smarty\u9996\u9875\u7a0b\u5e8f\u6587\u4ef6)
|
|—-news.php (Smarty\u65b0\u95fb\u663e\u793a\u6587\u4ef6)
|
|—-\u4f8b\u7a0b\u8bf4\u660e.txt (\u672c\u6587\u6863)<\/p>\n

\u8fd9\u91cc\u4e3b\u8981\u5728\/comm\/\u76ee\u5f55\u591a\u51fa\u4e24\u4e2a\u6587\u4ef6\uff0c\u4e00\u4e2a\u662fdb_mysql.inc.php,\u5728phplib\u4e2d\u5b83\u7684\u6587\u4ef6\u540d\u53ebdb_mysql.inc,inc\u6587\u4ef6\u5728\u9ed8\u8ba4\u60c5\u51b5\u4e0b\u76f4\u63a5\u4ece\u6d4f\u89c8\u5668\u4e2d\u5b9a\u4f4d\u65f6\u4f1a\u663e\u793a\u5728\u6d4f\u89c8\u5668\u4e2d\uff0c\u6240\u4ee5\u4e3a\u4e86\u5b89\u5168\u6211\u4eec\u5c06\u5b83\u7684\u6269\u5c55\u540d\u6539\u4e3adb_mysql.inc.php; \u7b2c\u4e8c\u4e2a\u6587\u4ef6\u662f\u4e00\u4e2a\u5305\u542b\u622a\u53d6\u4e2d\u6587\u5b57\u7b26\u7684\u4e00\u4e2a\u51fd\u6570<\/p>\n

csubstr(),\u5728\u7528\u7684\u65f6\u5019\u6211\u4eec\u5c06\u5b83\u7684\u6e90\u7801\u663e\u793a\u51fa\u6765\u3002
\u8fd9\u91cc\u5148\u5c06db_mysql.inc.php\u4e2d\u5b9a\u4e49\u7684DB_Sql\u7684\u4e3b\u8981\u6210\u5458\u53d8\u91cf\u4e0e\u6210\u5458\u51fd\u6570\u7ed9\u5927\u5bb6\u7b80\u5355\u4ecb\u7ecd\u4e00\u4e0b\uff1a
\u4e00\u3001\u6210\u5458\u53d8\u91cf\uff1a
1. $Host: \u4e3b\u673a\u540d
2. $Database: \u6570\u636e\u5e93\u540d\u79f0
3. $User:\u7528\u6237\u540d
4. $Password:\u5bc6\u7801
\u4e8c\u3001\u6210\u5458\u51fd\u6570\uff1a
1. connect($Database=””, $Host=””, $User=””, $Password=””): \u5efa\u7acb\u8fde\u63a5\uff0c\u8fd4\u56de\u8fde\u63a5ID
2. query($Query_String):\u8fdb\u884c\u67e5\u8be2\uff0c\u8fd4\u56de\u67e5\u8be2ID
3. free(): \u91ca\u653e\u5f53\u524d\u67e5\u8be2ID\u8d44\u6e90
4. next_record(): \u8fd4\u56de\u4e0b\u4e00\u6761\u8fd4\u56de\u96c6
5. num_rows(): \u5f53\u524d\u67e5\u8be2\u53f7\u4e2d\u7684\u6570\u636e\u884c\u6570
6. f($name): \u5f53\u524d\u5b57\u6bb5\u7684\u503c<\/p>\n

\u5176\u5b83\u7684\u51fd\u6570\u5728\u6211\u4eec\u7684\u7a0b\u5e8f\u4e2d\u57fa\u672c\u7528\u4e0d\u5230\uff0c\u6240\u4ee5\u5c31\u4e0d\u4ecb\u7ecd\u4e86\uff0c\u611f\u5174\u8da3\u7684\u8bfb\u8005\u53ef\u4ee5\u81ea\u5df1\u67e5\u770b\u76f8\u5173\u8d44\u6599\u3002<\/p>\n

PHP\u4ee3\u7801:——————————————————————————–<\/p>\n

templates\u4e2d\u7684index.tpl\u4e0enews.tpl\u4e0e\u4e0a\u4e00\u8282\u7684\u76f8\u5f53\uff0c\u4e0d\u540c\u7684\u53ea\u662f\u5728index.php\u4e0enews.tpl\u4e2d\uff0c\u5148\u6765\u770b\u770bindex.php:<\/p>\n

===============================
index.php
===============================

<?php
\/*********************************************
*
* \u6587\u4ef6\u540d\uff1a index.php
* \u4f5c \u7528\uff1a \u663e\u793a\u5b9e\u4f8b\u7a0b\u5e8f
*
*********************************************\/
include_once(\".\/comm\/Smarty.class.php\"); \/\/\u5305\u542bsmarty\u7c7b\u6587\u4ef6
1. \/\/=======================================
include_once(\".\/comm\/db_mysql.inc.php\"); \/\/\u5305\u542b\u6570\u636e\u5e93\u64cd\u4f5c\u7c7b
include_once(\".\/comm\/csubstr.inc\"); \/\/\u5305\u542b\u4e2d\u6587\u622a\u53d6\u7c7b
\/\/=======================================
define(\"NUM\", 5); \/\/\u5b9a\u4e49\u6bcf\u6b21\u663e\u793a\u7684\u65b0\u95fb\u6761\u6570<\/p>\n

$smarty = new Smarty(); \/\/\u5efa\u7acbsmarty\u5b9e\u4f8b\u5bf9\u8c61$smarty
$smarty->templates_dir = \".\/templates\"; \/\/\u8bbe\u7f6e\u6a21\u677f\u76ee\u5f55
$smarty->compile_dir =\".\/templates_c\"; \/\/\u8bbe\u7f6e\u7f16\u8bd1\u76ee\u5f55
$smarty->cache_dir = \".\/cache\"; \/\/\u8bbe\u7f6e\u7f13\u5b58\u76ee\u5f55
$smarty->caching = false; \/\/\u8fd9\u91cc\u662f\u8c03\u8bd5\u65f6\u8bbe\u4e3afalse,\u53d1\u5e03\u65f6\u8bf7\u4f7f\u7528true
$smarty->left_delimiter = \"<{\"; \/\/\u8bbe\u7f6e\u5de6\u8fb9\u754c\u7b26
$smarty->right_delimiter = \"}>\"; \/\/\u8bbe\u7f6e\u53f3\u8fb9\u754c\u7b26<\/p>\n

2. $db = new DB_Sql(); \/\/\u5b9e\u4f8b\u5316\u4e00\u4e2aDB\u7c7b
$db->Host = \"localhost\"; \/\/ \u6570\u636e\u5e93\u4e3b\u673a\u540d
$db->Database = \"news\"; \/\/\u6570\u636e\u5e93\u540d\u79f0
$db->User = \"root\"; \/\/\u7528\u6237\u540d
$db->Password = \"\"; \/\/\u5bc6\u7801<\/p>\n

$db->connet(); \/\/\u8fdb\u884c\u6570\u636e\u5e93\u8fde\u63a5<\/p>\n

\/\/\u8fd9\u91cc\u5c06\u5904\u7406\u56fd\u5185\u65b0\u95fb\u90e8\u5206
$strQuery = \"Select iNewsID, iNewsTitle FROM tb_news_CH orDER BY iNewsID DESC\";
3. $db->query($strQuery);
$i = NUM;
4. while($db->next_record() && $i > 0)
{
5. $array[] = array(\"NewsID\", csubstr($db->f(\"iNewsID\"), 0, 20),
\"NewsTitle\", csubstr($db->f(\"vcNewsTitle\"), 0, 20));<\/p>\n

$i--;
}
$smarty->assign(\"News_CH\", $array);
unset($array);
6. $db->free();<\/p>\n

\/\/\u8fd9\u91cc\u5904\u7406\u56fd\u9645\u65b0\u95fb\u90e8\u5206
$strQuery = \"Select iNewsID, iNewsTitle FROM tb_news_IN orDER BY iNewsID DESC\";
$db->query($strQuery);
$i = NUM;
while($db->next_record() && $i > 0)
{
$array[] = array(\"NewsID\", csubstr($db->f(\"iNewsID\"), 0, 20),
\"NewsTitle\", csubstr($db->f(\"vcNewsTitle\"), 0, 20));<\/p>\n

$i--;
}
$smarty->assign(\"News_IN\", $array);
unset($array);
$db->free();<\/p>\n

\/\/\u8fd9\u91cc\u5c06\u5904\u7406\u5a31\u4e50\u65b0\u95fb\u90e8\u5206
$strQuery = \"Select iNewsID, iNewsTitle FROM tb_news_MU orDER BY iNewsID DESC\";
$db->query($strQuery);
$i = NUM;
while($db->next_record() && $i > 0)
{
$array[] = array(\"NewsID\", csubstr($db->f(\"iNewsID\"), 0, 20),
\"NewsTitle\", csubstr($db->f(\"vcNewsTitle\"), 0, 20));<\/p>\n

$i--;
}
$smarty->assign(\"News_MU\", $array);
unset($array);
$db->free();<\/p>\n

\/\/\u7f16\u8bd1\u5e76\u663e\u793a\u4f4d\u4e8e.\/templates\u4e0b\u7684index.tpl\u6a21\u677f
$smarty->display(\"index.tpl\");
?>
<\/code><\/p>\n

\u8001\u89c4\u77e9\uff0c\u5bf9\u4e8e\u5173\u952e\u7684\u5730\u65b9\u6211\u52a0\u4e86\u6807\u53f7\uff0c\u6765\u770b\u8fd9\u4e9b\u5730\u65b9\uff1a
1. \u8fd9\u91cc\u662f\u5c06DB_Sql\u7c7b\u6587\u4ef6\u5305\u542b\u8fdb\u6765\uff0c\u4e0b\u9762\u4e00\u884c\u662f\u5c06\u4e00\u4e2a\u4e2d\u6587\u622a\u53d6\u7c7b\u5305\u542b\u5230\u5f53\u524d\u9875
2. \u5b9e\u4f8b\u5316\u4e00\u4e2a\u7c7b\uff0c\u5e76\u8bbe\u7f6e\u7c7b\u7684Host, Database, User, Password\u5c5e\u6027, \u6700\u540econnect\u6570\u636e\u5e93
3. \u8c03\u7528$db->query($strQuery)\u8fdb\u884c\u4e00\u6b21\u6570\u636e\u67e5\u8be2
4. $db->next_record()\u8bfb\u53d6\u6570\u636e\u5e93\u67e5\u8be2\u8fd4\u56de\u503c\u7684\u4e0b\u4e00\u884c\uff08\u6ce8\uff1a\u8c03\u7528query()\u8fd4\u56de\u6570\u636e\u96c6\u7684\u7b2c\u4e00\u6761\u8bb0\u5f55\u7684\u524d\u4e00\u4e2a\u8bb0\u5f55\uff09
5. csubstr()\u662f\u6211\u4eec\u4f7f\u7528\u7684\u4e00\u4e2a\u4e2d\u6587\u622a\u53d6\u7c7b\uff0c\u7c7b\u7684\u6e90\u6587\u4ef6\u5982\u4e0b\uff1a
=====================================================
csubstr.inc.php
=====================================================<\/p>\n

6.$db->free(): \u91ca\u653e\u5f53\u524d\u7684\u67e5\u8be2\u8fd4\u56de\u8d44\u6e90<\/p>\n

\u597d\u4e86\uff0c\u4f7f\u7528\u7c7b\u8fdb\u884c\u6570\u636e\u5e93\u64cd\u4f5c\uff0c\u53ef\u4ee5\u6781\u5927\u7a0b\u5e8f\u4e0a\u63d0\u9ad8\u7a0b\u5e8f\u7684\u53ef\u8bfb\u6027\uff0c\u540c\u65f6\u4e5f\u65b9\u4fbf\u4e86\u5bf9\u6570\u636e\u5e93\u7684\u64cd\u4f5c\u3002
\u63a5\u4e0b\u6765\u6211\u4eec\u518d\u770b\u770bnews.php:
=================================================
news.php
=================================================

<?php
\/*********************************************
*
* \u6587\u4ef6\u540d\uff1a news.php
* \u4f5c \u7528\uff1a \u65b0\u95fb\u663e\u793a\u7a0b\u5e8f
*
*********************************************\/
include_once(\".\/comm\/Smarty.class.php\"); \/\/\u5305\u542bsmarty\u7c7b\u6587\u4ef6
\/\/=======================================
include_once(\".\/comm\/db_mysql.inc.php\"); \/\/\u5305\u542b\u6570\u636e\u5e93\u64cd\u4f5c\u7c7b
include_once(\".\/comm\/csubstr.inc\"); \/\/\u5305\u542b\u4e2d\u6587\u622a\u53d6\u7c7b
\/\/=======================================
define(\"NUM\", 5); \/\/\u5b9a\u4e49\u6bcf\u6b21\u663e\u793a\u7684\u65b0\u95fb\u6761\u6570<\/p>\n

$smarty = new Smarty(); \/\/\u5efa\u7acbsmarty\u5b9e\u4f8b\u5bf9\u8c61$smarty
$smarty->templates_dir = \".\/templates\"; \/\/\u8bbe\u7f6e\u6a21\u677f\u76ee\u5f55
$smarty->compile_dir =\".\/templates_c\"; \/\/\u8bbe\u7f6e\u7f16\u8bd1\u76ee\u5f55
$smarty->cache_dir = \".\/cache\"; \/\/\u8bbe\u7f6e\u7f13\u5b58\u76ee\u5f55
$smarty->cache_lifetime = 60 * 60 * 24; \/\/\u8bbe\u7f6e\u7f13\u5b58\u65f6\u95f4
$smarty->caching = false; \/\/\u8fd9\u91cc\u662f\u8c03\u8bd5\u65f6\u8bbe\u4e3afalse,\u53d1\u5e03\u65f6\u8bf7\u4f7f\u7528true
$smarty->left_delimiter = \"<{\"; \/\/\u8bbe\u7f6e\u5de6\u8fb9\u754c\u7b26
$smarty->right_delimiter = \"}>\"; \/\/\u8bbe\u7f6e\u53f3\u8fb9\u754c\u7b26<\/p>\n

$db = new DB_Sql(); \/\/\u5b9e\u4f8b\u5316\u4e00\u4e2aDB\u7c7b
$db->Host = \"localhost\"; \/\/ \u6570\u636e\u5e93\u4e3b\u673a\u540d
$db->Database = \"news\"; \/\/\u6570\u636e\u5e93\u540d\u79f0
$db->User = \"root\"; \/\/\u7528\u6237\u540d
$db->Password = \"\"; \/\/\u5bc6\u7801<\/p>\n

$db->connet(); \/\/\u8fdb\u884c\u6570\u636e\u5e93\u8fde\u63a5<\/p>\n

$NewsID = $_GET[\"id\"]; \/\/\u83b7\u53d6\u65b0\u95fb\u7f16\u53f7
$NewsType = $_GET[\"type\"]; \/\/\u8981\u663e\u793a\u7684\u65b0\u95fb\u7c7b\u578b
switch($NewsType)
{
case 1:
$dbName = \"tb_news_ch\";
break;
case 2:
$dbName = \"tb_news_in\";
break;
case 3:
$dbName = \"tb_news_mu\";
break;
}<\/p>\n

$strQuery = \"Select vcNewsTitle, ltNewsContent FROM \" . $dbName;
1. $db->query($strQuery);
2. if($db->next_record())
{
$smarty->assign(\"NewsTitle\", $db->f(\"vcNewsTitle\"));
$smarty->assign(\"NewsContent\", $db->f(\"ltNewsContent\"));<\/p>\n

$db->free();
$smarty->display(\"news.tpl\");
}else
{
echo \"\u6ca1\u6709\u65b0\u95fb\u5185\u5bb9\";
}<\/p>\n

?><\/p>\n

<\/code><\/p>\n

\u5927\u5bb6\u53ef\u4ee5\u770b\u770b1, 2\u4e24\u5904\uff0c\u662f\u4e0d\u662f\u6bd4\u539f\u6765\u76f4\u63a5\u4f7f\u7528mysql\u51fd\u6570\u8981\u7b80\u5355\u4e00\u4e9b\uff1f
\u591a\u4f59\u7684\u8bdd\u5c31\u4e0d\u591a\u8bf4\u4e86\uff0c\u5982\u679c\u5927\u5bb6\u8ba4\u771f\u7684\u770b\u8fc7\u4e0a\u4e00\u7bc7\u5b9e\u4f8b\uff0c\u90a3\u4e48\u8fd9\u4e00\u7bc7\u5e94\u8be5\u975e\u5e38\u597d\u7406\u89e3\u7684\u3002<\/p>\n

======================
\u540e\u8bb0:
\u6a21\u677f\u90e8\u5206\u6211\u57fa\u672c\u662f\u4ee5\u624b\u518c\u4e2d\u7684\u4f8b\u5b50\u6765\u8bb2\u7684,\u628a\u5b83\u5177\u4f53\u5316\u4e86\u4e00\u4e9b,\u5b9e\u9645\u7684\u7cbe\u534e\u5728\u7a0b\u5e8f\u8bbe\u8ba1\u90e8\u5206,\u8981\u5b66\u5b83\u7684\u8bdd\u8981\u770b\u4e24\u4e2a\u4f8b\u7a0b\u5e8f,\u6211\u628a\u4e24\u4e2a\u4f8b\u7a0b\u53ca\u5148\u524d\u63d0\u5230\u7684\u90a3\u4e9b\u793a\u4f8b\u7a0b\u5e8f\u653e\u51653\u4e2a\u6253\u5305\u6587\u4ef6\u4e2d,\u7531 \u201c\u795e\u4ed9\u59d0\u59d0\u201d \u6d4b\u8bd5\u8fc7,\u5927\u5bb6\u53ef\u4ee5\u8fb9\u770b\u8fb9\u8c03\u8bd5.<\/p>\n

=========================================================================================<\/p>\n

Smarty\u5b9e\u4f8b\u6559\u5b66 \u5b9e\u4f8b\u7bc7\uff08\u4e09\u3001\u4f7f\u7528ADODB\u8fde\u63a5\u6570\u636e\u5e93\uff09 <\/p>\n

\u524d\u4e24\u4e2a\u6708\u56e0\u4e3a\u5de5\u4f5c\u4e0a\u7684\u539f\u56e0\u4e00\u76f4\u5f88\u5fd9,\u6240\u4ee5\u6ca1\u6709\u53ca\u65f6\u5b8c\u6210\u8fd9\u4e2a\u6559\u7a0b,\u6b63\u597d\u4eca\u5929\u5468\u516d\u4e0d\u7528\u52a0\u73ed,\u62bd\u4e2a\u7a7a\u5b8c\u6210\u5b83\u5427! \u5728\u5f00\u59cb\u65b0\u7684\u7684\u6559\u7a0b\u7684\u65f6\u5019,\u6211 <\/p>\n

\u5148\u628a\u4ee5\u524d\u7684\u6211\u5199\u7684\u90a3\u4e2a\u6559\u7a0b\u4e2d\u7684\u4e00\u4e9b\u9519\u8bef\u7684\u5730\u65b9\u4fee\u6539\u8fc7\u6765,\u5728\u8fd9\u91cc\u8981\u611f\u8c22 nesta2001zhang\u5144\u5f1f,\u662f\u4ed6\u627e\u51fa\u4e86\u6587\u7ae0\u4e2d\u7684\u4e00\u4e9b\u9519\u8bef,\u5426\u5219\u771f\u7684\u88ab\u522b\u4eba <\/p>\n

\u9a82”\u8bef\u4eba\u5b50\u5f1f\u4e86”(\u8bf4\u6765\u771f\u662f\u60ed\u6127,\u6211\u7684\u521d\u7a3f\u53d1\u5e03\u540e\u540e\u5c31\u53d1\u73b0\u5728\u4e00\u5927\u5806\u7684\u95ee\u9898,\u540e\u6765\u4e00\u4e9b\u65f6\u5019\u53d1\u91cd\u65b0\u4fee\u6539\u540e\u7684\u6587\u4ef6\u4e2d\u5c45\u7136\u4e5f\u51fa\u73b0\u4e86\u9519\u8bef,\u771f\u662f\u4e0d\u5e94 <\/p>\n

\u8be5…)
\u5728\u4e0a\u51e0\u7bc7\u6559\u7a0b\u4e2d\u7684\uff1a

while($db->next_record() && $i > 0)
{
$array[] = array(\"NewsID\", csubstr($db->f(\"iNewsID\"), 0, 20),
\"NewsTitle\", csubstr($db->f(\"vcNewsTitle\"), 0, 20)); <\/p>\n

$i--;
}
<\/code><\/p>\n

\u5e94\u8be5\u66f4\u6539\u4e3a\uff1a

while($db->next_record() && $i > 0)
{
$array[] = array(\"NewsID\" => $db->f(\"iNewsID\"),
\"NewsTitle\" => csubstr($db->f(\"vcNewsTitle\"), 0, 20)); <\/p>\n

$i--;
}
<\/code>
\u4e3a\u4ec0\u4e48\u8fd9\u6837\u6539\u5462?\u56e0\u4e3a\u7b2c\u4e8c\u79cd\u65b9\u6cd5\u66f4\u6e05\u6670\u660e\u4e86\u4e00\u4e9b,\u5b9e\u9645\u4e0a\u7b2c\u4e00\u79cd\u65b9\u5f0f\u6240\u6267\u884c\u7684\u6548\u679c\u4e0e\u7b2c\u4e8c\u79cd\u65b9\u6cd5\u6ca1\u4ec0\u4e48\u5dee\u522b,\u800c\u4e14\u90a3\u51e0\u4e2a\u7a0b\u5e8f\u6211\u90fd\u66fe\u7ecf\u8c03\u8bd5\u8fc7, <\/p>\n

\u6ca1\u6709\u4efb\u4f55\u95ee\u9898.
\u597d\u4e86,\u90a3\u6211\u4eec\u4eca\u5929\u5c31\u5148\u6765\u8bf4\u8bf4ADODB.\u8bf4\u5230ADODB,\u53ef\u80fd\u505a\u8fc7ASP\u7684\u90fd\u77e5\u9053WINDOWS\u5e73\u53f0\u7684ADO\u7ec4\u4ef6,\u4f46\u6211\u4eec\u8fd9\u91cc\u7684ADODB\u4e0d\u662f\u5fae\u8f6f\u7684\u90a3\u4e2a\u6570\u636e\u5e93\u64cd <\/p>\n

\u4f5c\u7ec4\u4ef6,\u800c\u662f\u7531php\u8bed\u8a00\u5199\u7684\u4e00\u5957\u6570\u636e\u5e93\u64cd\u4f5c\u7c7b\u5e93,\u5148\u8ba9\u6211\u4eec\u6765\u770b\u770b\u5b83\u5012\u5e95\u6709\u4ec0\u4e48\u6837\u7684\u4f18\u70b9.
1. \u4ee5\u6807\u51c6\u7684SQL\u8bed\u53e5\u4e66\u5199\u7684\u6570\u636e\u5e93\u6267\u884c\u4ee3\u7801\u5728\u8fdb\u884c\u6570\u636e\u5e93\u79fb\u690d\u65f6\u4e0d\u7528\u66f4\u6539\u6e90\u7a0b\u5e8f,\u4e5f\u5c31\u662f\u8bf4\u5b83\u53ef\u4ee5\u652f\u6301\u591a\u79cd\u6570\u636e\u5e93,\u5305\u62ecACCESS.
2. \u63d0\u4f9b\u4e0e\u5fae\u8f6fADODB\u76f8\u4f3c\u7684\u8bed\u6cd5\u529f\u80fd.\u8fd9\u4e00\u70b9\u5bf9\u4e8e\u4eceASP\u8f6c\u884c\u5230PHP\u7684\u4eba\u4eec\u662f\u4e00\u5927\u798f\u97f3,\u5b83\u7684\u5f88\u591a\u64cd\u4f5c\u90fd\u4e0eWINDOWS\u4e2d\u7684ADODB\u76f8\u4f3c.
3. \u53ef\u4ee5\u751f\u6210Smarty\u5faa\u73af\u9700\u8981\u7684\u4e8c\u7ef4\u6570\u7ec4,\u8fd9\u6837\u4f1a\u7b80\u5316smarty\u5f00\u53d1.\u8fd9\u4e00\u70b9\u662f\u7b49\u4f1a\u6211\u7ed9\u5927\u5bb6\u6f14\u793a.
4. \u652f\u6301\u6570\u636e\u5e93\u7684\u7f13\u5b58\u67e5\u8be2\uff0c\u6700\u5927\u53ef\u80fd\u7684\u63d0\u9ad8\u67e5\u8be2\u6570\u636e\u5e93\u7684\u901f\u5ea6\u3002
5. \u5176\u5b83\u7684\u5b9e\u7528\u529f\u80fd.
\u867d\u7136\u8bf4\u4f18\u70b9\u5f88\u591a,\u4f46\u662f\u7531\u4e8e\u8fd9\u4e2a\u7c7b\u5e93\u975e\u5e38\u7684\u5e9e\u5927,\u5149\u5b83\u7684\u4e3b\u6267\u884c\u7c7b\u5c31107K,\u6240\u4ee5\u5982\u679c\u5927\u5bb6\u8003\u8651\u6267\u884c\u6548\u7387\u7684\u8bdd\u5c31\u8981\u8ba4\u771f\u60f3\u60f3\u4e86.\u4e0d\u8fc7\u8bf4\u5b9e\u8bdd,\u5b83\u7684 <\/p>\n

\u529f\u80fd\u8fd8\u662f\u5f88\u5f3a\u5927\u7684,\u6709\u5f88\u591a\u7684\u5f88\u5b9e\u7528\u7684\u529f\u80fd,\u4f7f\u7528\u5b83\u7684\u8fd9\u4e9b\u529f\u80fd,\u53ef\u4ee5\u975e\u5e38\u65b9\u4fbf\u7684\u5b9e\u73b0\u6211\u4eec\u60f3\u8981\u7684\u529f\u80fd.\u6240\u4ee5\u5bf9\u4e8e\u90a3\u4e9b\u8001\u677f\u6ca1\u6709\u7279\u6b8a\u8981\u6c42\u65f6\u5927\u5bb6\u4e0d <\/p>\n

\u9632\u7528\u7528\u5b83 <\/p>\n

\u4e00\u3001\u5982\u4f55\u5f97\u5230ADODB? \u5b83\u7684\u8fd0\u884c\u73af\u5883\u662f\u4ec0\u4e48\uff1f
\u4ecehttp:\/\/sourceforge.net\/project\/show…<\/a>\u7c06hp4.0.5\u4ee5\u4e0a\u3002
\u4e8c\u3001\u5982\u4f55\u5b89\u88c5ADODB?
\u89e3\u538b\u4e0b\u8f7d\u56de\u7684\u538b\u7f29\u6587\u4ef6\uff0c\u6ce8\u610f\uff1a\u5927\u5bb6\u4e0b\u8f7d\u56de\u6765\u7684\u683c\u5f0f\u4e3aADODB.tar.gz\uff0c\u8fd9\u662flinux\u7684\u538b\u7f29\u683c\u5f0f\uff0c\u5728windows\u4e0b\u5927\u5bb6\u53ef\u4ee5\u4f7f\u7528winrar\u5bf9\u5176\u8fdb <\/p>\n

\u884c\u89e3\u538b\uff0c\u89e3\u538b\u5b8c\u6210\u540e\u5c06\u76ee\u5f55\u62f7\u8d1d\u5230\u6307\u5b9a\u7684\u76ee\u5f55\u7684adodb\u76ee\u5f55\u4e0b\uff0c\u50cf\u6211\u5728\u4f8b\u5b50\u4e2d\u5c06\u5b83\u62f7\u8d1d\u5230\u4e86\/comm\/adodb\/\u4e2d\u3002
\u4e09\u3001\u5982\u4f55\u8c03\u7528ADODB?
\u4f7f\u7528include_once (“.\/comm\/adodb\/adodb.inc.php”);\u8fd9\u884c\u5c31\u4e0d\u7528\u8bf4\u4e86\u5427\uff1f\u5305\u542bADODB\u7684\u4e3b\u6587\u4ef6\u3002
\u56db\u3001\u5982\u4f55\u4f7f\u7528ADODB?
1.\u8fdb\u884c\u521d\u59cb\u5316\uff1a
ADODB\u91c7\u7528$conn = ADONewConnection();\u8fd9\u6837\u7684\u8bed\u53e5\u8fdb\u884c\u521d\u59cb\u5316,\u5bf9ADODB\u8fdb\u884c\u521d\u59cb\u5316\u6709\u4e24\u79cd\u65b9\u5f0f\uff1a
\u7b2c\u4e00\u79cd\u65b9\u5f0f\u4e3a\uff1a\u4f20\u7edf\u65b9\u5f0f\u3002\u6211\u6682\u65f6\u79f0\u5b83\u4e3a\u8fd9\u4e2a\u540d\u79f0\u3002\u5b83\u4f7f\u7528\u7684\u5efa\u7acb\u4e00\u4e2a\u65b0\u8fde\u63a5\u7684\u65b9\u5f0f\u5f88\u50cfphp\u4e2d\u7684\u6807\u51c6\u8fde\u63a5\u65b9\u5f0f\uff1a
$conn = new ADONewConnection($dbDriver);
$conn->Connect($host, $user, $passwd, $db);
\u7b80\u5355\u5427\uff1f\u5982\u679c\u4f7f\u7528\u8fc7phplib\u4e2d\u7684db\u7c7b\u5e94\u8be5\u5bf9\u5b83\u5f88\u719f\u6089\u7684\u3002 <\/p>\n

\u7b2c\u4e8c\u79cd\u65b9\u5f0f\uff1a\u91c7\u7528dsn\u65b9\u5f0f\uff0c\u8fd9\u6837\u662f\u5c06\u6570\u636e\u5e93\u7684\u8fde\u63a5\u8bed\u53e5\u5199\u6210\u4e00\u6761\u8bed\u53e5\u6765\u8fdb\u884c\u521d\u59cb\u5316\uff0cdsn\u7684\u5199\u6cd5\u6709\u4e3a\uff1a$dsn = <\/p>\n

“DBType:\/\/User:Passwd@Host\/DBName”; \u5176\u4e2dDBType\u8868\u793a\u6570\u636e\u5e93\u7c7b\u578b\uff0cUser\u8868\u793a\u7528\u6237\u540d\uff0cPasswd\u4e3a\u5bc6\u7801\uff0cHost\u4e3a\u670d\u52a1\u5668\u540d\uff0cDBName\u4e3a\u6570\u636e\u5e93\u540d <\/p>\n

\uff0c\u50cf\u8fd9\u6837\u6211\u4f7f\u7528oracle\u6570\u636e\u5e93\uff0c\u7528\u6237\u540d\uff1aoracleUser,\u5bc6\u7801\u4e3aoraclePasswd,\u6570\u636e\u5e93\u670d\u52a1\u5668\u4e3alocalhost, \u6570\u636e\u5e93\u4e3aoradb\u7684dsn\u8fd9\u6837\u5199\uff1a
$dsn = “oracle:\/\/oracleUserraclePasswd@localhost\/oradb”;
$conn = new ADONewConnection($dsn);
\u8fd9\u79cd\u65b9\u5f0f\u53ef\u80fd\u4eceASP\u8f6c\u884c\u6765\u7684\u7a0b\u5e8f\u5458\u4f1a\u66f4\u611f\u5174\u8da3\u3002 <\/p>\n

\u8fd9\u4e24\u79cd\u65b9\u5f0f\u90fd\u53ef\u4ee5\u4f7f\u7528\uff0c\u8981\u770b\u4e2a\u4eba\u4e60\u60ef\u6765\u9009\u7528\u4e86. <\/p>\n

2. \u76f8\u5173\u7684\u6982\u5ff5\uff1a
\u4f7f\u7528ADODB\u6709\u4e24\u4e2a\u57fa\u672c\u7684\u7c7b\uff0c\u4e00\u662f\u662fADOConnection\u7c7b\uff0c\u53e6\u4e00\u4e2a\u662fADORecordSet\u7c7b\uff0c\u4f7f\u7528\u8fc7ASP\u7684\u4eba\u770b\u5230\u8fd9\u4e24\u4e2a\u7c7b\u4f1a\u660e\u767d\u5b83\u7684\u542b\u4e49\uff0c <\/p>\n

ADOConnection\u6307\u7684\u662f\u6570\u636e\u5e93\u8fde\u63a5\u7684\u7c7b\uff0c\u800cADORecordSet\u6307\u7684\u662f\u7531ADOConnection\u6267\u884c\u67e5\u8be2\u8bed\u53e5\u8fd4\u56de\u7684\u6570\u636e\u96c6\u7c7b\uff0c\u76f8\u5173\u7684\u8d44\u6599\u5927\u5bb6\u53ef\u4ee5\u67e5\u8be2ADODB <\/p>\n

\u7c7b\u7684\u624b\u518c\u3002 <\/p>\n

3.\u57fa\u672c\u7684\u51fd\u6570\uff1a <\/p>\n

\u5173\u4e8eADOConnection\u7c7b\u7684\u76f8\u5173\u65b9\u6cd5\u6709\uff1a
1.Connect\uff1a\u6570\u636e\u5e93\u8fde\u63a5\u65b9\u6cd5\uff0c\u4e0a\u8fb9\u6211\u4eec\u4ecb\u7ecd\u8fc7\u7684\u3002\u5bf9\u4e8emysql\u8fd8\u6709PConnect\uff0c\u4e0ePHP\u8bed\u8a00\u4e2d\u7684\u7528\u6cd5\u4e00\u6837
2.Execute($sql):\u6267\u884c\u67e5\u8be2\u8bed\u53e5\u7ed3\u679c\u8fd4\u56de\u4e00\u4e2aADORecordSet\u7c7b\u3002
3.GetOne($sql):\u8fd4\u56de\u7b2c\u4e00\u884c\u7684\u7b2c\u4e00\u4e2a\u5b57\u6bb5
4.GetAll($sql):\u8fd4\u56de\u6240\u6709\u7684\u6570\u636e\u3002\u8fd9\u4e2a\u51fd\u6570\u53ef\u662f\u5927\u6709\u7528\u5904\uff0c\u8bb0\u5f97\u4e0d\u8bb0\u7684\u6211\u5728\u4ee5\u524d\u7684\u6559\u7a0b\u4e2d\u5199\u5173\u4e8e\u65b0\u95fb\u5217\u8868\u7684\u8f93\u5165\u65f6\u8981\u5c06\u9700\u8981\u5728\u9875\u9762\u663e\u793a\u7684 <\/p>\n

\u65b0\u95fb\u5217\u8868\u505a\u6210\u4e00\u4e2a\u4e8c\u7ef4\u6570\u7ec4\uff1f\u5c31\u662f\u8fd9\u6837\u7684\u8bed\u53e5\uff1a
=====================================================================================
while($db->next_record())
{
$array[] = array(“NewsID” => $db->f(“iNewsID”),
“NewsTitle” => csubstr($db->f(“vcNewsTitle”), 0, 20));
}
=====================================================================================
\u8fd9\u4e00\u884c\u662f\u4ec0\u4e48\u610f\u601d\u5462\uff1f\u5c31\u662f\u5c06\u8981\u663e\u793a\u7684\u65b0\u95fb\u4f8b\u8868\u751f\u6210
$array[0] = array(“NewsID”=>1, “NewsTitle”=>”\u8fd9\u91cc\u65b0\u95fb\u7684\u7b2c\u4e00\u6761”);
$array[1] = array(“NewsID”=>2, “NewsTitle”=>”\u8fd9\u91cc\u65b0\u95fb\u7684\u7b2c\u4e8c\u6761”);
…
\u8fd9\u6837\u7684\u5f62\u5f0f\uff0c\u4f46\u5982\u679c\u6211\u4eec\u4e0d\u9700\u8981\u5bf9\u6807\u9898\u8fdb\u884c\u63a7\u5236\uff0c\u5728ADODB\u4e2d\u6211\u4eec\u5c31\u6709\u798f\u4e86\uff0c\u6211\u4eec\u53ef\u4ee5\u8fd9\u6837\u5199\uff1a
==================================================================================
$strQuery = “select iNews, vcNewsTitle from tb_news_ch”;
$array = &$conn->GetAll($strQuery);\/\/\u6ce8\u610f\u8fd9\u6761\u8bed\u53e5
$smarty->assign(“News_CH”, $array);
unset($array);
==================================================================================
\u5f53\u7136\uff0c\u8fd9\u91cc\u7684$conn\u5e94\u8be5\u8fdb\u884c\u521d\u59cb\u5316\u8fc7\u4e86\uff0c\u4e0d\u77e5\u5927\u5bb6\u770b\u660e\u767d\u4e86\u6ca1\u6709\uff1f\u539f\u6765\u6211\u8981\u624b\u5de5\u521b\u5efa\u7684\u4e8c\u7ef4\u6570\u636e\u5728\u8fd9\u91cc\u76f4\u63a5\u4f7f\u7528GetAll\u5c31\u884c\u4e86\uff01\uff01\uff01\u8fd9\u4e5f\u662f\u4e3a <\/p>\n

\u4ec0\u4e48\u6709\u4eba\u4f1a\u8bf4ADODB+Smarty\u662f\u65e0\u654c\u7ec4\u5408\u7684\u539f\u56e0\u4e4b\u4e00\u4e86…
4.SelectLimit($sql, $numrows=-1, $offset=-1, $inputarrr=false): \u8fd4\u56de\u4e00\u4e2a\u6570\u636e\u96c6\uff0c\u5927\u5bb6\u4ece\u8bed\u53e5\u4e0a\u4e5f\u4e0d\u96be\u770b\u51fa\u5b83\u662f\u4e00\u6761\u9650\u91cf\u67e5\u8be2\u8bed <\/p>\n

\u53e5\uff0c\u4e0emysql\u8bed\u53e5\u4e2d\u7684limit \u6709\u5f02\u66f2\u540c\u5de5\u4e4b\u6548\uff0c\u6765\u4e00\u4e2a\u7b80\u5355\u7684\u4f8b\u5b50\uff1a
$rs = $conn->SelectLimit(“select iNewsID, vcNewsTitle from tb_news_CH”, 5, 1);
\u770b\u660e\u767d\u4e86\u5417\uff1f$rs\u4e2d\u4fdd\u5b58\u7684\u662f\u6570\u636e\u5e93\u4e2d\u4ece\u7b2c\u4e00\u8bb0\u5f55\u5f00\u59cb\u76845\u6761\u8bb0\u5f55\u3002\u6211\u4eec\u77e5\u9053\uff0c\u5728oracle\u6570\u636e\u5e93\u4e0d\u652f\u6301\u5728SQL\u8bed\u53e5\u4e2d\u4f7f\u7528limit\uff0c\u4f46\u662f\u6211\u4eec\u5982\u679c\u4f7f <\/p>\n

\u7528ADODB\u7684\u8bdd\uff0c\u90a3\u8fd9\u4e2a\u95ee\u9898\u5c31\u5bb9\u6613\u89e3\u51b3\u591a\u4e86\uff01
5.Close():\u5173\u95ed\u6570\u636e\u5e93\uff0c\u867d\u7136\u8bf4PHP\u5728\u9875\u9762\u7ed3\u675f\u65f6\u4f1a\u81ea\u52a8\u5173\u95ed\uff0c\u4f46\u4e3a\u4e86\u7a0b\u5e8f\u7684\u5b8c\u6574\u5927\u5bb6\u8fd8\u662f\u8981\u5728\u9875\u9762\u7ed3\u675f\u8fdb\u884c\u6570\u636e\u5e93\u7684\u5173\u95ed\u3002 <\/p>\n

\u5173\u4e8eADORecordSet.ADORecordSet\u4e3a$conn->Execute($sql)\u8fd4\u56de\u7684\u7ed3\u679c,\u5b83\u7684\u57fa\u672c\u51fd\u6570\u5982\u4e0b:
1. Fields($colname):\u8fd4\u56de\u5b57\u6bb5\u7684\u503c.
2. RecordCount():\u6240\u5305\u542b\u7684\u8bb0\u5f55\u6570.\u8fd9\u4e2a\u8bb0\u5f55\u786e\u5b9a\u6570\u636e\u96c6\u7684\u8bb0\u5f55\u603b\u6570.
3. GetMenu($name, [$default_str=”], [$blank1stItem=true], [$multiple_select=false], [$size=0], [$moreAttr=”])\u975e\u5e38\u597d\u7684\u4e00 <\/p>\n

\u4e2a\u51fd\u6570,\u4f7f\u7528\u5b83\u53ef\u4ee5\u8fd4\u56de\u4e00\u4e2aname=$name\u7684\u4e0b\u62c9\u83dc\u5355(\u6216\u591a\u9009\u6846)!!!\u5f53\u7136,\u5b83\u662f\u4e00\u4e2aHTML\u7684\u5b57\u7b26\u4e32,\u8fd9\u662f\u4e00\u4e2a\u4ee4\u4eba\u6fc0\u52a8\u7684\u597d\u4e1c\u897f,$name\u6307\u7684\u662f <\/p>\n

option\u7684name\u5c5e\u6027,$default_str\u662f\u9ed8\u8ba4\u9009\u4e2d\u7684\u5b57\u4e32,$blank1stItem\u6307\u51fa\u7b2c\u4e00\u9879\u662f\u5426\u4e3a\u7a7a,$multiple_select\u6307\u51fa\u662f\u5426\u4e3a\u591a\u9009\u6846,\u800c\u6211\u4eec\u5f97\u5230\u8fd9\u4e2a <\/p>\n

\u5b57\u4e32\u540e\u5c31\u53ef\u4ee5\u4f7f\u7528$smarty->(“TemplateVar”, “GetMenuStr”)\u6765\u5728\u6a21\u677f\u7684”TemplateVar” \u5904\u8f93\u5165\u4e00\u4e2a\u4e0b\u62c9\u5217\u8868(\u6216\u662f\u591a\u5148\u6846)
4. MoveNext():\u6765\u770b\u4e00\u6bb5\u4ee3\u7801:

$rs = &$conn->Exceute($sql);
if($rs)
{
while($rs->EOF)
{
$array[] = array(\"NewsID\" => $rs->fields[\"iNewsID\"],
\"NewsTitle\" => csubstr($rs->fields[\"vcNewsTitle\"]), 0, 20); <\/p>\n

$rs->MoveNext();
}
}
<\/code>
\u660e\u767d\u4e86\u5417?\u5f88\u50cfMS ADODB\u4e2d\u7684\u90a3\u4e00\u5957\u561b!
5. MoveFirst(),MoveLast(), Move($to):\u4e00\u6837\u7684,\u770b\u51fd\u6570\u540d\u5927\u5bb6\u5c31\u53ef\u4ee5\u77e5\u9053\u5b83\u662f\u4ec0\u4e48\u610f\u601d\u4e86.
6. FetchRow():\u8fd4\u56de\u4e00\u884c,\u770b\u4ee3\u7801:

$rs = &$conn->Exceute($sql);
if($rs)
{
while($row = $rs->FetchRow())
{
$array[] = array(\"NewsID\" => $row[\"iNewsID\"],
\"NewsTitle\" => csubstr($row[\"vcNewsTitle\"]), 0, 20);
}
}
<\/code><\/p>\n

\u5b83\u5b9e\u73b0\u4e86\u4e0e4\u4e00\u6837\u7684\u529f\u80fd,\u4f46\u770b\u8d77\u6765\u66f4\u7b26\u5408PHP\u7684\u4e60\u60ef,\u800c4\u7684\u4e60\u60ef\u770b\u8d77\u6765\u66f4\u50cf\u662fMS ADODB\u7684\u529e\u6cd5\uff0e <\/p>\n

7.GetArray($num):\u8fd4\u56de\u6570\u636e\u96c6\u4e2d\u7684$num\u884c\u6570\u636e,\u5c06\u5176\u7ec4\u5408\u6210\u4e8c\u7ef4\u6570\u7ec4.\u8fd9\u4e2a\u65b9\u6cd5\u6211\u4eec\u5728\u4f8b\u5b50index.php\u8981\u7528\u5230. <\/p>\n

8. Close():\u540cmysql_free_result($rs);\u6e05\u9664\u5185\u5bb9\u5360\u7528. <\/p>\n

\u597d\u4e86,\u521d\u6b65\u7684\u51fd\u6570\u5c31\u4ecb\u7ecd\u5230\u8fd9\u91cc,\u591f\u6211\u4eec\u7528\u7684\u5566!\u5b9e\u9645\u4e0aADODB\u8fd8\u6709\u5f88\u591a\u5b9e\u7528\u7684\u6280\u672f,\u5305\u62ec\u683c\u5f0f\u5316\u65e5\u671f\u65f6\u95f4,\u683c\u5f0f\u5316\u67e5\u8be2\u8bed\u53e5,\u8f93\u51fa\u8868\u683c,\u66f4\u9ad8\u7ea7 <\/p>\n

\u70b9\u7684Cache\u67e5\u8be2,\u5e26\u53c2\u67e5\u8be2\u7b49\u7b49,\u5927\u5bb6\u53ef\u4ee5\u81ea\u884c\u67e5\u770b\u624b\u518c. <\/p>\n

\u4e0b\u9762\u6211\u4eec\u5f00\u59cb\u5b66\u4e60\u6211\u4eec\u7684\u7a0b\u5e8f,\u540c\u6837\u8fd8\u662f\u90a3\u4e2aWeb\u7a0b\u5e8f,\u6211\u5c06\u5176\u4e2d\u7684comm\u76ee\u5f55\u91cd\u65b0\u7ec4\u7ec7\u4e86\u4e00\u4e0b,\u540c\u65f6\u4e3a\u4e86\u63d0\u9ad8\u6548\u7387\u5bf9Smarty\u91cd\u65b0\u8fdb\u884c\u4e86\u5c01\u88c5 <\/p>\n

,mySmarty.class.php\u662f\u5c01\u88c5\u540e\u7684\u7c7b,\u5b83\u7ee7\u627f\u81eaSmarty,\u6240\u4ee5\u4ee5\u540e\u6240\u6709\u7684\u7a0b\u5e8f\u6587\u4ef6\u4e2d\u53ea\u8c03\u7528\u65b0\u7684\u7c7bMySmarty,\u5148\u6765\u770b\u770b\u76ee\u5f55\u7ed3\u6784:
+Web (\u7ad9\u70b9\u6839\u76ee\u5f55)
|
|—-+comm (Smarty\u76f8\u5173\u6587\u6863\u76ee\u5f55)
| |
| |—-+smarty (Smarty\u539f\u59cb\u6587\u4ef6\u76ee\u5f55)
| |—-+adodb (adodb\u539f\u59cb\u6587\u76ee\u5f55)
| |—–mySmarty.class.php (\u6269\u5c55\u540e\u7684smarty\u6587\u4ef6)
| |—–csubstr.inc (\u622a\u53d6\u4e2d\u6587\u5b57\u7b26)
|
|—-+cache (Smarty\u7f13\u5b58\u76ee\u5f55\uff0c*nix\u4e0b\u4fdd\u8bc1\u8bfb\u5199\u6743\u9650)
|
|—-+templates (\u7ad9\u70b9\u6a21\u677f\u6587\u4ef6\u5b58\u653e\u76ee\u5f55)
| |
| |—-header.tpl(\u9875\u9762\u9875\u5934\u6a21\u677f\u6587\u4ef6)
| |—-index.tpl(\u7ad9\u70b9\u9996\u9875\u6a21\u677f\u6587\u4ef6)
| |—-foot.tpl(\u9875\u9762\u9875\u811a\u6a21\u677f\u6587\u4ef6)
| |—-news.tpl (\u65b0\u95fb\u9875\u6a21\u677f\u6587\u4ef6)
|
|
|—-+templates_c (\u6a21\u677f\u6587\u4ef6\u7f16\u8bd1\u540e\u5b58\u653e\u76ee\u5f55\uff0c*nix\u4e0b\u4fdd\u8bc1\u8bfb\u5199\u6743\u9650)
|
|—-+css (\u7ad9\u70b9CSS\u6587\u4ef6\u76ee\u5f55)
|
|—-+image (\u7ad9\u70b9\u56fe\u7247\u76ee\u5f55)
|
|—-+media (\u7ad9\u70b9Flash\u52a8\u753b\u5b58\u653e\u76ee\u5f55)
|
|—-indexbak.htm (\u9996\u9875\u539f\u59cb\u6548\u679c\u56fe)
|
|—-newsbak,htm (\u65b0\u95fb\u9875\u539f\u59cb\u6548\u679c\u56fe)
|
|—-index.php (Smarty\u9996\u9875\u7a0b\u5e8f\u6587\u4ef6)
|
|—-news.php (Smarty\u65b0\u95fb\u663e\u793a\u6587\u4ef6)
|
|—-newsList.php (\u663e\u793a\u65b0\u95fb\u5217\u8868)
|
|—-\u4f8b\u7a0b\u8bf4\u660e.txt (\u672c\u6587\u6863) <\/p>\n

\u76f8\u5bf9\u4e8e\u524d\u4e24\u4e2a\u6559\u7a0b,\u6709\u5c06comm\u76ee\u5f55\u91cd\u65b0\u7ec4\u7ec7\u4e86\u4e00\u4e0b,\u5176\u5b83\u7684\u6587\u4ef6\u7ed3\u6784\u6ca1\u6709\u53d8\u5316,\u6574\u4e2a\u7ad9\u70b9\u76f8\u5bf9\u4e8e\u4e0a\u4e24\u4e2a\u6559\u7a0b\u6765\u8bb2,\u6539\u53d8\u7684\u5730\u65b9\u53ea\u6709comm\u76ee\u5f55\u4e0e <\/p>\n

index.php\u4e0enews.php,\u540c\u65f6\u589e\u52a0\u4e86\u65b0\u95fb\u5217\u8868,\u5927\u5bb6\u53ef\u4ee5\u5728index.php\u6267\u884c\u540e\u7684\u9875\u9762\u4e2d\u70b9\u51fb”\u56fd\u5185\u65b0\u95fb”,”\u56fd\u9645\u65b0\u95fb”, “\u5a31\u4e50\u65b0\u95fb”\u6765\u5206\u522b\u67e5\u770b\u5404\u81ea\u7684 <\/p>\n

\u65b0\u95fb\u5217\u8868, \u6211\u4eec\u5148\u6765\u770b\u770bindex.php: <\/p>\n

======================================================
index.php
======================================================

<?php
\/*********************************************
*
* \u6587\u4ef6\u540d\uff1a index.php
* \u4f5c \u7528\uff1a \u663e\u793a\u5b9e\u4f8b\u7a0b\u5e8f
*
*********************************************\/
include_once(\".\/comm\/mySmarty.class.php\"); \/\/\u5305\u542bsmarty\u7684\u6269\u5c55\u7c7b\u6587\u4ef6
include_once(\".\/comm\/adodb\/adodb.inc.php\"); \/\/\u5305\u542bADODB\u4e3b\u6267\u884c\u6587\u4ef6
include_once(\".\/comm\/csubstr.inc\"); \/\/\u5305\u542b\u4e2d\u6587\u622a\u53d6\u7c7b <\/p>\n

define (\"NEWS_NUM\", 5); \/\/\u5b9a\u4e49\u65b0\u95fb\u5217\u8868\u663e\u793a\u6570\u76ee <\/p>\n

$smarty = new MySmarty(); \/\/\u5efa\u7acbsmarty\u5b9e\u4f8b\u5bf9\u8c61$smarty <\/p>\n

1. $conn = ADONewConnection(\"mysql\"); \/\/\u521d\u59cb\u5316ADODB
2. $conn->Connect(\"localhost\", \"root\", \"\", \"News\"); \/\/\u8fde\u63a5\u6570\u636e\u5e93 <\/p>\n

\/\/\u8fd9\u91cc\u5c06\u5904\u7406\u56fd\u5185\u65b0\u95fb\u90e8\u5206
3. $strQuery = \"Select iNewsID AS NewsID, vcNewsTitle AS NewsTitle FROM tb_news_CH orDER BY iNewsID DESC\";
4. $rs = &$conn->Execute($strQuery);
5. $smarty->assign(\"News_CH\", $rs->GetArray(NEWS_NUM));
6. unset($rs); <\/p>\n

\/\/\u8fd9\u91cc\u5904\u7406\u56fd\u9645\u65b0\u95fb\u90e8\u5206
$strQuery = \"Select iNewsID AS NewsID, vcNewsTitle AS NewsTitle FROM tb_news_IN orDER BY iNewsID DESC\";
$rs = &$conn->Execute($strQuery);
$smarty->assign(\"News_IN\", $rs->GetArray(NEWS_NUM));
unset($rs); <\/p>\n

\/\/\u8fd9\u91cc\u5c06\u5904\u7406\u5a31\u4e50\u65b0\u95fb\u90e8\u5206
$strQuery = \"Select iNewsID AS NewsID, vcNewsTitle AS NewsTitle FROM tb_news_MU orDER BY iNewsID DESC\";
$rs = &$conn->Execute($strQuery);
$smarty->assign(\"News_MU\", $rs->GetArray(NEWS_NUM));
unset($rs); <\/p>\n

7. $conn->close(); <\/p>\n

\/\/\u7f16\u8bd1\u5e76\u663e\u793a\u4f4d\u4e8e.\/templates\u4e0b\u7684index.tpl\u6a21\u677f
$smarty->display(\"index.tpl\");
?>
<\/code><\/p>\n

\u540c\u6837,\u6211\u5728\u5173\u952e\u7684\u5730\u65b9\u52a0\u4e86\u6570\u6807,\u4e0b\u9762\u6765\u8bf4\u660e\u4e00\u4e0b\u5b83\u4eec\u7684\u542b\u4e49: <\/p>\n

1. \u5efa\u7acb\u4e00\u4e2a\u8fde\u63a5\u5bf9\u8c61$conn,\u5927\u5bb6\u5728\u8fd9\u91cc\u8981\u6ce8\u610f\u7684\u662f\u5b83\u7684\u521d\u59cb\u4e0d\u662f\u4ee5$conn = new ADONewConnection($dbType)\u8fd9\u6837\u7684\u5f62\u5f0f\u51fa\u73b0\u7684,\u4e5f\u5c31\u662f\u8bf4 <\/p>\n

,ADONewConnection\u4e0d\u662f\u4e00\u4e2aclass,\u4f60\u4e0d\u80fd\u4f7f\u7528new \u5bf9\u5b83\u8fdb\u884c\u521d\u59cb\u5316.\u770b\u770b\u5b83\u7684\u6e90\u7801\u4f60\u5c31\u4f1a\u660e\u767d,\u8fd9\u53ea\u4e0d\u8fc7\u662f\u4e00\u4e2a\u51fd\u6570. <\/p>\n

2. \u8fd9\u4e2a\u5c31\u4e0d\u7528\u8bf4\u4e86\u5427?\u6253\u5f00\u4e00\u4e2aNews\u7684\u6570\u636e\u5e93,\u4e3b\u673a\u4e3a:localhost, \u7528\u6237\u540d\u4e3aroot, \u5bc6\u7801\u4e3a”” <\/p>\n

3. \u4e00\u4e2a\u67e5\u8be2\u8bed\u53e5,\u6ce8\u610f,\u8fd9\u91cc\u8981\u5c06\u67e5\u8be2\u7684\u5b57\u6bb5\u4f7f\u7528AS\u5173\u952e\u5b57\u6765\u91cd\u65b0\u6807\u8bc6,\u540d\u79f0\u4e3a\u4f60\u5728\u6a21\u677f\u4e2d\u8bbe\u7f6e\u7684\u6a21\u677f\u53d8\u91cf\u7684\u540d\u79f0. <\/p>\n

4. \u4f7f\u7528Execute\u6765\u6267\u884c\u8fd9\u4e2a\u67e5\u8be2,\u7ed3\u679c\u8fd4\u56de\u4e00\u4e2aRecordSet\u6570\u636e\u96c6 <\/p>\n

5. \u8fd9\u91cc\u6709\u4e2a\u65b9\u6cd5:$rs->GetArray($num) \u8fd9\u4e2a\u5728\u4e0a\u8fb9\u4ecb\u7ecd\u8fc7,\u5b83\u662f\u8981\u4ece$rs\u8fd9\u4e2a\u6570\u636e\u96c6\u4e2d\u8fd4\u56de$num\u884c,\u7ed3\u679c\u4e3a\u4e00\u4e2a\u53ef\u88abSmarty\u6240\u8bc6\u522b\u7684\u4e8c\u7ef4\u6570 <\/p>\n

\u636e.\u8fd9\u6837ADODB\u5c31\u81ea\u52a8\u4e3a\u6211\u4eec\u6784\u5efa\u8d77\u4e86\u8fd9\u6837\u7684\u7ed3\u6784,\u800c\u5728\u6211\u4eec\u4ee5\u524d\u7684\u4f8b\u5b50\u4e2d,\u90fd\u662f\u4f7f\u7528\u4e00\u4e2a\u5faa\u73af\u6784\u5efa\u8fd9\u6837\u7684\u6570\u7ec4\u7684. <\/p>\n

6. \u8fd9\u4e00\u53e5\u6211\u770b\u4e5f\u4e0d\u7528\u8bf4\u4e86\u5427? <\/p>\n

7. \u5173\u95ed\u5185\u5b58\u4e2d\u7684\u76f8\u5173\u8d44\u6e90. <\/p>\n

\u5927\u5bb6\u53ef\u4ee5\u770b\u770b,\u6574\u4e2a\u7a0b\u5e8f\u4e2d\u518d\u6ca1\u6709\u51fa\u73b0\u4ec0\u4e48while\u8bed\u53e5,\u7a0b\u5e8f\u6574\u4f53\u7ed3\u6784\u663e\u7684\u975e\u5e38\u6e05\u695a,\u8fd9\u5c31\u662f\u4e3a\u4ec0\u4e48ADODB+Smarty\u662f\u9ec4\u91d1\u7ec4\u5408\u7684\u539f\u56e0.\u4e0d\u8fc7\u8bdd\u4e5f <\/p>\n

\u8bf4\u56de\u6765\u4e86,\u7b80\u5355\u6709\u7b80\u5355\u7684\u95ee\u9898,\u4e0d\u77e5\u5927\u5bb6\u60f3\u8fc7\u6ca1\u6709,\u8fd9\u91cc\u5bf9\u663e\u793a\u7684\u65b0\u95fb\u6807\u9898\u7684\u957f\u5ea6\u6ca1\u6709\u63a7\u5236,\u4e5f\u5c31\u662f\u8bf4,\u5982\u679c\u67d0\u6761\u65b0\u95fb\u6807\u9898\u7684\u957f\u5ea6\u8d85\u51fa\u4e00\u884c\u663e\u793a\u7684\u8303 <\/p>\n

\u56f4,\u5b83\u5c31\u662f\u81ea\u52a8\u6298\u884c\u5230\u4e0b\u4e00\u884c,\u90a3\u4e48\u6574\u4e2a\u7684\u7248\u9762\u5c31\u4f1a\u53d8\u4e71,\u6240\u8bf4\u5927\u5bb6\u81ea\u5df2\u9002\u81ea\u5df1\u7684\u60c5\u51b5\u6765\u51b3\u5b9a\u662f\u5426\u8fd9\u6837\u4f7f\u7528\u5427\u5f53\u7136,\u4f60\u4e5f\u53ef\u4ee5\u4f7f\u7528\u50cf\u4e0a\u4e00\u8282\u4e2d\u4ecb <\/p>\n

\u7ecd\u7684\u90a3\u6837,\u4f7f\u7528\u4e00\u4e2a\u5faa\u73af\u8bed\u53e5\u91cd\u6784\u8fd9\u4e2a\u4e8c\u7ef4\u6570\u7ec4,\u4f7f\u5b83\u7b26\u5408\u4f60\u7684\u7528\u9014,\u600e\u4e48\u505a\u5927\u5bb6\u81ea\u5df1\u53bb\u60f3\u5427,\u53c2\u8003PHPLIB\u4e2d\u7684\u505a\u6cd5,\u4e0a\u8282\u6211\u4ecb\u7ecd\u8fc7\u4e86… <\/p>\n

\u518d\u6765\u770b\u770b\u65b0\u95fb\u9875\u5427 <\/p>\n

=============================================================
news.php
=============================================================

<?php
\/*********************************************
*
* \u6587\u4ef6\u540d\uff1a news.php
* \u4f5c \u7528\uff1a \u65b0\u95fb\u663e\u793a\u7a0b\u5e8f
*
*********************************************\/
include_once(\".\/comm\/mySmarty.class.php\"); \/\/\u5305\u542bsmarty\u7684\u6269\u5c55\u7c7b\u6587\u4ef6
include_once(\".\/comm\/adodb\/adodb.inc.php\"); \/\/\u5305\u542bADODB\u4e3b\u6267\u884c\u6587\u4ef6 <\/p>\n

$smarty = new MySmarty(); \/\/\u5efa\u7acbsmarty\u5b9e\u4f8b\u5bf9\u8c61$smarty <\/p>\n

$conn = ADONewConnection(\"mysql\"); \/\/\u521d\u59cb\u5316ADODB
$conn->Connect(\"localhost\", \"root\", \"\", \"News\"); \/\/\u8fde\u63a5\u6570\u636e\u5e93 <\/p>\n

$NewsID = $_GET[\"id\"]; \/\/\u83b7\u53d6\u65b0\u95fb\u7f16\u53f7
$NewsType = $_GET[\"type\"]; \/\/\u8981\u663e\u793a\u7684\u65b0\u95fb\u7c7b\u578b
switch($NewsType)
{
case 1:
$dbName = \"tb_news_CH\";
break;
case 2:
$dbName = \"tb_news_IN\";
break;
case 3:
$dbName = \"tb_news_MU\";
break;
} <\/p>\n

$strQuery = \"Select vcNewsTitle AS NewsTitle, ltNewsContent AS NewsContent FROM \" . $dbName;
1. $row = &$conn->GetRow($strQuery); \/\/\u8fd4\u56de\u4e00\u4e2a\u4e00\u7ef4\u6570\u7ec4,\u4e0b\u6807\u4e3a\u6a21\u677f\u53d8\u91cf\u540d <\/p>\n

$smarty->display($row);
unset($row); <\/p>\n

$conn->Close();
?>
<\/code><\/p>\n

\u8bf4\u660e\u4e00\u4e0b\u5173\u952e\u7684\u5730\u65b9,\u5176\u5b9e\u5728news.php\u4e2d\u4e5f\u53ea\u6709\u4e00\u4e2a\u5730\u65b9\u503c\u7684\u8bf4\u660e\u4e00\u4e0b\u4e86. <\/p>\n

1. $conn->GetRow($strQuery):\u8fd9\u4e00\u53e5\u8fd4\u56de\u4e00\u4e2a\u4e00\u7ef4\u6570\u7ec4,\u8fd4\u56de\u7684\u5f62\u5f0f\u4e3a: <\/p>\n

$array = (“NewsTitle”=>”xxxx”, “NewsContent”=>”yyyyy…”)
\u660e\u767d\u5982\u679c\u4f7f\u7528$smarty($array)\u540eSmarty\u4f1a\u5e72\u4ec0\u4e48\u5417?\u5bf9\u4e86,\u5c31\u662f\u76f8\u5f53\u4e8e:
$smarty->assign(“NewsTitle”, “xxxx”);
$smarty->assign(“NewsContent”, “yyyyy…”); <\/p>\n

\u7b80\u5355\u5427,\u786e\u5b9e\u5f88\u7b80\u5355 <\/p>\n

\u4e0b\u9762\u518d\u6765\u770b\u770b\u65b0\u95fb\u5217\u8868:
================================================================
newsList.php
================================================================

<?php
\/*********************************************
*
* \u6587\u4ef6\u540d\uff1a newsList.php
* \u4f5c \u7528\uff1a \u65b0\u95fb\u5217\u8868\u663e\u793a\u7a0b\u5e8f
*
*********************************************\/
include_once(\".\/comm\/mySmarty.class.php\"); \/\/\u5305\u542bsmarty\u7684\u6269\u5c55\u7c7b\u6587\u4ef6
include_once(\".\/comm\/adodb\/adodb.inc.php\"); \/\/\u5305\u542bADODB\u4e3b\u6267\u884c\u6587\u4ef6 <\/p>\n

$smarty = new MySmarty(); \/\/\u5efa\u7acbsmarty\u5b9e\u4f8b\u5bf9\u8c61$smarty <\/p>\n

$conn = ADONewConnection(\"mysql\"); \/\/\u521d\u59cb\u5316ADODB
$conn->Connect(\"localhost\", \"root\", \"\", \"News\"); \/\/\u8fde\u63a5\u6570\u636e\u5e93 <\/p>\n

$NewsID = $_GET[\"id\"]; \/\/\u83b7\u53d6\u65b0\u95fb\u7f16\u53f7
$NewsType = $_GET[\"type\"]; \/\/\u8981\u663e\u793a\u7684\u65b0\u95fb\u7c7b\u578b
switch($NewsType)
{
case 1:
$tbName = \"tb_news_CH\";
break;
case 2:
$tbName = \"tb_news_IN\";
break;
case 3:
$tbName = \"tb_news_MU\";
break;
} <\/p>\n

$strQuery = \"Select iNewsID AS NewsID, vcNewsTitle AS NewsTitle FROM \" . $tbName;
1. $rs = &$conn->GetAll($strQuery);
2. $smarty->assign(\"NewsType\", $NewsType); \/\/\u8fd9\u4e00\u53e5\u4e3a\u65b0\u95fb\u5217\u8868\u4e2d\u7684\u94fe\u63a5\u670d\u52a1
3. $smarty->assign(\"NewsList\", $rs);
unset($rs);
$conn->close(); <\/p>\n

$smarty->display(\"newsList.tpl\");
?>
<\/code><\/p>\n

\u5206\u522b\u6765\u8bf4\u660e\u4e00\u4e0b: <\/p>\n

1. GetAll($strQuery):\u8fd9\u4e2a\u51fd\u6570\u53ef\u662f\u4e2a\u597d\u4e1c\u4e1c,\u5b83\u7684\u4f5c\u7528\u662f\u5c06$strQuery\u67e5\u8be2\u5230\u7684\u6240\u6709\u6570\u636e\u7ec4\u5408\u6210\u4e3a\u4e00\u4e2a\u80fd\u591f\u88abSmarty\u6240\u8bc6\u522b\u7684\u4e8c\u7ef4\u6570\u7ec4, <\/p>\n

\u8bb0\u4f4f:\u5b83\u8fd4\u56de\u7684\u662f\u4e00\u4e2a\u4e8c\u7ef4\u6570\u7ec4\u800c\u4e0d\u662f\u4e00\u4e2aRecordSet,\u6240\u5728\u4f60\u53ef\u4ee5\u7a0b\u5e8f\u4e2d\u76f4\u63a5\u57283\u5904\u4f7f\u7528.
2. \u8fd9\u91cc\u662f\u4e3a\u4e86\u7ed9\u65b0\u95fb\u6807\u9898\u505a\u94fe\u63a5\u65f6\u8981GET\u53c2\u6570type=XX\u800c\u505a\u7684 <\/p>\n

\u540e\u8bb0:
\u5927\u5bb6\u5728\u4f7f\u7528ADODB\u65f6\u6709\u51e0\u4e2a\u5730\u65b9\u8981\u6ce8\u610f:
1. \u521d\u59cb\u5316: \u521d\u59cb\u5316\u7684\u65b9\u5f0f\u4e0d\u662f\u4f7f\u7528new,\u56e0\u4e3a\u5b83\u4e0d\u662f\u4e00\u4e2a\u5bf9\u8c61
2. \u65b9 \u6cd5: \u57fa\u672c\u4e0a\u6bcf\u4e2a\u65b9\u6cd5\u90fd\u662f\u4ee5\u5927\u5199\u5b57\u6bcd\u5f00\u5934\u5927\u5c0f\u5199\u6df7\u5408\u7684\u540d\u79f0,\u8fd9\u4e00\u70b9\u597d\u50cf\u4e0e*NIX\u7684\u4e60\u60ef\u6709\u4e9b\u4e0d\u540c,\u4e5f\u4e0d\u540c\u4e8ePHP\u7684\u6574\u4f53\u98ce\u683c,\u6240\u4ee5 <\/p>\n

\u6ce8\u610f\u8fd9\u91cc\u7684\u5927\u5c0f\u5199\u95ee\u9898. <\/p>\n

\u597d\u4e86,\u8fd9\u4e2aSmarty\u7684\u7cfb\u5217\u6559\u7a0b\u5230\u8fd9\u91cc\u5c31\u57fa\u672c\u5df2\u7ecf\u5b8c\u6210\u4e86<\/p>\n","protected":false},"excerpt":{"rendered":"

\u4e00\u3001\u4f7f\u7528PHP\u5185\u7f6eMYSQL\u51fd\u6570 \u4ece\u672c\u8282\u5f00\u59cb\u6211\u4eec\u6765\u5b66\u4e60\u4e00\u4e0b\u5982\u679c\u628aSm...<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[18],"tags":[],"class_list":["post-436","post","type-post","status-publish","format-standard","hentry","category-Php"],"_links":{"self":[{"href":"https:\/\/www.poloo.org\/index.php?rest_route=\/wp\/v2\/posts\/436","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.poloo.org\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.poloo.org\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.poloo.org\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.poloo.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=436"}],"version-history":[{"count":0,"href":"https:\/\/www.poloo.org\/index.php?rest_route=\/wp\/v2\/posts\/436\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.poloo.org\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=436"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.poloo.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=436"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.poloo.org\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=436"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}