Home > Article > Backend Development > Two methods to obtain mysql column information in PHP_PHP Tutorial
Two methods to obtain mysql column information in PHP_PHP Tutorial
- WBOYOriginal
- 2016-07-13 10:35:451312browse
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：PHP performance monitoring test----Xhprof_PHP tutorialNext article：PHP performance monitoring test----Xhprof_PHP tutorial