Home >
Article > Backend Development > Implementation code for moving the pointer to the initial position of the data set in PHP [mysql_data_seek]_PHP tutorial
Implementation code for moving the pointer to the initial position of the data set in PHP [mysql_data_seek]_PHP tutorial
WBOYOriginal
2016-07-21 15:15:001015browse
Copy code The code is as follows:
// Start snipit 1 $sql = " SELECT * from
"; $result = mysql_query($sql); while ($row = mysql_fetch_assoc($result)) { // do stuff with $row } mysql_data_seek($result, 0); //The key is here while ($row = mysql_fetch_assoc($result)) { // do other stuff with $row } ? >
Definition and Usage
The mysql_data_seek() function moves the pointer of the internal result.
Syntax
mysql_data_seek(data,row) Parameter Description data Required. Returns a result set of type resource. This result set is obtained from a call to mysql_query(). row required. The number of rows in the new result set pointer you want to set. 0 indicates the first record.
Description
mysql_data_seek() moves the row pointer inside the MySQL result specified by the data parameter to the specified row number. Then calling mysql_fetch_row() will return that row. row starts from 0. The value range of row should be from 0 to mysql_num_rows - 1. But if the result set is empty (mysql_num_rows() == 0), moving the pointer to 0 will fail with an E_WARNING level error and mysql_data_seek() will return false.
Return value
Returns true if successful, false if failed.
Tips and Notes
Note: mysql_data_seek() can only be used with mysql_query(), not mysql_unbuffered_query().
Array ( [0] => Carter [1 ] => Thomas [2] => Beijing )
http://www.bkjia.com/PHPjc/326166.htmlwww.bkjia.comtruehttp: //www.bkjia.com/PHPjc/326166.htmlTechArticleCopy the code as follows: ? // Start snipit 1 $sql = "SELECT * from table"; $result = mysql_query($sql); while ($row = mysql_fetch_assoc($result)) { // do stuff with $row } mysql_...
Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn