downloads \| documentation \| faq \| getting help \| mailing lists \| reporting bugs \| php.net sites \| links \| my php.net

search for in the

Predefined Constants	Ingres II Functions

	Last updated: Thu, 26 Jun 2008

Examples

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

Example #1 Simple Ingres Example


<?php

// Connecting, selecting database

$link = ingres_connect('database', 'user', 'password')

    or die('Could not connect: ' . ingres_error($link));

echo 'Connected successfully';



// Select from a table that exists in all Ingres databases

$query = 'SELECT * FROM iirelation';

$returncode = ingres_query($query,$link) or die('Query failed: ' .

ingres_error($link));



// Print results in HTML

// relid - table name

// relowner - table owner

echo "<table>\n";

while ($iirelation = ingres_fetch_object(INGRES_BOTH, $link)) {

    echo "\t<tr>\n";

    echo "\t\t<td>" . $iirelation->relid . "</td>\n";

    echo "\t\t<td>" . $iirelation->relowner . "</td>\n";

    echo "\t</tr>\n";

}

echo "</table>\n";



// Commit transaction

ingres_commit($link);

// Closing connection

ingres_close($link);

?>

add a note User Contributed Notes
Examples

There are no user contributed notes for this page.

Predefined Constants	Ingres II Functions

	Last updated: Thu, 26 Jun 2008

This unofficial mirror is operated at: http://phpbuilder.com/
Last updated: Tue Nov 1 20:20:59 2005 EST