PHP: mysql_select_db - Manual (original) (raw)

(PHP 4, PHP 5)

mysql_select_db — Select a MySQL database

Description

mysql_select_db(string $database_name, resource $link_identifier = NULL): bool

Sets the current active database on the server that's associated with the specified link identifier. Every subsequent call to mysql_query() will be made on the active database.

Parameters

database_name

The name of the database that is to be selected.

link_identifier

The MySQL connection. If the link identifier is not specified, the last link opened bymysql_connect() is assumed. If no such link is found, it will try to create one as if mysql_connect() had been called with no arguments. If no connection is found or established, an**[E_WARNING](errorfunc.constants.php#constant.e-warning)** level error is generated.

Return Values

Returns [true](reserved.constants.php#constant.true) on success or [false](reserved.constants.php#constant.false) on failure.

Examples

Example #1 mysql_select_db() example

`<?php

$link

= mysql_connect('localhost', 'mysql_user', 'mysql_password');
if (!$link) {
die('Not connected : ' . mysql_error());
}// make foo the current db dbselected=mysqlselectdb(′foo′,db_selected = mysql_select_db('foo', dbs​elected=mysqls​electd​b(′foo′,link);
if (!$db_selected) {
die ('Can't use foo : ' . mysql_error());
}
?>`

Notes

Note:

For backward compatibility, the following deprecated alias may be used: mysql_selectdb()

See Also

• mysql_connect() - Open a connection to a MySQL Server
• mysql_pconnect() - Open a persistent connection to a MySQL server
• mysql_query() - Send a MySQL query

Found A Problem?

There are no user contributed notes for this page.