Php/docs/ingres.examples-basic
Basic usage
The following simple example shows how to connect to an Ingres database, execute a query, print resulting rows and disconnect from the 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 iitables";$result = ingres_query($link,$query) or die("Query failed: " .ingres_error($link));// Print results in HTML// relid - table name// relowner - table ownerecho "<table>\n";while ($iitables = ingres_fetch_object($result)) { echo "\t<tr>\n"; echo "\t\t<td>" . $iitables->relid . "</td>\n"; echo "\t\t<td>" . $iitables->relowner . "</td>\n"; echo "\t</tr>\n";}echo "</table>\n";// Free resultsingres_free_result($result);// Commit transactioningres_commit($link);// Closing connectioningres_close($link);?>
