Switch to: V11V10V9V8V7V6V5

valentina_data_seek()

Declaration

bool valentina_data_seek ( resource result, int row_number )

Parameters

Name Description
result The result resource that is being evaluated. This result comes from a call to valentina_query().
row_number The desired row number of the new result pointer.

Description

Moves the internal row pointer of the Valentina Server result associated with the specified result identifier to point to the specified row number. The next call to valentina_fetch_row() would return that row.

row_number starts at 0. The row_number should be a value in the range from 0 to valentina_num_rows() - 1. However if the result set is empty (valentina_num_rows() == 0), a seek to 0 will fail with a E_WARNING and valentina_data_seek() will return FALSE.

Return Values

Returns TRUE on success or FALSE on failure.

Examples

Example 1.

<?php
$link = valentina_connect('localhost', 'val_user', 'val_password');
if (!$link) {
   die('Could not connect: ' . valentina_error());
}
$db_selected = valentuna_select_db('sample_db');
if (!$db_selected) {
   die('Could not select database: ' . valentina_error());
}
$query = 'SELECT last_name, first_name FROM friends';
$result = valentina_query($query);
if (!$result) {
   die('Query failed: ' . valentina_error());
}
/* fetch rows in reverse order */
for ($i = valentina_num_rows($result) - 1; $i >= 0; $i--) {
   if (!valentina_data_seek($result, $i)) {
       echo "Cannot seek to row $i: " . valentina_error() . "\n";
       continue;
   }
 
   if (!($row = valentina_fetch_assoc($result))) {
       continue;
   }
 
   echo $row['last_name'] . ' ' . $row['first_name'] . "<br />\n";
}
 
valentina_free_result($result);
?> 

See Also