Home > Article > Backend Development > How does mysql jump to a specified record mysql_field_seek tutorial_PHP tutorial
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>
mysql_field_seek(data,field_offset)
参数:
data:必须 指的是mysql_query正确返回的数据集.
field_offset:指定位置.不写代码从0开始
看个mysql_feild_seek实例.
<?
<pre class="brush:php;toolbar:false">$sql = "SELECT * from Person";
$result = mysql_query($sql,$con);
mysql_field_seek($result,3);
print_r(mysql_fetch_field($result));
mysql_close($con);
?>
输出结果.
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>)