General steps for php to access mysql database
PHP access operationMySQL database can generally be divided into 5 steps: 1. Connect to the MySQL database server; 2. Select the database; 3. Execute the SQL statement; 4. Close the result Set; 5 Disconnect from the MySQL database server.
1. Use the mysql_connect() function to connect to the MySQL database server
Use the mysql_connect() function to establish a connection with the server. Different connections are then positioned based on the return value of this function.
$host = "localhost"; //MySQL服务器地址
$user = "root"; //用户名
$pwd = "***"; // 密码
$connID = mysql_connect($host, $user,$pwd); //返回的连接标识符
2. Use the mysql_select_db() function to select the database file
Use the mysql_select_db() function based on the connection identifier returned in the first step. Select the database
mysql_select_db( $dbName , $connID ); //$dbName 表示要选择的数据库
3. Use the mysql_query() function to execute the SQL statement
The first step: mysql_query("select * from tb_stu", $connID); //Execute the query and return the result set
Step 2: Obtain information from the above result set. There are two paths here. 1. Use the mysql_fetch_array() function to obtain information from the array result set; 2. Use the mysql_fetch_object() function to obtain a row from the result set as an object. The difference between them is that the return value of mysql_fetch_object() is an object, not an array, that is, the function can only access the array through the field name.
$result = mysql_fetch_array ( $query );
OR
$result = mysql_fetch_object ( $query );
There are generally five types of operations on data:
1. Query data (select)
2. Display data (select)
3. Insert data (insert)
4. Update data (update)
5. Delete data (delete)
4. Close the result set
After the database operation is completed, you need to close the result set and release the resources
mysql_free_result($result);
5. Close the mysql server connection
Every time you use the mysql_connect() or mysql_query() function, system resources will be consumed. To avoid wasting resources, use mysql_close () function closes the connection to the MySQL server to save system resources.
mysql_close($connID);
The above is the detailed content of General steps for php to access 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
PHP development practice: Use PHPMailer to send emails to users in the MySQL database
Aug 05, 2023 pm 06:21 PM
PHP development practice: Use PHPMailer to send emails to users in the MySQL database Introduction: In the construction of the modern Internet, email is an important communication tool. Whether it is user registration, password reset, or order confirmation in e-commerce, sending emails is an essential function. This article will introduce how to use PHPMailer to send emails and save the email information to the user information table in the MySQL database. 1. Install the PHPMailer library PHPMailer is
Go language and MySQL database: How to separate hot and cold data?
Jun 18, 2023 am 08:26 AM
As the amount of data continues to increase, database performance has become an increasingly important issue. Hot and cold data separation processing is an effective solution that can separate hot data and cold data, thereby improving system performance and efficiency. This article will introduce how to use Go language and MySQL database to separate hot and cold data. 1. What is hot and cold data separation processing? Hot and cold data separation processing is a way of classifying hot data and cold data. Hot data refers to data with high access frequency and high performance requirements. Cold data
To what extent can I develop MySQL database skills to be successfully employed?
Sep 12, 2023 pm 06:42 PM
To what extent can I develop MySQL database skills to be successfully employed? With the rapid development of the information age, database management systems have become an indispensable and important component in all walks of life. As a commonly used relational database management system, MySQL has a wide range of application fields and employment opportunities. So, to what extent do MySQL database skills need to be developed to be successfully employed? First of all, mastering the basic principles and basic knowledge of MySQL is the most basic requirement. MySQL is an open source relational database management
How to perform incremental data backup of MySQL database using Go language
Jun 17, 2023 pm 02:28 PM
As the amount of data increases, database backup becomes more and more important. For the MySQL database, we can use the Go language to achieve automated incremental backup. This article will briefly introduce how to use Go language to perform incremental backup of MySQL database data. 1. Install the Go language environment. First, we need to install the Go language environment locally. You can go to the official website to download the corresponding installation package and install it. 2. Install the corresponding library. The Go language provides many third-party libraries for accessing MySQL databases, among which the most commonly used ones are
How to use MySQL database for time series analysis?
Jul 12, 2023 am 08:39 AM
How to use MySQL database for time series analysis? Time series data refers to a collection of data arranged in time order, which has temporal continuity and correlation. Time series analysis is an important data analysis method that can be used to predict future trends, discover cyclical changes, detect outliers, etc. In this article, we will introduce how to use a MySQL database for time series analysis, along with code examples. Create a data table First, we need to create a data table to store time series data. Suppose we want to analyze the number
How to use MySQL database for image processing?
Jul 14, 2023 pm 12:21 PM
How to use MySQL database for image processing? MySQL is a powerful relational database management system. In addition to storing and managing data, it can also be used for image processing. This article will introduce how to use a MySQL database for image processing and provide some code examples. Before you begin, make sure you have installed a MySQL database and are familiar with basic SQL statements. Create a database table First, create a new database table to store the image data. The structure of the table can be as follows
How to make reliable MySQL database connection using Go language?
Jun 17, 2023 pm 07:18 PM
With the large amount of data that needs to be stored and processed, MySQL has become one of the most commonly used relational databases in application development. The Go language is becoming more and more popular among developers due to its efficient concurrency processing and concise syntax. This article will lead readers to implement reliable MySQL database connection through Go language, allowing developers to query and store data more efficiently. 1. Several ways for Go language to connect to MySQL database. There are usually three ways to connect to MySQL database in Go language, which are: 1. Third-party library
MySQL database and Go language: How to perform data caching?
Jun 17, 2023 am 10:05 AM
In recent years, the Go language has become increasingly popular among developers and has become one of the preferred languages for developing high-performance web applications. MySQL is also a popular database that is widely used. In the process of combining these two technologies, caching is a very important part. The following will introduce how to use Go language to handle the cache of MySQL database. The concept of caching In web applications, caching is a middle layer created to speed up data access. It is mainly used to store frequently requested data to
