| 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 ] ) |