PHP is used with MySQL to retrieve and store data from the database. When the script execution ends, the connection to the database needs to be closed. In this article, we will explain how to close a MySQL database connection in PHP.
Close the MySQL database connection
In PHP, to close the connection to the MySQL database, you must use the "mysql_close()" function. This function accepts a parameter representing the database connection.
For example:
mysql_close($connection);
In this case, $connection is the name of the connection variable.
Below is a complete example showing how to connect to a MySQL database, and how to close the connection.
<?php // 定义 MySQL 数据库连接变量 $dbhost = 'localhost'; $dbuser = 'username'; $dbpass = 'password'; $connection = mysql_connect($dbhost, $dbuser, $dbpass); // 如果无法连接到数据库,则显示错误信息 if(! $connection ) { die('无法连接: ' . mysql_error()); } echo '连接成功'; // 关闭数据库连接 mysql_close($connection); ?>
In the above example, if it cannot connect to the MySQL database, PHP will exit with an error message. If the connection is successful, the message "Connection successful" will be displayed. At the end of the script, close the database connection using the "mysql_close()" function.
Summary
This article explains how to close a connection to a MySQL database in PHP. After using the database, be sure to remember to close the connection to release resources. Otherwise, the connection will consume server resources and may cause performance issues.
The above is the detailed content of How to close MySQL database connection in PHP. For more information, please follow other related articles on the PHP Chinese website!

This article details implementing message queues in PHP using RabbitMQ and Redis. It compares their architectures (AMQP vs. in-memory), features, and reliability mechanisms (confirmations, transactions, persistence). Best practices for design, error

This article examines current PHP coding standards and best practices, focusing on PSR recommendations (PSR-1, PSR-2, PSR-4, PSR-12). It emphasizes improving code readability and maintainability through consistent styling, meaningful naming, and eff

This article details installing and troubleshooting PHP extensions, focusing on PECL. It covers installation steps (finding, downloading/compiling, enabling, restarting the server), troubleshooting techniques (checking logs, verifying installation,

This article explains PHP's Reflection API, enabling runtime inspection and manipulation of classes, methods, and properties. It details common use cases (documentation generation, ORMs, dependency injection) and cautions against performance overhea

PHP 8's JIT compilation enhances performance by compiling frequently executed code into machine code, benefiting applications with heavy computations and reducing execution times.

This article explores strategies for staying current in the PHP ecosystem. It emphasizes utilizing official channels, community forums, conferences, and open-source contributions. The author highlights best resources for learning new features and a

This article explores asynchronous task execution in PHP to enhance web application responsiveness. It details methods like message queues, asynchronous frameworks (ReactPHP, Swoole), and background processes, emphasizing best practices for efficien

This article addresses PHP memory optimization. It details techniques like using appropriate data structures, avoiding unnecessary object creation, and employing efficient algorithms. Common memory leak sources (e.g., unclosed connections, global v


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

AI Hentai Generator
Generate AI Hentai for free.

Hot Article

Hot Tools

SAP NetWeaver Server Adapter for Eclipse
Integrate Eclipse with SAP NetWeaver application server.

PhpStorm Mac version
The latest (2018.2.1) professional PHP integrated development tool

DVWA
Damn Vulnerable Web App (DVWA) is a PHP/MySQL web application that is very vulnerable. Its main goals are to be an aid for security professionals to test their skills and tools in a legal environment, to help web developers better understand the process of securing web applications, and to help teachers/students teach/learn in a classroom environment Web application security. The goal of DVWA is to practice some of the most common web vulnerabilities through a simple and straightforward interface, with varying degrees of difficulty. Please note that this software

SublimeText3 English version
Recommended: Win version, supports code prompts!

ZendStudio 13.5.1 Mac
Powerful PHP integrated development environment
