Home >Backend Development >PHP Tutorial >Quickly master the skills of obtaining field data type in PHP_PHP tutorial
For a beginner, they must learn to flexibly use various
mysql_field_type() function to obtain the data type of the field during the learning process , the syntax format of this function is as follows.
string mysql_field_type ( resource $result, int $field_offset )
The mysql_field_type() function is similar to the function mysql_field_name(), but the mysql_field_type() function returns the data type of the field. Its parameters are described below.
l result: the result set returned after the mysql_query() function is executed.
l field_offset: The offset of the field, starting from zero.
The sample code using the mysql_field_type() function is as follows:
Code 23-12 CD codes Chapter 23 23.3mysql_field_type.php
<ol class="dp-xml"> <li class="alt"><span><span class="tag"><</span><span> ?php </span></span></li><li><span>$</span><span class="attribute">connection</span><span>=</span><span class="attribute-value">mysql_connect</span><span>("localhost",<br />"root","root") or die("连接服务器失败"); </span></li><li class="alt"><span>mysql_select_db("sunyang",$connection) <br />or die("选择数据库失败"); </span></li><li><span>$</span><span class="attribute">query</span><span>=</span><span class="attribute-value">"select * from employee"</span><span>; </span></li><li class="alt"><span>$</span><span class="attribute">result</span><span>=</span><span class="attribute-value">mysql_query</span><span>($query) or die<br />("查询数据失败"); </span></li><li><span>//执行查询 </span></li><li class="alt"><span>echo mysql_field_type($result,0); </span></li><li><span>//第一个字段的数据类型 </span></li><li class="alt"><span>echo "</span><span class="tag"><</span><span> </span><span class="tag-name">br</span><span class="tag">></span><span>"; </span></span></li> <li><span>echo mysql_field_type($result,1); </span></li> <li class="alt"><span>//第二个字段的数据类型 </span></li> <li> <span>echo "</span><span class="tag"><</span><span> </span><span class="tag-name">br</span><span class="tag">></span><span>"; </span> </li> <li class="alt"><span>echo mysql_field_type($result,2); </span></li> <li><span>//第三个字段的数据类型 </span></li> <li class="alt"><span>mysql_free_result($result); </span></li> <li><span>mysql_close(); </span></li> <li class="alt"> <span class="tag">?></span><span> </span> </li> </ol>
After the above code is executed, the data types of the first three fields in the employee table will be output.