📄 16-4.php3
字号:
<?
//start HTML page
print("<HTML>\n");
print("<HEAD>\n");
print("<TITLE>Figure 16-4</TITLE>\n");
print("</HEAD>\n");
print("<BODY>\n");
// connect to server
$mysql_link = mysql_connect("localhost", "httpd", "");
// select the 'store' database
mysql_select_db("test", $mysql_link);
// get everything from catalog table
$query = "SELECT * FROM catalog ";
$mysql_result = mysql_query($query, $mysql_link);
//start table
print("<TABLE BORDER=\"0\">\n");
//create header row
print("<TR>\n");
print("<TD BGCOLOR=\"#CCCCCC\"><B>Item</B></TD>\n");
print("<TD BGCOLOR=\"#CCCCCC\"><B>Price</B></TD>\n");
print("</TR>\n");
// get each row
while($row = mysql_fetch_row($mysql_result))
{
//get columns
$item_ID = $row[0];
$item_Name = $row[1];
$item_Price = $row[2];
print("<TR>\n");
print("<TD>$item_Name</TD>\n");
print("<TD ALIGN=\"right\">\$$item_Price</TD>\n");
print("</TR>\n");
}
//end table
print("</TABLE>\n");
//close page
print("</BODY>\n");
print("</HTML>\n");
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -