Ingres II
My post below works but is *not* the correct way. It only works because of default behavior. I'll re-post my understanding of what is "correct" soon.
Ingres II Functions
Table of Contents
- ingres_autocommit — Switch autocommit on or off
- ingres_close — Close an Ingres II database connection
- ingres_commit — Commit a transaction
- ingres_connect — Open a connection to an Ingres database
- ingres_cursor — Gets a cursor name for a given link resource
- ingres_errno — Gets the last ingres error number generated
- ingres_error — Gets a meaningful error message for the last error generated
- ingres_errsqlstate — Gets the last SQLSTATE error code generated
- ingres_fetch_array — Fetch a row of result into an array
- ingres_fetch_object — Fetch a row of result into an object
- ingres_fetch_row — Fetch a row of result into an enumerated array
- ingres_field_length — Get the length of a field
- ingres_field_name — Get the name of a field in a query result
- ingres_field_nullable — Test if a field is nullable
- ingres_field_precision — Get the precision of a field
- ingres_field_scale — Get the scale of a field
- ingres_field_type — Get the type of a field in a query result
- ingres_num_fields — Get the number of fields returned by the last query
- ingres_num_rows — Get the number of rows affected or returned by the last query
- ingres_pconnect — Open a persistent connection to an Ingres II database
- ingres_query — Send a SQL query to Ingres II
- ingres_rollback — Roll back a transaction
add a note
User Contributed NotesIngres II Functions
corysbrain-ondrugs at yahoo dot com
07-Jul-2007 10:04
07-Jul-2007 10:04
corysbrain-ondrugs at yahoo dot com
13-Feb-2007 07:57
13-Feb-2007 07:57
On the three versions of Linux/Ingres I've worked on, I've always had to modify the following line in the example above:
while ($iirelation = ingres_fetch_object($link)) {
to:
while ($iirelation = ingres_fetch_object()) {
If not, PHP will return "Undefined property" notices.
However, it's my understanding that the following is the proper way to access the database (it works as expected):
<?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';
$rs = 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($rs)) {
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);
?>
mail at hannes-reinecke dot de
12-Dec-2002 04:09
12-Dec-2002 04:09
If you try to use the 'Embedded Ingres' as it is delivered with certain CA products (e.g. TNG UHD), the referenced library '-lingres' is not available. You need to add '-lq -lframe' instead.
burckhardtNOSPAM at SNIPITOFFgsf dot de
23-Jan-2002 11:07
23-Jan-2002 11:07
Hi,
I am currently migrating from MySQL to Ingres. Generally, almost ALL INGRES-functions that use arrays start with counter=1, NOT counter=0. Also, whereas MySQL-functions use $result as an argument, INGRES-functions use $connection instead.
Florian