pg_exec.php3

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

PHP3
67
字号
<HTML>
<HEAD>
<TITLE>pg_exec</TITLE>
</HEAD>
<BODY>
<?
	// connect to the database 
	$connection = pg_connect("pg.clearink.com",
		"123", "store");

	// execute query 
	$query = "SELECT * FROM item";
	$result = pg_exec($connection, "SELECT * FROM item");

	// print each row in a table 
	print("<TABLE>\n");

	// print header row 
	print("<TR>\n");
	for($field = 0; 
	$field < pg_numfields($result);
 		$field++)
	{
		print("<TD>");
		print(pg_fieldname($result, $field));
		print(" ");
		print(pg_fieldtype($result, $field));
		print("(");
		print(pg_fieldsize($result, $field));
		print(")");
		print("</TD>\n");
	}
	print("</TR>\n");


	for($row = 0; 
	$row < pg_NumRows($result); 
	$row++)
	{
		print("<TR>\n");
		for($field = 0; 
		$field < pg_numfields($result); 
		$field++)
		{
			print("<TD>");
			if(pg_fieldisnull($result, $row, $field))
			{
				$price = "NULL";
			}
			else
			{
				print(pg_result($result,
				$row, $field));
			}
			print("</TD>\n");
		}
		print("</TR>\n");
	}

	print("</TABLE>\n");

	// free the result and close the connection 
	pg_freeresult($result);
	pg_close($connection);
?>
</BODY>
</HTML>

⌨️ 快捷键说明

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