- PHP Tutorial
- PHP - Home
- PHP - Introduction
- PHP - Environment Setup
- PHP - Syntax Overview
- PHP - Variable Types
- PHP - Constants
- PHP - Operator Types
- PHP - Decision Making
- PHP - Loop Types
- PHP - Arrays
- PHP - Strings
- PHP - Web Concepts
- PHP - GET & POST
- PHP - File Inclusion
- PHP - Files & I/O
- PHP - Functions
- PHP - Cookies
- PHP - Sessions
- PHP - Sending Emails
- PHP - File Uploading
- PHP - Coding Standard
- Advanced PHP
- PHP - Predefined Variables
- PHP - Regular Expression
- PHP - Error Handling
- PHP - Bugs Debugging
- PHP - Date & Time
- PHP & MySQL
- PHP & AJAX
- PHP & XML
- PHP - Object Oriented
- PHP - For C Developers
- PHP - For PERL Developers
- PHP Form Examples
- PHP - Form Introduction
- PHP - Validation Example
- PHP - Complete Form
- PHP login Examples
- PHP - Login Example
- PHP - Facebook Login
- PHP - Paypal Integration
- PHP - MySQL Login
- PHP AJAX Examples
- PHP - AJAX Search
- PHP - AJAX XML Parser
- PHP - AJAX Auto Complete Search
- PHP - AJAX RSS Feed Example
- PHP XML Example
- PHP - XML Introduction
- PHP - Simple XML
- PHP - Simple XML GET
- PHP - SAX Parser Example
- PHP - DOM Parser Example
- PHP Frame Works
- PHP - Frame Works
- PHP - Core PHP vs Frame Works
- PHP Design Patterns
- PHP - Design Patterns
- PHP Function Reference
- PHP - Built-In Functions
- PHP Useful Resources
- PHP - Questions & Answers
- PHP - Useful Resources
- PHP - Discussion
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
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 |