Database operation is an important part of the development process. Developers who are proficient in database operation are A must-have weapon. PHP Chinese website provides you with various encapsulated PHP database operation libraries for you to download and learn.
Recommended related mysql video tutorials: "mysql tutorial"
php various database operation library downloads
PDO (PHP Data Object) is a lightweight , PHP data connection extension with compatible interface, 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 cannot be used on earlier versions. 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.
2. php realizes MySQL database backup and restore class library
This is a very simple class file that uses php to back up mysql database. We just need to simply Just 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.
3. The mysqli complete class library encapsulated by php
The mysqli class encapsulated by php, combined with the example form, analyzes the definition and usage skills of php for the mysqli operation class, and masters it Satisfy the necessary conditions for the singleton mode
(1) Private constructor - to prevent the use of the new keyword to instantiate objects outside the class
(2) Private member attributes-to prevent Introduce the attribute of this stored object outside the class
(3)Private clone method-in order to prevent another object from being cloned outside the class
(4)Public static method-in order to allow Users perform operations on instantiated objects
4. php encapsulation class for operating mysql
php encapsulation class for operating mysql, static attributes, shared by all database instances to avoid duplication Connect to the database, status, 0 means the query conditions are clean, 1 means the query conditions are polluted, ensure that there are no errors when using keywords in the instructions, obtain the field information of the data table, filter and format the data table fields, and execute the statements for INSERT, UPDATE and DELETE. The exec result returns the number of rows affected.
5. php operates the class encapsulated by redis
php operates the class encapsulated by redis, Redis operation, supports Master/Slave load cluster, server connection handle, and connects to the server Note: A long connection is used here to improve efficiency, but it will not be closed automatically. More operations can be performed to obtain the original Redis object. The cache is set in a conditional form. If the key does not exist, it will be set. If the key exists, the setting will fail.
6. SQLite database connection class implemented by PHP
Introduces the SQLite database connection class implemented by PHP, involving SQLite database connection, addition, deletion, modification, query and other SQL operations The usage is of great practical value, friends in need can refer to it. Database connection, returns the database connection identifier, executes the SQL statement, and obtains a row from the result set as an associative array.
7. MongoDB database operation class implemented by PHP
Sharing of MongoDB database operation class implemented by PHP, template mysql version of the operation class, supports passing in multiple mongo_server( 1. Connect to other servers when a problem occurs 2. Automatically distribute queries evenly to different servers)
8. php encapsulates the mysql class based on singleton mode
php Based on the singleton mode to encapsulate the mysql class, combined with the complete instance form, the definition and usage of the mysql class encapsulated by PHP using the singleton mode are analyzed
9. PHP database processing class
Database operation classes are an indispensable thing in developing WEB applications. Of course, you can directly connect to the database for query, but this is inconvenient to maintain. I have compiled a good PHP database processing class to share with you. A simple database operation class that facilitates quickly inserting data into the database, deleting data, and updating data.
10. The mysqli class of php cache data function
Introduces the mysqli class of php cache data function. If __autoload() is used in the framework, there is no need to load the file. Friends who need it can learn and refer to it. If you have a better plan, you can bring it to us to learn and share it with us.
For more database operation related class library downloads, please pay attention to: //m.sbmmt.com/xiazai/leiku/db
[Related class library recommendations 】
2. php paging class Code Sharing: Download the latest 10 PHP paging class codes in 2017
3.[php thumbnail class] Download the latest 10 libraries that use PHP to generate thumbnails
4.[php verification code class] Share 10 useful php verification code class codes