Home  >  Article  >  php教程  >  在php中 取得mysql 列信息的两种方法

在php中 取得mysql 列信息的两种方法

WBOY
WBOYOriginal
2016-06-13 09:40:391096browse

1、使用mysql_fetch_field

$query=$db->query(" SELECT * FROM $tablename limit 1");

$num=mysql_num_fields($query);
for($i=0;$i {
$f_db=mysql_fetch_field($query,$i);
$showdb[]=$f_db->name;
}

2、使用show fields

$sqlr="show fields from $tablename";
$query=mysql_query($sqlr);
while($row=mysql_fetch_array($query))
{
print_r($row);
$data[]=$row['Field'];
}


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
Previous article:手动12Next article:PHP性能监控测试----Xhprof