| Description | SQLServer Driver for PHP | MySQL Functions |
| Begins a transaction | sqlsrv_begin_transaction( resource $conn ) | START TRANSACTION, BEGIN, COMMIT, ROLLBACK can be executed as statements in mysql_query |
| Cancels a statement; discards any pending results for the statement | sqlsrv_cancel( resource $stmt ) | - |
| Provides information about the client | sqlsrv_client_info( resource $conn ) | mysql_get_client_info ( void ) |
| Closes a connection. Frees all resources associated with the connection | sqlsrv_close( resource $conn ) | mysql_close ([ resource $link_identifier ] ) |
| Commits a transaction | sqlsrv_commit( resource $conn ) | START TRANSACTION, BEGIN, COMMIT, ROLLBACK can be executed as statements in mysql_query |
| Changes error handling and logging configurations | sqlsrv_configure( string $setting, int $value ) | - |
| Creates and opens a connection | sqlsrv_connect( string $serverName [, array $connectionInfo ) | mysql_connect ([ string $server [, string $username [, string $password [, bool $new_link [, int $client_flags ]]]]] ) |
| Returns error and/or warning information about the last operation | sqlsrv_errors( [int $errosAndOrWarnings] ) | mysql_errno ([ resource $link_identifier ] )
mysql_error ([ resource $link_identifier ] ) |
| Executes a prepared statement with sqlsrv_prepare | sqlsrv_execute( resource $stmt ) | - |
| Makes the next row of data available for reading | sqlsrv_fetch( resource $stmt ) | - |
| Retrieves the next row of data as a numerically indexed array, an associative array, or both | sqlsrv_fetch_array( resource $stmt [, int $fetchType] ) | mysql_fetch_array ( resource $result [, int $result_type ] ) |
| Retrieves the next row of data as an object | sqlsrv_fetch_object( resource $stmt [, string $className] ) | mysql_fetch_object ( resource $result [, string $class_name [, array $params ]] ) |
| Returns field metadata | sqlsrv_field_metadata( resource $stmt ) | See
mysql_field_type ( resource $result , int $field_offset ) specifically the Example and mysql_fetch_field ( resource $result [, int $field_offset ] )
|
| Closes a statement. Frees all resources associated with the statement | sqlsrv_free_stmt( resource $stmt ) | mysql_free_result ( resource $result ) |
| Returns the value of the specified configuration setting | sqlsrv_get_config( string $setting ) | mysql_get_client_info ( void ) |
| Retrieves a field in the current row by index. The PHP return type can be specified | sqlsrv_get_field( resource $stmt, int $fieldIndex [, int $getAsType] ) | similar to mysql_result ( resource $result , int $row [, mixed $field ] ) |
| Makes the next result available for processing | sqlsrv_next_result( resource $stmt ) | - |
| Retrieves the number of fields in an active result set | sqlsrv_num_fields( resource $stmt ) | mysql_num_fields ( resource $result ) |
| Prepares a Transact-SQL query without executing it. Implicitly binds parameters, executed with sqlsrv_execute | sqlsrv_prepare( resource $conn, string $tsql[ ,array $params[, array $options]] ) | - |
| Prepares and executes a Transact-SQL query. | sqlsrv_query( resource $conn, string $tsql[ , array $params[, array $options]] ) | mysql_query ( string $query [, resource $link_identifier ] ) |
| Rolls back a transaction. | sqlsrv_rollback( resource $conn ) | START TRANSACTION, BEGIN, COMMIT, ROLLBACK can be executed as statements in mysql_query |
| Returns the number of modified rows. | sqlsrv_rows_affected( resource $stmt ) | mysql_affected_rows ([ resource $link_identifier ] ) |
| Sends up to eight kilobytes (8 KB) of data to the server with each call to the function. | sqlsrv_send_stream_data( resource $stmt ) | - |
| Provides information about the server. | sqlsrv_server_info( resource $conn ) | mysql_get_server_info ([ resource $link_identifier ] ) |
