PHP db2_fetch_object函数代码示例

function query($sql, $conn)
{
    try {
        $result = db2_exec($conn, $sql);
        $count = 0;
        while ($row = db2_fetch_object($result)) {
            echo $row->NAME1 . ", " . $row->NAME2 . " " . $row->STREET . ", " . $row->CITY . ", " . $row->STATE . ", " . $row->ZIP . ", " . $row->COUNTY . ", " . $row->LONG . ", " . $row->LAT . "<br>";
            $count++;
        }
        //print_r($result);
        if ($result) {
            echo "Query Successful<br>" . $count . " total entries<br>";
        }
    } catch (Exception $e) {
        echo "Query Failed<br>";
        echo "Exception: " . $e->getMessage() . "<br>";
        echo db2_conn_error() . "<br>";
        echo db2_conn_errormsg() . "<br>";
    }
}

 /**
  * Fetches a row from the result set.
  *
  * @param int $style  OPTIONAL Fetch mode for this fetch operation.
  * @param int $cursor OPTIONAL Absolute, relative, or other.
  * @param int $offset OPTIONAL Number for absolute or relative cursors.
  * @return mixed Array, object, or scalar depending on fetch mode.
  * @throws Zend_Db_Statement_Db2_Exception
  */
 public function fetch($style = null, $cursor = null, $offset = null)
 {
     if (!$this->_stmt) {
         return false;
     }
     if ($style === null) {
         $style = $this->_fetchMode;
     }
     switch ($style) {
         case Zend_Db::FETCH_NUM:
             $row = db2_fetch_array($this->_stmt);
             break;
         case Zend_Db::FETCH_ASSOC:
             $row = db2_fetch_assoc($this->_stmt);
             break;
         case Zend_Db::FETCH_BOTH:
             $row = db2_fetch_both($this->_stmt);
             break;
         case Zend_Db::FETCH_OBJ:
             $row = db2_fetch_object($this->_stmt);
             break;
         case Zend_Db::FETCH_BOUND:
             $row = db2_fetch_both($this->_stmt);
             if ($row !== false) {
                 return $this->_fetchBound($row);
             }
             break;
         default:
             /**
              * @see Zend_Db_Statement_Db2_Exception
              */
             require_once PHP_LIBRARY_PATH . 'Zend/Db/Statement/Db2/Exception.php';
             throw new Zend_Db_Statement_Db2_Exception("Invalid fetch mode '{$style}' specified");
             break;
     }
     return $row;
 }

 /**
  * Fetches a row from the result set.
  *
  * @param int $style  OPTIONAL Fetch mode for this fetch operation.
  * @param int $cursor OPTIONAL Absolute, relative, or other.
  * @param int $offset OPTIONAL Number for absolute or relative cursors.
  * @return mixed Array, object, or scalar depending on fetch mode.
  * @throws \Zend\Db\Statement\Db2Exception
  */
 public function fetch($style = null, $cursor = null, $offset = null)
 {
     if (!$this->_stmt) {
         return false;
     }
     if ($style === null) {
         $style = $this->_fetchMode;
     }
     switch ($style) {
         case Db\Db::FETCH_NUM:
             $row = db2_fetch_array($this->_stmt);
             break;
         case Db\Db::FETCH_ASSOC:
             $row = db2_fetch_assoc($this->_stmt);
             break;
         case Db\Db::FETCH_BOTH:
             $row = db2_fetch_both($this->_stmt);
             break;
         case Db\Db::FETCH_OBJ:
             $row = db2_fetch_object($this->_stmt);
             break;
         case Db\Db::FETCH_BOUND:
             $row = db2_fetch_both($this->_stmt);
             if ($row !== false) {
                 return $this->_fetchBound($row);
             }
             break;
         default:
             throw new Db2Exception("Invalid fetch mode '{$style}' specified");
             break;
     }
     return $row;
 }

 /**
  * {@inheritdoc}
  */
 public function fetch($fetchMode = null)
 {
     $fetchMode = $fetchMode ?: $this->_defaultFetchMode;
     switch ($fetchMode) {
         case \PDO::FETCH_BOTH:
             return db2_fetch_both($this->_stmt);
         case \PDO::FETCH_ASSOC:
             return db2_fetch_assoc($this->_stmt);
         case \PDO::FETCH_CLASS:
             $className = $this->defaultFetchClass;
             $ctorArgs = $this->defaultFetchClassCtorArgs;
             if (func_num_args() >= 2) {
                 $args = func_get_args();
                 $className = $args[1];
                 $ctorArgs = isset($args[2]) ? $args[2] : array();
             }
             $result = db2_fetch_object($this->_stmt);
             if ($result instanceof \stdClass) {
                 $result = $this->castObject($result, $className, $ctorArgs);
             }
             return $result;
         case \PDO::FETCH_NUM:
             return db2_fetch_array($this->_stmt);
         case \PDO::FETCH_OBJ:
             return db2_fetch_object($this->_stmt);
         default:
             throw new DB2Exception("Given Fetch-Style " . $fetchMode . " is not supported.");
     }
 }

 /**
  * Fetch the next row from the given result object, in object form.
  * Fields can be retrieved with $row->fieldname, with fields acting like
  * member variables.
  *
  * @param $res array|ResultWrapper SQL result object as returned from Database::query(), etc.
  * @return DB2 row object
  * @throws DBUnexpectedError Thrown if the database returns an error
  */
 public function fetchObject($res)
 {
     if ($res instanceof ResultWrapper) {
         $res = $res->result;
     }
     wfSuppressWarnings();
     $row = db2_fetch_object($res);
     wfRestoreWarnings();
     if ($this->lastErrno()) {
         throw new DBUnexpectedError($this, 'Error in fetchObject(): ' . htmlspecialchars($this->lastError()));
     }
     return $row;
 }

