PHP | ODBC Functions

Hello folks! welcome back to a new edition of our tutorial on PHP. In this tutorial guide, we are going to be studying about the PHP ODBC Functions.

What is ODBC?

Open DataBase Connectivity (ODBC) is an Application Programming Interface (API) that allows a programmer to abstract a program from a database.

Installation

There is no Installation needed to use these functions; they are part of the PHP core.

READ: PHP | MYSQLi Functions

List of ODBC Functions

The following is the list of ODBC functions that are supported in PHP. PHP - indicates the earliest versions of PHP that have support for the functions.

Sr.No	Function & Description	PHP
1	autocommit It used to toggle autocommit behaviour.s	4
2	binmode Closing the connections	4
3	Close all It is used to close all odbc connections	4
4	Close It is used to close an odbc connection	4
5	columnprivileges It contains the information about list of coloumn	4
6	columns It is used to get ithe list of coloumn names in specificed table.	5
7	commit It is used to commit odbc transaction	5
8	connect It is used to connect ODBC data source	5
9	cursor It is used to get the cursor	5
10	Data Source It returns the information about current connection	4.3
11	error It is used to get the last error	4.0.5
12	errormsg It is used to get the last error messsage	4
13	exec It is used to prepare and excute Sql statements	4
14	fetch array It is used to fetch a result row as an associated array	4
15	fetch into It is used to fetch the result into row	5.4
16	fetch_object It is used to fetch a result row as an object	4.0.2
17	fetch row It is used to fetch a row	4
18	field len It is used to get the length of a filed	4
19	filed name It is used to get the coloumn name	4
20	field num It is used to get the filed number	4
21	field scale It is used to get the scale of filed.	5.1
22	field type It is used to get the information about data type of a filed	5.1
23	foreignkeys It is used to retrieve list of foreignkeys.	5
24	free result It contains the information about free resource that contained with a result	5
25	gettypeinfo It is used to retrieve the information about data types	4
26	loongreadlen It is used to handling the long coloumns	4
27	next result It is used to check if multiful results are available	4
28	num rows It contains the information about number of rows in a result	4
29	pconnect It is an open a persistent database connection	4
30	prepare It is used to prepare a statement for execution	4
31	primarykeys It is used to get the primary key for a table	4
32	procedurecolumns It is used to retrieve the information about parameters to procedures	4
33	procedures It is used to get the list of procedures stored in a specific data resources	4
34	result all It is used to print the result as a html table	4
35	result It is used to print the result as a html table	4
36	rollback It is used to rollback the transaction	4
37	setoption It is used to adject adbc settings	4
38	specialcolumns It is used to retrieve the special coloumns	4
39	statistics It is used to retrieve the statics about table	4
40	tableprivileges It is used to list the tables and privileges associated with each table	4
41	tables It is used to get the list of tables are stored in data sources	4

In our subsequent tutorials, we are going to be discussing about the above listed PHP network functions.

READ: PHP | Network Functions

Alright guys! This is where we are going to be rounding up for this tutorial post. In our next tutorial, we are going to be discussing about PHP odbc_autocommit() Function.

Do feel free to ask your questions where necessary and we will attend to them as soon as possible. If this tutorial was helpful to you, you can use the share button to share this tutorial.

Follow us on our various social media platforms to stay updated with our latest tutorials. You can also subscribe to our newsletter in order to get our tutorials delivered directly to your emails.

Thanks for reading and bye for now.