Home > Backend Development > PHP Tutorial > How does mysql jump to a specified record mysql_field_seek tutorial_PHP tutorial

How does mysql jump to a specified record mysql_field_seek tutorial_PHP tutorial

WBOY
Release: 2016-07-13 17:03:54
Original
1172 people have browsed it

The function of mysql_field_seek is to adjust the record set returned by mysql_query to the record we specify. If there is one, it will return the current record. If not, it will be false;

<pre class="brush:php;toolbar:false"><strong>mysql_field_seek语法:</strong>
Copy after login
mysql_field_seek(data,field_offset)
Copy after login
参数:
Copy after login
data:必须 指的是mysql_query正确返回的数据集.
Copy after login
field_offset:指定位置.不写代码从0开始
Copy after login
看个mysql_feild_seek实例.
Copy after login
<?
Copy after login
<pre class="brush:php;toolbar:false">$sql = "SELECT * from Person";
Copy after login
 
Copy after login
Copy after login
Copy after login
Copy after login
Copy after login
$result = mysql_query($sql,$con);
Copy after login
 
Copy after login
Copy after login
Copy after login
Copy after login
Copy after login
mysql_field_seek($result,3);
Copy after login
 
Copy after login
Copy after login
Copy after login
Copy after login
Copy after login
print_r(mysql_fetch_field($result));
Copy after login
 
Copy after login
Copy after login
Copy after login
Copy after login
Copy after login
mysql_close($con);
Copy after login
 
Copy after login
Copy after login
Copy after login
Copy after login
Copy after login
?>
Copy after login
 
Copy after login
Copy after login
Copy after login
Copy after login
输出结果.
Copy after login
stdClass Object<br>(<br>[name] => Age<br>[table] => Person<br>[def] =><br>[max_length] => 2<br>[not_null] => 0<br>[primary_key] => 0<br>[multiple_key] => 0<br>[unique_key] => 0<br>[numeric] => 1<br>[blob] => 0<br>[type] => int<br>[unsigned] => 0<br>[zerofill] => 0<br>)
Copy after login
 
Copy after login
Copy after login
Copy after login
Copy after login
 
Copy after login
Copy after login
Copy after login
Copy after login
 
Copy after login
Copy after login
Copy after login
Copy after login

www.bkjia.comtruehttp: //www.bkjia.com/PHPjc/630892.htmlTechArticleThe function of mysql_field_seek is to adjust the record set returned by mysql_query to the record we specified, and if there is one, return the current Record, if not, it is false; mysql_field_seek syntax: mysql_fi...
source:php.cn
Statement of this Website
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
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template