PHP mysql_data_seek() 函数

ta ɗaɓe ɗan yiɗa

ta ɗaɓe ɗan yiɗa tana ɗan ɗoɗo, tana ɗan ɗoɗo MySQL result, tana ɗan ɗoɗo tana ɗan ɗoɗo tana ɗan ɗoɗo.

ta ɗaɓe ɗan yiɗa

mysql_data_seek(data,row)
ta ɗaɓe ɗan yiɗa ta ɗaɓe ɗan yiɗa
data ta ɗaɓe ɗan yiɗa. Tana ɗan ɗoɗo tana resource, tana ɗan ɗoɗo tana ɗan ɗoɗo tana mysql_query() tana ɗan ɗoɗo.
row ta ɗaɓe ɗan yiɗa. 0 tana ɗan ɗoɗo tana ɗan ɗoɗo.

ta ɗaɓe ɗan yiɗa

mysql_data_seek() tana ɗan ɗoɗo data ta ɗaɓe ɗan yiɗa tana ɗan ɗoɗo, tana ɗan ɗoɗo MySQL result, tana ɗan ɗoɗo ɗan ɗoɗo tana ɗan ɗoɗo tana ɗan ɗoɗo.

ta ɗaɓe ɗan yiɗa mysql_fetch_row() ta ɗaɓe ɗan yiɗa tana ɗan ɗoɗo.

row ta ɗaɓe ɗan yiɗa tana 0.row ta ɗaɓe ɗan yiɗa tana 0 ɗan ɗan tana mysql_num_rows - 1.

laɓa ba ceesannan hanyan ba ɗaɓe ɗan yiɗa (mysql_num_rows() == 0), tana ɗaɓe ɗan ɗoɗo tana ɗan ɗoɗo, ta ɗan ɗoɗo tana ɗan ɗoɗo, mysql_data_seek() tana ɗan ɗoɗo false.

Returns value

Returns true if successful, false if not.

Tips and Comments

Note:mysql_data_seek() can only be used with mysql_query() used together, but not for mysql_unbuffered_query().

Example

<?php
$con = mysql_connect("localhost", "hello", "321");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }
$db_selected = mysql_select_db("test_db",$con);
$sql = "SELECT * from Person";
$result = mysql_query($sql,$con);
print_r(mysql_fetch_row($result));
mysql_data_seek($result,3);
print_r(mysql_fetch_row($result));
mysql_close($con);
?>

Output:

Array
(
[0] => Adams
[1] => John
[2] => London
)
Array
(
[0] => Carter
[1] => Thomas
[2] => Beijing
)