• PHP Video Tutorials

PHP - ODBC Function



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

List of Functions

PHP − indicates the earliest version of PHP that supports the function.

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
php_function_reference.htm
Advertisements