INTERVIEW QUESTIONS DATABASE MS SQL SERVER DETAILS

Question: What Are Commonly Used ODBC Functions in PHP?

Answer: If you look at the PHP 5 manual, you will see a group of functions listed under the ODBC Functions (Unified) setion. The commonly used ODBC functions are:
* odbc_connect ? Establish an OBDC connection.
* odbc_data_source ? Returns information about a current connection.
* odbc_close ? Close an ODBC connection.
* odbc_exec ? Prepare and execute a SQL statement.
* odbc_fetch_row ? Fetch a row - moving the pointer to the a new row in a result object.
* odbc_result ? Get the value of a specific field from the current row of a result object.
* odbc_fetch_array ? Fetch a result row as an associative array.
* odbc_fetch_object ? Fetch a result row as an object.
* odbc_num_rows ? Number of rows in a result.
* odbc_field_name ? Get the name of a specified field index.
* odbc_field_type ? Get the data type of a specified field index.
* odbc_next_result ? Checks if multiple results are available.
* odbc_free_result ? Free resources associated with a result object.
* odbc_prepare ? Prepares a statement for execution.

If you look at the PHP 5 manual, you will see a group of functions listed under the ODBC Functions (Unified) setion. The commonly used ODBC functions are:
* odbc_connect ? Establish an OBDC connection.
* odbc_data_source ? Returns information about a current connection.
* odbc_close ? Close an ODBC connection.
* odbc_exec ? Prepare and execute a SQL statement.
* odbc_fetch_row ? Fetch a row - moving the pointer to the a new row in a result object.
* odbc_result ? Get the value of a specific field from the current row of a result object.
* odbc_fetch_array ? Fetch a result row as an associative array.
* odbc_fetch_object ? Fetch a result row as an object.
* odbc_num_rows ? Number of rows in a result.
* odbc_field_name ? Get the name of a specified field index.
* odbc_field_type ? Get the data type of a specified field index.
* odbc_next_result ? Checks if multiple results are available.
* odbc_free_result ? Free resources associated with a result object.
* odbc_prepare ? Prepares a statement for execution. Source: CoolInterview.com

If you have the better answer, then send it to us. We will display your answer after the approval.

Rules to Post Answers in CoolInterview.com:-

• There should not be any Spelling Mistakes.
• There should not be any Gramatical Errors.
• Answers must not contain any bad words.
• Answers should not be the repeat of same answer, already approved.
• Answer should be complete in itself.

Name :*
Email Id :*
Answer :*
Verification Code	Not readable? Load New Code
Enter the above shown code: *
	Inform me about updated answers to this question