A php encapsulation class for operating mysql, static properties, shared by all database instances, to avoid repeated connections to the database, status, 0 indicates that the query conditions are clean, 1 indicates that the query conditions are contaminated, ensures that there are no errors when using keywords in the instructions, obtains the field information of the data table, Filter and format the data table fields, The execution statement returns the number of affected rows for INSERT, UPDATE and DELETE, and the exec result returns. ##

Introducing a A very practical mysql tool class for direct object-oriented development, which can realize the operations of adding, deleting, modifying and querying the database.

This is the database operation class of php mysql, taken from discuz, it can be used in other programs after modification, and there are enough comments, you can learn from it and study it.

A database class instance that connects to the database in PHP in mysqli mode. This database class is sorted out from a PHP CMS. It can realize PHP connection database class. MySQLi version is compatible with PHP4. For targeted needs Friends can optimize and modify based on this code.

Describes the mysql database operation class for PHP to implement PDO. dbconfig class is responsible for configuring database access information , including: server address, port, database instance name, user name, user password, character set wait. The dbtemplate class collects access operations to the database, mainly including the following operations: 1. queryrows: returns multiple rows of records 2. queryrow: returns a single record 3. queryforint: Query a single field and return an integer 4. queryforfloat: Query a single field and return a floating point number (float) 5. queryfordouble: Query a single field and return a floating point number (double) 6. queryforobject: Query a single field and return the object. The actual type is determined by the database. 7. update: execute an update statement. insert / upadate / delete

PHP classes for operating databases, including MySQL, MSSQL, Oracle, and SQLite class Database { }

IntroductionThe mysqli class encapsulated by php, combined with the example form to analyze the definition and usage skills of php for the mysqli operation class,Master the necessary conditions to meet the singleton mode (1) Private constructor - to prevent using the new keyword to instantiate objects outside the class (2) Private member attributes-in order to prevent the attributes of storing objects from being introduced outside the class (3)Private clone method-in order to prevent another object from being cloned outside the class (4) Public static methods - to allow users to instantiate objects

Describes the simple database operation Model class implemented by PHP. This database model class can realize the addition, deletion, modification and query of the database, simplify the database operation, and facilitate direct calls. The basic process of database manipulation is: 1. Connect to the database server 2. Select database 3. Execute SQL statement 4. Processing result set 5. Print operation information

PDO (PHP Data Object) is a lightweight, PHP data connection extension with a compatible interface. It is an official PECL library of PHP. It is released with PHP 5.1 and requires the object-oriented support of PHP 5, so it is not available on earlier versions. not available. The data access abstraction layer it provides has the advantage of being independent of specific database types and provides a unified operating interface for the databases it supports. Currently supported databases include Cubrid, FreeTDS / Microsoft SQL Server / Sybase, Firebird/Interbase 6, IBM DB2, IBM Informix Dynamic Server, MySQL 3.x/4.x/5.x, Oracle Call Interface, ODBC v3 (IBM DB2 , unixODBC and win32 ODBC), PostgreSQL, SQLite 3 and SQLite 2, Microsoft SQL Server / SQL Azure, etc. Since PDO is a unified database operation interface implemented at the bottom layer, it can be used to implement more advanced database operations, such as scheduling of stored procedures, etc.

Adminer is a database management tool, a single file, very easy to use, supports mysql, sqlite, the best choice if phpmyadmin is not installed; delete it after use;

This is a very simple class file that uses php to back up mysql database. We only need to simply configure the connection address username and database in dbmange. Function: Implement mysql database volume backup, select tables for backup, and implement single sql file and volume sql import.

A PHP object-oriented database operation class library. When using it, be sure not to forget to close the data connection $SqlDB->Close(); Of course, this sentence is optional, PHP will automatically log out! But this can develop a good habit, and the best It’s better to add it!