Database
Mysql Tutorial
Use mysql_fetch_array() to obtain information in the array result set (PHP method 4 for operating MySQL database)
Use mysql_fetch_array() to obtain information in the array result set (PHP method 4 for operating MySQL database)
How PHP operates the MySQL database - use the mysql_fetch_array() function to obtain information in the array result set
The mysql_fetch_array() function obtains a row from the result set as an association Array, or numeric array, or both Returns an array based on the rows taken from the result set, or false if there are no more rows.
In the previous article "Using the mysql_query() function to execute SQL statements (PHP method three for operating MySQL database)", the mysql_query() function is introduced to execute SQL statements. Next, use The mysql_fetch_array() function fetches information from the result set.
Related mysql video tutorial recommendations: "mysql tutorial"
mysql_fetch_array() The syntax structure of the function is as follows:
array mysql_fetch_array(resource result[,int result_type])
result: resource Type parameter, what is passed in is the data pointer returned by the mysql_query() function.
result_type: optional, integer parameter, to be passed in are 3 index types: MYSQL_ASSOC (associative index), MYSQL_NUM (numeric index), MYSQL_BOTH (array containing both associative and numeric indexes), default value for MYSQL_BOTH.
Note:
The field names returned by the mysql_fetch_array() function are case-sensitive. This is the most easily overlooked issue for beginners.
The following example implements a retrieval function. First, use the mysql_query() function to execute SQL statements and query information, then use the mysql_fetch_array() function to obtain the query results, and finally use echo data to output the array result set.
The specific development steps are as follows:
1. Create a PHP dynamic page, name it index.php, add a form, a text box and a submit button to index.php. The specific code is as follows ：
<html>
<body>
<!--上传文件表单-->
<form method="post" action="" name = form1>
<table>
<tr>
<td width="605" height="51" bgcolor="#CC99FF">
<p align="center">请输入查询内容
<input type="text" name="txt_book" id="txt_book" size="25">
<input type="submit" name="Submit" value="查询">
</p>
</td>
</tr>
</table>
</form>
</body>
</html>2. Connect to the MySQL database server, select the database php_cn, and set the encoding format of the database to GB2312. The specific code is as follows:
<?php
header("Content-Type:text/html; charset=utf-8");
$link = mysql_connect("localhost","root","root")or die("连接数据库失败".mysql_error());
mysql_select_db("php_cn",$link);
mysql_query("set names gb2312"); //设置编码，防止发生乱发
?>3. Use the if conditional statement to determine whether the user clicks the "Query" button. If so, use the POST method to accept the passed information, and use the mysql_query() function to execute the SQL statement. The query The statement is mainly used to implement fuzzy query of information, and the query result is assigned to the variable $sql. Then use the mysql_fetch_array() function to obtain information from the array result set. The specific code is as follows:
<?php
$sql = mysql_query("select from tb_book"); //执行查询语句
$info = mysql_fetch_array($sql); //获取查询结果，返回值为数组
if($_POST['Submit']=="查询"){ // 判断按钮的值是否为查询
$txt_book = $_POST['txt_book']; //获取文本框提交的值
$sql = mysql_query("select * from tb_book where bookname like '%".trim($txt_book)."%'"); //执行模糊查询
$info = mysql_fetch_array($sql); // 获取查询结果
}
?>Note:
The above example When querying blurred vision, the wildcard character "%" is used. "%" means zero or any more characters!
4. Use the if conditional statement to judge the result set variable $info. If the value is false, then use the echo statement to output that the retrieved information does not exist. The specific code is as follows:
<?php
if($info = false){ //如果检索的信息不存在，则输出相对的提示信息
echo "<p align='center' style='color: #FF0000;font-size: 12px'>对不起，你要查询的信息不存在</p>";
}
?>5. Use the do...while loop statement to output the information in the array result set $info[] in tabular form. The name of a field is the index. Use the echo statement to output the information in the array $info[]. The specific code is as follows :
<?php
do { //do...while 循环
?>
<table>
<tr align="left" bgcolor="#FFFFFF">
<td height="20" align="center"><?php echo $info["id"] ?></td>
<td height="20" align="center"><?php echo $info["bookname"] ?></td>
<td height="20" align="center"><?php echo $info["data"] ?></td>
<td height="20" align="center"><?php echo $info["price"] ?></td>
<td height="20" align="center"><?php echo $info["maker"] ?></td>
<td height="20" align="center"><?php echo $info["publisher"] ?></td>
</tr>
</table>
<?php
}while($info = mysql_fetch_array($sql));
?>The output results are as follows:
We will introduce the use of the mysql_fetch_array() function here. In the next section, we will introduce the array results. Get a row in the result set as an object. For details, please read "Use the mysql_fetch_object() function to get a row in the result set as an object (Method 5 of PHP operating MySQL database)"!
The above is the detailed content of Use mysql_fetch_array() to obtain information in the array result set (PHP method 4 for operating MySQL database). For more information, please follow other related articles on the PHP Chinese website!
Hot AI Tools
Undresser.AI Undress
AI-powered app for creating realistic nude photos
AI Clothes Remover
Online AI tool for removing clothes from photos.
Undress AI Tool
Undress images for free
Clothoff.io
AI clothes remover
Video Face Swap
Swap faces in any video effortlessly with our completely free AI face swap tool!
Hot Article
Hot Tools
Notepad++7.3.1
Easy-to-use and free code editor
SublimeText3 Chinese version
Chinese version, very easy to use
Zend Studio 13.0.1
Powerful PHP integrated development environment
Dreamweaver CS6
Visual web development tools
SublimeText3 Mac version
God-level code editing software (SublimeText3)
Hot Topics
1664
14
1423
52
1318
25
1269
29
1248
24
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.
Explain the purpose of foreign keys in MySQL.
Apr 25, 2025 am 12:17 AM
In MySQL, the function of foreign keys is to establish the relationship between tables and ensure the consistency and integrity of the data. Foreign keys maintain the effectiveness of data through reference integrity checks and cascading operations. Pay attention to performance optimization and avoid common errors when using them.
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.
Compare and contrast MySQL and MariaDB.
Apr 26, 2025 am 12:08 AM
The main difference between MySQL and MariaDB is performance, functionality and license: 1. MySQL is developed by Oracle, and MariaDB is its fork. 2. MariaDB may perform better in high load environments. 3.MariaDB provides more storage engines and functions. 4.MySQL adopts a dual license, and MariaDB is completely open source. The existing infrastructure, performance requirements, functional requirements and license costs should be taken into account when choosing.
What happens if session_start() is called multiple times?
Apr 25, 2025 am 12:06 AM
Multiple calls to session_start() will result in warning messages and possible data overwrites. 1) PHP will issue a warning, prompting that the session has been started. 2) It may cause unexpected overwriting of session data. 3) Use session_status() to check the session status to avoid repeated calls.
SQL vs. MySQL: Clarifying the Relationship Between the Two
Apr 24, 2025 am 12:02 AM
SQL is a standard language for managing relational databases, while MySQL is a database management system that uses SQL. SQL defines ways to interact with a database, including CRUD operations, while MySQL implements the SQL standard and provides additional features such as stored procedures and triggers.
Composer: Aiding PHP Development Through AI
Apr 29, 2025 am 12:27 AM
AI can help optimize the use of Composer. Specific methods include: 1. Dependency management optimization: AI analyzes dependencies, recommends the best version combination, and reduces conflicts. 2. Automated code generation: AI generates composer.json files that conform to best practices. 3. Improve code quality: AI detects potential problems, provides optimization suggestions, and improves code quality. These methods are implemented through machine learning and natural language processing technologies to help developers improve efficiency and code quality.
MySQL: The Database, phpMyAdmin: The Management Interface
Apr 29, 2025 am 12:44 AM
MySQL and phpMyAdmin can be effectively managed through the following steps: 1. Create and delete database: Just click in phpMyAdmin to complete. 2. Manage tables: You can create tables, modify structures, and add indexes. 3. Data operation: Supports inserting, updating, deleting data and executing SQL queries. 4. Import and export data: Supports SQL, CSV, XML and other formats. 5. Optimization and monitoring: Use the OPTIMIZETABLE command to optimize tables and use query analyzers and monitoring tools to solve performance problems.
