Selects the default database for database queries maxdb_rpl_query_type maxdb_send_long_data MaxDB Functions PHP Manual maxdb_select_db maxdb->select_db (PECL maxdb:1.0-7.6.00.38)maxdb_select_db -- maxdb->select_db — Selects the default database for database queries Description bool maxdb_select_db ( resource $link , string $dbname ) The maxdb_select_db() function selects the default database (specified by the dbname parameter) to be used when performing queries against the database connection represented by the link parameter. Note: This function should only be used to change the default database for the connection. You can select the default database with 4th parameter in maxdb_connect(). Return Values Returns TRUE on success or FALSE on failure. Examples Example #1 Object oriented style <?php$maxdb = new maxdb("localhost", "MONA", "RED", "DEMODB");/* check connection */if (maxdb_connect_errno()) { printf("Connect failed: %s\n", maxdb_connect_error()); exit();}/* return name of current default database */if ($result = $maxdb->query("SELECT SERVERDB FROM USERS WHERE USERNAME='MONA'")) { $row = $result->fetch_row(); printf("Default database is %s.\n", $row[0]); $result->close();}/* change db to non existing db */$maxdb->select_db("XXXXXXXX");/* return name of current default database */if ($result = $maxdb->query("SELECT SERVERDB FROM USERS WHERE USERNAME='MONA'")) { $row = $result->fetch_row(); printf("Default database is %s.\n", $row[0]); $result->close();}$maxdb->close();?> Example #2 Procedural style <?php$link = maxdb_connect("localhost", "MONA", "RED", "DEMODB");/* check connection */if (maxdb_connect_errno()) { printf("Connect failed: %s\n", maxdb_connect_error()); exit();}/* return name of current default database */if ($result = maxdb_query($link, "SELECT SERVERDB FROM USERS WHERE USERNAME='MONA'")) { $row = maxdb_fetch_row($result); printf("Default database is %s.\n", $row[0]); maxdb_free_result($result);}/* change db to non existing db */maxdb_select_db($link, "XXXXXXXX");/* return name of current default database */if ($result = maxdb_query($link, "SELECT SERVERDB FROM USERS WHERE USERNAME='MONA'")) { $row = maxdb_fetch_row($result); printf("Default database is %s.\n", $row[0]); maxdb_free_result($result);}maxdb_close($link);?> The above example will output something similar to: Default database is <...>. Warning: maxdb_select_db(): -10709 Connection failed (RTE:database not running) <...> Warning: maxdb_query(): -10821 Session not connected [] <...> Warning: maxdb_close(): -10821 Session not connected [] <...> See Also maxdb_connect() maxdb_real_connect() maxdb_rpl_query_type maxdb_send_long_data MaxDB Functions PHP Manual
