Use mysql_fetch_array() in PHP to get the current row data

This article is a detailed analysis and introduction to the method of using mysql_fetch_array() to obtain the current row data. Friends who need it can refer to it

Similar to mysql_fetch_row(), the function mysql_fetch_array() also obtains the result set The current row of data will automatically slide to the next row after being called. Its definition is as follows.

array mysql_fetch_array(int result, int [result_type])

The parameter description is as follows.
(1) result: The result identifier returned by the function mysql_query() or mysql_db_query(), used to specify the SQL statement type of the data to be obtained.
(2) result_type: used to specify the result set type, optional, the value range is the PHP constant set {MYSQL_ASSOC, MYSQL_NUM, MYSQL_BOTH}.
The function return value is as follows.
Success: An array that contains the current row data information in the query result set. The array subscript ranges from 0 to the number of record attributes −1, the i-th in the array The element value is the value on the i-th attribute of the record. At the same time, you can use the attribute name to get the value of the attribute.
Failed: false.
The following example uses mysql_fetch_array() to obtain book information with a price of not less than 20 in the Computers data table.

1    <!----使用mysql_fetch_array()来获取数据：mysql_fetch_array.php---->
2        <?php
3        //连接并选择到数据库服务器
4        $connection = mysql_connect ("localhost", "root", "password");
5        mysql_select_db("Books", $connection);
6        //查询数据
7        $query="SELECT * FROM Computers ";
8        $query.="WHERE price >= 20";
9        //echo $query."<br>";
10       $result=mysql_query($query,$connection);
11       //mysql_fetch_array()获得数据，并输出
12       while($row=mysql_fetch_array($result))
13       {
14            echo "书名：    ".$row[1]."<br>";
15            echo "价格：    ".$row["price"]."<br>";
16            echo "出版日期：    ".$row["publish_date"]."<br>";
17            echo "<br>";
18       }
19   ?>

The example uses mysql_fetch_array() on line 12 to obtain the current row data, and then uses the attribute index and attribute name in the loop on lines 12 to 18 to obtain the value of an attribute in this row. It is not difficult to see from this that the difference between mysql_fetch_array() and mysql_fetch_row() is that the former returns two backups of the result set saved in the array, one can be accessed through the attribute index, and the other can be accessed through the attribute name.
Note
When accessing the value on an attribute through the attribute name, if there are several attributes with the same name, the attribute with the later index will be replaced by the previous one. The attribute value is overwritten. Therefore, when using attribute names to obtain data, avoid duplicate attribute names in the query result set.
The results of the example run are as follows.

书名： 数据结构
价格： 20
出版日期： 2001-01-01
书名： C语言
价格： 23
出版日期： 1998-04-04
书名： PHP入门技术
价格： 22
出版日期： 2005-05-01

The above is the entire content of this article. I hope it will be helpful to everyone's study. For more related content, please pay attention to the PHP Chinese website!

Related recommendations:

About the functional analysis of common functions of the Common/common.php file in ThinkPHP

php encapsulated Database functions and usage

Usage analysis of initialize() and constructor construct() in ThinkPHP

The above is the detailed content of Use mysql_fetch_array() in PHP to get the current row data. For more information, please follow other related articles on the PHP Chinese website!