PHP Doku:: Moves the internal row pointer of the CUBRID result - function.cubrid-data-seek.html

Verlauf / Chronik / History: (1) anzeigen

Sie sind hier:
Doku-StartseitePHP-HandbuchFunktionsreferenzDatenbankerweiterungenAnbieterspezifische DatenbankerweiterungenCubridCubrid Funktionencubrid_data_seek

Ein Service von Reinhard Neidl - Webprogrammierung.

Cubrid Funktionen

<<cubrid_current_oid

cubrid_db_name>>

cubrid_data_seek

(PECL CUBRID >= 8.3.0)

cubrid_data_seekMoves the internal row pointer of the CUBRID result

Beschreibung

bool cubrid_data_seek ( resource $req_identifier , int $row_number )

This function performs the moving of the internal row pointer of the CUBRID result (associated with the specified result identifier) to point to a specific row number. There are functions, such as cubrid_fetch_assoc(), which use the current stored value of row number.

Parameter-Liste

req_identifier

This is the request identifier.

row_number

This is the desired row number of the new result pointer.

Rückgabewerte

CUBRID_CURSOR_SUCCESS, on success.

CUBRID_NO_MORE_DATA, when it is not a valid cursor location.

FALSE on CAS error, row count is 0, or invalid offset.

Beispiele

Beispiel #1 cubrid_data_seek() example

<?php
    $link 
cubrid_connect("localhost"30000"demodb2""dba""");
    if (!
$link)
    {
        die(
'Could not connect.');
    }
    
$query 'SELECT name, address, salary FROM employees';
    
$result cubrid_execute($link$query);
    if (
$result
    {
        echo 
"seek to row 0 and fetching fields: ";
        
cubrid_data_seek($result0);
        
$row cubrid_fetch_assoc($result);
        echo 
$row["name"]."|"$row["address"]."|".$row["salary"]."<br>";

        echo 
"seek to row 2 and fetching fields: ";    
        
cubrid_data_seek($result2);
        
$row cubrid_fetch_assoc($result);
        echo 
$row["name"]."|"$row["address"]."|".$row["salary"]."<br>";

        
cubrid_close_request($result); 
    }
?>

Das oben gezeigte Beispiel erzeugt folgende Ausgabe:

Result:
seek to row 0 and fetching fields: Peter|1st Avenue, New York|1000.0000000000000000
seek to row 2 and fetching fields: Peter Norton|81254, CA|19834.0000000000000000


Keine BenutzerBeiträge.
- Beiträge aktualisieren...



PHP Powered Diese Seite bei php.net
The PHP manual text and comments are covered by the Creative Commons Attribution 3.0 License © the PHP Documentation Group - Impressum - mail("TO:Reinhard Neidl",...)