恰当应用函数实现PHP获取表字段名-php手册-php.cn

Home

php教程

php手册

恰当应用函数实现PHP获取表字段名

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB

Jun 13, 2016 am 11:12 AM

mysqlphpfunctionexistFieldaccomplishapplicationObtainsurfaceusepass

在运用

PHP获取表字段名通过mysql_field_name()函数来实现，该函数的语法格式如下：

string mysql_field_name ( resource $result, int $field_offset )

mysql_field_name()函数将返回指定索引的字段的名字，它的参数的描述如下。

l result：mysql_query()函数执行后返回的结果集。

l field_offset：字段的偏移量，起始值为零。

使用mysql_field_name()函数的PHP获取表字段名示例代码如下：

?php
$connection=mysql_connect("localhost",
"root","root") or die("连接服务器失败");
mysql_select_db("sunyang",$connection)
or die("选择数据库失败");
$query="select * from employee";
$result=mysql_query($query) or
die("查询用户失败");
echo mysql_field_name($result,0);
//输出第一个字段名
echo "br>";
echo mysql_field_name($result,1);
//输出第二个字段名
mysql_close($connection);
?>

在上面PHP获取表字段名代码中可输出第一个字段名和第二个字段名。

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

Hot AI Tools

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

Online AI tool for removing clothes from photos.

Undress AI Tool

Undress images for free

Clothoff.io

AI clothes remover

Video Face Swap

Swap faces in any video effortlessly with our completely free AI face swap tool!

Hot Article

How to fix KB5055523 fails to install in Windows 11?

3 weeks agoByDDD

How to fix KB5055518 fails to install in Windows 10?

3 weeks agoByDDD

Strength Levels for Every Enemy & Monster in R.E.P.O.

3 weeks agoBy尊渡假赌尊渡假赌尊渡假赌

Roblox: Dead Rails - How To Tame Wolves

3 weeks agoByDDD

Blue Prince: How To Get To The Basement

3 weeks agoByDDD

Hot Tools

WebStorm Mac version

Useful JavaScript development tools

MinGW - Minimalist GNU for Windows

This project is in the process of being migrated to osdn.net/projects/mingw, you can continue to follow us there. MinGW: A native Windows port of the GNU Compiler Collection (GCC), freely distributable import libraries and header files for building native Windows applications; includes extensions to the MSVC runtime to support C99 functionality. All MinGW software can run on 64-bit Windows platforms.