(PHP 4, PHP 5)
mysql_data_seek — 锟狡讹拷锟节诧拷锟斤拷锟斤拷锟街革拷锟�
$result
, int $row_number
) : boolmysql_data_seek() 锟斤拷指锟斤拷锟侥斤拷锟斤拷锟绞讹拷锟斤拷锟斤拷锟斤拷锟� MySQL 锟斤拷锟斤拷诓锟斤拷锟斤拷锟街革拷锟斤拷贫锟斤拷锟街革拷锟斤拷锟斤拷泻拧锟斤拷锟斤拷诺锟斤拷锟� mysql_fetch_row() 锟斤拷锟斤拷锟斤拷锟斤拷一锟叫★拷
row_number 锟斤拷 0 锟斤拷始锟斤拷row_number
锟斤拷取值锟斤拷围应锟矫达拷 0 锟斤拷 mysql_num_rows - 1锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷为锟秸ｏ拷mysql_num_rows()
== 0锟斤拷锟斤拷要锟斤拷指锟斤拷锟狡讹拷锟斤拷 0 锟斤拷失锟杰诧拷锟斤拷锟斤拷 E_WARNING
锟斤拷锟侥达拷锟斤拷mysql_data_seek() 锟斤拷锟斤拷锟斤拷 FALSE锟斤拷
resultresource 锟酵的斤拷锟斤拷锟斤拷锟斤拷私锟斤拷锟斤拷锟斤拷锟皆讹拷 mysql_query() 锟侥碉拷锟矫★拷
row_number锟斤拷要锟借定锟斤拷锟铰的斤拷锟斤拷锟街革拷锟斤拷锟斤拷锟斤拷锟斤拷
锟缴癸拷时锟斤拷锟斤拷 TRUE锟斤拷 锟斤拷锟斤拷锟斤拷失锟斤拷时锟斤拷锟斤拷 FALSE锟斤拷
Example #1 mysql_data_seek() 锟斤拷锟斤拷
<?php
$link = mysql_connect('localhost', 'mysql_user', 'mysql_password');
if (!$link) {
die('Could not connect: ' . mysql_error());
}
$db_selected = mysql_select_db('sample_db');
if (!$db_selected) {
die('Could not select database: ' . mysql_error());
}
$query = 'SELECT last_name, first_name FROM friends';
$result = mysql_query($query);
if (!$result) {
die('Query failed: ' . mysql_error());
}
/* fetch rows in reverse order */
for ($i = mysql_num_rows($result) - 1; $i >= 0; $i--) {
if (!mysql_data_seek($result, $i)) {
echo "Cannot seek to row $i: " . mysql_error() . "\n";
continue;
}
if (!($row = mysql_fetch_assoc($result))) {
continue;
}
echo $row['last_name'] . ' ' . $row['first_name'] . "<br />\n";
}
mysql_free_result($result);
?>
Note:
锟斤拷锟斤拷展锟斤拷 PHP 5.5.0 锟斤拷锟窖凤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷 PHP 7.0.0 锟斤拷始锟斤拷锟狡筹拷锟斤拷应使锟斤拷 MySQLi 锟斤拷 PDO_MySQL 锟斤拷展锟斤拷锟芥换之锟斤拷锟轿硷拷 MySQL锟斤拷选锟斤拷 API 指锟斤拷锟皆硷拷锟斤拷锟� FAQ 锟斤拷锟斤拷取锟斤拷锟斤拷锟斤拷息锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷校锟�
- mysqli_data_seek()
PDO::FETCH_ORI_ABS
Note:
mysql_data_seek() 只锟杰猴拷 mysql_query() 锟斤拷锟斤拷锟斤拷锟绞癸拷茫锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟� mysql_unbuffered_query()锟斤拷