Database
Mysql Tutorial
Use the mysql_fetch_object() function to obtain a row in the result set as an object (PHP method 5 for operating MySQL database)
Use the mysql_fetch_object() function to obtain a row in the result set as an object (PHP method 5 for operating MySQL database)
Use the mysql_fetch_object() function to obtain a row in the result set as an object (Method 5 of PHP operating MySQL database)
Use the mysql_fetch_object() function to also obtain the difference Selecting the data in the result set is similar to the function introduced in the previous article. Let's learn the difference in the use of these two functions through different methods in the same example.
In the previous article "Use mysql_fetch_array() to obtain information in the array result set (PHP method 4 for operating MySQL database)" we introduced the mysql_fetch_array() function to obtain the result set. So today we continue to introduce the mysql_fetch_object() function to obtain the result set.
First we look at the syntax format of the function as follows:
object mysql_fetch_object(resource result)
Note:
This extension is Obsolete in PHP 5.5.0, it was removed in PHP 7.0.0. Instead, the mysqli extension or pdo_mysql should be used. See the MySQL: Selection API Guide and related FAQ for more information.
The mysql_fetch_object() function is similar to the mysql_fetch_array() function, with one difference. The former returns an object instead of an array. This function only accesses the array through the field name. Use the following format to obtain it. The element value of the row in the result set.
$row->col_name //col_name为列名，$row代表结果集
For example, if you retrieve id and name values from a data table, you can use $row->id and $row->name to access the element values in the row.
Note:
#The fields returned by this function are also case-sensitive. This is the most easily overlooked issue for beginners learning programming. .
The following example uses the mysql_fetch_object() function to obtain the data information in the result set, and then uses the echo statement to output the book corresponding to each field from the result set in the form of "result set->column name" information.
The specific 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 mysql_fetch_object() function to obtain the data in the query result set, and the returned value is an object:
<?php
header("Content-Type:text/html; charset=utf-8");
$sql = mysql_query("select from tb_book"); //执行查询语句
$info = mysql_fetch_object($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); // 获取查询结果
}
?>4. Use the do...while loop statement , output the graphic and text information in the result set using the "Result Column -> Column Name" method. The 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_object($sql));
?>The output result is:
The The function is introduced here. In the next article, we will introduce another function, which is to obtain each record in the result set row by row. For details, please read "Using the mysql_fetch_row() function to obtain each record in the result set row by row (PHP Method 6 of operating MySQL database)》!
The above is the detailed content of Use the mysql_fetch_object() function to obtain a row in the result set as an object (PHP method 5 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
1666
14
1425
52
1324
25
1272
29
1251
24
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.
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.
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.
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.
Steps to add and delete fields to MySQL tables
Apr 29, 2025 pm 04:15 PM
In MySQL, add fields using ALTERTABLEtable_nameADDCOLUMNnew_columnVARCHAR(255)AFTERexisting_column, delete fields using ALTERTABLEtable_nameDROPCOLUMNcolumn_to_drop. When adding fields, you need to specify a location to optimize query performance and data structure; before deleting fields, you need to confirm that the operation is irreversible; modifying table structure using online DDL, backup data, test environment, and low-load time periods is performance optimization and best practice.
How to uninstall MySQL and clean residual files
Apr 29, 2025 pm 04:03 PM
To safely and thoroughly uninstall MySQL and clean all residual files, follow the following steps: 1. Stop MySQL service; 2. Uninstall MySQL packages; 3. Clean configuration files and data directories; 4. Verify that the uninstallation is thorough.
What is the significance of the session_start() function?
May 03, 2025 am 12:18 AM
session_start()iscrucialinPHPformanagingusersessions.1)Itinitiatesanewsessionifnoneexists,2)resumesanexistingsession,and3)setsasessioncookieforcontinuityacrossrequests,enablingapplicationslikeuserauthenticationandpersonalizedcontent.
