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 |