What is the concept of building development using ADODB

This article mainly introduces what is the construction and development concept of ADODB. The introduction in this article is very detailed and has certain reference value. Interested friends must read it!

ADODB is short for Active Data Objects Data Base. It is an intermediate function component for PHP to access databases. You can check the strings in your program first and temporarily set them to "". Try it. Maybe he caused the problem.

Although PHP is a powerful tool for building Web systems, PHP's ability to access databases has not been standardized, and each database uses a different and incompatible application programming interface (API). In order to fill this gap, ADODB appeared. Once the interfaces for accessing databases are standardized, differences between databases can be hidden and it becomes easy to switch to different databases.

ADODB*** version is V4.62, supports a wide variety of databases, such as MySQL, PostgreSQL, Interbase, Informix, Oracle, MS SQL 7, Foxpro, Access, ADODB, Sybase, DB2 and general ODBC (PostgreSQL, Informix, Sybase drivers are contributed by the free software community).

One of the advantages of using ADODB *** is that regardless of the back-end database, the way to access the database is consistent, developers and designers do not have to learn a different set of access methods for one set of databases, which greatly reduces the burden of knowledge on developers, and the past knowledge can continue to be used later.

The concept of ADODB is not original, DBI is older than ADODB, it provides Perl access to the database, using a consistent API call interface. I believe that friends who have used Perl + DBI will have a familiar feeling when they use ADODB again.

Another benefit of using a DataSet is that it can be inherited to build strongly typed DataSets. The benefits of a strongly typed DataSet include design-time checking and Visual Studio. NET statement population for a strongly typed DataSet. When you fix an outline or relational structure for a DataSet, you can build a strongly typed DataSet that treats rows and columns as attributes of objects rather than collections of items.

For example, instead of exposing the column name of a row of the customer table, you could expose the Name attribute of the Customer object. Strongly typed ADODB is derived from the DataSet class and therefore does not sacrifice any of the functionality of the DataSet, that is, a strongly typed DataSet can also be remote and served as a data source for a data-bound control such as DataGrid. If you don't know the outline, you can also gain benefits by using the usual DataSet, but lose the additional features of a strongly typed DataSet.

That's all for the article "What is the concept of building development using ADODB?" Thank you for reading! Hope to share the content to help everyone, more relevant knowledge, welcome to pay attention to the industry information channel!