Summary of usage of mysql_fetch_field() function

mysql_init initializes the database link – gets a link mysql_real_connect connects to the database server and executes the mysql_query query – the query statement is a string that retrieves each row separately mysql_store_result – the results are stored in the link and are a one-time query. Get the table header from the result set Information – mysql_fetch_fields – header information is stored in the memory space pointed to by the MYSQL_FIELD type pointer. Parse the header – mysql_field_count to obtain the number of columns. The for loop parses column by column. mysql_fetch_row obtains data row by row from the result set and releases memory after parsing each column for each row. Space close link specific code #include #include #include #include

1. MySQL Getting Started Simple Data Query

Introduction: mysql_init initializes the database link – gets a link mysql_real_connect connects to the database server and executes the mysql_query query – the query statement is a string that retrieves each row separately mysql_store_result – the results are stored in the link and are a one-time query from the result set , Get the header information – mysql_fetch_fields – The header information is stored in the memory space pointed to by the MYSQL_FIELD type pointer. Parse the header – mysql_field_count to get the number of columns. The for loop parses mysql_fetch_row column by column from the result set one row at a time.

2. mysql tutorial: Read the data table field name mysql_fetch_field()_PHP tutorial

Introduction: mysql tutorial: Read the data table field name mysql_fetch_field( ). Now let's take a look at the mysql_fetch_field() function. This function reads the example name and field name of the mysql data table. Let's take a look at its syntax. mysql_fetch_field(data,field_o

3. Two ways to get mysql column information in php_PHP tutorial

Introduction: Two ways to get mysql column information in php Method. 1. Use 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

4. Two methods to obtain mysql column information in php_PHP tutorial

Introduction: Two methods to obtain mysql column information in php 1. Use mysql_fetch_field $query=$db-query( SELECT * FROM $tablename limit 1); $num=mysql_num_fields. ($query); for($i=0;$i$num;$i++) { $f_db=mysql_fetch_field($query,$i); $showdb[

##5. Mysql_fetch_field and mysqli_fetch_field problems?

#Introduction: mysql_fetch_field and mysqli_fetch_field problems?

#6.

mysql tutorial: Read the data table field name mysql_fetch_field()

Introduction: mysql tutorial: Read the data table field name mysql_fetch_field(). Now let’s take a look at the mysql_fetch_field() function. This function reads the example name and field name of the mysql data table. Let's take a look at its syntax. mysql_fetch_field(data,field_o

7.

In php Two ways to get mysql column information in php

Introduction: Two ways to get mysql column information in php. 1. Use 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

8.

Two methods to obtain mysql column information in php

Introduction: Two methods to obtain mysql column information in php 1. Use mysql_fetch_field $query=$db-query( SELECT * FROM $tablename limit 1); $num=mysql_num_fields($query); for($i=0;$i$num;$i++) { $f_db=mysql_fetch_field($query,$i); $showdb[

9.

MySQL Some syntax and C API

Introduction: 25) MYSQL_FIELD *mysql_fetch_fields(MYSQL_RES *result)//All column information in the result set 26) MYSQL_RES *mysql_list_dbs(MYSQL *mysql, const

##10. Automatically filter POST data

Introduction: No details None//Get all fields in the current table public function _facade($post){$data = array( );$arr=array();$sql = 'select * from '.$this-table;$res = $this-db-ftable($sql);for($i=0;$imysql_num_fields($res) ;$i++){$m = mysql_fetch_field($res);$m = $m-

The above is the detailed content of Summary of usage of mysql_fetch_field() function. For more information, please follow other related articles on the PHP Chinese website!