Home >Backend Development >PHP Tutorial >Quickly master the skills of obtaining field data type in PHP_PHP tutorial

Quickly master the skills of obtaining field data type in PHP_PHP tutorial

WBOY
WBOYOriginal
2016-07-15 13:35:091156browse

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.


www.bkjia.comtruehttp: //www.bkjia.com/PHPjc/445931.htmlTechArticleFor a beginner, they must learn to flexibly use various mysql_field_type( ) function can obtain the data type of the field. The syntax format of this function is as follows. ...
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