Schon mal in's PHP-Handbuch geschaut? ...
Beispiel 1. mysql_select_db() example
1 | <?php
|
2 |
|
3 | $link = mysql_connect('localhost', 'mysql_user', 'mysql_password');
|
4 | if (!$link) {
|
5 | die('Verbindung nicht möglich : ' . mysql_error());
|
6 | }
|
7 |
|
8 | // benutze Datenbank foo
|
9 | $db_selected = mysql_select_db('foo', $link);
|
10 | if (!$db_selected) {
|
11 | die ('Kann foo nicht benutzen : ' . mysql_error());
|
12 | }
|
13 | ?>
|
----------------------------------------------------------------------
Alternativ auch mit mysqli-funktionen:
Beispiel 1. Object oriented style
1 | <?php
|
2 | $mysqli = new mysqli("localhost", "my_user", "my_password", "test");
|
3 |
|
4 | /* check connection */
|
5 | if (mysqli_connect_errno()) {
|
6 | printf("Connect failed: %s\n", mysqli_connect_error());
|
7 | exit();
|
8 | }
|
9 |
|
10 | /* return name of current default database */
|
11 | if ($result = $mysqli->query("SELECT DATABASE()")) {
|
12 | $row = $result->fetch_row();
|
13 | printf("Default database is %s.\n", $row[0]);
|
14 | $result->close();
|
15 | }
|
16 |
|
17 | /* change db to world db */
|
18 | $mysqli->select_db("world");
|
19 |
|
20 | /* return name of current default database */
|
21 | if ($result = $mysqli->query("SELECT DATABASE()")) {
|
22 | $row = $result->fetch_row();
|
23 | printf("Default database is %s.\n", $row[0]);
|
24 | $result->close();
|
25 | }
|
26 |
|
27 | $mysqli->close();
|
28 | ?>
|
Beispiel 2. Procedural style
1 | <?php
|
2 | $link = mysqli_connect("localhost", "my_user", "my_password", "test");
|
3 |
|
4 | /* check connection */
|
5 | if (mysqli_connect_errno()) {
|
6 | printf("Connect failed: %s\n", mysqli_connect_error());
|
7 | exit();
|
8 | }
|
9 |
|
10 | /* return name of current default database */
|
11 | if ($result = mysqli_query($link, "SELECT DATABASE()")) {
|
12 | $row = mysqli_fetch_row($result);
|
13 | printf("Default database is %s.\n", $row[0]);
|
14 | mysqli_free_result($result);
|
15 | }
|
16 |
|
17 | /* change db to world db */
|
18 | mysqli_select_db($link, "world");
|
19 |
|
20 | /* return name of current default database */
|
21 | if ($result = mysqli_query($link, "SELECT DATABASE()")) {
|
22 | $row = mysqli_fetch_row($result);
|
23 | printf("Default database is %s.\n", $row[0]);
|
24 | mysqli_free_result($result);
|
25 | }
|
26 |
|
27 | mysqli_close($link);
|
28 | ?>
|
Anmerkung: 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().