简体中文(ZH-CN) English(EN) 繁体中文(ZH-TW) 日本語(JA) 한국어(KO) Melayu(MS) Français(FR) Deutsch(DE)
Home > Backend Development > PHP Tutorial > body text

Use php to get table field information

WBOY
Release： 2016-07-25 09:11:46
Original
1479 people have browsed it

php中获取字段信息，可以用到以下的函数： mysql_fetch_field() mysql_num_fields() mysql_list_fields() mysql_field_flags() mysql_field_len() mysql_field_name() mysql_field_type() mysql_field_table()

字段的属性有： name ,table,max_length,not_null,primary_key,unique_key,multiple_key,numeric,blob,type,unsigned,zerofill

举例：

  2. $link=mysql_connect("localhost","root","root") or die("couldn't connect:".mysql_error());
  3. mysql_select_db("rorely");
  4. $result=mysql_query("select * from test")or die("query failed:".mysql_error());
  5. for($i=0;$i $meta=mysql_fetch_field($result);
  6. if(!$meta) echo "没有字段信息.
    ";
  7. echo "
    ".$meta->name."<br>".$meta->type."<br>".$meta->max_length."<hr>
    ";
  8. }
  9. mysql_free_result($result);
  11. ?>
复制代码

结果如下： id int 2

name string 4

age int 2

sex string 6

address string 16



Related labels：
使用 php 获取表的字段信息
source：php.cn
Previous article：PHP microtime usage tips Next article：php mysqli multiple query example
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
What are the best practices for displaying version information in web applications? I'm developing a web application. What are the best practices for displaying version infor...
From 2024-04-06 19:13:16
0
2
476
How do I get my image to appear on the page's main display? What I want to do is receive some photos using NASAAPI. These photos are then displayed on...
From 2024-04-06 15:33:12
0
1
433
How to render data through DOM instead of through table I have a question about an application I'm creating, I'm using an Oracle database and I'm ...
From 2024-04-04 18:17:27
0
1
3567
Connect your account and get your tokens easily with DocuSign's simple button I'm using the sdk version and almost get what I want, but it's not clear yet. How can we c...
From 2024-04-04 15:46:02
0
1
396
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
About us Disclaimer Sitemap
php.cn：Public welfare online PHP training，Help PHP learners grow quickly！