16-4.php3

来自「linux操作系统中 php 核心编程所有例程 都是一些很不错的案例」· PHP3 代码 · 共 54 行

PHP3
54
字号
<?
	//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 + =
减小字号Ctrl + -
显示快捷键?