15: if (mysql_num_rows($get_cats_res) < 1) { //如果返回记录行数小于1，则说明没有分类
16: $display_block = "<P><em>Sorry, no categories to browse.</em></p>";
17: } else {
18:
19: while ($cats = mysql_fetch_array($get_cats_res)) { //将记录放入变量$cats中
20:$cat_id = $cats[id];
21:$cat_title = strtoupper(stripslashes($cats[cat_title]));
22:$cat_desc = stripslashes($cats[cat_desc]);
23:
24: $display_block .= "<p><strong><a
25: href=\"$_SERVER[PHP_SELF][U1] ?cat_id=$cat_id\">$cat_title</a></strong>//点击此url，刷新本页，第28行读取cat_id，显示相应分类的条目
26: <br>$cat_desc</p>";
27:
28:if ($_GET[cat_id] == $cat_id) { //选择一个分类，看下面的条目
29: //get items
30: $get_items = "select id, item_title, item_price
31: from store_items where cat_id = $cat_id
32: order by item_title";
33: $get_items_res = mysql_query($get_items) or die(mysql_error());
34:
35: if (mysql_num_rows($get_items_res) < 1) {
36: $display_block = "<P><em>Sorry, no items in
37: this category.</em></p>";
38: } else {
39:
40: $display_block .= "<ul>";
41:
42: while ($items = mysql_fetch_array($get_items_res)) {
43: $item_id = $items[id];
44: $item_title = stripslashes($items[item_title]);
45: $item_price = $items[item_price];
46:
47: $display_block .= "<li><a
48: href=\"showitem.php?item_id=$item_id\">$item_title</a>
49: </strong> (\$$item_price)";
[U2] 50: }
51:
52: $display_block .= "</ul>";
53: }
54: }
55: }
56: }
57: ?>
58: <HTML>
59: <HEAD>
60: <TITLE>My Categories</TITLE>
61: </HEAD>
62: <BODY>
63: <? print $display_block; ?>
64: </BODY>
65: </HTML>
16、PHP连接Access：
<?
$dbc=new com("adodb.connection");
$dbc->open("driver=microsoft access driver (*.mdb);dbq=c:\member.mdb");
$rs=$dbc->execute("select * from tablename");
$i=0;
while (!$rs->eof){
$i+=1
$fld0=$rs->fields["UserName"];
$fld0=$rs->fields["Password"];
....
echo "$fld0->value $fld1->value ....";
$rs->movenext();
}
$rs->close();
?>
