select-db
mysqli::select_db
mysqli_select_db
Selects the default database for database queries
ENTITY
ENTITY
public
bool
mysqli::select_db
string
database
ENTITY
bool
mysqli_select_db
mysqli
mysql
string
database
Selects the default database to be used when performing queries against the database connection.
This function should only be used to change the default database for the connection. You can select the default database with the 4th parameter in mysqli_connect.
ENTITY
database
The database name.
ENTITY
ENTITY
ENTITY ENTITY
ENTITY
mysqli::select_db example
ENTITY
<?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 = $mysqli->query("SELECT DATABASE()");
$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 = $mysqli->query("SELECT DATABASE()");
$row = $result->fetch_row();
printf("Default database is %s.\n", $row[0]);
ENTITY
<?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 = mysqli_query($link, "SELECT DATABASE()");
$row = mysqli_fetch_row($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 = mysqli_query($link, "SELECT DATABASE()");
$row = mysqli_fetch_row($result);
printf("Default database is %s.\n", $row[0]);
ENTITY
Default database is test.
Default database is world.
ENTITY
mysqli_connect, mysqli_real_connect