Home Database Mysql Tutorial Use the mysql_fetch_row() function to obtain each record in the result set row by row (PHP method 6 for operating MySQL database)

Use the mysql_fetch_row() function to obtain each record in the result set row by row (PHP method 6 for operating MySQL database)

Apr 20, 2017 pm 01:47 PM
mysql php

Use the mysql_fetch_row() function to obtain each record in the result set row by row (PHP method 6 for operating MySQL database)

We introduced two types earlier To obtain the data in the result set, today we will introduce to you the third mysql_fetch_row() function to obtain the result set. The usage of this function is similar to the function mentioned above!

In the previous articles "Use the mysql_fetch_array() function to obtain the information in the array result set (PHP method 4 for operating MySQL database)" and "Use the mysql_fetch_object() function to obtain the results Concentrate one row as an object (Method 5 of PHP operating MySQL database) " introduced the mysql_fetch_array() function and mysql_fetch_object() function. In this chapter, we introduce the mysql_fetch_row() function in detail!

The syntax format of the function is as follows:

1

array mysql_fetch_row(resource result)

Copy after login

mysql_fetch_row() function obtains a row of data from the result set associated with the specified result identifier and returns it as an array. This row is assigned to the array variable $row. The column of each result is stored in an array element. Starting from 0, the first array element is accessed in the form of $row[0] (the same is true when there is only one element). A call to the mysql_fetch_row() function will return the result. The next row in the set will return false if there are no more rows.

Note: The field names returned by this function are case-sensitive!

The following example has the same function as the previous article. The difference is that the following example obtains each record in the result set row by row through the mysql_fetch_row() function. Then use the echo statement to output the book information corresponding to each field from the array result set.

The specific development steps are as follows:

1. The implementation process of creating a project, adding a form, connecting to the database, and selecting the database is the same as in the previous article, so I won’t repeat it here for those who are unclear. Friends, you can check it out. This article is linked to the previous article.

2. Different from the previous article, this example uses the mysql_fetch_row() function to obtain the records in the result set row by row. The core code is as follows:

1

2

3

4

5

6

7

8

9

<?php

$sql = mysql_query("select * from tb_book");

$row = mysql_fetch_row($sql);

if ($_POST["Submit"]=="查询"){

    $txt_book = $_POST["txt_book"];

    $sql = mysql_query("select * from tb_book where bookname like &#39;%".trim($txt_book)."%&#39;"); //执行模糊查询

    $row = mysql_fetch_row($sql);  //逐行获取查询结果,返回值为数组

}

?>

Copy after login

3. Use the if conditional statement to The result set variable $row is judged. If the value is false, then the information you retrieve does not exist. Otherwise, use the do...while loop statement to output the information in the result set in the form of an array. The core code is as follows:

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

<?php

if ($row == false){

    echo "<p align=&#39;center&#39; style=&#39;color: #FF0000;font-size: 12px&#39;>对不起,你要查询的信息不存在</p>";

}

?>

<?php

do {

    ?>

    <table>

        <tr align="left" bgcolor="#FFFFFF">

            <td height="20" align="center"><?php echo $row[0] ?></td>

            <td height="20" align="center"><?php echo $row[1] ?></td>

            <td height="20" align="center"><?php echo $row[2] ?></td>

            <td height="20" align="center"><?php echo $row[3] ?></td>

            <td height="20" align="center"><?php echo $row[4] ?></td>

            <td height="20" align="center"><?php echo $row[5] ?></td>

        </tr>

    </table>

    <?php

}while ($row = mysql_fetch_row($sql));

?>

Copy after login

The results of the above example are the same as those of the previous two articles. The pictures are pasted here. Friends can try it locally!

In the next article, we will introduce how to obtain the records in the query result set. For details, please read "Use the mysql_num_rows() function to obtain the number of records in the result set row by row (Method 7 of PHP operating MySQL database)

The above is the detailed content of Use the mysql_fetch_row() function to obtain each record in the result set row by row (PHP method 6 for operating MySQL database). For more information, please follow other related articles on the PHP Chinese website!

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

Hot AI Tools

Undresser.AI Undress

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

AI Clothes Remover

Online AI tool for removing clothes from photos.

Undress AI Tool

Undress AI Tool

Undress images for free

Clothoff.io

Clothoff.io

AI clothes remover

Video Face Swap

