com doc/ja: Simplify mysqli select db examples: reference/mysqli/mysqli/select-db.xml

[email protected] (Yoshinari Takaoka) Mon, 22 Mar 2021 18:35:39 +0000
Newsgroups php.doc.ja
Message-ID <[email protected]>
Commit:    2ec4ab8194991f9e334ebaf54de9b787c51b924a=0AAuthor:    Yoshinari =
Takaoka <[email protected]>         Tue, 23 Mar 2021 03:35:39 +0900=0AParen=
ts:   c01b860bee7374e9acc6b344d12b14dad18aec38=0ABranches:  master=0A=0ALin=
k:       http://git.php.net/?p=3Ddoc/ja.git;a=3Dcommitdiff;h=3D2ec4ab819499=
1f9e334ebaf54de9b787c51b924a=0A=0ALog:=0ASimplify mysqli select db examples=
=0A=0AChanged paths:=0A  M  reference/mysqli/mysqli/select-db.xml=0A=0A=0AD=
iff:=0Adiff --git a/reference/mysqli/mysqli/select-db.xml b/reference/mysql=
i/mysqli/select-db.xml=0Aindex 8307367c6b..f44b0942ea 100644=0A--- a/refere=
nce/mysqli/mysqli/select-db.xml=0A+++ b/reference/mysqli/mysqli/select-db.x=
ml=0A@@ -1,6 +1,6 @@=0A <?xml version=3D"1.0" encoding=3D"utf-8"?>=0A <!-- =
$Revision$ -->=0A-<!-- EN-Revision: 7e5d0d1bb69180c9de1992edf9613215c975fa5=
7 Maintainer: takagi Status: ready -->=0A+<!-- EN-Revision: 34ec8e992f4ac2c=
6abb35e58452842cdaff975bc Maintainer: takagi Status: ready -->=0A <!-- Cred=
its: mumumu -->=0A <refentry xml:id=3D"mysqli.select-db" xmlns=3D"http://do=
cbook.org/ns/docbook">=0A  <refnamediv>=0A@@ -67,66 +67,44 @@=0A    <progra=
mlisting role=3D"php">=0A <![CDATA[=0A <?php=0A-$mysqli =3D new mysqli("loc=
alhost", "my_user", "my_password", "test");=0A =0A-/* =E6=8E=A5=E7=B6=9A=
=E7=8A=B6=E6=B3=81=E3=82=92=E3=83=81=E3=82=A7=E3=83=83=E3=82=AF=E3=81=97=
=E3=81=BE=E3=81=99 */=0A-if (mysqli_connect_errno()) {=0A-    printf("Conne=
ct failed: %s\n", mysqli_connect_error());=0A-    exit();=0A-}=0A+mysqli_re=
port(MYSQLI_REPORT_ERROR | MYSQLI_REPORT_STRICT);=0A+$mysqli =3D new mysqli=
("localhost", "my_user", "my_password", "test");=0A =0A-/* =E7=8F=BE=
=E5=9C=A8=E3=81=AE=E3=83=87=E3=83=95=E3=82=A9=E3=83=AB=E3=83=88=E3=83=87=
=E3=83=BC=E3=82=BF=E3=83=99=E3=83=BC=E3=82=B9=E5=90=8D=E3=82=92=E8=BF=94=
=E3=81=97=E3=81=BE=E3=81=99 */=0A-if ($result =3D $mysqli->query("SELECT DA=
TABASE()")) {=0A-    $row =3D $result->fetch_row();=0A-    printf("Default =
database is %s.\n", $row[0]);=0A-    $result->close();=0A-}=0A+/* =E7=8F=
=BE=E5=9C=A8=E3=81=AE=E3=83=87=E3=83=95=E3=82=A9=E3=83=AB=E3=83=88=E3=83=
=87=E3=83=BC=E3=82=BF=E3=83=99=E3=83=BC=E3=82=B9=E5=90=8D=E3=82=92=E5=8F=
=96=E5=BE=97=E3=81=97=E3=81=BE=E3=81=99 */=0A+$result =3D $mysqli->query("S=
ELECT DATABASE()");=0A+$row =3D $result->fetch_row();=0A+printf("Default da=
tabase is %s.\n", $row[0]);=0A =0A /* =E3=83=87=E3=83=BC=E3=82=BF=E3=83=
=99=E3=83=BC=E3=82=B9=E3=82=92 world =E3=81=AB=E5=A4=89=E6=9B=B4=E3=81=
=97=E3=81=BE=E3=81=99 */=0A $mysqli->select_db("world");=0A =0A-/* =
=E7=8F=BE=E5=9C=A8=E3=81=AE=E3=83=87=E3=83=95=E3=82=A9=E3=83=AB=E3=83=88=
=E3=83=87=E3=83=BC=E3=82=BF=E3=83=99=E3=83=BC=E3=82=B9=E5=90=8D=E3=82=92=
=E8=BF=94=E3=81=97=E3=81=BE=E3=81=99 */=0A-if ($result =3D $mysqli->query("=
SELECT DATABASE()")) {=0A-    $row =3D $result->fetch_row();=0A-    printf(=
"Default database is %s.\n", $row[0]);=0A-    $result->close();=0A-}=0A-=0A=
-$mysqli->close();=0A-?>=0A+/* =E7=8F=BE=E5=9C=A8=E3=81=AE=E3=83=87=
=E3=83=95=E3=82=A9=E3=83=AB=E3=83=88=E3=83=87=E3=83=BC=E3=82=BF=E3=83=99=
=E3=83=BC=E3=82=B9=E5=90=8D=E3=82=92=E5=8F=96=E5=BE=97=E3=81=97=E3=81=BE=
=E3=81=99 */=0A+$result =3D $mysqli->query("SELECT DATABASE()");=0A+$row =
=3D $result->fetch_row();=0A+printf("Default database is %s.\n", $row[0]);=
=0A ]]>=0A    </programlisting>=0A    <para>&style.procedural;</para>=0A   =
 <programlisting role=3D"php">=0A <![CDATA[=0A <?php=0A-$link =3D mysqli_co=
nnect("localhost", "my_user", "my_password", "test");=0A =0A-/* =E6=8E=
=A5=E7=B6=9A=E7=8A=B6=E6=B3=81=E3=82=92=E3=83=81=E3=82=A7=E3=83=83=E3=82=
=AF=E3=81=97=E3=81=BE=E3=81=99 */=0A-if (mysqli_connect_errno()) {=0A-    p=
rintf("Connect failed: %s\n", mysqli_connect_error());=0A-    exit();=0A-}=
=0A+mysqli_report(MYSQLI_REPORT_ERROR | MYSQLI_REPORT_STRICT);=0A+$link =3D=
 mysqli_connect("localhost", "my_user", "my_password", "test");=0A =0A-/* =
=E7=8F=BE=E5=9C=A8=E3=81=AE=E3=83=87=E3=83=95=E3=82=A9=E3=83=AB=E3=83=88=
=E3=83=87=E3=83=BC=E3=82=BF=E3=83=99=E3=83=BC=E3=82=B9=E5=90=8D=E3=82=92=
=E8=BF=94=E3=81=97=E3=81=BE=E3=81=99 */=0A-if ($result =3D mysqli_query($li=
nk, "SELECT DATABASE()")) {=0A-    $row =3D mysqli_fetch_row($result);=0A- =
   printf("Default database is %s.\n", $row[0]);=0A-    mysqli_free_result(=
$result);=0A-}=0A+/* =E7=8F=BE=E5=9C=A8=E3=81=AE=E3=83=87=E3=83=95=E3=82=
=A9=E3=83=AB=E3=83=88=E3=83=87=E3=83=BC=E3=82=BF=E3=83=99=E3=83=BC=E3=82=
=B9=E5=90=8D=E3=82=92=E5=8F=96=E5=BE=97=E3=81=97=E3=81=BE=E3=81=99 */=0A+$r=
esult =3D mysqli_query($link, "SELECT DATABASE()");=0A+$row =3D mysqli_fetc=
h_row($result);=0A+printf("Default database is %s.\n", $row[0]);=0A =0A /* =
=E3=83=87=E3=83=BC=E3=82=BF=E3=83=99=E3=83=BC=E3=82=B9=E3=82=92 world =
=E3=81=AB=E5=A4=89=E6=9B=B4=E3=81=97=E3=81=BE=E3=81=99 */=0A mysqli_select_=
db($link, "world");=0A =0A-/* =E7=8F=BE=E5=9C=A8=E3=81=AE=E3=83=87=E3=83=
=95=E3=82=A9=E3=83=AB=E3=83=88=E3=83=87=E3=83=BC=E3=82=BF=E3=83=99=E3=83=
=BC=E3=82=B9=E5=90=8D=E3=82=92=E8=BF=94=E3=81=97=E3=81=BE=E3=81=99 */=0A-if=
 ($result =3D mysqli_query($link, "SELECT DATABASE()")) {=0A-    $row =3D m=
ysqli_fetch_row($result);=0A-    printf("Default database is %s.\n", $row[0=
]);=0A-    mysqli_free_result($result);=0A-}=0A-=0A-mysqli_close($link);=0A=
-?>=0A+/* =E7=8F=BE=E5=9C=A8=E3=81=AE=E3=83=87=E3=83=95=E3=82=A9=E3=83=
=AB=E3=83=88=E3=83=87=E3=83=BC=E3=82=BF=E3=83=99=E3=83=BC=E3=82=B9=E5=90=
=8D=E3=82=92=E5=8F=96=E5=BE=97=E3=81=97=E3=81=BE=E3=81=99 */=0A+$result =3D=
 mysqli_query($link, "SELECT DATABASE()");=0A+$row =3D mysqli_fetch_row($re=
sult);=0A+printf("Default database is %s.\n", $row[0]);=0A ]]>=0A    </prog=
ramlisting>=0A    &examples.outputs;=0A