Ingres 函数

ingres_autocommit_state — Test if the connection is using autocommit
ingres_autocommit — Switch autocommit on or off
ingres_charset — Returns the installation character set
ingres_close — Close an Ingres database connection
ingres_commit — Commit a transaction
ingres_connect — Open a connection to an Ingres database
ingres_cursor — Get a cursor name for a given result resource
ingres_errno — Get the last Ingres error number generated
ingres_error — Get a meaningful error message for the last error generated
ingres_errsqlstate — Get the last SQLSTATE error code generated
ingres_escape_string — Escape special characters for use in a query
ingres_execute — Execute a prepared query
ingres_fetch_array — Fetch a row of result into an array
ingres_fetch_assoc — Fetch a row of result into an associative array
ingres_fetch_object — Fetch a row of result into an object
ingres_fetch_proc_return — Get the return value from a procedure call
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_free_result — Free the resources associated with a result identifier
ingres_next_error — Get the next Ingres error
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 a query
ingres_pconnect — Open a persistent connection to an Ingres database
ingres_prepare — Prepare a query for later execution
ingres_query — Send an SQL query to Ingres
ingres_result_seek — Set the row position before fetching data
ingres_rollback — Roll back a transaction
ingres_set_environment — Set environment features controlling output options
ingres_unbuffered_query — Send an unbuffered SQL query to Ingres

User Contributed Notes

corysbrain-ondrugs at yahoo dot com 07-Jul-2007 09:04


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.

corysbrain-ondrugs at yahoo dot com 13-Feb-2007 06: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($link,$query) 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);


?>

Ingres 函数

Table of Contents

User Contributed Notes