Ingres Functions

Table of Contents

Коментарии

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);
?>
2007-02-13 20:57:39
http://php5.kiev.ua/manual/ru/ref.ingres.html
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.
2007-07-07 12:04:17
http://php5.kiev.ua/manual/ru/ref.ingres.html

    Поддержать сайт на родительском проекте КГБ