PhpDig.net

What is PhpDig?
PhpDig is a PHP MySQL based
Web Spider & Search Engine.




mysql_select_db

Name

mysql_select_db — Sets the active database.

Synopsis

bool mysql_select_db(database_name[, connection]);
string database_name: Database to select
mysql link connection (optional): Connection handle returned by mysql_connect() or mysql_pconnect()

Returns

TRUE on success; FALSE otherwise

Description

mysql_select_db() sets the active database for the connection referenced by connection . If no connection handle is specified in the connection argument, the last connection opened is used by default. If no connection is open, mysql_select_db() attempts to connect to a MySQL database by calling mysql_connect() without arguments.

The active database works with mysql_query() , providing the default database for queries. See mysql_query() for more information.

Note

This function is roughly equivalent to typing \u database; in the MySQL client.

Version

PHP 3+, PHP 4+

See also

To connect to a MySQL server:

mysql_connect()

mysql_pconnect()

To query the active database:

mysql_query()



Example

Example 829. Set the active database for the default connection

$db = 'some_db';

mysql_select_db ($db)
    or die ("Could not set '$db' as the default database for the default connection.");



PHP Functions Essential Reference. Copyright © 2002 by New Riders Publishing (Authors: Zak Greant, Graeme Merrall, Torben Wilson, Brett Michlitsch). This material may be distributed only subject to the terms and conditions set forth in the Open Publication License, v1.0 or later (the latest version is presently available at http://www.opencontent.org/openpub/). The authors of this book have elected not to choose any options under the OPL. This online book was obtained from http://www.fooassociates.com/phpfer/ and is designed to provide information about the PHP programming language, focusing on PHP version 4.0.4 for the most part. The information is provided on an as-is basis, and no warranty or fitness is implied. All persons and entities shall have neither liability nor responsibility to any person or entity with respect to any loss or damage arising from the information contained in this book.

Powered by: vBulletin Version 3.0.7
Copyright ©2000 - 2005, Jelsoft Enterprises Ltd.
Copyright © 2001 - 2005, ThinkDing LLC. All Rights Reserved.