Mysql's complete database connection PHP class library

<?php
class mysql {
public function __construct($db_host, $db_user, $db_pwd, $db_database, $conn, $coding) {
$this->db_host = $db_host;
$this->db_user = $db_user;
$this->db_pwd = $db_pwd;
$this->db_database = $db_database;
$this->conn = $conn;
$this->coding = $coding;
$this->connect();
}
/*数据库连接*/
public function connect() {
if ($this->conn == "pconn") {
//永久链接
$this->conn = mysql_pconnect($this->db_host, $this->db_user, $this->db_pwd);
} else {
//即使链接
$this->conn = mysql_connect($this->db_host, $this->db_user, $this->db_pwd);
}
if (!mysql_select_db($this->db_database, $this->conn)) {
if ($this->show_error) {
$this->show_error("数据库不可用：", $this->db_database);
}
}

private $db_host; //Database host

private $db_user; //Database username

private $db_pwd; //Database username and password

private $db_database; //Database name

private $conn; //Database connection identification;

private $result; //Result identification of query command execution

private $ sql; //sql execution statement

private $row; //number of entries returned

private $coding; //database encoding, gbk, utf8, gb2312

private $bulletin = true; //Whether to enable error logging

private $show_error = false; //In the testing phase, all errors are displayed, which has security risks and is closed by default

private $is_error = false; //Whether to terminate immediately when an error is detected, the default is true, it is recommended not to enable it, because it is very distressing for users to not see anything when there is a problem

Related Article

How Does jQuery Simplify DOM Manipulation for Web Developers?

03Jan2025

Overflow: Hidden and Expansion of HeightjQuery distinguishes itself from other JavaScript libraries through its cross-platform compatibility and...

How to Execute Command Line Binaries in Node.js?

27Dec2024

Executing Command Line Binaries in Node.jsExecuting third-party binaries is an essential task when porting CLI libraries from other languages to...

Manage duplicates in your Bitwarden Vault with Python

05Jan2025

Bitwarden doesn't have a built-in method for managing duplicates in your vault. I wasn't happy with the other user-made libraries I found, so I went and created a Python-based tool to help automate the process. Features Filter entries by

How to Integrate External Libraries into IntelliJ IDEA Artifacts?

23Dec2024

Incorporating External Libraries into IntelliJ IDEA ArtifactsTo seamlessly integrate external libraries within your IntelliJ IDEA artifacts,...

How Can Libraries Access Configuration Settings Without Using app.config?

01Jan2025

Providing Configuration Settings for Libraries: An Alternative to App.configUnlike executable applications, libraries (DLLs) do not have direct...

How Do I Integrate External Libraries, Like Psapi.lib, into My Qt Creator Projects?

26Dec2024

Integrating External Libraries into Qt Creator ProjectsAdding external libraries to projects developed using Qt Creator enhances their...

See all articles