pgsql-php-examples-basic-1

  • Examples
  • Basic usage

  • Basic usage
  • Basic usage

    Basic usage

    This simple example shows how to connect, execute a
    query, print resulting rows and disconnect from a PostgreSQL
    database.

    Example #1 PostgreSQL extension overview
    example

    <?php
    // Connecting, selecting database
    $dbconn pg_connect("host=localhost dbname=publishing user=www password=foo")
        or die(
    'Could not connect: ' pg_last_error());

    // Performing SQL query
    $query 'SELECT * FROM authors';
    $result pg_query($query) or die('Query failed: ' pg_last_error());

    // Printing results in HTML
    echo "<table>\n";
    while (
    $line pg_fetch_array($resultnullPGSQL_ASSOC)) {
        echo 
    "\t<tr>\n";
        foreach (
    $line as $col_value) {
            echo 
    "\t\t<td>$col_value</td>\n";
        }
        echo 
    "\t</tr>\n";
    }
    echo 
    "</table>\n";

    // Free resultset
    pg_free_result($result);

    // Closing connection
    pg_close($dbconn);
    ?>