msql_fetch_field.php3

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

PHP3
28
字号
<HTML>
<HEAD>
<TITLE>msql_fetch_field</TITLE>
</HEAD>
<BODY>
<?
	$database_link = msql_connect("msql.clearink.com");
	msql_select_db("store", $database_link);
	$query = "SELECT * FROM item i, SKU s ";
	$query .= "WHERE i.SKU = s.ID ";
	$result = msql_query($query, $database_link);

	// get description of each field 
	while($field = msql_fetch_field($result))
	{
		print("Name: " . $field->name . "<BR>\n");
		print("Table: " . $field->table . "<BR>\n");
		print("Not Null: " . $field->not_null .
		"<BR>\n");
		print("Primary Key: " . 
		$field->primary_key "<BR>\n");
		print("Unique: " . $field->unique . "<BR>\n");
		print("Type: " . $field->type . "<BR>\n<BR>\n");
	}
	msql_close($database_link);
?>
</BODY>
</HTML>

⌨️ 快捷键说明

复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?