Video Face Swap

Swap faces in any video effortlessly with our completely free AI face swap tool!

Hot Tools

Notepad++7.3.1

Notepad++7.3.1

Easy-to-use and free code editor

SublimeText3 Chinese version

SublimeText3 Chinese version

Chinese version, very easy to use

Zend Studio 13.0.1

Zend Studio 13.0.1

Powerful PHP integrated development environment

Dreamweaver CS6

Dreamweaver CS6

Visual web development tools

SublimeText3 Mac version

SublimeText3 Mac version

God-level code editing software (SublimeText3)

Hot Topics

Java Tutorial
1655
14
PHP Tutorial
1252
29
C# Tutorial
1226
24
Laravel Introduction Example Laravel Introduction Example Apr 18, 2025 pm 12:45 PM

Laravel is a PHP framework for easy building of web applications. It provides a range of powerful features including: Installation: Install the Laravel CLI globally with Composer and create applications in the project directory. Routing: Define the relationship between the URL and the handler in routes/web.php. View: Create a view in resources/views to render the application's interface. Database Integration: Provides out-of-the-box integration with databases such as MySQL and uses migration to create and modify tables. Model and Controller: The model represents the database entity and the controller processes HTTP requests.

Solve database connection problem: a practical case of using minii/db library Solve database connection problem: a practical case of using minii/db library Apr 18, 2025 am 07:09 AM

I encountered a tricky problem when developing a small application: the need to quickly integrate a lightweight database operation library. After trying multiple libraries, I found that they either have too much functionality or are not very compatible. Eventually, I found minii/db, a simplified version based on Yii2 that solved my problem perfectly.

The Continued Use of PHP: Reasons for Its Endurance The Continued Use of PHP: Reasons for Its Endurance Apr 19, 2025 am 12:23 AM

What’s still popular is the ease of use, flexibility and a strong ecosystem. 1) Ease of use and simple syntax make it the first choice for beginners. 2) Closely integrated with web development, excellent interaction with HTTP requests and database. 3) The huge ecosystem provides a wealth of tools and libraries. 4) Active community and open source nature adapts them to new needs and technology trends.

Laravel framework installation method Laravel framework installation method Apr 18, 2025 pm 12:54 PM

Article summary: This article provides detailed step-by-step instructions to guide readers on how to easily install the Laravel framework. Laravel is a powerful PHP framework that speeds up the development process of web applications. This tutorial covers the installation process from system requirements to configuring databases and setting up routing. By following these steps, readers can quickly and efficiently lay a solid foundation for their Laravel project.

MySQL and phpMyAdmin: Core Features and Functions MySQL and phpMyAdmin: Core Features and Functions Apr 22, 2025 am 12:12 AM

MySQL and phpMyAdmin are powerful database management tools. 1) MySQL is used to create databases and tables, and to execute DML and SQL queries. 2) phpMyAdmin provides an intuitive interface for database management, table structure management, data operations and user permission management.

MySQL vs. Other Programming Languages: A Comparison MySQL vs. Other Programming Languages: A Comparison Apr 19, 2025 am 12:22 AM

Compared with other programming languages, MySQL is mainly used to store and manage data, while other languages ​​such as Python, Java, and C are used for logical processing and application development. MySQL is known for its high performance, scalability and cross-platform support, suitable for data management needs, while other languages ​​have advantages in their respective fields such as data analytics, enterprise applications, and system programming.

Solve MySQL mode problem: The experience of using the TheliaMySQLModesChecker module Solve MySQL mode problem: The experience of using the TheliaMySQLModesChecker module Apr 18, 2025 am 08:42 AM

When developing an e-commerce website using Thelia, I encountered a tricky problem: MySQL mode is not set properly, causing some features to not function properly. After some exploration, I found a module called TheliaMySQLModesChecker, which is able to automatically fix the MySQL pattern required by Thelia, completely solving my troubles.

The Compatibility of IIS and PHP: A Deep Dive The Compatibility of IIS and PHP: A Deep Dive Apr 22, 2025 am 12:01 AM

IIS and PHP are compatible and are implemented through FastCGI. 1.IIS forwards the .php file request to the FastCGI module through the configuration file. 2. The FastCGI module starts the PHP process to process requests to improve performance and stability. 3. In actual applications, you need to pay attention to configuration details, error debugging and performance optimization.

See all articles