PHP sybase_num_rows函数代码示例

 function select($fields, $tables, $where = "", $order_by = "", $group_by = "", $having = "")
 {
     $sql_stat = " select {$fields} from {$tables} ";
     if (!empty($where)) {
         $sql_stat .= "where {$where} ";
     }
     if (!empty($group_by)) {
         $sql_stat .= "group by {$group_by} ";
     }
     if (!empty($order_by)) {
         $sql_stat .= "order by {$order_by} ";
     }
     if (!empty($having)) {
         $sql_stat .= "having {$having} ";
     }
     $this->db_result = @sybase_query($sql_stat) or print "Error";
     $this->db_affected_rows = @sybase_num_rows($this->db_result);
     return $sql_stat;
 }

 /**
  * Number of rows in the result set
  *
  * @access	public
  * @return	integer
  */
 function num_rows()
 {
     return @sybase_num_rows($this->result_id);
 }

 /**
  * Gets the number of rows in a result set
  *
  * This method is not meant to be called directly.  Use
  * DB_result::numRows() instead.  It can't be declared "protected"
  * because DB_result is a separate object.
  *
  * @param resource $result  PHP's query result resource
  *
  * @return int  the number of rows.  A DB_Error object on failure.
  *
  * @see DB_result::numRows()
  */
 function numRows($result)
 {
     $rows = @sybase_num_rows($result);
     if ($rows === false) {
         return $this->sybaseRaiseError();
     }
     return $rows;
 }

 function _initrs()
 {
     global $ADODB_COUNTRECS;
     $this->_numOfRows = $ADODB_COUNTRECS ? @sybase_num_rows($this->_queryID) : -1;
     $this->_numOfFields = @sybase_num_fields($this->_queryID);
 }

 /**
  * Returns number of rows in previous resultset. If no previous resultset exists,
  * this returns false.
  *
  * @return integer Number of rows in resultset
  */
 function lastNumRows()
 {
     if ($this->hasResult()) {
         return @sybase_num_rows($this->_result);
     }
     return null;
 }

function sql_num_rows($res)
{
    global $dbtype;
    switch ($dbtype) {
        case "MySQL":
            $rows = mysql_num_rows($res);
            return $rows;
            break;
        case "mSQL":
            $rows = msql_num_rows($res);
            return $rows;
            break;
        case "postgres":
        case "postgres_local":
            $rows = pg_numrows($res->get_result());
            return $rows;
            break;
        case "ODBC":
        case "ODBC_Adabas":
            $rows = odbc_num_rows($res);
            return $rows;
            break;
        case "Interbase":
            echo "<BR>Error! PHP dosen't support ibase_numrows!<BR>";
            return $rows;
            break;
        case "Sybase":
            $rows = sybase_num_rows($res);
            return $rows;
            break;
        default:
            break;
    }
}

 protected function _num_rows($result_id)
 {
     global $configArray;
     if (strcasecmp($configArray['System']['operatingSystem'], 'windows') == 0) {
         return sybase_num_rows($result_id);
     } else {
         return mssql_num_rows($result_id);
     }
 }

 /**
  * Return the number of rows of the current result
  * @return integer
  */
 protected function num_rows()
 {
     return @sybase_num_rows($this->resResult);
 }

 function num_rows()
 {
     return sybase_num_rows($this->Query_ID);
 }

 /**
  * Process end of query event.
  *
  * @param   var observable
  * @param   var dbevent
  */
 public function onQueryEnd($obs, $arg)
 {
     $this->cat->info($this->getClassName() . '::onQueryEnd() Query was:', sizeof($this->queries) == 1 ? $this->queries[0] : $this->queries);
     $result = $arg->getArgument();
     $sc = 0;
     $reads = 0;
     foreach (array_keys($this->messages) as $idx) {
         $msg = $this->messages[$idx];
         switch ($msg['msgnumber']) {
             case 3615:
                 $split = sscanf($msg['text'], 'Table: %s scan count %d, logical reads: (regular=%d apf=%d total=%d), physical reads: (regular=%d apf=%d total=%d), apf IOs used=%d');
                 $this->cat->infof('IO(%s): scan count= %d, logical= %d, physical= %d', $split[0], $split[1], $split[4], $split[7]);
                 // Add overall statistics
                 $sc += $split[1];
                 $reads += $split[4] + $split[7];
                 break;
             case 3614:
                 $split = sscanf($msg['text'], 'Total writes for this command: %d');
                 if ($split[0] > 0) {
                     $this->cat->infof('Write-IO: %d', $split[0]);
                 }
                 break;
         }
     }
     $this->cat->infof('Overall stats for query: scan count= %d, reads= %d', $sc, $reads);
     // Retrieve number of rows returned, then calculate average cost of row
     if (1 < ($nrows = sybase_num_rows($result->handle))) {
         $this->cat->infof('Average stats for query: scan count= %0.02f, reads= %0.02f (%d lines)', $sc / $nrows, $reads / $nrows, $nrows);
     }
     $this->queries = $this->messages = array();
 }

 /**
  * Number of rows in a result
  *
  * @param   mixed $result
  * @return  integer
  */
 function numRows($result)
 {
     return sybase_num_rows($result);
 }

 function ExecuteScalar($sql)
 {
     $retVal = null;
     if (!$this->conn) {
         $this->Connect();
     }
     $res = sybase_query($sql, $this->conn);
     if ($res) {
         if (sybase_num_rows($res) > 0) {
             $retVal = sybase_result($res, 0, 0);
         }
         sybase_free_result($res);
     }
     return $retVal;
 }

 /**
  * Returns number of rows in previous resultset. If no previous resultset exists,
  * this returns false.
  *
  * @return integer Number of rows in resultset
  */
 function lastNumRows()
 {
     if ($this->_result and is_resource($this->_result)) {
         return @sybase_num_rows($this->_result);
     }
     return null;
 }

 public function numRows()
 {
     if (!empty($this->query)) {
         return sybase_num_rows($this->query);
     } else {
         return 0;
     }
 }