(PHP 4, PHP 5, PECL odbtp >= 1.1.1)

mssql_select_dbSelect MS SQL database


Ta funkcja została USUNIĘTA w PHP 7.0.0.

Alernatywy dla tej funkcji obejmują:


mssql_select_db ( string $database_name [, resource $link_identifier ] ) : bool

mssql_select_db() sets the current active database on the server that's associated with the specified link identifier.

Every subsequent call to mssql_query() will be made on the active database.



The database name.

To escape the name of a database that contains spaces, hyphens ("-"), or any other exceptional characters, the database name must be enclosed in brackets, as is shown in the example, below. This technique must also be applied when selecting a database name that is also a reserved word (such as primary).


A MS SQL link identifier, returned by mssql_connect() or mssql_pconnect().

If no link identifier is specified, the last opened link is assumed. If no link is open, the function will try to establish a link as if mssql_connect() was called, and use it.

Zwracane wartości

Zwraca TRUE w przypadku powodzenia, FALSE w przypadku błędu.


Przykład #1 mssql_select_db() example

// Create a link to MSSQL
$link mssql_connect('KALLESPC\SQLEXPRESS''sa''phpfi');

// Select the database 'php'

Przykład #2 Escaping the database name with square brackets

// Create a link to MSSQL
$link mssql_connect('KALLESPC\SQLEXPRESS''sa''phpfi');

// Select the database 'my.database-name'

Zobacz też:

add a note add a note

User Contributed Notes 2 notes

jack at downeastinternet dot com
12 years ago
I have noted that mssql_select_db fails if the database name contains a dash or hyphen. for example a database named foo-bar will fail and the error that is returned indicates that the name was interpreted as only 'foo'
15 years ago
Use of square brackets to enclose the database name is also necessary if the name contains a dot: '.'



Produces the error:
Warning: mssql_select_db(): Sybase:  Server message:  Could not locate entry in sysdatabases for database 'Company'. No entry found with that name. Make sure that the name is entered correctly. (severity 16, procedure N/A) in


Will select successfully
To Top