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. ##
Database operation class26332017-03-16
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.
Database operation class18742017-03-14
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.
Database operation class14082017-03-13
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.
Database operation class16312017-03-13
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
Database operation class19552017-03-13
PHP classes for operating databases, including MySQL, MSSQL, Oracle, and SQLite
class Database { }
Database operation class16022017-03-12
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
Database operation class57672017-03-10
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
Database operation class18002017-03-10
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.
Database operation class47862017-03-08
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;
Database operation class21172017-03-08
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.
Database operation class32002017-02-27
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!
Database operation class19392017-02-23