PHP | ODBC Functions

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.


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.NoFunction & DescriptionPHP
1autocommit

It used to toggle autocommit behaviour.s

4
2binmode

Closing the connections

4
3Close all

It is used to close all odbc connections

4
4Close

It is used to close an odbc connection

4
5columnprivileges

It contains the information about list of coloumn

4
6columns

It is used to get ithe list of coloumn names in specificed table.

5
7commit

It is used to commit odbc transaction

5
8connect

It is used to connect ODBC data source

5
9cursor

It is used to get the cursor

5
10Data Source

It returns the information about current connection

4.3
11error

It is used to get the last error

4.0.5
12errormsg

It is used to get the last error messsage

4
13exec

It is used to prepare and excute Sql statements

4
14fetch array

It is used to fetch a result row as an associated array

4
15fetch into

It is used to fetch the result into row

5.4
16fetch_object

It is used to fetch a result row as an object

4.0.2
17fetch row

It is used to fetch a row

4
18field len

It is used to get the length of a filed

4
19filed name

It is used to get the coloumn name

4
20field num

It is used to get the filed number

4
21field scale

It is used to get the scale of filed.

5.1
22field type

It is used to get the information about data type of a filed

5.1
23foreignkeys

It is used to retrieve list of foreignkeys.

5
24free result

It contains the information about free resource that contained with a result

5
25gettypeinfo

It is used to retrieve the information about data types

4
26loongreadlen

It is used to handling the long coloumns

4
27next result

It is used to check if multiful results are available

4
28num rows

It contains the information about number of rows in a result

4
29pconnect

It is an open a persistent database connection

4
30prepare

It is used to prepare a statement for execution

4
31primarykeys

It is used to get the primary key for a table

4
32procedurecolumns

It is used to retrieve the information about parameters to procedures

4
33procedures

It is used to get the list of procedures stored in a specific data resources

4
34result all

It is used to print the result as a html table

4
35result

It is used to print the result as a html table

4
36rollback

It is used to rollback the transaction

4
37setoption

It is used to adject adbc settings

4
38specialcolumns

It is used to retrieve the special coloumns

4
39statistics

It is used to retrieve the statics about table

4
40tableprivileges

It is used to list the tables and privileges associated with each table

4
41tables

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.


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.