mysqli如何查看字段名?貌似没有mysqli_field_name这个函数! 如题,请教下 php使用mysqli连接,如何获取表的字段名呢? 如使用mysql_field_name 麻烦知道的说下,谢谢! 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 $result = mysqli_query($link, "desc tablename"); mysqli_result::fetch_fieldsmysqli_fetch_fields(PHP 5)mysqli_result::fetch_fields -- mysqli_fetch_fields — Returns an array of objects representing the fields in a result set<?php$link = mysqli_connect("localhost", "my_user", "my_password", "world");/* check connection */if (mysqli_connect_errno()) { printf("Connect failed: %s\n", mysqli_connect_error()); exit();}$query = "SELECT * from yourtablename";if ($result = mysqli_query($link, $query)) { /* Get field information for all columns */ $finfo = mysqli_fetch_fields($result); foreach ($finfo as $val) { printf("Name: %s\n", $val->name); printf("Table: %s\n", $val->table); printf("max. Len: %d\n", $val->max_length); printf("Flags: %d\n", $val->flags); printf("Type: %d\n\n", $val->type); } mysqli_free_result($result);}/* close connection */mysqli_close($link);?> PHP 程序有问题。访问路径多个/ 符号网站 图片显示不出来 求一个正则表达式! 寻找高手,关于 foreach from的问题 高手请进变量取不到值? 使用PHP架构嵌套数组,在线等 求一套无Javascript的PHP+MYSQL方案网站源代码 php 如何实现消息预知功能 一个问题解决不了,高手看啦 php 如何取得网页原始码 做php项目时,数据表中的外键是自动成生的吗 怎么设置网站的主页 关于织梦的问题 表单里面套表单怎么执行?
mysqli_fetch_fields(PHP 5)mysqli_result::fetch_fields -- mysqli_fetch_fields — Returns an array of objects representing the fields in a result set
<?php
$link = mysqli_connect("localhost", "my_user", "my_password", "world");/* check connection */
if (mysqli_connect_errno()) {
printf("Connect failed: %s\n", mysqli_connect_error());
exit();
}$query = "SELECT * from yourtablename";if ($result = mysqli_query($link, $query)) { /* Get field information for all columns */
$finfo = mysqli_fetch_fields($result); foreach ($finfo as $val) {
printf("Name: %s\n", $val->name);
printf("Table: %s\n", $val->table);
printf("max. Len: %d\n", $val->max_length);
printf("Flags: %d\n", $val->flags);
printf("Type: %d\n\n", $val->type);
}
mysqli_free_result($result);
}/* close connection */
mysqli_close($link);
?>