PHP: mysqli::select_db - Manual (original) (raw)
mysqli_select_db
(PHP 5, PHP 7, PHP 8)
mysqli::select_db -- mysqli_select_db — Selects the default database for database queries
Description
Object-oriented style
public mysqli::select_db(string $database): bool
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 mysqli_connect().
Return Values
Returns [true](reserved.constants.php#constant.true) on success or [false](reserved.constants.php#constant.false) on failure.
Examples
Example #1 mysqli::select_db() example
Object-oriented style
`<?php
mysqli_report
(MYSQLI_REPORT_ERROR | MYSQLI_REPORT_STRICT);
$mysqli = new mysqli("localhost", "my_user", "my_password", "test");/* get the name of the current default database / result=result = result=mysqli->query("SELECT DATABASE()"); row=row = row=result->fetch_row();
printf("Default database is %s.\n", $row[0]);/ change default database to "world" /
$mysqli->select_db("world");/ get the name of the current default database */ result=result = result=mysqli->query("SELECT DATABASE()"); row=row = row=result->fetch_row();
printf("Default database is %s.\n", $row[0]);`
Procedural style
`<?php
mysqli_report
(MYSQLI_REPORT_ERROR | MYSQLI_REPORT_STRICT);
$link = mysqli_connect("localhost", "my_user", "my_password", "test");/* get the name of the current default database / result=mysqliquery(result = mysqli_query(result=mysqliquery(link, "SELECT DATABASE()"); row=mysqlifetchrow(row = mysqli_fetch_row(row=mysqlifetchrow(result);
printf("Default database is %s.\n", $row[0]);/ change default database to "world" /
mysqli_select_db($link, "world");/ get the name of the current default database */ result=mysqliquery(result = mysqli_query(result=mysqliquery(link, "SELECT DATABASE()"); row=mysqlifetchrow(row = mysqli_fetch_row(row=mysqlifetchrow(result);
printf("Default database is %s.\n", $row[0]);`
The above examples will output:
Default database is test. Default database is world.
See Also
- mysqli_connect() - Alias of mysqli::__construct
- mysqli_real_connect() - Opens a connection to a mysql server
Found A Problem?
lori at astoundingteam dot com ¶
2 years ago
Note that the order of arguments for `mysqli_select_db` is opposite what it is for the deprecated `mysql_select_db`.