php教程

Ingres 函数

Table of Contents

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);
?>

CopyRight © 2008-2022 verySource.Com All Rights reserved. 京ICP备17048824号-1 京公网安备:11010502034788