Community Learn Tools Library Leisure
search
English
Home > Backend Development > PHP Tutorial > Two methods to obtain mysql column information in PHP_PHP Tutorial

Two methods to obtain mysql column information in PHP_PHP Tutorial

WBOY
Release： 2016-07-13 10:35:45
Original
1319 people have browsed it

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'];
}


www.bkjia.comtruehttp://www.bkjia.com/PHPjc/742413.htmlTechArticle1、使用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...
Related labels：
在php中 取得mysql 列信息的两种方法
source：php.cn
Previous article：PHP performance monitoring test----Xhprof_PHP tutorial Next article：php static delayed static binding_PHP tutorial
Statement of this Website
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
Latest Articles by Author
Latest Issues
PHP arrays obtained from URL parameters do not behave as expected I have a URL parameter that contains the category ID and I want to treat it as an array li...
From 2024-04-06 22:09:02
0
1
1428
Move the content to the left by adding the Width property I have provided margins to the body. main {left margin: 200px; right margin: 200px; text a...
From 2024-04-06 22:01:35
0
3
816
Where should I place CustomLog directive in apache I'm using php:7.2-apachedocker. I need to disable health check url login access log. Based...
From 2024-04-06 22:03:59
0
1
990
The page suddenly cannot pull css or bootstrap So I'm developing a page, I did part of it yesterday and it worked great, and today I cont...
From 2024-04-06 21:58:04
0
1
800
How to trigger render (with filter and pagination) on sort method in React? Here is my Sort.js style component: <SortWrapper><SortText>SortBy</SortText...
From 2024-04-06 21:28:37
0
1
2257
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template