<?php

require 'php/connection.php';
$orderID = "";
$orderTime = "N/A";
$shippingType = "Unknown";
$shippingPrice = "Unknown";
$tax = "Unknown";
$products = "No products bought";
if (isset($_GET['orderID'])) {
    $query = "SELECT * FROM orderedItems join orderInfo on orderedItems.orderID = orderInfo.orderID WHERE orderID = " + orderID + ";";
    $results = db2_exec($_SESSION['connection'], $query);
    //only one entry
    while ($row = db2_fetch_object($results)) {
        $orderID = $row->orderID;
        $orderTime = $row->orderTime;
        $shippingType = $row->shippingType;
        $shippingPrice = $row->shippingPrice;
        $tax = $row->tax;
        $productID = $row->productID;
    }
}

 /**
  * This function fetches a result row as an object.
  *
  * @param   mixed $result
  * @return  mixed
  * @access  public
  * @author  Thorsten Rinne <thorsten@phpmyfaq.de>
  * @author  Helmut Tessarek <tessus@evermeet.cx>
  * @since   2005-04-16
  */
 function fetchObject($result)
 {
     $_result = db2_fetch_object($result);
     if (is_object($_result)) {
         return (object) array_change_key_case(get_object_vars($_result), CASE_LOWER);
     } else {
         return false;
     }
 }

 public static function fetch_object($psql, $fetchall, $conn = null)
 {
     if ($psql) {
         if (!$fetchall) {
             return db2_fetch_object($psql);
         } else {
             $ret = array();
             while ($obj = db2_fetch_object($psql)) {
                 $ret[] = $obj;
             }
             return $ret;
         }
     }
     return false;
 }

 /**
  * Fetch the next row from the given result object, in object form.
  * Fields can be retrieved with $row->fieldname, with fields acting like
  * member variables.
  *
  * @param $res SQL result object as returned from Database::query(), etc.
  * @return DB2 row object
  * @throws DBUnexpectedError Thrown if the database returns an error
  */
 public function fetchObject($res)
 {
     if ($res instanceof ResultWrapper) {
         $res = $res->result;
     }
     @($row = db2_fetch_object($res));
     if ($this->lastErrno()) {
         throw new DBUnexpectedError($this, 'Error in fetchObject(): ' . htmlspecialchars($this->lastError()));
     }
     // Make field names lowercase for compatibility with MySQL
     if ($row) {
         $row2 = new BlankObject();
         foreach ($row as $key => $value) {
             $keyu = strtolower($key);
             $row2->{$keyu} = $value;
         }
         $row = $row2;
     }
     return $row;
 }