NDSU CS Department Wiki

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.

====== PHP example for Postgres database connection ======

<code>

<head>
</head>
<body>

<?php
	// Make a connection to the database
        // The values here MUST BE CHANGED to match the database and credentials you wish to use
	$dbhost = pg_connect("host=hostname dbname=databasename user=username password=password");

	// If the $dbhost variable is not defined, there was an error
	if(!$dbhost)
	{
		die("Error: ".pg_last_error());
	}

	// Define the SQL query to run (replace these values as well)
	$sql = "SELECT * FROM Schema.Tablename";

        // Run the SQL query
	$result = pg_query($dbhost, $sql);

        // If the $result variable is not defined, there was an error in the query
	if (!$result)
	{
		die("Error in query: ".pg_last_error());
	}

	// Iterate through each row of the result 
	while ($row = pg_fetch_array($result))
	{
		// Write HTML to the page, replace this with whatever you wish to do with the data
		echo $row[0]."<br/>\n";
	}

	// Free the result from memory
	pg_free_result($result);

	// Close the database connection
	pg_close($dbhost);
?>

</body>
</html>


</code>